Reply To: Microsoft Dynamics AX cubes

#20853

Locus IT
Participant

Hello Ruth,

When you upgrade from Microsoft Dynamics AX 2012 to Microsoft Dynamics AX 2012 R2, you can upgrade the cubes by using the SQL Server Analysis Services project wizard. The cubes can be categorized as follows:

1. Default cubes

Default cubes are included with Microsoft Dynamics AX. If you upgrade from Microsoft Dynamics AX 2012 to Microsoft Dynamics AX 2012 R2, you can upgrade the cubes by using the SQL Server Analysis Services project wizard. If you upgrade to a new version of Microsoft Dynamics AX from Microsoft Dynamics AX 2009, you can use new default cubes to replace your existing default cubes.

To upgrade default cubes

a. Click Tools > Business Intelligence (BI) tools > Analysis Services project wizard.
b. If you upgrade from Microsoft Dynamics AX 2012 to Microsoft Dynamics AX 2012 R2, follow the steps in the wizard to update an Analysis Services project that contains the default cubes you want to use. If you upgrade to a new version of Microsoft Dynamics AX from Microsoft Dynamics AX 2009, follow the steps in the wizard to create an Analysis Services project that contains the default cubes you want to use.
c. Manually delete the legacy cubes from your Analysis Services database.

2. Customized Default Cubes

Customized default cubes are default cubes that you modify. If you upgrade from Microsoft Dynamics AX 2012 to Microsoft Dynamics AX 2012 R2, you can upgrade customized default cubes by using the SQL Server Analysis Services project wizard. If you upgrade to a new version of Microsoft Dynamics AX from Microsoft Dynamics AX 2009, you must apply the same customizations to the default cubes in the new version. Either modify the corresponding perspective and then create an Analysis Services project that contains the customized default cube, or perform customizations in Microsoft SQL Server Business Intelligence Development Studio (BIDS) or SQL Server Data Tools.

To upgrade a customized default cube

1. In the AOT, expand Data Dictionary > Perspectives.
2. Optionally modify the perspective that corresponds to the default cube you want to customize. For example, you can specify dimension attributes and measures in the perspective.
3. Click Tools > Business Intelligence (BI) tools > Analysis Services project wizard. If you upgrade from Microsoft Dynamics AX 2012 to Microsoft Dynamics AX 2012 R2, follow the steps in the wizard to update an Analysis Services project that contains the customized default cubes you want to use. If you upgrade to a new version of Microsoft Dynamics AX from Microsoft Dynamics AX 2009, follow the steps in the wizard to create an Analysis Services project that contains the default cubes you want to use.
4. Optionally customize your cube in SQL Server Business Intelligence Development Studio or SQL Server Data Tools.
5. Manually delete the old cube from your Analysis Services database.

3. Custom Cubes

Custom cubes are cubes that you create from scratch. If you upgrade from Microsoft Dynamics AX 2012 to Microsoft Dynamics AX 2012 R2, you can upgrade custom cubes by using the Update path in the SQL Server Analysis Services project wizard. If you upgrade to a new version of Microsoft Dynamics AX from Microsoft Dynamics AX 2009, you must recreate the custom cube manually. To create a custom cube, create a perspective that defines the data that will be included in the cube, and then run the Analysis Services project wizard.

Skip to toolbar