DIMIX TM1 Function: Use and Syntax

DIMIX checks if an element exists in a dimension and if so, returns the index value of the element. If there is no element for the value being tested, it will return a 0.

Syntax of DIMIX

The syntax is DIMIX (dimension, element); where

  • Dimension, is the name of the dimension you want to check
  • Element, is the name of the element you are checking to see if it already exists

Use and Example

This function is quite often used with an IF statement to check if an element exists in the form of IF ( DIMIX (‘Year’, sYear ) = 0); This statement will check if the contents of the sYear variable exists in the Year dimension.  If variable sYear is not in the Year dimension then the DIMIX will return 0.  This is then compared to “0” in the IF statement which gives a true answer.

From here you could add a DimensionElementInsert to add the element if required.

This function can be used in Rules and Turbo Integrator processes.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

This entry was posted in Rule Functions, TI Functions. Bookmark the permalink.

4 Responses to "DIMIX TM1 Function: Use and Syntax"

Log in to post a comment.