How to: Deploy an Existing SQL Server Analysis Services Project

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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

You can deploy and process Analysis cubes by using the Analysis Services project wizard in Microsoft Dynamics AX) or by using SQL Server Business Intelligence Development Studio (BIDS).

Deploying an Analysis Services project creates the defined objects in an instance of Analysis Services. Processing the objects in an instance of Analysis Services extracts and then maps data from the data sources defined in the project into the cube objects. After the cube and dimensions are processed, you can view the data for the objects in the project.

To deploy an Analysis Services project by using the Analysis Services project wizard

  1. Click Tools > Business Intelligence (BI) tools > SQL Server Analysis Services project wizard. The SQL Server Analysis Services Project wizard form appears. Click Next.

  2. Click Deploy and then click Next.

  3. Select the Analysis Services project to deploy. You can select a project that is already in the AOT or open a project from disk. Click Next.

  4. Select Deploy the project.

    Note

    If you are using Microsoft Dynamics AX 2012 R2, select the database to deploy, and then select Deploy. Specify whether to process the project, and then click Next.

  5. Specify the following options:

    Option

    Description

    Analysis Services server

    Specify the Analysis Services server to which to deploy the project.

    Analysis Services database

    Specify the existing Analysis Services database where you want to deploy the project.

    -OR-

    Specify to create a new Analysis Services database.

    Note

    If you are using Microsoft Dynamics AX 2012 R2, skip this step.

  6. Specify whether to process the project after it is deployed. If you do not process the cubes, you will not be able to browse cube data. Click Next.

After the project is deployed and processed, you can view the data in the project.

Information is logged in the global log file path that is specified in the Analysis servers form. Log files are not generated if you do not specify the global log file path.

To deploy an Analysis Services project by using BIDS

  1. In the AOT in Microsoft Dynamics AX, right-click Analysis Services project that you want to deploy and then click Edit. Analysis Services projects are located under Visual Studio Projects > Analysis Services Projects.

    Note

    If you have already deployed an Analysis Services project and you need to deploy it again, you must open it from the AOT. Otherwise, a duplicate WHERE clause will be added to the data source view.

  2. In Solution Explorer, right-click the Analysis Services project, and then click Properties. The project Property Pages window opens. In the left pane, click Deployment, and then in the right pane, enter the deployment target group settings.

  3. Click OK to save the property changes.

  4. In Solution Explorer, right-click the Analysis Services project, and then click Deploy.

BIDS builds and then deploys the Analysis Services project to the specified instance of Analysis Services by using a deployment script. The progress of the deployment is displayed in two windows: the Output window and the Deployment Progress window. The Output window displays the overall progress of the deployment. The Deployment Progress window displays the detail about each step taken during deployment.

After the project is deployed and processed, you can view the data in the project.

Note

You might have to update the connection string of the project database file.

See also

How to: Create a New SQL Server Analysis Services Project

Working with Analysis Services Projects