How to Add or Delete Dimensions from a Model in SpotlightXL
- 2 Minutes to read
- Print
- DarkLight
- PDF
How to Add or Delete Dimensions from a Model in SpotlightXL
- 2 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Adding a Dimension to a Model
In Practice
- In SpotlightXL, navigate to the Model > Setup.
- Click the Modify Model action as shown below. The dimensions associated with the model are displayed.
- Click Add Dimension.
- Enter the name of the dimension you want to add and select whether it is a Value or Key dimension.
- Click OK and then Close the dialog page.
- The added dimension is updated in the Dimension list on the Model Setup page.
- Click Save.
- Click Generate Model.
.png)
- Access the Model Dimension page and select the newly added dimension for the Model. Add members for the dimension and then click Save. Also, a root member with the name of the dimension is added. You can then add additional dimension members for the dimension and click Save.
- Access the Model Map page. Observe the new line for the added dimension. If you select the model with the new dimension as your Source Model, the Source Filter for the new Dimension (Department) is set to DimensionFilter and the Source Value is Department (the name of the root value). The Target Filter is set to None along with the Target Value. Similarly, if you select the model with the new dimension as your Target Model, the Target Filter is set to Dimension Filter with the Target Value as the root value. The Source Filter is set to None along with the Source Filter Value.
.png)
- Access the Analyze > Data page. Notice the Company dimension member is now displayed in the Model View.
.png)
.png)
Note:
Adding a dimension will adjust all dependent artifacts of the model (for example; Map, Formula, Scope, Views, and Reports) so that they all become available for usage once the dimension is added, however, it is recommended that a Power user validates the key artifacts and makes the necessary changes if required. Adding a dimension will not make any changes to the Calculations defined on the model. Power users have to review the calculations and make necessary changes if needed.
Deleting a Dimension from a Model
Note:
You can delete one dimension at a time.
In Practice
- In SpotlightXL, go to Model > Setup.
- The model must be in a non-generated state. Click Modify Model. The dimensions associated with the model are displayed.
- Delete the required dimension.
- When asked if you want to delete the selected item, click Yes.
Note:
If there is a formula defined on the dimension that is being deleted then that formula will be deleted when the dimension is deleted. Delete dimension will adjust all dependent artifacts of the model (for example; Map, Formula, Scope, Views, Reports) so that they all become available for usage once the dimension is deleted, however, it is recommended that a Power user validates key artifacts and make necessary changes if needed. Deleting a dimension will not make any changes to the Calculations defined on the model. Power users have to review the calculations and make necessary changes if needed.
Was this article helpful?