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
commandsCHILDLOCK
commandDEADLOCK
commandDIMENSION
commandERRORLOG
commandERRORMASK
commandSOURCEVAL
commandA 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.
With a 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.
The 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.
The 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.
The 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.
The 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.
The ERRORMASK
command specifies which error conditions to exclude from the error log.
The 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.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|