TM1 Function for Excel, DIMIX

DIMIX returns an element’s index number in a dimension.

**Where can the DIMIX****function be used?**Excel, Rules and TurboIntegrator

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

Version 11 and 12

**What is the DIMIX****function?****DIMIX** returns an element’s index number in a dimension.

**What is the syntax for DIMIX?**DIMIX(TM1ServerName:Dimension,Element)

TM1ServerName = Name of the TM1 Server

Dimension = Name of the Dimension

Element = An element in the dimension. Can be alias or Element

**DIMIX****A demonstration on how to use**From the **Account** dimension, return the index for the member ID **10** and show that DIMIX works if an alias, **Assets**, is used too.