Configure an Existing SQL Server Analysis Services Project [AX 2012]

Updated: November 15, 2013

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

Microsoft Dynamics AX includes several default cubes. If you deploy these cubes before you modify your license configuration, you must update the cubes that you deployed by using the Analysis Services project wizard.

You can use SQL Server Business Intelligence Development Studio (BIDS) or the Analysis Services project wizard to deploy the default cubes.

To deploy the default cubes

During implementation, it is common to change configuration keys. You should update the default cubes after the configuration phase is completed. You configure Microsoft Dynamics AX by entering license codes in the License information form, and by enabling or disabling configuration keys in the License configuration form.

NoteNote

If you change your Microsoft Dynamics AX configuration more than one time, you can use the Configure option in the Analysis Services project wizard the first time, but you should use the Update option to update your Analysis Services project to reflect any subsequent configuration changes.

To configure Microsoft Dynamics AX

After you configure Microsoft Dynamics AX, you must configure any analysis cubes that were already deployed based on the original configuration. Use the Analysis Services project wizard to remove measures, dimensions, and all dependent objects that are not available due to the Microsoft Dynamics AX configuration change.

You can create Key Performance Indicators (KPIs) in SQL Server Business Intelligence Development Studio (BIDS) after you create an Analysis Services project. KPIs are also included with the default cubes. When you configure or update the Analysis Services project, the KPIs will be updated based on the following:

  • If the KPI is in both the source and the target Analysis Services projects, the KPI from the source will override the KPI in the target.

  • If the KPI is in the source only, the KPI from the source will be added to the updated Analysis Services project.

  • If the KPI is in the target only, the KPI from the target will remain unchanged in the Analysis Services project. In this case, the KPI may become invalid if it uses data that has been removed from the Analysis Services project. You must validate your KPIs in this scenario.

NoteNote

When you configure an Analysis Services project by using the wizard, the old project is overwritten by a new Analysis Services project. A backup copy of the project folder is available in your temp directory. For example, the project folder may be located in C:\Users\User1\AppData\Local\Temp\1.

To configure analysis cubes

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

  2. On the Select an option page, select Configure. Click Next.

  3. On the Select an existing Analysis Services project page, select the project to update. You can select a project from the AOT or from disk. Click Next After the project builds, click Next again.

  4. Select the Apply the Microsoft Dynamics AX configuration to the Analysis Services project check box. Click Next.

  5. Select additional languages for which to provide label translations and then click Next.

    NoteNote

    Language translations are supported if you use Microsoft SQL Server 2008 Enterprise Edition or Microsoft SQL Server 2008 R2 or later for your Analysis Services server. Do not include translations in the project if you are using a Microsoft SQL Server 2008 Standard Edition Analysis Services server. If you do and you get an error, you can delete the Analysis Services project in the AOT and then redeploy the Analysis Services project by using the SQL Server Analysis Services project update wizard. Alternatively, you can edit the Analysis Services project in BIDS to remove the translations. To do this, open the Analysis Services project in BIDS. Open each cube and dimension, and then click the Translations tab. Right-click the column for each translation that is not a Default translation, and then click Delete translation. After you have removed the translations, import the project into the AOT.

  6. After the project is generated, click Next.

  7. On the Deployment options page, specify whether to deploy the project and whether to process the project. If you do not process the project, you will not be able to browse cube data. Click Next until you reach the end of the wizard.

NoteNote

The fixed database schema that Microsoft Dynamics AX uses means that related data is not removed from the database when a configuration key is disabled. When you disable a license or configuration key, some data and functionality in Microsoft Dynamics AX is removed from cubes. You must remove all reports and KPIs that rely on the data that is unavailable.

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.


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

Community Additions

ADD
Show: