Allocation creates lower-level data from summary data by distributing the values down a hierarchical dimension. You can use allocations for budgeting, forecasting, and profitability analysis, among other applications.
To allocate data:
Create the source, basis, target, and weight measures in the same cube:
Source measure: A measure or calculated measure that provides the values to allocate.
Basis measure: A measure or calculated measure that, depending on the allocation operator, identifies which cells are the targets of an allocation and what the proportion of the source value each target cell will receive. The basis can be the same as the target. Hierarchical operators do not use a basis measure.
Target measure: A measure that stores the allocated values. The target can be the same as the source, or the basis, or both.
Weight measure: An optional measure or calculated measure who values are applied after the allocation and before the value is stored. It is used to make an adjustment to the value, such as a currency conversion.
Create or edit a cube script to add an allocation step.
To create an allocation step:
On the General tab of the cube script, click New Step, then select New Allocation Step. The New Allocation Step property pages are displayed.
On the General page, select the source, target, and basis measures.
On the Rules page, list the dimensions in the order you want them allocated. Select an allocation method for each dimension and, optionally, a weight measure.
On the Status page, select both the source and the target cells. Be sure that the source data is at the highest level selected. Click Help for additional information about each tab.
Click Create to save the allocation step, then click Create to save the cube script.
To execute the allocation step, right-click the cube script and choose Execute Cube Script .
View the allocated data in the measure viewer.
Copyright © 2003, 2007, Oracle. All rights reserved.