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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book