Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to Run SQL Query from BI Publisher Report
Description
Creating a BI Publisher Data Model that can dynamically accepts SQL query from a BI Publisher Report. passed as a Parameter from Report.
Use Case and Business Need
With no direct access to Fusion cloud database and with announcement from Oracle on retirement of OTBI direct query option. Technical and Functional team have challenges in making some simple query for validating the data and fixing defects in Fusion Application. So if we can have an option in BI Publisher that can have a data model that shall accepts requests from BI Publisher Report that can dynamically pass the SQL from the report (like SQL queries in the Report prompts).
Data model has limitation of maximum record outputs of 200.
Or Oracle should re-consider limiting 200 records maximum from a data model query.
Original Idea Number: 9c8d93e5fb