Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sidhuonline
Starting Member
2 Posts |
 Posted - 2011-02-03 : 02:12:27
|
| I have SSAS cubes serving as a data source for my SSRS reports. Since SSRS and SSAS both use Windows authentication I have a constraint that whenever a person login to the system to view the reports he should only be able to see the reports catering to his dept.for ex: Suppose there are two users userA and userB. userA operates in India and userB operates in China. I have created a mapping table in SSAS of user with operating place like this:Table : ----------------------------------------------------------------------- UserName OperatingPlace----------------------------------------------------------------------- userA India userB China Now what I want to achieve is that whenever userA logins into the system to view the SSRS reports he should be able to see only the records belonging to India in the SSRS report and when userB logins he should be able to see only the records belonging to China in the SSRS reportQ) Can this be achieved through SSAS or SSRS?Q) Do I need to pass any kind of parameter to the datasource(SSAS cubes) from SSRS reports so that the data is filtered there in cubes itself? Note: I am very new to SSAS and SSRS.A Sidhu |
|
|
|
|
|
View to filtered report in SSRS based on userlogin