Update the OLAP data source [AX 2012]

Updated: February 24, 2014

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

By default, when you deploy the cubes that are included with Microsoft Dynamics AX 2012 or Microsoft Dynamics AX 2012 Feature Pack, the database that is created in Microsoft SQL Server Analysis Services is named Dynamics AX. If you entered a new name for the Analysis Services database when you deployed the cubes, you must modify the DynamicsAXOLAP data source. To modify the data source, complete the following procedures on the server that runs Microsoft SQL Server Reporting Services.


If you are using Microsoft Dynamics AX 2012 R2 or later, the following procedures do not apply to you.

Follow these steps to modify the DynamicsAXOLAP data source on the Report Manager website.

  1. Open Report Manager. By default, the URL is http://[SSRSServerName]:80/Reports.

  2. Click the DynamicsAX folder.

  3. Click the DynamicsAXOLAP data source.

  4. In the Connection string field, locate the text Initial Catalog=Dynamics AX.

  5. Change Dynamics AX to the new name of the Analysis Services database.

Follow these steps to use Windows PowerShell to modify the DynamicsAXOLAP data source in the Application Object Tree (AOT) of Microsoft Dynamics AX.

  1. Open Windows PowerShell as an administrator by following these steps:

    • Click Start > Administrative Tools.

    • Right-click the Microsoft Dynamics AX 2012 Management Shell option.

    • Click Run as administrator.

  2. Enter the following command. In this command, note the following information:

    • [SSASServerName] is the name of the server that runs Analysis Services. If you have a named instance of Analysis Services, enter [SSASServerName\InstanceName].

    • [DatabaseName] is the name of the Analysis Services database.

    Set-AXReportDataSource -DataSourceName DynamicsAXOLAP -ConnectionString “Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Data Source=[SSASServerName];Initial Catalog=[DatabaseName]

    For more information about the Set-AXReportDataSource command, see Set-AXReportDataSource.

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

Community Additions