Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
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 command.
Syntax
CONSIDER name
Arguments
The name of a definition in the current workspace or in an attached workspace.
Notes
When you use an LD, VNF, EQ, PROGRAM, MODEL, or PERMIT command 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 command, 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 commands produce an error.
The DEFINE, COPYDFN, and RENAME command automatically issue an implicit CONSIDER command.
Examples
Example 9-15 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