Skip to Content

Show specific hierarchy level in BEx

Hi all,

I want to build a query ( let say ) per cost centre in rows. Cost centre has 5 levels and I want to show only Level 2. When I go to cost centre and hierarchy tab in BEx, there is standard option under Display of Nodes "expand to Level 2" but it is showing me Level 1+ Level 2. Is there a way to show only Level 2 without showing upper node ?Please note that I can not add all level-2 members one by one ( like a constant selection in rows) since I will need to update the report when a new Level 2 member comes in the future.

Thank you

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 02 at 04:59 AM

    You can create for this a characteristic with the hierarchy type 'Own Implementation' (virtual hierarchy). Check note 2131675 - Sets as a virtual BW hierarchy for characteristic InfoObject modeled by customer: Example implementation

    Also check https://wiki.scn.sap.com/wiki/display/BI/Remote+hierarchy+used+for+0TCTMDXFC

    Or simply create several hierarchies and use a variable to select the one you need in the report.

    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.