OAC DV Constraint While adding Direct Hierarchy Column into Report and Expand Different Levels.

Question

In Classic BI, when we add direct hierarchy column into report and set column heading interaction property to drill levels once we click data expands in new column as a new column. i.e., Region —> Area —> Branch… as columns.

Whereas that function doesn't exists in OAC DV, in DV we only can expand hierarchy values as new rows not column as new column.

Do we have any way to enable similar functionality in OAC DV?

Classic BI Behavior vs OAC DV Behavior.docx

Attached the Classic BI and DV differences as screenshots for reference.

++@Bala.01

Gianni Ceresa · Answer

@User_A63N1 , if you want to request that feature that is currently not available, you can do it by posting an idea for it.

https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server

You can have a look first if the idea already exist, and if it does, up-vote it. If an idea for this feature doesn't exist, post a new one.

In both cases, to support your idea and trying to get some more votes, post the link of the idea back here.

GayathriAnand-Oracle · Answer

We don't have the hierarchy drilldown feature at column header level for DV . Seems like a feature enhancement request.