Skip to main content
Newcomer
Apr 20, 2023 7:14 PM UTC

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 ?

4 replies

Member
Apr 20, 2023 7:45 PM UTC

You can if and only if (for now)it is a grid.

Member
Apr 20, 2023 7:46 PM UTC

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. 

sku571Author
Newcomer
Apr 20, 2023 7:52 PM UTC

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 ?

Member
Apr 20, 2023 10:41 PM UTC

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.