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

[Former Member]

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

[Former Member]

Within the universe you can set up what are called Connection Overrides. You would need to set up a couple of groups in the CMC, one for the Oracle users, and one for the SQL Server users. Then in the universe, reset the connection to the proper database based on the group membership. When you export the universe, anyone that uses this universe (via Infoview or other tools) will be directed to the proper database.

The groups have to be set up in CMC. The override takes place in the universe designer tool.

[Former Member]

hi Dave,

Thank you for the response.

I have created 2 groups 'Oracle_Group' and 'SQLServer_Group'.

In Universe, under Manage Access Restrictions, i have added the groups on right side.

But how should i define the restrictions on left side regarding connection?

Here, Are we going to create two connections. one for oracle DB, other for SQL server DB?

or

a Single Connection?

Please provide me the detailed steps regarding your statement "Then in the universe, reset the connection to the proper database based on the group membership".

Thanks,

Vamsee

[Former Member]

You will have to create 2 connection in designer. 1 for Oracle and the other one for SQL Server.

[Former Member]

hi Anil,

Thank you for the response.

I have tried creating 2 connections and restricted each connection for each group, but in Infoview, only one group user is able to refresh the report, whose connection is exported along with the Universe. when the other group user tries to refresh the report, an error is displayed 'You donot have access the data from this Universe'.

So the reason is : 'As Universe can be exported to Repository with only one connection' that connection specific group user is able to access data from Universe Whereas other groupuser cannot( as other connection can't be exported along with the same universe).

As Universe can be exported to Repository with only one connection, how should these connections set for the corresponding groups?

Could you please provide me the detailed steps w.r.t connections restrictions...?

Thanks,

Vamsee

[Former Member]

Vamsee,

Can you check Group1 has access to Connection 1 (Which I think it is there as the Group1 is able to refresh the report) and Group2 has access to Connection2. You can do this by going to CMC->Home>Connection user rights pane.

To make it simple, just add Group 2 into Administrators group so that he will get access to everything in System and once you get the desired result, you can narrow the access rights with the help of your BO admin.

I think you have done everything else required for connection overloading.

Anil