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