Changing the Status List of a Dimension

---

You can change the current status list for a dimension by using:

• The LIMIT command to change the values and the order of the values in the current status list of a dimension.

• The SORT command to arrange the order of values in the current status list of a dimension.

• The PERMIT command to change the read permissions for dimension values.

You can change the default status list of a dimension in the following ways:

• You can add, delete, move, merge, and rename values in a dimension by using the MAINTAIN command or adding dimension values in other ways (for example, using a SQL FETCH statement).

• You can change the read permission of values that are associated with a dimension by using a PERMIT or PERMITRESET statement.

The OLAP DML provides a number of statements that you can use to identify and retrieve the status of dimension values These statements are listed in Table: Dimension and Composite Operation Statements.