## TM1 Function for Excel, DIMSIZ

### DIMSIZ returns the number of elements in a dimension.

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

**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