|Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)
Part Number A95298-01
Allocating Data, 4 of 5
An aggregation map for allocation contains commands that specify relations that define the path of an allocation through a dimension hierarchy, the method of the allocation operation, and other aspects of the allocation. To create an aggregation map you define an aggmap object with the
DEFINE command or specify an existing aggregation map with the
CONSIDER command. You then use the
ALLOCMAP command to add commands to the aggregation map and to mark it as an
ALLOCMAP type aggregation map.
You can add the following commands to an
ALLOCMAP aggregation map:
RELATION command specifies a self-relation that identifies the child-parent relationships of a dimension hierarchy that you want to use in the allocation. You use a separate
RELATION command for each dimension that you want to participate in the allocation. The order of the
RELATION commands in the aggregation map determines the order of the allocation.
RELATION command you specify an operator that determines the method of the allocation for the hierarchy. The
RELATION command also has arguments with which you can specify other aspects of an allocation. For example, you can use the
ARGS MIN minval argument to specify a value that the allocation assigns to the target cell if the allocated value is below a minimum value. You can use the
ARGS ADD argument to specify that the allocation adds the allocated data to the current data of the target cell before assigning the result to the cell instead of replacing the current data with the allocated data.
CHILDLOCK command tells the
ALLOCATE command whether to determine if
RELATION commands in the aggregation map specify locks on both a parent and a child element of a dimension hierarchy.
DEADLOCK command tells the
ALLOCATE command whether to continue an allocation if it encounters a deadlock, which occurs when the allocation cannot distribute a value because the targeted cell is locked or, for some operations, has a basis value of NA.
DIMENSION command specifies a single value to set as the status of a dimension that is not shared by the target variable and the source or the basis objects.
ERRORLOG command specifies how many errors to allow in the error log specified by the
ALLOCATE command and whether to continue the allocation if the maximum number of errors has occurred.
ERRORMASK command specifies which error conditions to exclude from the error log.
SOURCEVAL command specifies whether
ALLOCATE changes the source data value after the allocation. You use
SOURCEVAL only if the source is a variable. With
SOURCEVAL you can specify that the value of the source after the allocation is zero or NA or the current value, which is the value that the cell had before the allocation. In a recursive allocation,
ALLOCATE applies the value specified by
SOURCEVAL to any cell used as a source in the allocation.