Prevent New Categories from Being Added to a Dimension
If you do not want any new categories in your data source added to a particular dimension, you can prevent this from occurring automatically on category generation.
For example, suppose you have created a cube group based on one level in a dimension, and you do not want new categories added to that level; otherwise, each new category would automatically create a new cube for the cube group. You prohibit this action.
Procedure
- Open the property sheet for the applicable dimension.
- Select Prohibit automatic creation of new categories and click OK.