Skip to Content
0

How can I filter and drilldown in a webi table

Jun 22, 2017 at 11:19 AM

57

avatar image

Hello, here is my question which has been bothering me for a few days....

I have a table with all of the fields that I need to report on- see below

However I want my report to have an initial view as follows

and then click on the country I am interested in which will filter on this country and display the next level of detail Then in turn I click on the next level and this filters and drilldowns to the third level. I've looked at the filter and drill options but, they don't seem to do it for me. Any help is greatly appreciated. Guy

image1.jpg (82.2 kB)
image2.jpg (15.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vidhya V Jun 22, 2017 at 12:42 PM
0

Hi Guy,

Are you using universe as back end?

If Yes, Then check the country object Hierarchy level in Universe and also check in scope of analysis in webi.

For more details, Please check the below URL,

https://dwbicastle.com/2014/04/07/hierarchies-and-drilling-in-bo-report/

Regards,

Vidhya.C

Show 2 Share
10 |10000 characters needed characters left characters exceeded

No I am using a BEX query

0

Then check the country object Hierarchy level in BW and also check in scope of analysis in webi.

Regards,

Vidhya.C

0
AMIT KUMAR
Jun 22, 2017 at 03:33 PM
0

have you maintained the hierarchy in BW?

check attached link.use of hierarchy objects in webi give you the similar output mentioned in link.


https://blogs.sap.com/2014/10/23/bw-hierarchy-tree-structure-in-webi-report/

Show 1 Share
10 |10000 characters needed characters left characters exceeded

this isn't a hierarchy

0