If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Providing Security using Session Parameters

Started by Mpotla, 04 Mar 2011 12:09:58 AM

Previous topic - Next topic

Mpotla

Hi,

We have a requirment in providing the user secutiry based on region. For this we are implementing the security based on login (SSO) .

We have created a table with two fields SSO and Region. Means employee is mapped to the regions to which he wants to see the data, one employee can see the data related to one or more regions.

EX:

SSO      Region

101      Asia
101      Europe
102      Asia
!03       Europe

In each Fact table we have the region field.
we have implemented data level security filter using parameter maps

"substring([Common Objects].[Opp Fact].[REGION],1,4) = #sq($Security_Parameter_Map{$account.parameters.osSignon})#"

This works fine for an SSO which is mapped to a single region.
But when an SSO is mapped to multiple regions we are not able to get multiple values from the paramter map.

Please help in resolving the issues.

Thanks in Advance
Mohan




rockytopmark