How to Delete a Dimension Member from a Generated and Locked Model?

You can delete dimension members and associated data from a locked model without clearing and regenerating the model. For example, if you have a Revenue Forecast model and you want to remove an old product, you can do so without clearing or regenerating your model.

This option is available only in SpotlightXL.

1. In SpotlightXL, select Model > Setup.
2. Select the model from the Model drop-down.
3. Lock the model.
   Note:

   The model is still generated but is now locked from data changes by users.
4. Select Model > Dimension.
5. Select the dimension that you want to delete the member from. Make a note of the correct spelling of the Member Code and Member Parent.
   
   
   
6. Select Delete from the Action field.       
   • Type the Member Code and Member Parent.
     
     
     
   • Click Save.
   • A message appears and asks you to confirm, Deleting dimension members will clear all the rollup and deleted leaf member's data. Would you like to continue?
   • Click Yes to confirm.
   • A message appears and informs you that the operation has been submitted for execution. Notification will be sent via email once the process is complete.
   • The data for all associated rollup members is deleted with this operation. You need to unlock the model and then run the necessary calculations to obtain the new rollup data.
   • Select Model > Model Administration > Validation.
   • Select the model from the Model drop-down.
   • Review the status of the validation report to determine if any model artifacts need to be updated. You may have reports, views, calculations, formulas, or maps that refer to the deleted member and that need to be updated. Repeat the validation until you have made corrections to all the artifacts.

See Notes about Restructuring.