Skip to Content
Former Member
Jun 23, 2016 at 05:48 AM

Represent herarchies in data but when we select any level it should display that level only else every thing should be hidden


I was wondering if it is possible to achieve getting a hierarchical view on my webi report without establish such herarchies on my backend, and create that behavior on my front end, I don't have access to the back end so I'm only able to obtaining the values as attributes when the query is been design, therefore it prevent me to create a hierarchical behavior on my report. We are using BEx Query as a data source.

At highest level of hirarchy I have Segment which gives me data like IT, BPO, INFRA.

at second level I have the breakup of Department groups like domestic and global.

similarly I have 3rd level i have braeakup of groups .

I have charts displaying revenue from perticular segment.

My task is to show highest most in hirarchy first as a display page and nothig else to be shown and its graphs but when I selet any of the segment like "IT" then it should display data in cross tab with IT and graphs only showing data for IT similarly if I select any department group then it should go to 3 rd level.