We provide - for every analytic - default Data Models containing the most commonly used fields, to allow the average user to get started without having to deal with the complications of tables and relationships, or become overwhelmed with a long list of pieces and parts.
In this guide we give you information about the default data models we have created, and information about how to view them. This can be helpful when creating your own measures, or for understanding how the structure works in QQube.
All analytics contain:
We change the name of the original fields. For instance we change the original name of "SalesTxn Document Transaction Number" to just "Document Transaction Number".
We also hide fields that might be used in a report, but not in an analytic. For instance we would hide an address street field, because you wouldn't normally filter something by "1223 Main Street".
The easiest way to view the QQube schema for a particular analytic is to:
There is only way to connect one table with another - even if you are an advanced user who wants to construct a different type of model. Since QQube is a traditional star schema data warehouse, all relationships are "inner joins".
IMPORTANT DO NOT:
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/4873/viewing-the-qqube-data-model