How to Grant Permissions on the Data Warehouse Server
This topic provides steps for granting permissions on the Data Warehouse server. The DTS tasks and Reporting Services use these permissions. The DTS tasks use this access to process the cubes/dimensions whereas the Reporting Services uses this role to query data from the Analysis Services databases.
Note
Make sure that the Reporting Services account for the Data Warehouse Analysis server is configured to use this role. Also, make sure that the user who is running the DTS task is added to this role. If the DWRole has permission to the Data Warehouse database and cubes, the account that the reporting services is running under must be a part of this role. Additionally, you have to enable the reports Web site to impersonate the reporting services account.
To grant permissions on the Data Warehouse server
In SQL Server, create a Data Warehouse role and provide it a name such as DWRole.
Give the DWRole read access to the Data Warehouse data source.
Give the DWRole read and write access to the OLAP cubes.
Note
For information about how to grant permissions in SQL Server, see your respective SQL Server documentation.