<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

CellValueS function for IBM Planning Analytics (TM1)

    CellValueS returns the string value of the specified element in a specified cube.

    In this video, CellValueS is used to retrieve the string value from cube and apply it in the rule to populate the Comment measure in the Product Scorecard cube. 

    Where can the CellValueS function be used?

    Rules

      Which TM1 Server version is the CellValueS function available for?

      Version 11 and 12

        What is the syntax for CellValueS?

        CellValueS(Cube, element1, element2…..)

          Relevant Functions

          • CellValueN = Returns the numeric value of the specified element in a specified cube
          • CellValueS = Returns a string attribute for a specified cube