This will be a full install, and will upgrade versions 4.1 and later in place. Those with QQube Version previous to 4.1 will need to un-install that previous version before installing 6.1.
Current users of QQube who are still within the yearly subscription period will be notified of download and upgrade procedures for this free upgrade. Users outside of the yearly subscription period will be able to renew their subscription here:
New users need to request the link for a trial download.
QQube 6.1 is not a newer version that is simply "more and better". It is essentially a re-write of the underpinnings using newer technology, and modern architectures not previously available to us.
We can't control how Intuit exposes their data using the Software Development Kit (SDK), but there are many other aspects we can control to enable a better customer experience and produce a more efficient application.
QQube now contains over 45 independent Analytic areas, ranging from Open Sales Orders to 52/53 Tax Year Financial Summaries with 6,000 + fields of information, and over 250 additional pre-calculated measures used in examples for Excel PowerPivot, and Microsoft Power BI.
Highlights
Changes to Requirements
Reworked Statement of Cash Flows
New and Improved Financial Analytics
New Enterprise only Financial Summary Analytics
Additions to General Ledger Detail
52/53 Calendar
Audit Trail
Bank Transfers
Billing Rate
Build Assemblies
Financial Summary Reports
Fixed Assets
General Ledger Detail
Payroll
Profit and Loss by Job (Enterprise Only)
Sales
Sales Tax
Presentation Clean-Up in Excel PowerPivot
Synchronizer Status
New Refresh Options
NOTE: Each refresh option is applicable ONLY to the currently open spreadsheet
We are proud to include a library of over 60 Power BI analytics with QQube - the first of its kind.
FACT Table
The main folder (FACT table) for each subject used to contain all transactional information, whether it was something you measured (e.g. amount or qty), or something you measured BY e.g. Document Ship Method, or Line Billable Status.
QQube 6.1 corrects this, by separating measures, from document attributes, line attributes, and geography.
IMPORTANT NOTE: These structural changes may require manual intervention after the upgrade for those customers who did not use the Excel Add-In for report creation and/or implementation. These structural changes were necessary for the future of the product, and will be explained in detail in an upcoming Knowledge Base Article before the public release.
Single Date Options
Like all traditional warehouses, QQube provides a true Calendar Dimension for the various dates that exist in QuickBooks transactions, e.g. Transaction Date, Ship Date, Expected Date, etc. Excel and Tableau provide their own date dimension extensions e.g. Year, Quarter, Month, Day; so we have provided single date fields to accommodate those applications, and simplify the field options.
Fields that remove clutter from the canvas:
Here are a few DIMENSION folders which may have only one or two fields, - fields that are rarely used - but clutter up the canvas. So to simplify, we have added those single fields into the Document Attributes Folder:
Auto reload of all data when an abnormal interruption or manual abort has occurred. It is a requirement for data accuracy, so it has been automated.
Data Truncation information. There are times where a field in QB has more characters stuffed into it, than is recognized by the Intuit SDK. We see this where customers use older IIF import tools, and strict field sizes are not followed, OR a user has put more than phone and extension in a phone field. Previously it would just error out, with no indication as to what record or field was at issue. We now log this information so that it can be easily read for correction.
Option to auto clear the data, before reloading from scratch. This is a huge help for clients with multi-company QB files, and there is a higher instance of merging accounts, customers, items, etc. - all of which require a complete reload.
Please enable JavaScript to use file uploader.
Your session has expired. You are being logged out.