What's New: Analytics for Developers in Microsoft Dynamics AX 2012 [AX 2012]
Updated: January 4, 2012
Applies To: Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This topic describes the changes to the Online Analytical Processing (OLAP) framework in Microsoft Dynamics AX 2012.
Microsoft Dynamics AX provides a model driven approach for developing Business Intelligence (BI) applications that use the SQL Server Business Intelligence Development Studio (BIDS) development environment. Microsoft SQL Server Analysis Services provides OLAP functionality.
What is New or Changed?
You can use Microsoft Dynamics AX views to model data in perspectives.
The Analysis Services project wizard is introduced to make it easier to create, update, configure, and deploy Analysis Services projects. The wizard performs many of the tasks that you would otherwise need to perform manually in BIDS.
You can create Gregorian calendars to use as date dimensions in your Analysis Services project.
Microsoft Dynamics AX View Support in Perspectives
| What can you do? | Microsoft Dynamics AX 2009 | Microsoft Dynamics AX 2012 | Why is this important? | Where can I find more information? |
|---|---|---|---|---|
| Model data in perspectives. | Use tables to model data in perspectives. Use custom query definitions to perform the following tasks:
| Use tables and views to model data in perspectives. | Modeling data using views and tables makes it easier to customize cubes. |
Analysis Services Project Wizard
| What can you do? | Microsoft Dynamics AX 2009 | Microsoft Dynamics AX 2012 | Why is this important? | Where can I find more information? |
|---|---|---|---|---|
| Deploy default cubes. | Initially deploy the default cubes by using the Setup wizard. | Use the Analysis Services project wizard to deploy an existing Analysis Services project. Choose the default cubes from the AOT. | It is easier to deploy the default cubes. | How to: Deploy an Existing SQL Server Analysis Services Project |
| Configure an Analysis Services project after you change the Microsoft Dynamics AX configuration. | Manually update your Analysis Services project in BIDS to remove measures, dimensions, and KPIs that you do not have access to according to the license and configuration keys in Microsoft Dynamics AX. | Use the Analysis Services project wizard to remove measures, dimensions, and KPIs that you do not have access to according to the license and configuration keys in Microsoft Dynamics AX. | It is easier to update Analysis Services projects after you change the Microsoft Dynamics AX configuration. | How to: Configure an Existing SQL Server Analysis Services Project |
| Update an existing Analysis Services project. | Use the Update a Business Intelligence project form. | Use the Analysis Services project wizard to update an Analysis Services project to do the following:
| It is easier to update an existing Analysis Services project. | How to: Update an Existing SQL Server Analysis Services Project |
| Create a new Analysis Services project. | Use the Update a Business Intelligence project form. | Use the Analysis Services project wizard to create an Analysis Services project. | It is easier to create a new Analysis Services project. |
Date Dimensions using Gregorian Calendars
| What can you do? | Microsoft Dynamics AX 2009 | Microsoft Dynamics AX 2012 | Why is this important? | Where can I find more information? |
|---|---|---|---|---|
| Add date dimensions to cubes. | Date dimensions are not available in Microsoft Dynamics AX 2009. Use a system time dimension instead. | Define Gregorian calendars in the Date dimensions form in Microsoft Dynamics AX that you can use as Date dimensions in your Analysis Services project. | The limitations of using the server time dimension in Microsoft Dynamics AX 2009 are as follows:
|
