Viewing the QQube Data Model in PowerPivot | CLEARIFY

About the QQube Data Model in PowerPivot

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.

Default Data Structure

All analytics contain:

• One FACT table that contains values
• Multiple DIMENSION tables that you measure by, e.g.
  • Lists like account, items, classes
  • Dates
  • Document Attributes like terms, ship method, paid/open status
  • Line Attributes like billable status, item custom field

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".

Viewing the Model

The easiest way to view the QQube schema for a particular analytic is to:

1. From the Power Pivot tab click on the "Manage Data Model" button, which will bring up the data model window.
2. From the Home tab on the Data Model window click on the Diagram View option (The default is usually the "Data View" options.

Viewing the QQube Data Model Relationships

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:

• Use the Detect Relationships feature.
• Change the relationships as shown below.