February 24, 2014 at 4:10 am
Hi,
I created a Report using BIDS.
The requirement is to restrict the parameter value based on User.
In the report there is one parameter(@Team) with multiple values which shows the team values.
The Team values should change for user to user based on the user .
Users: A,B,C,D and E Team:10,20,30,40 and 50
User A(belongs to team 10) should only choose @Team value 10 and other values(20,30,40 and 50) disappear/not able to choose.
User B(belongs to dept 10,20) should only choose @Team value 10,20 and other values(30,40 and 50) disappear/not able to choose.
User C(belongs to dept 30) should only choose @Team value 30 and other values(10,20,40 and 50) disappear/not able to choose.
User D(belongs to dept 40,20,10) should only choose @Team value 40,20,10 and other values(30 and 50) disappear/not able to choose.
User C(belongs to dept 10,20,30,40,50) should choose All @Team values 10,20,30,40,50.
How to implement this?
Thanks in advance
Neha
February 24, 2014 at 8:33 am
Create a hidden parameter using the built in field User.UserID as the default value. Then use that parameter as a constraint to another query that is used to create the available values of the parameter you want to be user sensitive.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply