Dynamic Database Connection on Report Refresh

[Former Member]

Hi,

I have a WEBI Report & Universe, which is duplicated inorder to fetch data from diff database based on each country.

i.e. If i have 3 countries (as databases are diff) for each country i have got specific Report and Universe. Same User can generate the report for diff countries.

Is there a solution to have only single report and single Universe for multiple databases? i.e. Can i switch database connection dynamically at report refresh.

All, the possible solutions are welcome (including SDKs).

Best Regards,

Anu

[MariannevL]

To add on to the previous post,

you can off course ask a user to log on with a different user if he/she wants to see a different country.

That way you can use the universe restrictions.

Another option is to bring them all into one database.

I.e. dependent on which country the source database is...

In Oracle you can use a database link to link one oracle database to another.

You can pull in a fixed country name as extra column in all these.

Its also possible to union those tables and have the user select a country in selfrestricting join.

I'm sure there are similar options for other database platforms.

Good luck,

Marianne