I have a WEBI report which is based on Single Universe, which can support both Oracle and SQL Server databases.
There are 2 users for this report.
When 'Oracle_User' opens report in InfoView, he should see the data from Oracle DB
When 'SQLServer_User' opens the same report in InfoView, he should see the data from SQL Server DB
Please let me know how to achieve this functionality.
Can we dynamically change the Universe connection based on the User who logged into InfoView..?