Configuration 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 administration> Setup > Business intelligence > Analysis Services > System currency and exchange rate type.

   

3. Set up OLAP Administration Form
   1. Click System administration> Setup > Business intelligence > Analysis Services >Analysis Server

   

   

Deploy the default cubes that are included with Microsoft Dynamics AX.
4. 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.

5. Configure the cubes, based on the changes that you have made to the Microsoft Dynamics AX configuration or license keys.
   1. Click Tools> Business 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.

6. To Run the Report:
   1. Click on Accounts Payable>Reports>Statistics>Vendor>Top Vendors by YTD Purchase