What's new: Analytics

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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.

What's new

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

Resources

New, Changed, and Deprecated Features for AX 2012 (articles)

What's new: Reporting (article)

New features in Microsoft Dynamics AX 2012 R3

The following features have been added in AX 2012 R3.

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.

Note

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 Create a report by using Power View to connect to a cube.

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.

  1. Start the Microsoft SQL Server Analysis Services Project wizard.

  2. Select the default Analysis Services project, which is named Dynamics AX.

  3. Deploy the project for each partition in your installation by selecting the partitions. In this example, you select Partition 1 and Partition 2.

  4. Complete the wizard.

  5. 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:

  • Filter 1: Year = 2012

  • Filter 2: Salesperson Name = Kim Ackers

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:

  • A menu item in the Microsoft Dynamics AX client

  • A menu item in Enterprise Portal for Microsoft Dynamics AX

  • A URL

For more information about how to use the Business Overview web part, see Manage business overview information.

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:

  • Verifies that prerequisite software has been installed on the server that runs Analysis Services. For more information about the prerequisite software, see the system requirements.

  • Prompts you to specify the domain accounts that will be used to process cubes. The Setup wizard gives these accounts read access to the online transaction processing (OLTP) database for Microsoft Dynamics AX.

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.

Deploy an Existing SQL Server Analysis Services Project

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.

Configure an Existing SQL Server Analysis Services Project

Update an existing Analysis Services project.

Use the Analysis Services Project wizard to update an Analysis Services project as follows:

  • Add or remove dimensions.

  • Add, remove, or update the calendars that are used as date dimensions.

  • Add or remove label translations.

  • Add or remove currency conversion.

Update an Existing SQL Server Analysis Services Project

Create an Analysis Services project.

Use the Analysis Services Project wizard to create an Analysis Services project.

Create a New SQL Server 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.

  1. 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.

  2. 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.