Configure Analysis Services by running Setup
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Use this procedure to configure Microsoft SQL Server Analysis Services for use with Microsoft Dynamics AX. You must complete this procedure on the computer that is running Analysis Services.
This procedure assumes that you are configuring Analysis Services on a dedicated server where no Microsoft Dynamics AX components are installed. If you are installing other Microsoft Dynamics AX components at the same time, the installation pages vary, depending on the components that you are installing.
Start Microsoft Dynamics AX Setup. Under Install, select Microsoft Dynamics AX components.
Advance through the initial wizard pages.
If the Setup Support files have not yet been installed on this computer, the Select a file location page is displayed. The Setup Support files are required for installation. Provide a file location or accept the default location, and then click Next. On the Ready to install page, click Install.
If you’re installing AX 2012 R3, in the Select an installation option page, click Microsoft Dynamics AX.
On the Select installation type page, select Custom installation. Click Next.
On the Select components page, follow these steps:
Select the Analysis Services configuration check box.
A message is displayed that states that you must complete the code upgrade checklist if you are upgrading. Click OK.
We recommend that you select the Management utilities check box so that you can deploy cubes by using Windows PowerShell commands.
On the Prerequisite Validation page, resolve any errors. For more information about how to resolve prerequisite errors, see Check prerequisites. When no errors remain, click Next.
On the Select a file location page, select the location in which to install 32-bit versions of Microsoft Dynamics AX files, and then click Next.
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.
On the Connect to an AOS instance page, enter the name of the computer that is running the Application Object Server (AOS) instance that you want to connect to. You can optionally specify the name of the AOS instance, the TCP/IP port number, and the WSDL port for services. Click Next.
If you entered AOS connection information for other Microsoft Dynamics AX components that are installed on this computer, this page is not displayed. Subsequent installations on this computer reuse the existing AOS connection.
On the Specify Business Connector proxy account information page, enter the password for the proxy account that is used by Business Connector. Click Next.
On the Specify an Analysis Services instance page, select an instance of Analysis Services. Click Next.
On the Connect to a SQL Server Database page, follow these steps:
Select the computer that hosts your Microsoft Dynamics AX online transaction processing (OLTP) database.
Select the Microsoft Dynamics AX OLTP database.
The domain account that the Analysis Services service runs as must have access to the Microsoft Dynamics AX OLTP database in order to process the cubes. The Specify user accounts page lists the accounts that currently have access to the OLTP database. If the account that the Analysis Services service runs as is not listed, click Add user to add it.
On the Prerequisite Validation page, resolve any errors. When no errors remain, click Next.
On the Ready to install page, click Install.
Click Finish to close the Setup wizard.
The Microsoft Dynamics AX 2012 Setup Summary Report is displayed. This report lists additional procedures that you must complete to integrate Microsoft Dynamics AX and Analysis Services. For more information about the procedures, see Complete the Analysis Services integration.