Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    TM1RptElisConsolidated function for IBM Planning Analytics (TM1)

      TM1RptElisConsolidated returns a boolean value if an element is consolidated. Used for Dynamic Reports (Active Form).

      In the video, the TM1RptElisConsolidated will be used in a Dynamic Report to identify elements that are consolidated and not consolidated.

      Where can the TM1RptElIsConsolidated function be used?

      Excel

        Which TM1 Server version is the TM1RptElIsConsolidated function available for?

        Version 11 and 12

          What is the syntax for TM1RptElIsConsolidated?

          TM1RptElIsConsolidated(RptRowFormula, Element)

          • RptRowFormula = an absolute reference to the formula TM1RPTROW, a dynamic Report function
          • Element = an element returned from TM1RPTROW

          Relevant Functions

          • TM1RptElIsConsolidated = returns a boolean value if an element is consolidated
          • TM1RptElIsExpanded = Returns a boolean value if an element is expanded on the row set
          • TM1RptElLev = Returns an element’s level relative to the root in the subset
          • TM1RptFilter = Apply a filter to the Dynamic report to sort the row based on a column
          • TM1RptRow = Returns the row set in a Dynamic Report
          • TM1RptView = controls the definition of the report like zero suppression and the format area
          • TM1RptTitle = Used to define the title dimension