Statements Used Primarily in Programs


Table: Statements Used Primarily in OLAP DML Programs lists the OLAP DML statements that are used primarily in OLAP DML programs.

Statements Used Primarily in OLAP DML Programs

Statement Description
ACROSS
Specifies a text expression that contains one or more statements to be executed in a loop.
CONTEXT command
Lets you create and use a context during your Oracle OLAP session. A context is a means of preserving object values. After you create a context, you can save the current status of dimensions and the values of options, single-cell variables, valuesets, and single-cell relations in the context. You can then restore some or all of the object values from the context.
CONTEXT function
Obtains information about object values that are saved in a context. You must first create the context with the CONTEXT command.
INFO (PARSE) Obtains information that has been produced by the PARSE command.
PARSE
Parses a specified group of expressions.
POP
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.
POPLEVEL
Restores all values saved with PUSH commands that were executed since the last POPLEVEL command specifying the same marker.
PUSH
Saves the current status of a dimension, the status of a valueset, or the value of an option or single-cell variable.
PUSHLEVEL
Marks the start of a series of PUSH commands.
SLEEP
Suspends the operation of Oracle OLAP for at least the specified number of seconds.