Ability to Expand/Collapse the Pivot table Rows like image shown

Rajakumar Burra

In OAC, when we add fields to Rows , they are display as seperate columns and and each value as Row.

If we have option to show to Expand/Collapse will be more useful. It will save space and have good UX.

Vladimir Mazunin-Oracle

This is such a desperately needed feature that's always been available in Classic OBIEE.

Patrick Northcraft

Agreed. Having it in pivots (not just for pre-defined hierarchies) would be a great help.

Bret Grinslade - Oracle Analytics-Oracle

Does the Row Expander extension help here?
https://www.oracle.com/business-analytics/data-visualization/extensions/

Patrick Northcraft

@Bret Grinslade - Oracle Analytics-Oracle is this compatible for the latest version of OAC? The documentation looks a little dated and only mentions Data Visualizer.

Rajakumar Burra

@Bret Grinslade - Oracle Analytics-Oracle Extension is very basic and some temporary kind of workaround. Requirement is similar to this with all capabilities of Visualizations.

Sarah Sazdar - Oracle

If you are not a BI Service Administrator then you would not be able to download this custom visualization extension. I really think this Visualization feature (being able to expand/collapse) could be helpful for DV Workbook performance reasons as well. For example, if the report opens with the Pivot table collapsed then it can be expanded to show more if the users needs that level of detail at that time. This would make the Visualization less overwhelming (for lack of a better term) as well.