Exploring TM1 - a Chartertech Company
Search
Close this search box.

ELPARN TM1 Function: How to Use and Syntax

ELPARN stands for Element Parent Number, in other words how many parents does an element have.

Syntax of ELPARN

The syntax is:

ELPARN(dimension, element);

Where:

  • dimension is a valid dimension name, and
  • element is the name of an element within the dimension or the name of an alias for an element in a dimension

Example of the Use of ELPARN

ELPARN ( ‘Customer’,’Freds Corner Store’);

If Fred’s Corner Store is a child in one rollup only in the Customer dimension, this will return the number 1. If, however, it was a child in two rollups (for example All Customers and All Customers by Channel), then it would return a 2.

Use at Root Level

If ELPARN was used on an element at Root level, what would it return? Well, as it has no parents (assuming it was not part of another rollup), then it would return a zero.

That is useful if you are trying to determine if an element is a root level element of not.

Notes

ELPARN can be used in both rules and TI processes.

Note this is not ELPAR!. Please see this post for ELPAR.

Do You Need Help with Elements in Rules, TI’s or Excel Worksheets?

If you have any questions on how to manage elements with either TI processes or rules, please get in touch. We’d love to help.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In