Change data source dynamically through Framework manager based on user group

[xmaxwell]

I'd like to explore more on the topic of changing data source connections dynamically through FM based on the users ad group. I've read somewhere that it's possible to do this through parameter maps, however I cannot find any documentation or any other info on it.

Anyway, here's my situation. I have 2 data sources, both identical, and I want the data sources to be dynamically changed in FM based on the group the user belongs to. Here's an example:

Data sources:

Location_NY
Location_NJ




When a user from NY logs in and runs the report, the reports should run off the Location_NY db. When a user from NJ logs in then the report/FM should automatically run the report off the Location_NJ database. Does this make sense?

[MFGF]

I'd like to explore more on the topic of changing data source connections dynamically through FM based on the users ad group. I've read somewhere that it's possible to do this through parameter maps, however I cannot find any documentation or any other info on it.

Anyway, here's my situation. I have 2 data sources, both identical, and I want the data sources to be dynamically changed in FM based on the group the user belongs to. Here's an example:

Data sources:

Location_NY
Location_NJ




When a user from NY logs in and runs the report, the reports should run off the Location_NY db. When a user from NJ logs in then the report/FM should automatically run the report off the Location_NJ database. Does this make sense?

Hi,

It's possible to define multiple connections within a logical data source (in the Admin Console), and secure those connections for different users, groups or roles. That sounds to me like what you're trying to achieve here? You wouldn't need to use a parameter map in this case. When a user logs in belonging to the NJ group, the data source uses the NJ connection because that's the only one visible to the user based on the security rules.

Would that work for you, or are there too many connections to make this feasible?

MF.

[xmaxwell]

Hi,

It's possible to define multiple connections within a logical data source (in the Admin Console), and secure those connections for different users, groups or roles. That sounds to me like what you're trying to achieve here? You wouldn't need to use a parameter map in this case. When a user logs in belonging to the NJ group, the data source uses the NJ connection because that's the only one visible to the user based on the security rules.

Would that work for you, or are there too many connections to make this feasible?

MF.

It might work, however the administration is controlled by a vendor and they have a tendency of not meeting deadlines. In reality I have 5 data sources, so I thought Parameter maps would be the best solution.

4 for each state (NY, NJ, MD and TX) and 1 containing all of this (for aggregation). So, the 4 will follow the same scenario as explained previously. We'll leave the 5th one alone for now...

[MFGF]

It might work, however the administration is controlled by a vendor and they have a tendency of not meeting deadlines. In reality I have 5 data sources, so I thought Parameter maps would be the best solution.

4 for each state (NY, NJ, MD and TX) and 1 containing all of this (for aggregation). So, the 4 will follow the same scenario as explained previously. We'll leave the 5th one alone for now...

Hmmmm. If you need to bake your own solution using parameter maps, you can use the approach shown below:

https://www.ibm.com/support/knowledgecenter/SS6QYM_9.2.0/com.ibm.help.bi.opreports.doc/c_FND_BIG_DataModelObjectsParameterMaps.html

But (and I think this is a big BUT in your case) this still requires you to have different data source connections defined in the Administration Console. If your Admin access is controlled by a vendor, you will need to get them to set up all five data sources. I suspect that leaves you in the same predicament...

Cheers!

MF.