Create an Analysis Services Project

The cube data can be saved in an Analysis Services project and deployed directly
to the Analysis Services server. However, to develop KPIs for a Role center
using the cube data, you must create an Analysis Services project and edit the
project using BIDS.

The following procedure explains how to create an Analysis Services project.

1. Click Tools > Business Intelligence (BI) tools > SQL Server Analysis Services project wizard. The SQL Server Analysis Services project wizard form appears.

2. Click Next. 

3. Select Create. In the Project name field, type Dynamics AX SalesAnalysis. Click Next.

4. Select Sales analysis from the Available list and move it to the Selected list. Click Next.

5. On the Select Microsoft Dynamics AX dimensions page, click Next.

6. Select Date from the Available list and move it to the Selected list. Click Next.

7. Select Arabic, Chinese (Simplified), and English (United States) from the Available list and move them to the Selected list. Click Next.

8. Select Add foreign currency support to the Analysis Services project and then click Next. After the project is generated, click Next again.

9. Select Save to AOT. Select Dynamics AX from the list, or create a new AOT node. Select Save to disk, type the location to which to save the project, and then click Next.

10. If the project is completed, you can also deploy from this wizard.

a. On the Deployment options page, Select Deploy the project. Specify the server name.

b. Select Create new database. Type Dynamics AX SalesAnalysis.

c. Select Process the project after it is successfully deployed and then click Next.

d. Click Next and then Finish. 

For this demonstration, you will not deploy the project because the it is not yet
complete.



Best Regards,
Hossein Karimi