Skip to content
Apr 19 / Administrator

CellGetS


Description:

Retrieves a value from a string cube cell.


Syntax:

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


Return Type:

String value which exists in that cube cell


Example:

CellGetS('Employee', 'Manager', 'EmployeeName');
We have a cube Employee with 2 dimensions: Designation and Details.
Above function will return the EmployeeName of Designation Manager from Employee cube



3 Comments

leave a comment
  1. Abdul / Aug 15 2013

    “CellGetN(‘Employee’, ‘Manager’, ‘EmployeeName’);
    We have a cube Employee with 2 dimensions: Designation and Details.
    Above function will return the EmployeeName of Designation Manager from Employee cube

    I think it should be CellGetS not CellGetN

    • Administrator / Aug 15 2013

      Sorry about the typo buddy… thanks for letting us know. The error has been corrected.

  2. Abdul / Aug 15 2013

    I think it should be CellGetS not CellGetN

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.