The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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
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.
You can if and only if (for now)it is a grid.
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.
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 ?
