LEAF function with Hierarchies

[Former Member]

We have a hierarchy in our columns and we want values calculated at the child level and then added at the parent level.

The child values should equal (X / Y) but the parent values should add the results of the children (child1 + child2).

What is happening is that we are getting (child1 X + child2 X) / (child1 Y + child2 Y) for the parent value.

We are trying to use the LEAF function to remedy this; however, it doesn't seem to be working. Any thoughts?

[Former Member]

This is one of the old BW problems and the answer is still the same I had to use back in BW 2.0A in 2000.

1. Store X/Y directly in the InfoCube. Then you can aggregate normally and get the right values.

2. Calculate X/Y as virtual key figure. Virtual key figures are key figures that are calculated at runtime and not stored in the cube. To create virtual key figures use the BAdI RSR_OLAP_BADI.

Best regards

Dirk

[Former Member]

Hi Jessika,

Sorry this not regarding the solution for your problem.

But i do have a doubt in Hierarchy creation.

It would be greatly appreciated if you can help me in this.

We want to create a customised hierarchy which as final drilldown to Producthierarchy and then to material level.

The initial nodes would be custom objects with master data and Does the drill drill down levels need to be defined as the attributes of first node in order to see the drilldown in report?(i just see the top node discription in the final report)Am i doing something wrong?

Please let me know.

Thanks,

Haarika.

Is there any documentation on such issue?

[Former Member]

Hi Haarika,

Unfortunately, I do not know the answer to your question.