CellPutProportionalSpread

Description:

Distributes a specified value to the leaves of a consolidation proportional to existing cell values.

Syntax:

CellPutProportionalSpread(value, Dim1Element, Dim2Element [,?DimNElement]);

Arguments:

value - numeric value which you want to spread proportionally
Cube - The name of the cube
Dim1Element, Dim2Element [,?DimNElement] - Dimension elements which define that cell.
Important - Remember that these dimension elements should be in the same order as in the cube. So if a cube has Products, Months and Calculation dimensions in order; function should first use element from Products, then from Months and then from Calculation dimension

Return Type:

Nothing

Example:

CellPutProportionalSpread(5000,'Revenue', 'Budget', 'America', 'Cars', 'Sales', 'Jan');
This will distribute value 5000 in Revenue cube across all children of consolidations: 'Revenue', 'Budget', 'America', 'Cars', 'Sales', 'Jan'