Skip to Content
0
Former Member
Jul 06, 2010 at 12:36 PM

how to display DB specific data in WEBI for users with Single Universe

20 Views

hi,

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.

1) Oracle_User

2) SQLServer_User

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..?

Thanks,

Vamsee