SSAS Tools Persisting SSAS OLAP Roles In Project Server 2007
Persisting SSAS OLAP Roles In Project Server 2007
User Rating: / 1
PoorBest 
Saturday, 03 May 2008 01:04
During the standard Cube Building process in Project Server 2007, any manually added OLAP Roles in an OLAP database are deleted. The Cube building creates a default Role ProjectServerViewOlapDataRole that automatically adds all the Project Server users to this Role. This customization saves the configuration of the existing OLAP Roles (except for ProjectServerViewOlapDataRole) in a text file, before they are deleted but the standard cube building process, using the OnCubeBuilding event. The saved configuration of the OLAP Roles is then restored using the following event OnCubeProcessed.
The following configuration is saved, for each Role:
* The list of Members
* The database permissions of the Role
* The dimensions permissions of the Role
* The cubes permissions of the Role