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’.

Video Demo