Excel Functions
TM1 Function – DIMIX
Available In
Excel
Definition
DIMIX returns an element’s index number in a dimension.
Syntax
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
Example
From the Account dimension, return the index for the member ID ’10’ and show that DIMIX works on an alias too.
In the Account dimension, ‘Assets’ is the alias for member ID ‘10’.
In Excel:
DIMIX(“AdventureWorks:Account”,”Assets”) returns index ‘6’.
Using ‘10’ as the element also returns the same result.
DIMIX(“AdventureWorks:Account”,”10″) also returns index ‘6’.