Skip Headers

Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)

Part Number A95298-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Allocating Data, 4 of 5


Creating an Aggregation Map for Allocation

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:

A 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.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback