On the OLAP database roles tab, you can create database roles to control access to the information in the data mart’s OLAP cube. With these database roles, you can set permissions to limit the data that users can view and manipulate in the cube. This tab includes three default database roles appear, and you can create roles as necessary.
When you create a database role, you can assign users to that role and set a variety of permissions for them. You can assign permissions for the database and for the individual cells in the OLAP cube, and you can assign rights to drill through the cube and to filter the data in the cube’s dimensions. The permissions you set for your database roles allow you to enforce security on the OLAP cube and control how users access the information in the database. After you add users to a database role, they can access the cube with the restrictions placed on their database role to conduct advanced reporting on the records in the data mart.
For more information about OLAP role security, see the Microsoft SQL Server 2008 help documentation for Analysis Services. You can also find information online about the Analysis Services database roles at msdn.microsoft.com/en-us/library.