|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
The POP command restores the status of a dimension (including the NAME dimension), the status of a valueset, or the value of an option or single-cell variable that was saved with a previous PUSH statement.
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 statement, whose saved value you want to restore.
For an example of using POP, see Example 10-85, "Saving and Restoring Values".