Changing the Definition of an Object

The definition of the last object you have defined in your analytic workspace is the current definition. You can append characteristics, such as a description, property, or permission to the current definition. If you want to append a characteristic to a definition that is not current, then you can use the CONSIDER command to make it the current definition.

The following table lists the OLAP DML commands that you can use to append characteristics to an object definition.

Command	Description
AGGMAP	Allows you to specify completely new contents for a new or existing AGGMAP type aggregation map, which you can use with the AGGREGATE command
ALLOCMAP	Allows you to specify completely new contents for a new or existing ALLOCMAP type aggregation map, which you can use with the ALLOCATE command
EQ	Allows you to specify the expression to be calculated for a formula that has already been defined
LD	Assigns a long description to an object definition
MODEL	Allows you to specify completely new contents for a new or existing model
PERMIT	Assigns access permission to an object definition
PROGRAM	Allows you to specify completely new contents for a new or existing program
PROPERTY	Assigns a property to an object definition

Suppose that you have defined a Boolean variable named onplan. Later, you want to add a description to the definition of the variable.

As shown below, to change the definition of the ONPLAN variable, you first make ONPLAN the current definition, and then you append a description to the definition.

CONSIDER onplan
LD Are these districts tracked on a special plan?

You can redefine some characteristics of a variable definition by using the CHGDFN command. In the following example, the segment size of the sales variable is changed.

CHGDFN sales SEGWIDTH 150 1000

For more information on the DEFINE and CHGDFN commands, see the topics for these commands in the Oracle9i OLAP DML Reference help.