When you installed the Microsoft Dynamics AX Analysis Extensions, an OLAP database named Dynamics AXwas created for you. This database includes several cubes that you must process. Initially, you must process these cubes so that they are available to users. After that, you will need to process the cubes on a regular basis so that they are up-to-date and contain the latest data.

Initial processing of cubes

Use the following steps to process your cubes for the first time.

  1. Open SQL Server Management Studio ( Start> All Programs> Microsoft SQL Server> SQL Server Management Studio).

  2. In the Connect to Serverwindow, select your Analysis Services instance and enter credentials to log on to the instance.

  3. In the Object Explorer, expand the Databases> Dynamics AX> Cubesfolder.

  4. Right-click the cube that you want to process and click Process.

  5. In the Process Cube - <Cube Name>form, click OKto process the cube.

  6. Repeat steps 4-5 for each cube that you want to process.

Processing cubes on a regular basis

To process cubes on a regular basis so that they are up-to-date and contain the latest data, set the proactive caching options. For more information, see Configure proactive caching to refresh cube data.