Skip to Content

How can I filter and drilldown in a webi table

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 22, 2017 at 12:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 22, 2017 at 03:33 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded