ELISANC TM1 Function: Use and Syntax

ELISANC stands for ELelemnt IS ANCestor, in other words, is one element in a dimension an ancestor of another. In other words, it is testing to see if one element is the child of another and return either a 1 if it is true or a 0 if false.

Syntax of ELISANC

The syntax is:

ELISANC (dimension, element1, element2);

where you are testing if element1 is the ancestor of element2 (i.e. higher in a hierarchy) in the dimension.

Usage

For example, ELISANC (‘Month’,’Full Year’,’Jan’) will return 1 for true if “Jan” is a child of “Full Year”.  If (for whatever reason) “Jan” was not a child of “Full Year”, the expression would return 0.

It often used inside an IF statement to determine if one element is an ancestor of another specific element and then if so, to execute a specific command or rule.

This function can be used in both TM1 Rules and TI 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.

3 comments on “ELISANC TM1 Function: Use and Syntax

  1. Would love to see it as a native TM1 Excel formula for reports too one day #TM1

This site uses Akismet to reduce spam. Learn how your comment data is processed.

/* THIS WAS THE CODE USED FOR EMBEDDING A SURVEYMONKEY POPUP */