Selecting Hierarchy at runtime

[Former Member]

Hi,

I have 2 hierarchies (HIER1, HIER2) created on InfoObject (IO1). In the query we had used this InfoObject in the free characteristics.

Our requirement is when the user drill down on this InfoObject, User should able to see the data without the hierarchy. But, when he right click on the InfoObject & activate the hierarchy, he should have the option of selecting the hierarchies (HIER1 or HIER2).

Can anyone please help me in resolving this.

Regards

Ramesh Ganji

[Former Member]

<FONT FACE = "Tahoma", Font Color = "Blue">

Hi<br>

I think it should be simple to achieve this.<br><br>

1, In the Query Designer, Open your Query. Right click on your IO1 and select Restrict <br>

2. Restrict it to both the Hierarchies HIER1 and HIER2 and select OK<br>

3. Right click on your IO1 and select Properties <br>

4. In the section <b>Display Hierarchy</b>, <u>do not</u> tick the checkbox Active. This will ensure that the Hierarchy is not Active by default when somebody executes the report<br>

5. But your other requirement of activating the hierarchy and selecting it on execution should be fulfilled<br>

<br><br>

Hope it helps.<br>

Cheers Abhijit</FONT><FONT FACE = "Verdana", Font Color = "Red">

• Please assign Reward Points if I deserve it in your opinion

</FONT>