Hi all,
Let's consider we have the following cube in SQL 2005 Server

Project
Period
Office

Hour
Capacity
Revenue

Where
{project, period, office} - are dimensions
{hour, capacity, revenue} - are facts

I need to configure the access rights for users using the following
use-cases:

- Fact access configuration
User has only access to the facts specified. E.g. Hour, Capacity

- Dimension specific settings
The user has only access to the dimensions specified. E.g. Projects:
CRM, ERP

Could you please give me some advises/links with information how to
achieve these goals using Microsoft SQL Server 2005 security
improvements?

Thanks,
Andrei