How to Define a Dimension Members for a Model?

Article summary

Did you find this summary helpful?

Thank you for your feedback

In SpotlightXL, navigate to the Model > Dimension.
The model last saved on the Setup page is populated in the Model cell. If you want to work with a different model, select it from the Model List box.
The first dimension defined on the Setup page is displayed, enter dimension data for that dimension or select another from the Dimension list box.
Add, edit, or delete dimension data. If you are working with a new model, there will be no members defined.
Enter Member Code, Member Parent, and Rollup Operator data. These 3 data items are present in the standard data structure.
For Member Type, select Hidden to hide the dimension member from display on the Analyze >Data page. Hidden members will not be removed from the model but they will be removed from the display based on view settings.
After you have defined dimensions, return to the Setup page and generate your model.

Was this article helpful?