Embedding DV Workbook in BI Answers Classic Dashboard - Row Count Safeguard Gap (OAS 2025)

Dhaval Parikh Stantec

Hello Community,

We are currently on Oracle Analytics Server 2025 and using both the Modern DV platform and BI Answers Classic. We have a requirement to embed a DV Workbook inside a Classic BI Dashboard page.

Our DV Workbook is built on top of a Subject Area (RPD-based), not a direct database dataset.

The Challenge:

In BI Answers Classic, we have an established governance standard where we run a row count check (COUNT(*)) before executing any report query. If the row count exceeds our defined threshold, the query is suppressed and the user is shown a message to refine their filters. This safeguard is implemented using the XML-based request model that Answers operates on.

When we embed the DV Workbook into the Classic Dashboard, this safeguard breaks down because DV operates on a JSON-based engine. The XML-layer row count checks we use in Answers cannot intercept or gate DV queries.

Is there a native OAS 2025 mechanism within the DV platform other than setting Max Rows and Max Time at the Subject Area level in the RPD to act as a hard ceiling for all queries regardless of origin (Answers or DV) and then using RPD Role-Based Override for DV Authors?

Any guidance, documentation references, or real-world implementation experience would be greatly appreciated.

Thank you.

RVohra

@Dhaval Parikh Stantec , I liked your approach of checking the row count and making sure that it is under the threshold before executing the report query. I do not think there is any native mechanism in DV platform besides Max Rows and Max Time. Thanks