23 Oct’17

Dynamics AXConfiguration of Analysis Services

Microsoft SQL Server Analysis Services is a server-based solution  that provides online analytical processing (OLAP) functionality. Analytical reports help users examine business data and identify trends that they might not otherwise discover when viewing data on traditional reports.

To integrate Microsoft Dynamics AX and Analysis Services, you must perform the following steps:

Step 1:

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.

Step 2:

Configure Microsoft SQL Server Analysis Services:

  1. Start Microsoft Dynamics AX Setup. Under Install, select Microsoft Dynamics AX components.
  2. On the Select components page:
    1. Select the Analysis Services configuration check box.
    2. Click Next.
  3. On the Prerequisite Validation page, resolve any errors. When no errors remain, click Next.
  4. On the Select a file location page, select the location, and then click Next.
  5. On the Specify a location for configuration settings page, specify whether you want the cubes to access configuration information from the registry on the local computer or from a shared configuration file. If you select to use a shared configuration file, you must enter the network location of the file. Click Next.
  6. On the Connect to an AOS instance page, enter the name of the computer that is running the Application Object Server (AOS) instance
  7. On the Specify Business Connector proxy account information page, enter the password for the proxy account that is used by Business Connector. Click Next.
  8. On the Specify an Analysis Services instance page, select an instance of Analysis Services. Click Next.
  9. On the Connect to a SQL Server Database page, follow these steps:
    1. Select the computer that hosts your Microsoft Dynamics AX online transaction processing (OLTP) database.
    2. Select the Microsoft Dynamics AX OLTP database.
    3. Click Next.
  10. On the Ready to install page, click Install.
  11. Click Finish to close the Setup wizard.

Step 3:

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.
    1. Click System administrationSetup > Business intelligence > Analysis Services > System currency and exchange rate type.
  1. Set up OLAP Administration Form
    1. Click System administrationSetup > Business intelligence > Analysis Services >Analysis Server

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

  1. PS: Ensure that the Microsoft Analysis Server should be connected to the Microsoft SQL Server Management Studio for the respective Server along with correct logon Credentials.

    1. Open the Microsoft Dynamics AX client.
    2. Click File > Tools > Business Intelligence (BI) tools > SQL Server Analysis Services project wizard.
    3. On the Analysis Services project wizard page, click Next.
    4. On the Select an option page, click Deploy, and then click Next.
    5. On the Select an existing Analysis Services project page, click Select a project from the AOT. Select the project you want to deploy from the list, and then click Next
    6. On the Deploying page, click Next when the deployment is completed.
    7. Click Finish to close the wizard.
  1. Configure the cubes, based on the changes that you have made to the Microsoft Dynamics AX configuration or license keys.
    1. Click ToolsBusiness Intelligence (BI) tools > SQL Server Analysis Services project wizard. Click Next.
    2. On the Select an option page, select Configure. Click Next.
    3. On the Select an existing Analysis Services project page, select the project to update. You can select a project from the AOT or from disk. Click Next After the project builds, click Next
    4. Select the Apply the Microsoft Dynamics AX configuration to the Analysis Services project check box. Click Next.
    5. Select additional languages for which to provide label translations and then click Next.
  1. To Run the Report:
    1. Click on Accounts Payable>Reports>Statistics>Vendor>Top Vendors by YTD Purchase


Written by

Naithika Shetty

Trainee Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more
  • Persistent Filters in the Power BI Service

    13 March’ 2018

    Introduction: The feature is finally release, and it is power BI has announced general availability of persistent filt...

    Read more
  • Cause and Solution for Scribe MSMQ not receiving Message from AX

    10 March’ 2018

    Issue: Microsoft Message Queuing (MSMQ) service running on Server might be unable to receive messages. Therefore, messa...

    Read more
  • User Privileges on SharePoint – D365 Document Integration

    10 March’ 2018

    Overview: Often, we wonder what could be wrong where we see a generic error on Documents in Dynamics 365. Something lik...

    Read more