Connecting to Oracle BI server data sources
Yes, Oracle BI server can be used as a data source to create a data set in the BI Publisher. A newcomer to the Oracle BI might think that since the Oracle BI server RPD is accessible via Presentation services and an ODBC connection, then BI Publisher should be able to access the RPD subject areas, just as Oracle BI can. This logic is only partially correct. BI Publisher does not currently have the ability to cherry pick Oracle BI subject area elements as if using the Analysis Ad-Hoc Editor. BI Publisher has two options to reference the Oracle BI server data. The first is to select an analysis request developed in the Analysis Ad-Hoc Editor and save to the Presentation Catalog. Typically, this will be an analysis request created specifically for the purpose of being consumed in a BI Publisher report. That report is usually saved in a folder location close to the BI Publisher report that ultimately leverages the said data. The second option is to...