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.