Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Embedding DV Workbook in BI Answers Classic Dashboard - Row Count Safeguard Gap (OAS 2025)
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.
Answers
-
@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
0
