Line Items: Are there excessive subsidiary views?


When is this a problem?

Subsidiary views should be avoided for data that is used in calculations.

The following are the situations where a subsidiary view can be used (note that they all are related to how the data displays):

  • Show an attribute for end-user analysis, filtering, or sorting.
  • Show an alternative hierarchy for a dimension.
  • Display numeric values, such as ratios, that are not needed for other calculations.
  • Filter reports or provide attributes for exports.

Why is this a problem?

Subsidiary views are hard to locate and audit in a model. If a line item with a subsidiary view is published to a classic dashboard, the data cannot be edited.


How to correct:

Think about adding a new module that includes the dimensions of the subsidiary view. See the Subsidiary Views lesson for examples.


More information:

Subsidiary Views 

Model Optimization Checklist