Skip to Content

Filter on Webi hierarchy does expand to lower node using Bex or Hana

Hello experts ,

Need your help. .

I am using Webi hierahcy using Bex . We need to diplay only certain nodes in the hierarchy so once Webi report is executed(In screen1) , I have filtered the nodes that we need(In screen2) using filter option on the right click . Once filtering on required nodes is done , the report is executed but the filtered nodes are collapsed and not able to expand(In screen 3) even after click on + button.

Is there any way to get these nodes expanded please ?

Any advice greatly appreciated .

Thanks

screen1.png (8.0 kB)
screen2.png (26.7 kB)
screen3.png (4.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 05, 2018 at 06:16 AM

    Hi

    because your filter in screen 2 is only those 2 nodes, if you want to see all below , you will need to select as well all below

    Koen

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 05, 2018 at 01:02 PM

    Thanks Koen for your response.

    In Bex, if we select nodes , automatically nodes and all below 'll display automaically . Is there a way in WEBI to function the same.

    If i select nodes and all below manually in WEBI, it works fine but in future , if these nodes changes in the source(ECC) or new items added to the hierarchy then 'll it pick up automatically or do we need to manually update the filters in WEBI each time hierarchy changes happen ?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 05, 2018 at 01:18 PM
    best way to filter those hierarchies is to do this in query panel level, you can make settings like you want, on report panel level you can not

    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.