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 |
|
matt.riley
Starting Member
2 Posts |
 Posted - 2009-03-02 : 15:49:50
|
| Hi,I have developed a number of reports for my business and need to deploy them in a certain manner.We have 200+ stores and each store needs to see the same report but containing that store data only.The data has a Store ID within. We cannot allow store 123 for example to view store 67's data.All users from each store are within an AD group for their store such as Store123.I want the end user to be able to run the report and for only their store data to be shown. I may be reading the books wrong but it seems like i have to deploy 200 copies of the report in 200 folders with custom parameters and then give the AD group permissions to view that folder.Is there a quicker way of doing this?Kind Regards,Matt Riley |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-03-04 : 14:23:43
|
| It's my understanding that you would control the access from SSAS and publish only one report. SSAS will only return the dimensional data the user has access to.An infinite universe is the ultimate cartesian product. |
 |
|
|
|
|
|
Reporting Services Deployment Question