Oracle9i OLAP Services Developer's Guide to the OLAP DML Release 1 (9.0.1) Part Number A86720-01 |
|
Limiting an Application's View of the Data, 2 of 11
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."
If you are familiar with relational database terminology, then you can think of the current status list of a dimension as a view of the dimension. Whether or not a dimension value is in status determines your view of the data from all of the objects that are dimensioned by it. In general, when an OLAP DML command is processed, only those values that are in status are accessed.
Whether or not a dimension value is in status merely restricts your view of the value during a given session; it does not permanently affect the values that are stored in the analytic workspace.
When you first attach an analytic workspace, the current status list of each dimension consists of all of the dimension's values 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 change the current status list for a dimension by using:
If you are familiar with relational database concepts and terminology, then it may help you to think of using a LIMIT command to "set or change dimension status" or "limit a dimension" in an analytic workspace as similar to using the SQL SELECT statement to "select a view" in a relational database. Changing dimension status merely restricts your view of the data during a given session. No matter how you change the current status list of a dimension, the changes have no permanent effect on your analytic workspace; every dimension retains all of its values.
You can use the following commands and functions to identify and retrieve the status of dimension values.
You can save the current status of a dimension in the following ways.
Contexts are the most sophisticated way to save object values for use in an analytic workspace. With contexts, you can access and update the saved object values, whereas PUSH and POP simply allow you to save and restore values. Typically, you only used the PUSH and POP commands within a program to make changes that apply only during the program's execution.
For more information, see the following table.
IF you want documentation about . . . | THEN see . . . |
---|---|
storing and maintaining values in a dimension, |
|
the CONTEXT, POP, POPLEVEL, PUSH, and PUSHLEVEL commands, |
"Preserving the Session Environment" the entries for the commands in OLAP DML Reference |
changing the read permission of dimension values using the PERMIT or PERMITRESET commands, |
"Adding Security to an Analytic Workspace" the topics for the commands in OLAP DML Reference |
sorting dimension values, |
the entry for the SORT command in OLAP DML Reference |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|