Skip to main content
M
MatthieuR
Contributor
September 23, 2022
Solved

Hierarchical display in BI Viewer

  • September 23, 2022
  • 1 reply
  • 0 views

Hello All,

Is there a way to obtain hierarchical view of dimension(s) in BI Viewer components (like pivot grid) when you use Cube View MD as a source ? In other words not to have all members of dimension(s) as flat but still to have the parents of the dimension displayed as totals (as it would be displayed in a CV)

Thank you

Matthieu

Best answer by JackLacava

Hey Mathieu,

If you are on 6.6+, you can use the "Dimension to Level" property on the data adapter. Instructions can be found on the Data Adapter page of the Design and Reference Guide, just below the Cube View MD, in a section called "Dimension Leveling".

Below 6.6 we don't have a feature for that. You could theoretically dump the dimension out with the Star Schema option in BiBlend to get a SQL representation of the hierarchy, and then somehow try to be clever with that, but it would be pretty painful - which is why the feature was added.

1 reply

J
OneStream Employee
JackLacavaOneStream EmployeeAnswer
OneStream Employee
September 26, 2022

Hey Mathieu,

If you are on 6.6+, you can use the "Dimension to Level" property on the data adapter. Instructions can be found on the Data Adapter page of the Design and Reference Guide, just below the Cube View MD, in a section called "Dimension Leveling".

Below 6.6 we don't have a feature for that. You could theoretically dump the dimension out with the Star Schema option in BiBlend to get a SQL representation of the hierarchy, and then somehow try to be clever with that, but it would be pretty painful - which is why the feature was added.

    H
    hj905
    Newcomer
    April 30, 2026

    Is it possible to have the data adapter, "Dimension to Level" setting, process 2 row specifications?  When my source cube view only has 1 dimension on the rows it works as expected (shows the multiple levels of the dimension from top to bottom).  When 2 rows are on the cube view, it is only showing the levels for the outermost dimension.  The ultimate goal is a bi viewer pivot table with 2 row expansions, one for each of the 2 dimensions on the row.

    thanks,

    hj

    Terms & ConditionsAccessibility statement