Specifying Required Dimensions
You can set the required dimensions for a measure.
Context
Some dimensions may be required for the calculation of a measure; for example, in a Lookup formula. If not all required dimensions are in the current drill state, users are notified that the displayed numbers could be incorrect.
You can set certain dimensions for a measure to be required, so that in stories and in the Explorer, users are informed if those dimensions are missing.
Procedure
- Open a model in the grid view.
- Select the cell in the Required Dimensions column for a measure.
- Select to open the Dimensions dialog.
- Choose which dimensions you want to be required for that measure.
Results
Note
- Dimensions that are marked as hidden on the All Dimensions tab are not displayed in the Select Dimensions dialog.
- Dimensions that are set as required can't be marked as hidden on the All Dimensions tab.