Excel Functions

TM1 Function – DIMSIZ

Available In

Excel

Definition

DIMSIZ returns the number of elements in a dimension.

Syntax

DIMSIZ (TM1ServerName:Dimension)

TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension

Example

Return the number of elements in the Account dimension.

In Excel:

DIMSIZ(“AdventureWorks:Account”) returns 104 elements.

Video Demo