QQube Version 10 includes speed enhancements, the ability to choose a range of data to be extracted from QuickBooks, EBIDTA for financial statements, additional measures in several detail data models, over five thousand DAX measures for Power Pivot and Power BI, and more than 100 additional improvements to cement its legacy as the most complete tool for QuickBooks analytics.
You can control the range of data you pull in from QuickBooks:
More options for default "As Of" dates for A/R and A/P
You get to decide what date "Today" is:
This affects any dependent measure or DAX formula in a QQube data model. For instance, if you define Today is 9/21/2022, but the actual date is 10/01/2022 then current month is based upon the 9/21/2022 date.
This guide will list all data model changes from QQube Version 7.9.536 - but does not include the list of bug fixes which are catalogued here. The data models are listed in order as implemented in the QQube Configuration Tool.
Specific changes to the Account and Calendar Dimensions are explained in separate guides for advanced users.
List Views (those that have vl_ prefixes) will no longer include the company name in the list, and will have a single link (LinkForCompanyID) to the Company Dimension (vd_Company). They will no longer have links such as ParentID.
The List Views were originally intended as information only views. However, we know of cases where advanced users (e.g. developers) would use these in place of the actual dimensions - which may, or may not, have the desired effect.
Example for vl_CustomerType:
There are three changes to the Sales Order FACT table:
LinkToFiscalDateID was added, but not shown.
There are two changes to the Open Sales Order Document Attributes Folder:
Only one change to the FACT table:
Added 25 new fields. We corrected - and expanded - the thought process behind job cost and related data models, e.g. vehicle mileage, time tracking with regard to billable status - to better follow the QuickBooks implementation and reporting.
Added 3 new fields. (LinktoFiscalDateID was added, but not shown here).
As discussed in Job Costing:
This data model has been completely reworked due to two factors: changes in QuickBooks implementation, and a need for more relevant metrics.
This replaces the old Profit and Loss by Job - which has been moved to the Legacy section of the QQube Configuration Tool.
This is aggregated by day, and refreshes in 10% of the time from the previous data model it replaces. It is designed for Power Pivot and Power BI where we have created all of the necessary DAX formulas.
This replaces the old Profit and Loss by Job by Class - which has been moved to the Legacy section of the QQube Configuration Tool.
There are no changes to the FACT table or associated document and line attribute dimensions.
Added 6 new fields to allow users to have complete open PO information within the purchasing details data model. Parenthesis added to PurchaseTxn Line Rate (Foreign)
There are two changes to the Open Purchase Order Document Attributes Folder:
Removed Shipping Address which does not exist in the SDK
Added two fields to Payroll Data Model Line Attributes:
There are no changes other than re-ordering the fields for natural order consistency.
There are no changes to the FACT table other than re-ordering the fields for natural order consistency. The new EBIDTA function is not available for this data model.
There are no changes to the FACT table other than re-ordering the fields for natural order consistency.
These are not considered Financial Statements in the Accounting World.
This data model is used in the Access, Excel, Tableau, and Crystal Reports examples. It has been replaced in Power Pivot and Power BI by the Flexible Custom Period Profit and Loss.
This is brand new, and replaces the previous "Profit and Loss Freestyle" which has been moved to the Legacy Section in the QQube Configuration Tool
It uses the new combination calendar/fiscal date calendar dimension, and an account dimension which contains EBIDTA and fixes hierarchy "holes" that existed in previous versions of QQube for PowerPivot and Power BI.
As noted in the previous data model section, it also replaces the Actual, Budget, Forecast Profit and Loss data model for use with Power Pivot and Power BI.
This is brand new, and replaces the previous "Balance Sheet Freestyle" which has been moved to the Legacy Section in the QQube Configuration Tool
It uses the new combination calendar/fiscal date calendar dimension, and an account dimension which fixes hierarchy "holes" that existed in previous versions of QQube for PowerPivot and Power BI.
This is brand new, and replaces the previous "Profit and Loss by Class Freestyle" which has been moved to the Legacy Section in the QQube Configuration Tool
As noted in the previous data model section, it also replaces the Actual, Budget, Forecast Profit and Loss by Class data model for use with Power Pivot and Power BI.
We intended to have a new model comparable to our other flexible period offerings for profit and loss and balance sheet. However, we were not able to fit it in our time frame. This will be included in Version 10.1
There are no changes and is only available out-of-the-box for Excel as it is intended to test the integrity of a file.
There are no changes.
There are no changes, other than re-ordering the fields for natural order consistency.
The data model was moved from Financial Statements. It still requires the Profit and Loss and Balance Sheet Summary Financials to populate.
The data model was moved from Financial Statements by Class. It still requires the Profit and Loss by Class and Balance Sheet Summary by Class Financials to populate.
(CHEAT SHEET)
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/6142/modifications-in-version-10
Your session has expired. You are being logged out.