Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    DimNm function for IBM Planning Analytics (TM1) – Rules

      DimNm returns an element’s member ID based on an index in a dimension.

      In the video, DimNm will be used on the Year dimension to return the element’s primary name based on an index.

      Where can the DimNm function be used?

      Excel, Rules and TurboIntegrator

        Which TM1 Server version is the DimNm function available for?

        Version 11 and 12

          What is the syntax for DimNm?

          DimNm(Dimension, index)

          • Dimension = Name of the Dimension
          • Index = Index Number for Element required

          Relevant Functions

          • DFrst = Returns the first element in a dimension
          • DimIx = Returns an element’s index number in a dimension
          • DimNm = Returns an element’s primary name based on an index in a dimension
          • DimSiz = Returns the number of elements in a dimension
          • DNext = Returns the next element based on the index in a dimension
          • DNLev = Returns the number of levels in a dimension
          • DType = Returns the element type in a dimension