TM1 Function for Excel, DIMSIZ

DIMSIZ returns the number of elements in a dimension.

**Where can the DIMSIZ****function be used?**Excel

**Which TM1 Server version is this function available for?**

Version 11 and 12

**What is the DIMSIZ****function?****DIMSIZ** returns the number of elements in a dimension.

**What is the syntax for DIMSIZ?**DIMSIZ (TM1ServerName:Dimension)

TM1ServerName = Name of the TM1 Server

Dimension = Name of the Dimension

**DIMSIZ****A demonstration on how to use**Return the number of elements in the **Account** dimension