Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BI 4.1 webi report based on BEx query hierarchy issue

Hi all,

I have a webi report based on Bex query, in bex query there are 3 mandatory variable and 1 optional. Into the report I build a query and then I select one hierarchy,I select all members, and one measure. The report works but it for the hierarchy it shows all node of the structure also the node that are defined as Hide always into the query bex.

For example:

Bex hierarchy:

Node 1 visible

node 2 visible

node 3 hide

Webi report shows all 3 nodes and not only the node 1 and 2. Why?

SAP BI 4.1 SP5

Thanks in advance

Former Member
Former Member replied


I check the BW hierarchy and I see that:

Node AAA: visible

Node BBB: always hide

     Node BBB1 visible

      Node BB2 visible

Node CCC visible

Node DDD always hide.

In the webi report the hierarchy shows the nodes:






node DDD is missing as I want.

The problem may be the visibility of the leaf bb1 and bb2?

I confirm in BI 4.1 SP 5 if a root is hidden and the leaf no in the webi report I can see the leaf, in BO4.0 this doesn't happen.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question