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.