POP

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.

Syntax

POP name1 [nameN]

Arguments

name

The name of a dimension, valueset, variable, or option that was specified in a previous PUSH command, whose saved value you want to restore.

Notes

NAME Dimension

PUSH and POP also work for the NAME dimension.

Effect of the MAINTAIN Command

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 month to ALL (the default), and popping that dimension will have no effect.

Related Statements

POPLEVEL, PUSH, PUSHLEVEL, and CONTEXT command.

Examples

For an example of using POP, see Example 19-44, "Saving and Restoring Values".