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
Questions on this topic? See Are there excessive subsidiary views? in our Model Optimization Checklist forum.