Previous
Previous
 
Next
Next

Changing the Current Status of a Dimension to Work with a Subset of Data

Since the current status list of a dimension determines the accessibility of the data in the analytic workspace, the way to work with a subset of analytic workspace data is to change the current status lists of one or more dimensions.

You change the values and the order of the values in the current status list of a dimension using the LIMIT command. The LIMIT command is a very complex OLAP DML command that lets you specify what values you want in the current status list by specifying the values explicitly or implicitly using relations. At it simplest level, Example: Using LIMIT to Partially Populate Variables illustrates how you can use the LIMIT command to change the current status list of a dimension so you can work with a subset of data.