Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    SubSiz function for IBM Planning Analytics (TM1)

      SubSiz returns the number of members in a dimension set.

      In this video, SubSiz will be used to return the set ‘Leaves’ from the ‘Department’ dimension.

      Where can the SubSiz function be used?

      Excel

        Which TM1 Server version is the SubSiz function available for?

        Version 11 and 12

          What is the syntax for SubSiz?

          SubSiz(Server:Dimension, Set)

          • Server:Dimension = The name of the TM1 Server and a dimension name.
          • Set = The name of a set in the dimension. If the value of the set argument is an empty string, the value is considered ‘Subset All’.

          Relevant Functions

          • SubNm = Returns an element from a dimension set
          • SubSiz = Returns the number of members in a dimension set