What's new: Analytics
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This article describes the new features for online analytical processing (OLAP) in Microsoft Dynamics AX.
New features in Microsoft Dynamics AX 2012 R3 New features in cumulative update 7 for Microsoft Dynamics AX 2012 R2 New features in Microsoft Dynamics AX 2012 R2 New features in Microsoft Dynamics AX 2012 |
.png "Resources")
Características nuevas, modificadas y obsoletas de AX 2012 (articles) Novedades: creación de informes (article) |
New features in Microsoft Dynamics AX 2012 R3
The following features have been added in AX 2012 R3.
.gif "Dn507140.collapse_all(es-es,AX.60).gif")
New cubes
Microsoft Dynamics AX provides cubes that you can use to analyze your business data. The following table lists the Microsoft SQL Server Analysis Services projects that are provided with AX 2012 R3, and the cubes that are included with each project. The cubes that are new in AX 2012 R3 are followed by an asterisk (*).
Analysis Services project |
Cubes that are included in project |
|---|---|
Demand Forecast |
Demand forecast cube* |
Demand Forecast Accuracy |
Demand forecast accuracy cube* |
Dynamics AX |
Accounts payable cube Accounts receivable cube Budget control cube Budget plan cube Environmental sustainability cube Expense management cube General ledger cube Human resources cube Inventory value cube Payroll cube Production cube Profit tax totals cube Project accounting cube Purchase cube Retail cube Sales and marketing cube Sales cube Trade allowance management cube* Workflow cube |
For more information about the cubes, see Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3.
New features in cumulative update 7 for Microsoft Dynamics AX 2012 R2
The following features have been added in cumulative update 7.
New cubes
Microsoft Dynamics AX provides cubes that you can use to analyze your business data. The following cubes are included with cumulative update 7. The cubes that are new in this version are followed by an asterisk (*).
Accounts payable cube
Accounts receivable cube
Budget control cube
Budget plan cube
Environmental sustainability cube
Expense management cube
General ledger cube
Human resources cube*
Inventory value cube
Payroll cube*
Production cube
Profit tax totals cube
Project accounting cube
Purchase cube
Retail cube
Sales and marketing cube
Sales cube
Workflow cube
For more information about the cubes, see Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3.
New features in Microsoft Dynamics AX 2012 R2
The following features have been added in AX 2012 R2.
New cubes
Microsoft Dynamics AX provides cubes that you can use to analyze your business data. The following cubes are included with AX 2012 R2. The cubes that are new in this version are followed by an asterisk (*).
Accounts payable cube
Accounts receivable cube
Budget control cube*
Budget plan cube*
Environmental sustainability cube
Expense management cube
General ledger cube
Inventory value cube*
Production cube
Profit tax totals cube*
Project accounting cube
Purchase cube
Retail cube*
Sales and marketing cube*
Sales cube
Workflow cube
For more information about the cubes, see Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3.
Windows PowerShell commands for cube deployment
If you are using AX 2012 R2, you can use Windows PowerShell commands to deploy the default cubes that are included with Microsoft Dynamics AX. For more information, see Deploy the default cubes.
Support for Power View
Power View is a tool that you can use to create highly interactive, custom reports. For example, assume that you want to create a report that shows sales amounts for your retail stores. In this case, you can open Power View, connect to the Retail cube, select the fields to display on the report, and display the report on a Role Center page in Microsoft Dynamics AX.
Nota
If Analysis Services and Enterprise Portal are installed on different computers, you must use Kerberos security to create Power View reports.
For more information about how to create Power View reports, see Crear un informe mediante Power View para conectarse a un cubo.
Support for data partitions
An AX 2012 R2 installation might consist of multiple data partitions. You must deploy cubes for each partition in your installation.
For example, assume that you have two partitions, Partition 1 and Partition 2. To deploy the cubes that are included with Microsoft Dynamics AX for both of these partitions, follow these steps.
Start the Microsoft SQL Server Analysis Services Project wizard.
Select the default Analysis Services project, which is named Dynamics AX.
Deploy the project for each partition in your installation by selecting the partitions. In this example, you select Partition 1 and Partition 2.
Complete the wizard.
Open SQL Server Management Studio, and connect to the Analysis Services instance. There are now a database and cubes for each partition.
For more information about data partitions, see Data partitioning architecture. For more information about how to deploy cubes for each partition, see Deploy the default cubes.
Improvements to the Business Overview web part
Business Overview web parts, which are used on Role Center pages, can display financial indicators or key performance indicators (KPIs).
A financial indicator is a data calculation across various time periods. An indicator represents a measure in an OLAP cube.
A KPI is a business metric, such as the total revenue, gross profit margin, or current ratio. A KPI can help you track your organization’s progress toward a performance goal.
The following enhancements have been made to the way that you display indicators and KPIs in the Business Overview web part in AX 2012 R2.
Feature |
Description |
|---|---|
You can apply multiple filters to indicators and KPIs. |
For example, assume that you have selected to display your organization’s sales total. You can filter this KPI so that it displays only the sales that were made in 2012 by a specific salesperson. In this case, the filters resemble the following filters:
|
You can filter by relative dates or actual values. |
For example, assume that you have selected to display your organization’s sales total. If you want to filter this KPI by a relative date, you can display only the sales that were made last year, last month, or last quarter. If you want to filter this KPI by an actual value, you can display only the sales where Year = 2012. |
You can split the data. |
You can display the individual elements that the whole indicator or KPI is made of. For example, assume that you have selected to display your organization’s sales total. You can split the sales total by salesperson to display the sales totals of all salespeople, or you can split the sales total by region to display the sales totals of each region. You can also filter the list of elements. For example, assume that you can display only the top 10 salespeople or the 10 regions where the fewest sales were made. Alternatively, you can filter out the regions where no sales occurred. |
You can link to menu items or URLs. |
You can format the name of the indicator or KPI as a hyperlink. The hyperlink can direct users to the following items:
|
For more information about how to use the Business Overview web part, see Visión general sobre la gestión de negocios.
Upgrade information
The instructions for upgrading cubes vary, depending on the version of Microsoft Dynamics AX that you are upgrading from. The following table describes upgrade scenarios.
Scenario |
How to upgrade |
|---|---|
You are upgrading from Microsoft Dynamics AX 2009 to any version of Microsoft Dynamics AX 2012. |
When you upgrade, you must create new cubes to display the information that your old cubes displayed. For more information, see How to: Upgrade Microsoft Dynamics AX cubes. |
You are upgrading from the initial release of Microsoft Dynamics AX 2012 or Microsoft Dynamics AX 2012 Feature Pack to Microsoft Dynamics AX 2012 R2. |
When you upgrade, use the Analysis Services Project wizard to upgrade the cubes. For more information, see How to: Upgrade Microsoft Dynamics AX cubes. |
New features in Microsoft Dynamics AX 2012
The following features have been added in AX 2012.
New cubes
Microsoft Dynamics AX provides cubes you can use to analyze your business data. The following cubes are included with the initial release of AX 2012. The cubes that are new in this version are followed by an asterisk (*).
Accounts payable cube
Accounts receivable cube
Customer relationship management cube
Environmental sustainability cube*
Expense management cube
General ledger cube
Production cube
Project accounting cube
Purchase cube
Sales cube
Workflow cube*
For more information about the cubes, see Cube and KPI reference for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack.
Cube deployment
The process for deploying the default Analysis Services cubes that are included with Microsoft Dynamics AX has changed in the following ways.
Feature |
Description |
|---|---|
The Setup wizard has changed. |
To deploy the default cubes that were included with AX 2009, you had to install the analysis extensions when you ran the Setup wizard. In AX 2012, the Setup wizard has been changed. The Setup wizard no longer includes an option for installing the analysis extensions. When you run the Setup wizard, you can select the Analysis Services configuration option. When you select this option, the Setup wizard performs the following actions:
The Setup wizard does not deploy the default cubes that are included with AX 2012. To deploy the cubes, you must run the Analysis Services Project wizard. |
The Analysis Services Project wizard has been added. |
The Analysis Services Project wizard has been added to AX 2012. Use this wizard to deploy and configure cubes. For more information, see the next section in this topic. |
Analysis Services Project wizard
The Analysis Services Project wizard has been added to AX 2012. This wizard makes it easier to deploy and configure cubes. The following table explains when you should use the Analysis Services Project wizard.
Task |
Description |
More information |
|---|---|---|
Deploy default cubes. |
Use the Analysis Services Project wizard to deploy an Analysis Services project and the cubes that the project contains. |
|
Configure an Analysis Services project after you change the Microsoft Dynamics AX configuration. |
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. |
|
Update an existing Analysis Services project. |
Use the Analysis Services Project wizard to update an Analysis Services project as follows:
|
|
Create an Analysis Services project. |
Use the Analysis Services Project wizard to create an Analysis Services project. |
Ability to use views to model data in perspectives
In AX 2012, you can now use both tables and views to model data in perspectives. Modeling data by using tables and views makes it easier to customize cubes. For more information, see Create a perspective for a cube.
Date dimensions
In AX 2012, you can add date dimensions to your cubes. This means you can now examine the data in a cube by using different periods, such as months, quarters, or weeks.
To add date dimensions to your cubes, follow these steps.
Use the Date dimensions form to specify the date dimensions that are used to examine the data in a cube. For more information, see How to: Create a Date Dimension for a Cube.
Run the Analysis Services Project wizard to add the date dimensions to your cube. For more information, see Update an Existing SQL Server Analysis Services Project.
Upgrade information
If you are upgrading from AX 2009 to AX 2012, you must create new cubes to display the information that your old cubes used to display. For more information, see How to: Upgrade Microsoft Dynamics AX cubes.