SUBSIZ function#

SUBSIZ returns the number of elements in a subset - useful for sizing a subset-driven range.

The function name is SUBSIZ, not SUBSIZE. Reportworq registers this function under the classic TM1 spelling SUBSIZ (no trailing "E"). SUBSIZE does not resolve.

SUBSIZ is a native TM1 / Planning Analytics function.

Signature#

=SUBSIZ("Server:Dimension", subset)

Arguments#

#	Argument	Type	Required	Permitted values and notes
1	`Server:Dimension`	String	Yes	`"server:dimension"`.
2	`subset`	String	No	A named subset. Omit it, leave it blank, or pass `"All"` to count the whole dimension.

SUBSIZ takes one or two arguments. The default result is 0. Omitting or blanking the subset assumes the "All" subset and logs an informational warning.

What happens when an argument is wrong#

For the shared error model and the Calc Mode effect, see how Reportworq handles errors.

Situation	Result
More than two arguments	Hard error
No arguments	Warning, the cell returns blank
A blank or omitted subset	Counts the whole dimension (informational warning)
The subset is not found	Warning, `0`

Examples#

=SUBSIZ("PlanTM1:Region", "Active Regions")
=SUBSIZ("PlanTM1:Region")

IBM Planning Analytics functions - the function index and the shared error model.
DIMSIZ function - the number of elements in a whole dimension.
SUBNM function - return an element from a subset by index or name.

Feedback on this page

Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.

Email feedback on this page

Or write to support@reportworq.com directly.