Update the Cubes in dynamics AX 2012 using Visual Studio

Following steps will illustrate the way to update the analysis project cubes via visual studio framework.

1- Open the Microsoft Dynamics development AX client.
2- Click 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 Update, and then click next.

5- On the Select an existing Analysis Services project page, Select Dynamics AX (or the other project you want to update) from the AOT, and then click next.

  

6- On the Verifying the SQL Server Analysis Service Project page, click Next.

7- On select perspectives Cubes and dimensions page, select all cubes, perspectives and dimension and click Next.

8- Then select all measure groups and click Next.

9- Then select Date dimension and click Next.

10- Select the language option English(United State) and click Next.

11- Checked the foreign currency option and click Next, as shown below.

12- On the Confirm changes page, click Next. 

13- On the Deployment option page, click Cancel as shown below. (Don’t deploy the project from here, we will use visual studio for this.)

14- Right click Dynamics AX analysis project and select edit to open it the project in Visual studio. (for this visual studio development tool must be installed in Ax).

15- When the Visual Studio get open, before doing anything make sure you are connected with the correct server and database. To confirm this Right Click Dynamics AX node and click properties option. See screenshot.

16- Now make sure that you are connected with correct database (or change it accordingly), for this double clicked on                  Data Sources -> Dynamics Database

17- Now the purchcube is ready to deploy and process. Right click on purchcube and select process option. The system may appear the below message, click Yes.

18- When you click “Yes” the system may again appear with the new message before overwriting the database. Click “Yes” to continue.

19- The final message will appear when the cube gets deployed, you will be required to click on “Run” option to process the cube.

          Hope this will be helpful.