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’.