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.