OLAP DML Options

An option is a special type of analytic workspace object that specifies the characteristic of some aspect of how Oracle OLAP calculates or formats data or what Oracle OLAP operations are activated. You cannot define your own options as part of a workspace. However, you can use any of the options that are defined as part of the Oracle OLAP DML. The options defined for the Oracle OLAP DML are outlined in "OLAP DML Options by Category".

Some options are read-only, while others are read/write options for which you can specify values. Read/write options have default values.

The general syntax for specifying and retrieving option values is shown in Table: Syntax for Specifying and Retrieving Option Values.

Syntax for Specifying and Retrieving Option Values

Action	Syntax
To specify an option value	option-name = value
To display an option value	SHOW option-name
To retrieve an option value into a predefined variable	variable-name = option-name