$ALLOCMAP

The $ALLOCMAP property specifies the default aggmap for allocation for a variable which is the aggmap that Oracle OLAP uses when the variable is the target variable of an ALLOCATE statement that does not include a USING phrase.

Syntax

You add or delete an $ALLOCMAP property to the most recently defined or considered object (see DEFINE and CONSIDER commands) using a PROPERTY statement:

To add the property, issue the following statement.

PROPERTY '$ALLOCMAP' aggmap-name
To delete the property, issue the following statement.

PROPERTY DELETE '$AALLOCMAP'

Parameters

aggmap-name: A TEXT expression that specifies the name of a previously defined ALLOCMAP type aggmap object.

Examples

OLADM1117 Example 4-5 Using $ALLOCMAP to Specify a Default Allocation Specification

Example 9-35, "Recursive Even Allocation with a Lock" uses the following statement to allocated data in the projbudget variable using the projbudgmap allocation specification.

ALLOCATE projbudget USING projbudgmap

You can specify that projbudgmap is the default allocation specification for the projbudget variable by issuing the following statements.

CONSIDER projbudget
PROPERTY '$ALLOCMAP' "projbugmap'

Now, by issuing the following statement, you can allocate data in the projbudget variable using the projbudgmap allocation specification.

ALLOCATE projbudget