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, 2 of 5


Introduction to Allocation

The Oracle OLAP ALLOCATE command distributes data from a source object to the cells of a target. The target is a variable that is dimensioned by one or more hierarchical dimensions. The source data is specified by dimension values at a higher level in a hierarchical dimension than the values that specify the target cells.

ALLOCATE uses an aggregation map to specify the dimensions and the values of the hierarchies to use in the allocation, the method of operation to use for a dimension, and other aspects of the allocation.

Some of the allocation operations are based on existing data. The object containing that data is the basis object for the allocation. In those operations, ALLOCATE distributes the data from the source based on the values of the basis object.

Forecasting and budgeting systems often use allocation in operations such as the automatic distribution of a bonus pool with the amounts based on the current salary and performance ratings of the employee.

An allocation is the opposite of an aggregation that you perform with the AGGREGATE command. In an aggregation, the data at lower levels of a hierarchy is combined into data at higher levels. In an allocation, data at a higher level in the hierarchy is distributed to lower levels.

The ALLOCATE command has operations that are the inverse of the operations of the AGGREGATE command. Figure 9-1 shows an aggregation up a simple hierarchy. In a SUM operation, the aggregation adds the detail level values 2, 3, and 4 to derive the value 9 at the aggregate level.

Figure 9-1 Aggregation in a Simple Hierarchy


Text description of simpagg.gif follows
Text description of the illustration simpagg.gif

As an example of an allocation, you could take the aggregate value 9, double it to 18, and allocate the results to the detail level with the previous values of the detail level cells as the basis of the allocation. In Figure 9-2 the hierarchy on the left shows the result of an EVEN allocation operation, in which the source value is distributed evenly. Each detail level cell receives a value of 6. The hierarchy on the right shows a PROPORTIONAL allocation operation, in which the source value is distributed proportionately. The values allocated to the detail level are 4, 6 and 8.

Figure 9-2 Allocation in a Simple Hierarchy


Text description of simpallc.gif follows
Text description of the illustration simpallc.gif

The allocation operation methods range from simple allocations, such as copying the source data to the cells of the target variable, to very complex allocations, such as a proportional distribution of data from a source that is a formula, with the amount distributed being based on another formula, with multiple variables as targets, and with an aggregation map that specifies different methods of allocation for different dimensions.

The Oracle OLAP allocation system is very flexible and has many features, including the following:

Along with the ALLOCATE command, the OLAP DML contains other commands that support allocation. Table 9-1 lists those commands.

Table 9-1
Command Description

AGGMAPINFO command

Returns information about the contents of an aggregation map object, such as the type of the aggregation map, which indicates whether it contains commands for aggregation or allocation.

ALLOCATE command

Allocates data from a source object to a target variable.

ALLOCERRLOGFORMAT command

Determines the contents and the formatting for the error log that you specify with the ERRORLOG argument to the ALLOCATE command.

ALLOCERRLOGHEADER command

Determines the column headings for the error log.

ALLOCMAP command

Adds contents to an aggmap object that specify the path of the allocation down a dimension hierarchy, the method of operation, and other aspects of the allocation. Marks the object as an ALLOCMAP type aggregation map.

POUTFILEUNIT option

Identifies a location that receives information on the progress of an ALLOCATE command.

The remainder of this chapter describes the objects that you use to allocate data and the types of allocation operations, and provides examples of various allocations.


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