Update Cubes

You can incrementally update the objects for an existing SQL Server Analysis
Services project based on metadata defined in Microsoft Dynamics AX. This
topic describes how to use the SQL Server 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.

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.

NOTE: For more information about creating and modifying perspectives, refer
to the help. For more information about BIDS, refer to MSDN or TechNet. 

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, follow these steps:

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

2. Select Update. Click Next.

3. 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.

4. 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.

5. On the Select Microsoft Dynamics AX dimensions page, select
Microsoft Dynamics AX dimensions to associate with the cubes and
then click Next.

NOTE: 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.

6. Select calendars to use for date dimensions and then click Next.

NOTE: 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.

7. Select label languages that you want to include as translations and
then click Next.

NOTE: 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.

8. Select to add foreign currency support to the Analysis Servicesproject. Click Next.

9. Specify deployment options. Click Next and complete the wizard. 


Regards,
Hossein Karimi