Deploy the default cubes

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 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This article explains how to deploy the default OLAP (online analytical processing) cubes that are included with Microsoft Dynamics AX. There are two ways to deploy these cubes: by using the Analysis Services Project Wizard in Microsoft Dynamics AX, or by using Windows PowerShell.

Tasks

See what cubes are available

Deploy the default cubes by using the Analysis Services Project Wizard

Deploy the default cubes by using Windows PowerShell

Resources

Cube and KPI reference for Microsoft Dynamics AX

Windows PowerShell for Microsoft Dynamics AX cmdlet reference

See what cubes are available

To deploy the default cubes that are included with Microsoft Dynamics AX, you must deploy a Microsoft SQL Server Analysis Services project. The following table lists the Analysis Services projects that you can deploy, and the cubes that they contain.

Analysis Services project

Cubes in the project

Notes

Dynamics AX

Accounts payable cube

Accounts receivable cube

Budget control cube*

Budget plan cube*

Environmental sustainability cube

Expense management cube

General ledger cube

Human resources cube**

Inventory value cube*

Payroll cube**

Production cube

Profit tax totals cube*

Project accounting cube

Purchase cube

Retail cube*

Sales and marketing cube*

Sales cube

Trade allowance management cube***

Workflow cube

This project must be deployed before any other Analysis Services projects are deployed.

Demand Forecast

Demand forecast cube***

This project is available with Microsoft Dynamics AX 2012 R3.

Demand Forecast Accuracy

Demand forecast accuracy cube***

This project is available with Microsoft Dynamics AX 2012 R3.

* Indicates cubes that are available with Microsoft Dynamics AX 2012 R2 or later.

** Indicates cubes that are available with cumulative update 7 for Microsoft Dynamics AX 2012 R2 or later.

*** Indicates cubes that are available with Microsoft Dynamics AX 2012 R3 or later.

Deploy the default cubes by using the Analysis Services Project Wizard

The following procedure explains how to deploy an Analysis Services project—and process the cubes that it contains—by using the Analysis Services Project Wizard in Microsoft Dynamics AX.

To complete this procedure, you must be assigned to the System Administrator role or the Information Technology Manager role in Microsoft Dynamics AX.

Note

If you are using the initial version of Microsoft Dynamics AX 2012, you must be assigned to the System Administrator role to complete this procedure. If you install cumulative update 1 for Microsoft Dynamics AX 2012, users in the Information Technology Manager role can also complete this procedure.

  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.

    Note

    You must deploy the Dynamics AX project first. After you deploy that project, you can deploy other projects.

  6. On the Deployment options page, follow the instructions for the version of Microsoft Dynamics AX that you are using.

    If you are using this version:

    Follow these steps:

    Microsoft Dynamics AX 2012 R3

    1. Select the Deploy check box. The Analysis Services project will be associated with the Microsoft Dynamics AX partition that you are currently logged into.

      If the name of the Analysis Services server is incorrect, click Cancel to close this wizard. Then open the Analysis servers form (System administration > Setup > Business intelligence > Analysis Services > Analysis servers) to enter the correct name of the server.

    2. By default, the database that is created is named in the following way: [Analysis Services project name] + [Partition Key Name]. If you want the database to have a different name, click the name. Then enter the new name.

    3. Select the Process the project after it is successfully deployed check box.

    4. Click Next to deploy the project and process the cubes that are in it.

    Microsoft Dynamics AX 2012 R2

    1. Select the Deploy check box that is associated with the Microsoft Dynamics AX partition that you are currently logged into.

      If the name of the Analysis Services server that is used by the partition is incorrect, click Cancel to close this wizard. Then open the Analysis servers form (System administration > Setup > Business intelligence > Analysis Services > Analysis servers) to enter the correct name of the server.

    2. By default, the database that is created for each partition is named Dynamics AX [Partition Key Name]. If you want the database to have a different name, click the name. Then enter the new name.

    3. Select the Process the project after it is successfully deployed check box.

    4. Click Next to deploy the project and process the cubes that are in it.

    The initial version of Microsoft Dynamics AX 2012 or Microsoft Dynamics AX 2012 Feature Pack

    1. Select the Deploy the project check box.

    2. Enter the name of the server that is running Analysis Services.

    3. Click Create new database.

      By default, the database is named Dynamics AX. If you want the database to have a different name, enter a new name.

      Important

      If you enter a new name for the database, you must modify the DynamicsAXOLAP data source. For more information, see Update the OLAP data source.

    4. Select the Process the project after it is successfully deployed check box.

    5. Click Next to deploy the project and process the cubes that are in it.

  7. On the Deploying page, click Next when the deployment is completed.

  8. Click Finish to close the wizard.

Deploy the default cubes by using Windows PowerShell

The following procedure explains how to deploy an Analysis Services project—and process the cubes that it contains—by using Windows PowerShell.

To complete this procedure, you must meet the following requirements:

  • You must be using Microsoft Dynamics AX 2012 R2 or later.

  • You must be assigned to the System Administrator role in Microsoft Dynamics AX.

  • You must be assigned to the Administrators group on the computer from which you’ll run Windows PowerShell.

  • You must install the SQL Server 2008 R2 Analysis Management Objects (AMO) on the computer from which you’ll run Windows PowerShell. You can download AMO from this page.

  • You must be assigned to the Server Administrator role in Analysis Services.

  • You must be assigned to the Administrators group on the server that runs Analysis Services.

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

    1. Click Start > Administrative Tools.

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

    3. Click Run as administrator.

  2. View a list of the Analysis Services projects that are in the Application Object Tree (AOT) by entering the following command:

    Get-AXAnalysisProjectDetail
    

    Note

    You must deploy the Dynamics AX project first. After you deploy that project, you can deploy other projects.

  3. Deploy an Analysis Services project. The Publish-AXAnalysisProject command is used to deploy and process a project. The following examples show how to use this command. For more information, see Publish-AXAnalysisProject.

    • To deploy and process a project for all partitions in your Microsoft Dynamics AX installation, enter the following command:

      Publish-AXAnalysisProject –ProjectName [SSASProjectName] –ServerName [SSASServerName]
      
    • To deploy and process a project for a specific partition in your Microsoft Dynamics AX installation, enter the following command:

      Publish-AXAnalysisProject –ProjectName [SSASProjectName] –PartitionKeys [PartitionKey1] -ServerName [SSASServerName]
      
    • To deploy and process a project for two specific partitions in your Microsoft Dynamics AX installation, enter the following command:

      Publish-AXAnalysisProject –ProjectName [SSASProjectName] –PartitionKeys [PartitionKey1], [PartitionKey2] -ServerName [SSASServerName]