March 22, 2010 at 9:21 am
Hi all,
I am gererating a Multidimentional report using the Analysis Database (Cube).
I created some parameters in SSRS for user select to filter out the data display on the report.
when I have a filter pulldown list with 3 items: HR,Sale,Rental. Is there any way that I can put a condition to allow a user in HR can only HR, Sale only see Sale Item, ect..
Please advice.
Thanks you very much.
Regards,
Dee
March 22, 2010 at 9:50 am
Do you already have other reports broken out by subject, Group Membership etc? IE. Is there a Sales folder that reports pertaining to sales exist in and an HR folder that contains other HR reports? If so I'd say create your report and then create some linked reports to that report in the appropriate folders. That way you still only need to maintain a single report but you can customize your parameters based on your group memberships and such.
Alternatively, you could try to query the databaseserver using the IS_MEMBER() function if they are split up into ActiveDirectory Groups, I would think you'd need to do something along the lines of populating the parameter drop downs dynamically instead of a static assignment. You will need a Dataset just to pull back this data with a query that might look something like this.
SELECT Membership
FROM (
SELECT CASE WHEN IS_MEMBER('DOMAIN\SALES') = 1 THEN 'SALES' END AS Membership
UNION
SELECT CASE WHEN IS_MEMBER('DOMAIN\HR') = 1 THEN 'HR' END
UNION
SELECT CASE WHEN IS_MEMBER('DOMAIN\Rental') = 1 THEN 'Rental' END
) AS a
WHERE a.Membership IS NOT NULL
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply