Selecting nodes within a hierarchy

[Former Member]

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

[Former Member]

Hi BI Experts

Your suggestions on this will be appreciated with Points

Thanks