How to Add or Delete Dimensions from a Model in SpotlightXL

Adding a Dimension to a Model

1. In SpotlightXL, navigate to Model > Setup.
2. Click the Modify Model action as shown below. The dimensions associated with the model are displayed.
   
   
   Note:

   The model must be in a Not Generated state and unlocked in order to add a dimension.
3. Click Add Dimension.
   
   
4. Enter the name of the dimension you want to add and select whether it is a Value or Key dimension.
5. Click OK and then Close the dialog page.
6. Click Save.
   
   
7. The added dimension is updated in the Dimension list on the Model > Setup page.
   
   
8. Access the Model > Dimension page and see the new dimension with the root dimension member. Add the desired members to the dimension and then click Save.
   
   
9. Navigate to Model > Setup, then click Generate Model.
   Optional, 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 is set to DimensionFilter and the Source Value is the parent member. 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.
   
   

Deleting a Dimension from a Model

1. In SpotlightXL, go to Model > Setup.
2. The model must be in a non-generated state. Click Modify Model. The dimensions associated with the model are displayed.
3. Delete the desired dimension.
4. When asked if you want to delete the selected item, click Yes.