$ALLOCMAP

The $ALLOCMAP property specifies the default aggmap for allocation for a variable. When calculating the data in a variable, Oracle OLAP checks to see if the variable has an $ALLOCMAP property and, if it does, uses the aggmap object specified by that property as the default allocation specification for a variable.

Note:

The $ALLOCMAP property is only one way in which you can specify a default aggmap for a variable. You can also use a $AGGMAP property or a AGGMAP SET statement to specify the default aggregation specification for a variable.

See:

The PROPERTY command for general information on using properties in the OLAP DML.

Syntax

You add or delete an $ALLOCMAP property to the most recently defined or considered object (see DEFINE PROGRAM and CONSIDER) using a PROPERTY statement with the following syntax.

PROPERTY {addproperty | deleteproperty}

where

addproperty has the following syntax.

'$ALLOCMAP' aggmap-name
deleteproperty has the following syntax.

DELETE '$ALLOCMAP'

Arguments

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

Examples

Example 6-4 Using $ALLOCMAP to Specify a Default allocation Specification

Example 7-16, "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, merely by issuing the following statement, you can allocate data in the projbudget variable using the projbudgmap allocation specification.

ALLOCATE projbudget