Mystery of the dissappearing roles in Analysis Services 2005..
One of the major differences in working with Analysis Services 2005 as compared to Analysis Services 2000 is that there is a specific developer environment to develop your cubes, data mining models etc and then there is a seperate interface for managing your Analysis Services 2005 server; SQL Server Management Studio.
This is different compared to AS 2000 as there was just one tool for developing and managing your cubes Analysis Manager. Therefore is some ways if you are used to the older way of doing things you would create your security roles using Analysis Manager. But with seperate interfaces with SSAS 2005 which tool do you use for that purpose?
Well, I have been fielding questions on dissappearing security roles within your SSAS environment. If you used the BI Dev Studio to create your cube and deployed it to the server and then used the Management Studio to assign security but then you went back to the BI Dev Studio and rebuilt your project; guess what everything on the server is rebuilt and therefore it overwrites your security assignments. AHA..
You either assign security roles withing your BI Dev Studio package so if you ever rebuilt your cube the security structure is rebuilt or you dont always rebuild the structure of the cibe just the data ensuring that the security setting always stay on the server..
-Raheel
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
