Making Selections and Working with Subsets of Data

Current Status Lists

The current status list of a dimension is an ordered list of currently accessible values for the dimension. Values that are in the current status list of a dimension are said to be "in status." The current status list of a dimension determines the selection of the data from all of the objects that are dimensioned by it.

For dimensions, only those dimension values that are in the current status list are accessed. For dimensioned objects, only those data values that are indexed by dimension values in the current status list are accessed. As a loop is performed through a dimensioned object, the order of the dimension values in the current status list is used to determine the order in which the values of the object are accessed.

A dimension and any surrogate for that dimension share the same status. Setting the status of a dimension surrogate sets the status of its dimension and setting the status of a dimension sets the status of any dimension surrogates for it. In Part II, "Alphabetic Reference", references to dimensions apply equally to dimension surrogates, except where noted.

Composites are not dimensions, and therefore they do not have any independent status. The values of a composite that are "in status" are determined by the status of the base dimensions of the composite. In general, when statements deal with objects defined with composites, the default behavior is to treat those objects as if no SPARSE keyword or named composite had been used when the object was defined.

Default Status Lists

When you first attach an analytic workspace, the current status list of each dimension consists of all of the values of the dimension that have read permission, in the order in which the values are stored. This list of values is called the default status list for the dimension.

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.

Changing the Current Status List of a Dimension

Changing the default status list of a dimension obviously also changes the current status list of a dimension. Additionally, you can use to change the current status list of a dimension using:

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

• The SORT command command which arranges the order of values in the current status list of a dimension.

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 A-41, "Dimension and Composite Operation Statements".

Saving and Restoring Current Dimension Status

There are several different ways that you can save the current status of a dimension. The scope of each way is different:

• Any session—To save the current status for use in any session, create a named valueset with that status. Use a DEFINE VALUESET statement to define the valueset. Use a LIMIT command to assign the values to the valueset.

• Current session—To save, access, or update the current status for use in the current session, then use a named context. Use the CONTEXT command to define the context.

• Current program—To save the current status for use in the current program, then use the PUSHLEVEL and PUSH statements. You can restore the current status values using the POPLEVEL and POP statements.