Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    IsLeaf function for IBM Planning Analytics (TM1)

      IsLeaf determines if an element is a leaf element or not.

      In this video, IsLeaf is used to check if an element is a leaf element or not and apply it in the rule to populate the Product Scorecard cube.

      Where can the IsLeaf function be used?

      Rules

        Which TM1 Server version is the IsLeaf function available for?

        Version 11 and 12

          What is the syntax for IsLeaf?

          IsLeaf 

          Relevant Functions

          • DB = Retrieve a value from a cube cell
          • IsLeaf = Determines if an element is a leaf element or not
          • IsUndefinedCellValue = Compares the argument value with the default numeric cube value and returns 1 if the cell value is equal to the cube’s default value
          • Undef = Returns the undefined value
          • UndefinedCellValue = Returns the default numeric cube value
          • UndefVals = Changes the default value for the cube from zero to a special undefined value