TM1 Function for Rules, DIMIX

DIMIX returns the index of the dimension’s element

Where can the DIMIX function be used?

Excel, Rules, TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the DIMIX function?

DIMIX returns the index of the dimension’s element 

What is the syntax for DIMIX?

DIMIX(DimName, Element) ​
DimName = Dimension Name ​
Element = Element Name

A demonstration on how to use DIMIX

In the System info cube, we will use ‘Numeric’ measure to retrieve the index of each element of the dimension System Info Parameter.