TM1 Function for Excel, SUBSIZ
Where can the SUBSIZ function be used?
Excel
Which TM1 Server version is this function available for?
Version 11 and 12
What is the SUBSIZ function?
Returns the number of members in a dimension set.
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’.
A demonstration of how to use SUBSIZ
From the ‘AdventureWorks’ TM1 Server, return the set ‘Leaves’ from the ‘Department’ dimension.