Allocation Step Property Sheet: Rules tab

The Rules tab identifies the allocation rules for the step.

Order

The order in which the dimensions are allocated. When the allocation operators are the same across all dimensions, the order is not important. However, some combinations of operations produce different results depending on the order in which they are calculated. To change the order, select a dimension and use the arrow keys to move it up or down the list.

Dimension

The dimensions of the cube.

Operator

Choose the type of calculation you want to perform across each dimension.

Allocation Operators
Operator	Description
None	No allocation.
Copy	Copies the allocation source to all of the target cells that have a basis value that is not NA (null)..
Hierarchical Copy	Copies the allocation source to all of the target cells specified by the hierarchy, regardless of the basis value.
Minumum	Copies the allocation source to the target that has the smallest basis data value.
Maximum	Copies the allocation source to the target that has the largest basis data value.
First	Copies the allocation source to the first target cell that has a non-NA basis data value.
Hierarchical First Member	Copies the allocation source to the first target cell specified by the hierarchy, regardless of the basis value.
Last Non-NA Data Value	Copies the allocation source to the last target cell that has a non-NA basis data value.
Hierarchical Last Non-NA Data Value	Copies the allocation source to the last target cell specified by the hierarchy, regardless of the basis value.
Even	Divides the allocation source by the number of target cells that have non-NA basis values and applies the quotient to each target cell.
Hierarchical Even	Divides the allocation source by the number of target cells, including the ones that have NA values, and applies the quotient to each target cell.
Proportional	Divides the allocation source by the sum of the basis values, then multiplies the quotient by the individual basis value for each target cell.

Weight By

Select a measure that contains weight factors. Weights are calculated after the allocation and may be used, for example, to convert currency before storing the value in the target cell.