Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
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.
CONSIDER name
The name of a definition in the current workspace or in an attached workspace.
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 more than one property.
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 statement automatically issue an implicit CONSIDER command.
Example 11-17 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