Example: Determining Which Model To Use

note

This example focuses on building a report that uses historical data (data from report logs) rather than operational (current) data.

Consider the following example: Assume aggregation has been completed and there is already in place an organizational structure with the following levels below the top level: Business Unit, Cost Center, and User. To create a report that displayed quarterly feature usage by business unit, you would find your model as follows:

1. First, open the 'Feature-Org OLAP' folder because you are interested in Feature usage (not product), and would like to use your Organizational Structure instead of leaf data.
2. Second, select the 'Feature Monthly' subfolder. Because this is a quarterly report, Monthly data contains enough granularity, and would yield better performance than Daily or Hourly data
3. Finally, you would choose the model F-M Level2. In the previous assumptions, Business Unit occupies the second level of the organization (underneath the top level), so the Level2 model is the correct choice.

With that choice made, any data available from F-M Level2 can be added to our report with assurances that it will be correctly linked to the rest of the data in our report, as long as everything was taken from this same model.