Is it Possible to Create a New BI Publisher Report From a SQL Query?
(Doc ID 2887421.1)
Last updated on AUGUST 05, 2022
Applies to:Oracle Primavera Cloud Service - Version 20.12 and later
Information in this document applies to any platform.
When trying to create a new BI Publisher report from a SQL Query there is no Data Source listed in the drop-down.
1. In OPC select Reports -> Report List
2. Create a new report
3. Under Layouts click Add
4. BI Publisher will open
5. Create a Blank report
6. Click New -> Data Model
7. Click Data Sets and then add a SQL Query
8. In the popup window no Data Source is available
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document