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

ELWEIGHT TM1 Function: How to Use, Syntax & Example

Ever wondered how you can use the weight assigned to an element in a hierarchy in a rule or turbo integrator process? Well, ELWEIGHT allows you to do just that!

Syntax of ELWEIGHT

The syntax of ELWEIGHT is:

ELWEIGHT(Dimension, parent, child)

where:

  • Dimension is the name of the dimension you are checking.
  • Parent is the name of the consolidation element in Dimension
  • Child is the element you want to find the weight of as it rolls up to Parent.

Example

A simple example of ELWEIGHT is as follows.

You have a hierarchy for GL accounts. In it you have Revenue and Cost of Sales rolling up to Gross Profit. Both have positive values, but you want Gross Profit to be the net of the two, so in essence, Revenue – Cost of Sales. To achieve this you set the weight of Cost of Sales, in the hierarchy that rolls up to Gross Profit, to be minus 1.

Then you might want to use the weight to multiply the values by the weight, so you create a rule using ELWEIGHT that says something like:

['Value (No Weight)'] = N: ['Value'] * ELWEIGHT ('Account', 'Gross Profit', !Account);

The only problem with this is what happens to the accounts below Gross Profit?

Example of ELWEIGHT with ELPAR

To overcome this we could insert an ELPAR in place of the ‘Gross Profit’ in the rule above. The ELPAR will extract the parent from the rollup and allow it to be used to derive the weight using the ELWEIGHT. It might look something like this:

['Value (No Weight)'] = N: ['Value'] * ELWEIGHT ('Account', ELPAR ( 'Account', !Account, 1), !Account);

Usage

This function can be used in both Rules and Processes.

  • 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