Skip to Content
0
Former Member
Aug 26, 2012 at 11:49 PM

BW Hierarchy Behaviour in Webi Filter

239 Views

Hi,

I'm using BI4.0 SP2 Patch 16. I'm using Profit Center in a Webi report. I have two different hierarchies for Profit Centre that I want to use in different reports.

In Webi, if I create a query filter on Hierarchy A, then all nodes below that will be returned in the query (that is, the selected node and its descendants)

If I create a query filter on Hierarchy B, then that node and one level below will be returned in the query (that is, the selected node and its immediate children)

I like how it works for Hierarchy A, and want to make hierarchy B behave in that way, so that whenever I filter by a node in the hierarchy, I get all descendants.

Note this is for a prompt, I'm not using the member selector. This is all in one BEx query. I'm using a BICS connection. I don't know much about BW hierarchies.

Any help would be great.