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