on 06-23-2016 6:48 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Neeraj,
Thanks for your support.
I tried to represent data mentioned in your link.
the things I was not able to do :
1. Hide all the lower hierarchy when top most selected.
2. not able to link graphs accordingly with the block which could represent that particular level which is selected.
Hope I am able to Conway my message.
Regards,
Nakul Jairath
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.