04-20-2023 03:14 PM
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 ?
04-20-2023 03:45 PM
You can if and only if (for now)it is a grid.
04-20-2023 03:46 PM
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.
04-20-2023 03:52 PM
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 ?
04-20-2023 06:41 PM
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.