Persisting SSAS OLAP Roles In Project Server 2007 (Free)
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
Tags: tool