DIMIX

DIMIX returns the index number of an element within a dimension.

This function is valid in TM1® rules and TurboIntegrator processes.

Syntax

DIMIX(server_name:dimension, element)

Argument	Description
dimension	A valid dimension name qualified by the database name.
element	The name of an element within the dimension. If the element is not a member of the dimension specified, the function returns 0.

Argument

Description

dimension

A valid dimension name qualified by the database name.

element

The name of an element within the dimension.

If the element is not a member of the dimension specified, the function returns 0.

Brazil has an index value of three in the Region dimension. The example returns 3.

DIMIX('planning_sample:Region','Brazil')