In our current production environment, we have SSRS setup to use Forms Authentication to verify the users.
For our data sources, we are using 2 different data models - 1 is used to point at the "raw" sql in the database - and the second model is to point at a SSAS cube.
currently, all users can see all data.
we now have a requirement to limit the data the a user can see from the Fact table dependant on the Portion that they are assigned to (and a user might be assigned to more than one Portion.
we have set this new requirement in the "raw" SQL model using a security filter - and all working well
we have set the filtering up in the cube - using a stored procedure in the Role "dimension data" tab which receives the user name and retruns the MDX required for the filtering - and it works if we connect to the cube via SQL management studio. However,
if we connect from Reporting Services, we can not get the UserName "transferred over" and therefore the filtering doesnt work.
n.b. we are using Shared data sources for our reports
does anyone out there know of a way of making this work - or do we go for Kerberos ??
View Complete Post