Newcomer

Drilldown ability in BI Viewer

Forum|Forum|3 years ago
April 20, 2023
4 replies
0 views

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 ?

BI Viewer

C

ckattookaran

Newcomer

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

C

ckattookaran

Newcomer

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.

S

sku571Author

Newcomer

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 ?

C

ckattookaran

Newcomer

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.