You are an advanced user/developer/expert - or somebody not knowledgeable about QuickBooks details - who is familiar with databases and table joins and is comfortable with using MSQuery or PowerQuery, Access, Crystal Reports, or even Power BI in the traditional manner - choosing specific tables and creating your own joins - and would like advanced documentation for this process.
The whole purpose of the QQube Technology is to avoid having to deal with the traditional manner in which we have been taught to interact with data for the last 4 decades. e.g. here is a mapping document, and you are off on your own.
QQube uses traditional data warehousing techniques, where the is one FACT table containing measures, and inner joined tables called DIMENSIONS
So unless you are trying to do something that QuickBooks doesn't do underneath the hood, the need to write manual SQL Queries, and join tables from scratch, is generally not part of the average end-user experience.
The end user, just opens up one of the examples, and just starts to drag and drop their fields; further if they use the Excel Add-In, they can use the bubble text information (shown below) to see what each field does, or contains.
BUT you may certainly have a legitimate need for writing SQL Queries for specific granular purposes - OR you just are more comfortable doing it the old fashioned way - no harm in that.
You will find that QQube provides out of the box examples - for each analytic available in QQube - for Access, Crystal Reports, Power Pivot, Tableau, and PowerBI. Which means that you never start from scratch. Just open up an example, and drag and drop.
Although Excel may not be the application in which you will end up writing your reports or analytics, you should use it for three purposes:
Add-In and Data Organization
Bubble Text for Deeper Field Information
FOLDER BUBBLE TEXT:
FIELD BUBBLE TEXT
Creating Manual SQL Queries
We provide an easy way to create manual SQL queries, as the Excel Add-In is actually a front-end to MSQuery.
Here is what you do:
If your needs are for advanced SQL elements and functions, you can use this page on Version 12.0.1 for SQLAnywhere for reference:
NOTE QQube versions 6.x and later are using SQLAnyhwere version 17, but the commands and functions have not materially changed from version 12.x
Updated 4/11//2020
Choose a location
Forum :
Your session has expired. You are being logged out.