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

[former_member327592]

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

[kohesco · Accepted solution]

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

[kohesco]

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

[former_member327592]

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 ?