The examples provided are great, but are (understandably) slimmed down to include only the relevant tables modelled for the topic at hand. However, I am hoping somebody already has a "master" template with *all* of the tables and defined relationships? Even if they aren't fleshed out with graphs, that would be fine. I am trying to make one single published QB datasource for my end users, if possible.
Providing a "master" template would be difficult for the following two reasons:
We have examples for every analytic available, and that would be your starting place, as the relationships are already created for you.
Additionally, if you look at, say one of the financial Power BI examples in the QQube Configuration Tool, you will see how you tie together several analytics. In particular, you will see that the same dimension (using account as an example) cannot be used across every FACT table for each analytic; it always requires an alias, to avoid getting unwarranted results.
Lastly, our examples only include the most often used DIMENSIONS, e.g. item, account, class, etc. because it is less data to load. If you want to see ALL of the possible linked tables for an analytic, I would simply open up one of the Microsoft Access examples, and look at the relationships. You will find them easy to follow; for instance the FACT table has "LinkToAccountID", and the DIMENSION table has "LinkForAccountID".
Choose a location