COGNOiSe.com - The IBM Cognos Community

Hi all,

I have a requirement where i need to hide values in a prompt based on user group.

Ex: I have a prompt 'Customer name' in prompt page and values in that prompt will be A, B, C and D
     my requirement is if a user called "X" runs the report the value A, B should be displayed in prompt and C, D should be hidden and also if all the users (M, N, O) from a particluar user group (gropu name: MIS) runs the report then A, B should be displayed and C, D should be hidden

I am trying to achieve this by creating the filter on Prompt with below expression but i am getting an error:

case
when
#CSVIdentityNameList()# in 'MIS' ----(Group Name)
then
([Modelled Layer].[table_name].[customer_Name]='A')
else
([Modelled Layer].[table_name].[customer_Name]='C')
end

Please help me to get the correct syntax to implement above requirement

thanks.

Hi..
Have you tried 'Specify Data Security' option in FM?

Cheers,
Mrcool

Have you tried conditional blocks?