SUBSIZ
SUBSIZ returns the number of members in a dimension set.
Syntax
SUBSIZ(server:dimension, set)
Argument |
Description |
Required/Optional |
---|---|---|
server:dimension |
The name of the TM1® server and a dimension name. |
Required |
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. |
Required |
Example
In this example, the TM1 server name is GO_New_Stores. The function returns the number of members in the Countries Only set of the Country and Region dimension. If the set contains six members, for example, the function returns 6.
SUBSIZ("GO_New_Stores:Country and Region", "Countries Only")