How to disable "Drill to Attribute/Hierarchy" while keeping the predefined hierarchy drill-down

Question

Hi everyone,

We have a Data Visualization workbook using a predefined hierarchy in the Semantic Model.

Our requirement is to:

* Keep the standard hierarchy drill-down enabled, so users can navigate through the predefined hierarchy levels
* Disable only the "Drill to Attribute/Hierarchy..." option available from the visualization context menu, so users cannot add arbitrary attributes outside the predefined drill path

We reviewed KB100396 - How To Disable the Drill To Option for an OAC DV. However, applying this configuration also disables the standard hierarchy drill-down, which we need to preserve

Essentially, we are looking for the following behavior:

Predefined hierarchy drill-down → Enabled
Drill to Attribute/Hierarchy... → Disabled

Is there any supported configuration in OAC to control these two drill capabilities independently?

Alternatively, is it possible to restrict a visualization so that users can drill only through the predefined hierarchy and up to a specific hierarchy level, without allowing additional attributes to be introduced through "Drill to Attribute/Hierarchy..."?

Any suggestions or supported workarounds would be appreciated.

Thanks!

Jacopo Giacco · Answer

Thank you @Mohammed Rafi for your comment.

Yes I confirm that we already tested the steps listed in your comment, but this is not the solution that we are looking for. The problem is that the Hierarchy navigation should be permitted, but the report should prevent to report at person level. I will create an idea for this.

Thank you

Mohammed Rafi · Answer

Hi Jacopo,

Your requirement is to retain the navigation defined in the Semantic Model while preventing users from extending the drill path to arbitrary attributes. Ideally, this should be controlled independently rather than by disabling drilling altogether.

The Drill action in the visualization menu. You can configure it under:

* Open the workbook and select Preview → Configure Presentation.
* Go to the Workbook tab.
* Under Visualization Actions → Visualization Menu, deselect Drill.
* Save and test the workbook.

Below is the document which would be helpful

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/specify-workbook-visualization-actions.html

However, because you have already tested KB100396 and found that its configuration disables both capabilities, I would not assume that this presentation setting will preserve hierarchy drill-down in your particular OAC version without testing it.

Thanks,

Mohammed Rafi