Skip to content
Apr 19 / Administrator

CellGetN


Description:

Retrieves a value from a numeric cube cell.


Syntax:

CellGetN(Cube, Dim1Element, Dim2Element, ... ,DimNElement);


Arguments:

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, CellGetN should first use element from Products, then from Months and then from Calculation dimension


Return Type:

Numeric value which exists in that cube cell


Example:

CellGetN('SalesCube', 'ProductName1', 'Apr', 'Revenue');



One Comment

leave a comment
  1. Code Snippets / Apr 28 2012

    Code to accumulate the cube values:

    oldVal = CellGetN(‘Sales’, ‘Product1’, ‘Actual Version’, ‘Jan’);
    newVal = NVALUE + oldVal;

    CellPutN(newVal, ‘Sales’, ‘Product1’, ‘Actual Version’, ‘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.