How to Hide values in a Prompt based on User and user group

[Kutti]

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.

[mrcool]

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

Cheers,
Mrcool

[sir_jeroen]

Have you tried conditional blocks?