cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hope this document should be able to help you.

Regards

Niraj

Former Member
0 Kudos

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