Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    TM1RptTitle function for IBM Planning Analytics (TM1)

      TM1RptTitle is used to define the title dimensions for a Dynamic Report. TM1RptTitle is used in conjunction with TM1RptView.

      In the video, you will learn where TM1RptTitle is used in a Dynamic Report.

      Where can the TM1RptTitle function be used?

      Excel

        Which TM1 Server version is the TM1RptTitle function available for?

        Version 11 and 12

          What is the syntax for TM1RptTitle?

          TM1RptTitle(TM1ServerName:Dimension, Element)

          • TM1ServerName = Name of the TM1 server
          • Dimension = Name of the Dimension
          • Element = a cell reference to an element that exists in the Dimension. The reference must be to a SUBNM.

          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