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

    DimSiz function for IBM Planning Analytics (TM1)

      DimSiz returns the first element in a dimension.

      In the video, DimSiz will be used to return the number of elements in the Account dimension

      Where can the DimSiz function be used?

      Excel, Rules and TurboIntegrator

        Which TM1 Server version is the DimSiz function available for?

        Version 11 and 12

          What is the syntax for DimSiz?

          DimSiz(TM1ServerName:Dimension)

          • TM1ServerName = Name of the TM1 Server
          • Dimension = Name of the Dimension

          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