Skip to Content
Jan 20, 2017 at 05:31 PM

Changing universe db connection before invoking opendocument page to open a webi report

156 Views Last edit Jan 24, 2017 at 01:52 PM 2 rev


I have to use a lot of webi reports and huge universe (BO XI 4.1 or above) on different user schemas of Oracle database (11.2 or above). Each of these user schemas represents a "company division". These user schema have identical tables structure, only data differ. Every BO user has to use same reports on every "company division".

We developed a .NET web application that invokes webi OpenDocument page to open and refresh these reports. Every time we add a company division (an Oracle db schema) now we have to clone universe and reports once again to change db user and pwd in universe default connection, and bo users have to open the "cloned" reports->universe. But maintenance is very very heavy.

Then... could I have a single set of reports and a single universe, and before to invoke and refresh a report through opendocument page, could I set db user and pwd in (default) connection of universe to connect to right oracle schema based of a previous user choice (that is the "company division")?

Could I do that with restful web services sdk? If it's possible, the change is "on the fly" (that is temporary in session, without persistent modification to universe default connection), so that concurrent use of reports by users on different oracle schema doesn't confuse the db connections?

Thanks in advance,