Microsoft Dynamics 365 Blog

In Dynamics AX 2009 a very common scenario with Enterprise Portal and Role Center is that only users that are local Administrators on the machine where Microsoft SQL Server 2005 is installed can correctly see Microsoft SQL Server 2005 Reporting Services reports (based on Microsoft SQL Server 2005 Analysis Services).

All the non-admin users see the following error message instead:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set ‘Company’. (rsErrorExecutingCommand) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors

Here, the non-admin users don’t have permission to access the target OLAP cube.

The permissions to access the OLAP cube need to be set up independently from Dynamics AX using Microsoft SQL Server Management Studio (for example). The TechNet article Configure security settings for cubes describes step by step how the correct permissions can be assigned.

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!