|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
The PUSH command saves the current status of a dimension (including the NAME dimension), the status of a valueset, or the value of an option or single-cell variable. You can then restore these saved values and status at a later time with a POP 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.
PUSH name1 [name]
The name of a dimension, valueset, option, or variable whose status or value you want to save.
Using a MAINTAIN statement 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 a MAINTAIN statement 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.
The following program uses PUSH and POP to produce sales figures without decimal places for a specific selection of products, districts, and months, and then restores the status settings and the value of DECIMALS to what they were before the program was run.
DEFINE report1 PROGRAM PROGRAM TRAP ON cleanup PUSH DECIMALS product district month DECIMALS = 0 LIMIT product TO 'Sportswear' 'Footwear' LIMIT district TO 'Atlanta' 'Dallas' LIMIT month TO 'Jan96' TO 'Jun96' REPORT sales cleanup: POP DECIMALS product district month END