Let's say I have 3 users that can access a Sales Report. I want User1 to access only Asia. I want User2 to access both Asia and US. User3 should access ALL countries.
What's the best way to set up the user authority in Cognos with less maintenance in the future? What are our options in setting up the authority? Should we use a custom table that will contain the authority and incorporate it on the report?
We don't want to create 3 different reports for each of the users. We want the report to only display the country that they are allowed to see.
Thanks in advance!
creat a table in the database
just like
user_id areaid
A asia
B asia
B US
......
then upper(USER_ID) = upper(#sq($account.personalInfo.userName) #)
and facttable.areaid =areaid
in fm
You can define security filters in your framework to do exactly this. In Framework Manager, select the desired query subject (s) and go to Actions > Specify Data Security. Use the Add Groups button to bring in the groups/roles/users for whom you wish to define filters, then for each, click in the Filter column and select "Create/Edit Embedded filter". Define the relevant country filter for each. Save your model and republish the package.
Cheers!
MF.