ELCOMPN TM1 Function: Syntax and Use

The ELCOMPN function in TM1 is used to derive number of an child elements of a parent.

Syntax

The syntax is:

ELCOMPN(DimName, Element)

where:

  • DimName is the dimension you are evaluating,
  • Element is the element you want to know how many children it has

Example of ELCOMPN

For example we have the following structure:

  • 2021
    • 2021 Period 1
      • Week 1 2021
      • Week 2 2021
      • Week 3 2021
      • Week 4 2021

When evaluating 2021 Period 1, we would return 4 as the number of children that it has.

This would be written in a rule as:

ELCOMPN('Time', !Time)

So when the rules hit 2021 Period 1, a rule would return the value of 4.

In a Turbo Integrator Process

We have a great write up of the use of ELCOMPN in a Turbo Integrator process in our post on using a TI to unwind a dimension. You’ll find it here.

Notes re ELCOMPN

ELCOMPN can be used in both Turbo Integrator processes and TM1 Rules.

See ELCOMP to find the element at a specific position as the child of a parent.

See this post about how we can use a combination of ELCOMP and ELCOMPN to find the “as at” balances of elements, rather than just rolling them up. For example, with inventory balances.

ELCOMPN can also be used in Planning Analytics for Excel reports. Please see this post for information on how you can use it in PAX.

You might also like