Hi,
I have one value prompt as study_number( single selection ) in prompt page. and I have to display default selection of study_number based on user login. I am using cognos 10.2. Please give me your suggestions.
Thanks,
Sharon.
Have you got a table that maps the default study number to the user login?
Hi Can you confirm if ur doing it in production or development and if u have access to Frame work manager
Hi Sharon,
To get this done the way what I could think of, is by using session parameters like (#sq($account.defaultName)#) in valueprompt query's filter in report, which will limit the values of prompt to that user only.
or the other way would be to go to framework manager. create a new query subject whose query pulls study_number based on the session parameter.
select study_number from XXXX where empid =(select empid from employee where employeename= #sq(($account.firstName)+($account.lastName)#) (U might need to verify the syntax, but logic will be like this)
In either of the ways u have to figure out a way to map session parameter to your study number.
Hi,
Yes I have a table for user role and study no. I can get the user role using session parameter and also appropriate study no. but I want to display that study no as defaut when i run the prompt page.