CellPutN
Description:
Writes numeric value to a cube cell
Syntax:
CellPutN(numVal, Cube, Dim1Element, Dim2Element [,?DimNElement]);
Arguments:
numVal - numeric value to write to cube
Cube - The name of the cube from which you want to retrieve a value.
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:
CellPutN(15, 'Sales', 'ProductName1', 'Jan', 'Quantity');
Loading ...
Code to accumulate the cube values:
oldVal = CellGetN(‘Sales’, ‘Product1′, ‘Actual Version’, ‘Jan’);
newVal = NVALUE + oldVal;
CellPutN(newVal, ‘Sales’, ‘Product1′, ‘Actual Version’, ‘Jan’);