Switching Data Sources Dynamically

Question

Summary

Content

Hey Gurus,

BIP 12c Oracle Business Intelligence 12.2.1.2.0

DB - oracle 12c

We have multiple DBs for multiple distributors. The tables are common.

Requirement is to switch between DBs dynamically. Is there a way to have a drop down of sources where in the user can select the sources and the reports point to a certain DB. they have a custom made reporting system which does this

What are the alternatives to give users this functionality.

Please see if you can figure something out

Regards

Maraprik · Answer

Thanks Brajesh,

I will try this and get back to you. Appreciate your response.

Maraprik · Answer

Hey Brajesh,

thanks for the response.

can you please elaborate on the

'

4. In the before report trigger execute the sql using DBLINK and populate one global temporary table

5. Create Data set for that global temporary table where you can pick the records.

'

I did not completely understand this.

Regards

Brajesh Shukla-95078 · Answer

Hi ,

I was talking about the event triggers in BI Publisher. Using the trigger you can register the database package. and in the database package you can select data from different data sources and populate one singe global temporary table and use that table to show the data in report. Hope I am clear now?

https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/add_event_trig.htm#BIPDM334