(Release Date: Tuesday, September 22, 2020)
We have addressed five items in this release.
Avast Anti-Virus Issues
Synch Log Messages
QQube implements a traditional data warehouse star schema, where values that don't exist in a FACT table, are represented by a "dummy marker", so that all joins are efficient inner joins, rather than "costly" left or right outer joins. This is true for any DIMENSION, including Date DIMENSIONS.
However Microsoft has decided to implement their own methodology for a date dimension, where it is necessary to designate a Date DIMENSION as a "Date Table", with certain structural requirements. It affects certain DAX date functions, without this designation.
In this release we accommodated this designation to allow customers to easily use the specific DAX date functions affected.
When relationships are established between the tables in our schema, Power BI allows us to assign a cardinality e.g. many to one, one to one with either singular or bi-directional filtering).
We have corrected all Cardinalities to properly reflect our Star Schema relationships:
Balance Sheet by Class
Since the class splits of transactions are not stored underneath the hood in QuickBooks, it is necessary to extract the actual Balance Sheet by Class report for the Balance Sheet by Class Analytic.
However, this "report extract" takes the exact time it would take as if you were manually running the report in QuickBooks. If you have a large number of classes and a large file in general, this process can literally take hours, and can be a hindrance to nightly or even manual synchs.
Since, the Balance by Sheet is not typically looked at on a daily basis, we have provided a feature under Advanced Options, that will allow you to bypass the synch of this analytic - and avoid the largest consumption of extract time in the list of Financial Analytics by Class.
With this feature, you can just run the Balance Sheet by Class over the weekend.