|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
The CONSIDER command identifies a definition as the current definition. This enables you to add a description, value name format, formula, program, model, permission, or property to the definition with an LD, VNF, EQ, PROGRAM, MODEL, PERMIT, or PROPERTY statement.
The name of a definition in the current workspace or in an attached workspace.
When you use an LD, VNF, EQ, PROGRAM, MODEL, or PERMIT statement to add a component to the current definition, any existing value for that component is discarded and replaced by the new value you specify. For the PROPERTY statement, the value is replaced only when you specify a new value for an existing property name. Definitions can have more than one property.
When the CONSIDER command you issue is unsuccessful, subsequent LD, VNF, EQ, PROGRAM, MODEL, PERMIT, or PROPERTY statements produce an error.
The DEFINE, COPYDFN, and RENAME commands automatically issue an implicit CONSIDER command.
This example adds a description (LD) to the definition for
district. To add the LD, you must first use CONSIDER to make
district the current definition. The statements
CONSIDER district LD Sales Districts DESCRIBE district
produce the following definition.
DEFINE district DIMENSION TEXT LD Sales Districts