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]

You can implement Row-level security at Universe level, so that User who looged into Infoview and accessing Universe & WebI can see the data as per his/her access rights defined.

So far one can use Universe for one datasource. To implement what you are expecting from BO, to use multiple data providers for single Universe, we have to wait for some time, until next release of BO.

I think, you can use ETL process to get data from multiple data sources and on top of target database you can design your Universe.

Thank You!!

[former_member142702]

The product is already avaialable and it's called Data Federator.

Regards,

Stratos

[Former Member]

Hi Guys,

Thank you all for the quick response.

Unfortunately these solution doesn't work in my case.

I cannot use DB links due to security restrictions in my firm. Nor I can load the data from multiple database to a single DB, and point my universe on that. Single User should be able to generate reports on multiple countries, hence i cannot use Universe restrictions also.

Currently, in XI R2 we have seperate Report & Universe for each country. We need a solution as maintenance is a big headache and we are migrating to XI R3.

I'm now left out with SDK, by which i can point Universe to diff database connection on report generation. Please help me with the below queries:-

1) Can I use SDK (to reset DB connection), while refreshing Report from InfoView? If so how to call the Program Object from the WebI Report on refresh?

2) If not, Do I have to go by end to end SDK implementation for Report refresh using SDK?

3) Any idea, when SAP will provide this feature (point Universe to multiple DB)?

Thanks again,

Best Regards,

Anu

[Former Member]

Anu,

You have no choice.

Answers to your qns:

1. Nope.

2. Nope

3. After couple of months.

As of now, i can suggest the same. Implementing Row-level security at Universe level and Prompts (Predefined filters) for User and Country. which reduces maintanace effort and User will get a flexibility to choose Country what he/she needs to see the data Or create Prompts at query/report level, And at the same time he/she can save the Reports to Excel/PDF for analysis as well.

Hope you got me.

Thank You!!

[Former Member]

Hi All,

Thanks for the quick reponse.

Hi BOCP-BOE,

Same user can generate the report for various countries (diff universe & diff databases). Hence can you please elaborate on

how to implement, Row-level security at Universe level and Prompts (Predefined filters) for User and Country.

Thanks again,

Anu

[Former Member]

Use @Variable(BOUSER/BOPASSWORD) , to validate whether User has access to Universe or nor and at the same time how much rights he/she has to retrieve or see the data.

Use Filter icon at Universe to create Prompt Filter for the same and apply it on Universe.

If you have , User table and Country table, join them based on fields you have to validate whether the User is member of that Country or not.

Thank You!!