Ability to Run SQL Query from BI Publisher Report — Oracle Analytics

Oracle Analytics Publisher Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Ability to Run SQL Query from BI Publisher Report

1
Views
0
Comments
Senthilrajan V
Senthilrajan V Rank 5 - Community Champion

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

1
1 votes

Submitted · Last Updated