|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
The POP command restores the status of a dimension, the status of a valueset, or the value of an option or single-cell variable that was saved with a previous PUSH command.
PUSH and POP are commonly used within a program to make changes to options and dimension status that apply only during the program's execution. Afterward, the options and status are the same as they were before the execution of the program.
POP name1 [nameN]
The name of a dimension, valueset, variable, or option that was specified in a previous PUSH command, whose saved value you want to restore.
Using the MAINTAIN command with a dimension clears that dimension's pushed status lists. For example, suppose you have pushed the dimension
month several times, with different limits each time. When you then use the MAINTAIN command to perform any maintenance activity on the
month dimension, Oracle OLAP resets the status of
ALL (the default), and popping that dimension will have no effect.
For an example of using POP, see Example 19-44, "Saving and Restoring Values".