Develop Cubes

The "Create New Cubes" demonstration will create a cube that enables you to
analyze data from Microsoft Dynamics AX 2012. During the demonstration, you
will use the Business Intelligence (BI) properties in Microsoft Dynamics AX
2012 to specify measures and attributes for the cube. Additionally you will
generate an Analysis Services project so that you can work with the cube in SQL
Server Business Intelligence Development Studio (BIDS).

In this demonstration's sequence of steps, you will create an analysis cube called
"Sales analysis" that will allow you to analyze the following data for the Contoso
group of companies:

• Sales revenue by quarter, months, and weeks

• Sales revenue by payment mode

• Average sales by customer group

The demonstration steps include the following tasks:

• Creating a perspective for a cube

• Specifying cube measure and attributes

• Generating an Analysis Services project

• Deploying a cube

• Browsing cube data

Before performing the steps in the demonstration, you will need to have the following installed:

• Microsoft Dynamics AX with demo data

• SQL Server Business Intelligence Development Studio

• Analysis Services extensions for Microsoft Dynamics AX


Best Regards,
Hossein Karimi