Skip to Content
author's profile photo Former Member
Former Member

LEAF function with Hierarchies

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2004 at 07:21 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2004 at 08:59 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.