Checklist: Configure Analysis Services and deploy cubes [AX 2012]

Updated: February 24, 2014

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

To configure Microsoft SQL Server Analysis Services for use with Microsoft Dynamics AX and to deploy the cubes that are included with Microsoft Dynamics AX, complete the tasks in the following checklist.


More information

Complete the prerequisite tasks:

  1. Verify that you have the permissions that are required to configure Analysis Services.

  2. Create a domain account to run the Analysis Services service.

  3. Assign the .NET Business Connector proxy account to the server administrator role in Analysis Services.

  4. Install prerequisites.

Before you configure Analysis Services

Configure Analysis Services by running the Microsoft Dynamics AX Setup Wizard.

Configure Analysis Services by running Setup

Complete the Analysis Services integration:

  1. Install SQL Server Shared Management Objects on Microsoft Dynamics AX client computers.

  2. Verify that information about exchange rates has been entered.

  3. Deploy the default cubes that are included with Microsoft Dynamics AX.

  4. Update the data source for online analytical processing (OLAP) if your Analysis Services database is not named Dynamics AX.


    If you are using Microsoft Dynamics AX 2012 R2 or later, this step does not apply to you.

  5. Configure the cubes, based on the changes that you have made to the Microsoft Dynamics AX configuration or license keys.

  6. Grant users access to the cubes.

  7. Automate the processing of cubes.

  8. Create new date dimensions for the cubes.

  9. Add financial dimensions to the cubes.

Install SQL Server Shared Management Objects

Verify that exchange rate information has been entered

Deploy the default cubes

Update the OLAP data source

Configure an Existing SQL Server Analysis Services Project

Grant users access to cubes

Automate the processing of cubes

How to: Create a Date Dimension for a Cube

How to: Add a Financial Dimension to a Cube

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).