How to Define Multiple Number Formats for Dimension Members in SpotlightXL View
- 1 Minute to read
- Print
- DarkLight
- PDF
How to Define Multiple Number Formats for Dimension Members in SpotlightXL View
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
To define multiple number formats for dimension members in Views, follow these steps:
- Select Model > Dimension.
- Choose the model from the Model list box and the dimension that contains the members you want to define number formats for from the Dimension list box.
- Select the Set Dimension Based Properties action.
- Click Save after defining number formats for each dimension.
- Select the Analyze > Design View.
- Select the view and click Properties.
- Select the dimension from the Dimension based 'Number Format field.
- Click Save.
- Go to Analyze > Data to see the results of your changes.
Note:
Dimension-based ‘Number Format’ and Dimension-based ‘Locked’ properties defined at the View are only applicable if the selected dimensions are defined either on row or column axis of the View.
Was this article helpful?