Saving and discarding dimension changes

Changes made to dimensions, or new dimensions, are only permanently saved to disk when you save the entire database, or when you save the dimensions in the Dimensions and Subsets dialog. You can experiment with changing dimensions, without making the changes permanent. You can save individual dimensions or all dimensions under a database alias, or you can discard all the changes made since the dimension was last saved.

Click Dimensions in the Database group on the ribbon and expand the database alias which contains the dimension to save. Select the dimension and click Save.

To save all the dimensions within a database alias, select the alias and click the Save button.

To discard changes, click Clear from Memory.

You can see if a dimension has been changed since it was last saved by selecting it and clicking the Properties button.