Oracle® OLAP DML Reference 11g Release 2 (11.2) E17122-08 |
|
|
PDF · Mobi · ePub |
The CONSIDER command identifies a definition as the current definition which 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.
Replacing a Definition Component
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 multiple properties.
Unsuccessful CONSIDER Statements
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.
Example 9-71 Adding a Description to an Analytic Workspace Object
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