|Oracle® OLAP DML Reference
11g Release 2 (11.2)
|PDF · Mobi · ePub|
Tip:The current object definition is the definition of the object that has been most recently defined or considered during the current session. To make an object definition the current definition, use a CONSIDER statement.
The text of the description you want to assign to the definition. When text is omitted, any existing description for the current definition is deleted.
You can create a multiline description by using a hyphen as a continuation character. However, you cannot create a description with an initial blank line with an LD statement.
This example changes the description associated with the variable
units. First, execute the CONSIDER statement to make
units the current definition. Then use a LD statement to assign a new description. The
units variable has the following definition.
DEFINE units VARIABLE INTEGER <month product district> LD Actual Unit Shipments
CONSIDER units ld Actual Unit Shipments for Each Division DESCRIBE units
produce the following definition for
DEFINE units VARIABLE INTEGER <month product district> LD Actual Unit Shipments for Each Division