Skip to content
Apr 19 / Administrator



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


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


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:



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'

Leave a Comment

Thank you for Downloading.

Please input valid email id so that we can send you download link.

Email id Required.

We respect your privacy and never share your email id with anybody.