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, element 2); 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.

This entry was posted in Rule Functions, TI Functions and tagged ELISANC, IF. Bookmark the permalink.

3 Responses to "ELISANC TM1 Function: Use and Syntax"

Log in to post a comment.