SQL Server Analysis Services enforces OLAP security through roles. A user can access OLAP data if the user's name has been added to a role with access to OLAP data. If the user's name has not been added to a role, the user will not have access to OLAP data, regardless of any configurations in Microsoft Dynamics AX. For this reason, see the SQL Analysis Servers books online regarding how to add a user to an Analysis Services role.

Once the user has been added to an Analysis Services role, you must configure Microsoft Dynamics AX access to OLAP data.

Applications such as Microsoft Excel can link directly to OLAP cubes in Analysis Services. Even if you have restricted access to cube data in Microsoft Dynamics AX, end users might still be able to access cube data in Microsoft SQL Server Analysis Services if you have not properly configured security roles in Analysis Services. For more information about securing access to OLAP cubes in Analysis Services, see Creating Security Roles in the Microsoft SQL Server Analysis Services books online.

Community Resources

FIX: OLAP:DSO Role Update May Return "Key Already Associated" Error or Cause System Hang (KB)
Role Security Issue (Forums)


Other Languages

This article is also available in the following languages:

Brazilian Portuguese (pt-BR)