How to allow multiple DBconnection dynamically based on user/User Group selection

[Former Member]

HI Experts,

I have a question related to accessing the reports into Multiple Groups.

Scenario1: I have Different  Warehouses situated in Different states. Each state equivalent to one Warehouse.

I have two types of users  one is State wise specific users and  another one is Business groups who looks all states information.

I have created standard queries on  one Universe ( For all states Universe is same, I am replacing the connection run-time) by implementing the Universe security profile concept.

Scenario2 : Business group want to see the data based on States Warehouse, we are not maintained any table for states.connection properties.

If business Users runs query the report should prompt the connection, based on selection that perticular state connection data should pass into  BO report. Logic required is dynamically it should prompt user to select connection name.

Please help me some good ideas to implement this scenario. I am facing issue with Scenario 2.

Regards

Prakash Vadla

[former_member182521]

Create a security table in your States warehouse with User-State mapping and try to utilize the Security table with all your reporting tables. You need to make use of BO_USER variable at universe level.

[Former Member]

Hi Manikandan,

Thanks for replying.

In fact I have searched your linkedin profile and email ID to reach you last week. No Luck for me.

The issue is not to restrict users to a specific connection, Issue is to dynamically how to pass the multiple data sources for the business group and there upon select only one source connection to display the data.

At this moment Replacement of connection works for the users who belong to States. but Replacement of connection is not working because this group belongs to all states. Hence I ideally planned to prompt the connection name to users to select.

Can you suggest me please.

Regards

Prakash V