Oracle Analytics Cloud and Server Idea Lab

Products Banner

Add Expand / Collapse Capability to Pivot Visualization


Organization Name

State of Maine


The pivot visualization in OBI Classic and DV does not provide the ability to drill in and out of data unless the model has a built in hierarchy or you work to set up column based interaction. I would like to see the pivot visualization allow for expand / collapse capability similar to that seen in Microsoft Excel out of the box for any returned rowset based on the query criteria.

Use Case and Business Need

Data Analyst has queried a data set and returned results. The analyst would like to create a hierarchy which allows the dashboard viewer or the collaborator to drill in / out of interesting headings. The hierarchy has not been constructed in the underlying data model. The visualization should allow this interaction much like MS Excel.

More details

It is too difficult to explore large data sets in the pivot view and drill to details.

Original Idea Number: f43de154d6

5 votes

Delivered · Last Updated