Skip to content

Latest commit

 

History

History
304 lines (207 loc) · 11.7 KB

deploy-the-default-cubes.md

File metadata and controls

304 lines (207 loc) · 11.7 KB
Raw
title TOCTitle ms:assetid ms:mtpsurl ms:contentKeyID author ms.date mtps_version
Deploy the default cubes
Deploy the default cubes
581f609e-588c-45ce-bc10-32a863ef4589
28119359
tonyafehr
07/28/2014
v=AX.60

Deploy the default cubes

[!INCLUDEarchive-banner]

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]