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

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.