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.