Dynamic Database Connection on Report Refresh

[#1]

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

[Former Member]

But this solution will work, only if data resides in single database. Please correct if i'm wrong.

In this case, there exists different database for each country.

[Former Member]

Yep...!!

See Anu,

To do the same stuff available options are:

1. Introducing ETL

2. Waiting for BO XI4.0

Which we can't solves our problem as of now.

Alternative is:

-->> Using Multiproviders for Reporting.

Steps:

-->> As I told you in my prior posts, implement Filter(Prompt) for all Universes what you have, it may be on top of Oracle or SQL Server or DB2 or any.

-->> In Query panel, Use all dataproviders to get Report data. Here, it will Prompt for each Universe COZ you have applied for all.

-->> As you need single Report, Develop it based on Requirements spec and to accomplish it, you have to use "Merge Dimensions" to see summerized data that is coming from multiple dataproviders or DB's.

-->> If User is having valid rights then he/she can able to get data for the Countries. Otherwise he/she can see data only for which DB/DP he/she has access rights.

I hope you got my logic.

Thank You!!

[former_member142702]

You can use the Data Federator, include in it tables from all related databases and use in your universe the @variable('BOUSER') and/or the prompt() commands in order to retrieve the data from the appropriate table.

Federation will be part of the generic universe functionality in BO XI 4.0 still I am not sure if the functionality you require will be covered. As far as I know there ill be also an XI 4.0 version for the Data Federator product.

Regards,

Stratos

Edited by: Efstratios Karaivazoglou on Oct 6, 2010 11:36 PM

Edited by: Efstratios Karaivazoglou on Oct 6, 2010 11:37 PM