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.