How to: Update an Existing SQL Server Analysis Services Project
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
You can incrementally update the objects for an existing SQL Server Analysis Services project that is based on metadata defined in Microsoft Dynamics AX. This topic describes how to use the Analysis Services project wizard to update Analysis Services projects.
You can update an Analysis Services project without overwriting the core dimensional model object definitions, such as dimensions, dimension attributes, measure groups, measures, and cubes. For example, you can update an Analysis Services project to add new language translations for tables and fields that are referenced by a deployed cube or to update the cube enumeration list. You can also add new attributes and measures to a perspective and then update a deployed cube by using the Analysis Services project wizard.
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 from 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.
When you update 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 update a SQL Server Analysis Services project
Click Tools > Business Intelligence (BI) tools > SQL Server Analysis Services project wizard. The SQL Server Analysis Services Project wizard form is displayed. Click Next.
Select Update. Click Next.
Select the Analysis Services project to update. You can select a project that is already deployed in the AOT or open a project from a file. Click Next. If the project builds, click Next again.
Select the perspectives that correspond with the cubes you want included in the project. Move the perspectives you want to include in the project to the Selected list. Move the perspectives you want to remove from the project to the Available list. Click Next.
On the Select Microsoft Dynamics AX dimensions page, select Microsoft Dynamics AX dimensions to associate with the cubes and then click Next.
Dimensions in the Selected list will be included in the project. Dimensions in the Available list will not be added to the project, and will be removed if they were in the project before.
Select calendars to use for date dimensions and then click next.
Calendars in the Selected list will be included in the project. Calendars in the Available list will not be added to the project, and will be removed if they were in the project before.
Select label languages that you want to include as translations and then click Next.
Languages in the Selected list will be included in the project. Languages in the Available list will not be added to the project, and will be removed if they were in the project before. If values in your cubes display in English even after you specify a different language, you can open the Analysis Services project in BIDS and modify the translations. For more information, see the SQL Server documentation.
Label translations are global and incremental. You cannot update the labels for a subset of elements.
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.
Select to add foreign currency support to the Analysis Services project. Click Next.
Specify deployment options. Click Next and complete the wizard.
Financial dimensions only work in the partition they are created in. Only deploy Analysis Services projects to the partition you are currently in.
Log files are generated in two locations. Information is logged in the global log file path that is specified in the Analysis servers form. This log file is not generated if you do not specify the global log file path. When the Analysis Services project is updated, the information about the changes to the project is logged in the UpdateProjectActions.log file in the project folder.