Filter prompt values based on user

[Kutti]

Hi All,

Need urgent help.

I need to implement data level secuirty in my report. I have a Prompt in a prompt page which holds different category names (A, B, C) and those categoty names shoule be displayed based on the user who runs the report.

If User A runs the report then category A should be displayed in the prompt.
I am trying to use  #sq($account.personalInfo.userName)# session parameter to filter the data but not sure how to check the user name with that parameter.

I donot have any data about the users in my DB tables. We are using Access manager as Authentication.

do i need to have a table with all the usernames in my DB to implement security. We also have Active directory.  I  also tried to create a filter on the prompt in Report studio  to filter the data but got "Parsing  text error". If am running the report and my username is 'User A' then how to get below logic work

IF
#sq($account.personalInfo.userName)#='UserA'
THEN
([Layer].

.[Category])='A' Please help me to get this implemented. thanks

[PRIT AMRIT]

another easy way is, you may have 3 prompts A, B, C on your prompt page.

Create a string variable #sq($account.personalInfo.userName)#

Value: User A, User B, User C.

Then just show/hide the prompts based on the Users.
---------------------------------------------------------
Or, create a Data Item where your prompt point to and write a case/if..else statement

If (#sq($account.personalInfo.userName)# ='User A'
then ('A')
else ('B')

Hope this would work for you.

Thanks
P