Oracle EPF, EPB – Dimension Rule and Hierarchy Rule

What is the main difference between running Dimension and Hierarchy Rule?

Let us consider the example hierarchy below

For instance, if you have the following hierarchy in GL
—1110 (L)
—1120 (L)
—1210 (L)
—2110 (L)
—2120 (L)

All the nodes with (L) are the lowest level leaf nodes.
When you run a Dimension Rule, it will bring over 1110, 1120, 1210, 2110, 2120.
When you run a Hierarchy Rule with TOTAL as the starting parent value, it will bring over the TOTAL, 1000, 1100, 1200, 2000, and 2100 parent values into EPF.

In GL you can have multiple hierarchies with different top nodes. In Oracle GL, you can have one child report to multiple parents but in EPF, this is not allowed. One child can report only to one parent and the hierarchy rule will fail if there is a violation of this rule.

Leave a Comment