Drill in BW hierarchy level in webi based on input control selection

[Former Member]

Hello Experts,

I have a requirement in Webi. The Webi report is based on BW hierarchy and it is using hierarhcy both in the report output block and also in the report prompts. We are are BI 4.0 SP5,Patch 6. The report has input controls in it based on the BW Hierarchy. When the report is first executed,the user can drill down the hierarchy by clicking on the "+" nodes to the max level as shown in the screenshot below.

Now, when the user selects an input control, the data gets filtered but the hierarchy level automatically expands. In other words, when they select a data hierarchy  showed in the input control the hierarchy in table is shown expanded and they want to see the  hierarchy in the table close automatically.

So ideally its like this when a value from input control is selected.

Whereas the user wants it to be like this automatically on selecting a particular value from the input control and not in expanded form.

I'm aware of the Hierarchy depth function but that only takes us to a particular node based on depth and then doesn't allow further drilling after that.

Is there any setting in webi/bex about always keeping all sub nodes closed to prevent this expansion on selection of input control?

Thanks and regards,

Abhishek

[Former Member · Accepted solution]

Just did some research on on this and the SAP best practice: The question itself is logically incorrect.

A report/table filter where there is a hierarchy may remove rows without respecting the hierarchy structure. For this reason, a filter can remove a parent node currently expanded and keep leaves or

  nodes collapsed. To avoid returning an empty table in this case the system automatically expands the hierarchy in the block to shows the resulting members

Thats why it automoatically expands the hierarchy.

Closing this thread. Thanks.