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,