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.