Forum Discussion

sku571's avatar
sku571
New Contributor II
2 years ago

Drilldown ability in BI Viewer

In BI Viewer,  Is it possible to drilldown to the base level members using Pivot Grid within the same dimension. Like if I pull Entity dimension in a row then is there any way to drill down to the base level members ?

Also, Can filters list out the members in a hierarchical /tree format?  Generally combo box/list/tree map displays it in a flat structure so is there any alternative way to achieve it ?

  • What are you trying to achieve? Give an option as a hierarchy for the users to pick a member and show some report?

    There is member tree component in dashboards. However, without knowing what you are trying to do there is no point in keep suggesting stuff. 

  • If you are looking for a hierarchy way, then use either the regular pivot grids or large pivot grids and add the parent and the child in rows and it'll automatically do the magic. 

  • sku571's avatar
    sku571
    New Contributor II

    Thanks . I have tried that option but there are almost 12 levels in our entity structure so is there any easy/simple way to

    achieve it using sql query or cubeview ?