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

  1. Open the property sheet for the applicable dimension.
  2. Select Prohibit automatic creation of new categories and click OK.