SSAS Tools 
Persisting SSAS OLAP Roles In Project Server 2007
Persisting SSAS OLAP Roles In Project Server 2007 | Persisting SSAS OLAP Roles In Project Server 2007 |
| 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 |
Top Rated
- Transact Sql Server Analysis Services Metadata
- Intelligencia Query for BIDS and Reporting Services
- SSAS Utility to process dimensions and partitions
- Exologic CubePort - migration from Hyperion Essbase to Microsoft SQL Server Analysis Services
- BIDS Helper
- SqlSpec - documentation tool for Analysis Services 2005
- xSQL Documenter - SSAS Documentations
- MDX Editor
