DISAGGREGATE

Description

Disaggregates the values of the Original Node for the given Level based on the value distribution from the Distribution Node in relation to the aggregated values of the Distribution Node when rolled up to the levels of the Original Node. Can be used to redistribute values that are not available on a certain level. An example is the assignment of OPEX to products according to their revenue.

Use when you need to allocate values from a higher level to a more detailed level based on an existing distribution.

Notes

The function groups the values according to all shared levels of OriginalNode and DistributionNode. In the example given here, this is the "Year" level, and hence the distribution is applied to each year individually. If both nodes share a hierarchy but have different levels, the DistributionNode needs to have the finer level and is rolled up to match the level of OriginalNode.

Syntax

`DISAGGREGATE('OriginalNode', "Level", 'DistributionNode')`

Parameters

• OriginalNode: Input node, specified using the node name in single quotes (e.g. 'OPEX')

• Level: Level by which the OriginalNode should be disaggregated, i.e. the level which should exist on the node after application of the function (e.g. "Product")

• DistributionNode: Node by whose distribution the values of the OriginalNode should be disaggregated, specified using the node name in single quotes (e.g. 'Revenue')