Selecting nodes within a hierarchy
Greetings BI Experts
(We are on BI 7.0 SP - 14)
Here is my problem,
I have loaded 2 different hierarchies for 0COSTCENTER H1 and H2.
In BEX 7.0, I have dragged 0COSTCENTER on the Rows Section and from the right side of the Properties section I have checked the Box for Acitvate Hierarchy Display
I created a variable on the 0COSTCENTER Hierarchy and when I run the query it allows me to choose one of the 2 hierarchies.
The problem here is that the user not only wants to select one of the 2 hierarchies but also a node/child within the hierarchy.
If I create a variable on one of the Hierarchy I can choose the nodes within the Hierarchy which I dont want
Can you all please give your suggestions ...will appreciate with maximum points