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

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

A demonstration on how to use DIMIX

From the Account dimension, return the index for the member ID 10 and show that DIMIX works if an alias, Assets, is used too.