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.