You experience slow performance when you generate a financial statement in Microsoft Dynamics AX 2012

This article applies to Microsoft Dynamics AX for all regions.

Symptoms

Assume that you use an account structure that contains a main account and several dimensions in Microsoft Dynamics AX 2012. You define a financial statement by using a dimension set for a dimension and the main account. When you generate the financial statement, you experience slow performance. It takes too much time to generate the financial statement.

Resolution

Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website: You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

PartnersCustomersIn special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.


Installation information

If you have customizations for one or more of the methods or the tables that are affected by this hotfix, you must apply these changes in a test environment before you apply the hotfix in a production environment.
For more information about how to install this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:
893082 How to install a Microsoft Dynamics AX hotfix

Prerequisites

You must have Microsoft Dynamics AX 2012 installed to apply this hotfix.

Restart requirement

You must restart the Application Object Server (AOS) service after you apply the hotfix.
File information

Objects that are affected

This hotfix affects the following object:
  • \Classes\DimensionTopicsPrioritizer\initFromHierarchy

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

This hotfix improves the performance. However, it may not provide sufficient reductions in time to generate the financial statements.

To improve the performance of the creation and generation of financial statements, you can use Microsoft Dynamics Management Reporter 2012. Management Reporter uses a Data Mart that is conducive to reporting requirements and allows for faster report generation times. By using a Data Mart for the financial statement generation, As a Microsoft Dynamics AX user, you will not experience any system degradation when you perform other business tasks or processes.

With Management Reporter, you can create boardroom-quality reports without IT assistance. You can use Microsoft Dynamics AX dimensions to create customized financial statements, and use a centralized report library to provide secure report distribution and storage. Management Reporter works directly with the Microsoft Dynamics AX general ledger. This eliminates the need to create a custom connection to your primary data source.

Microsoft Dynamics Management Reporter 2012 is available in the following countries:
  • Australia
  • Austria
  • Belgium
  • Canada
  • Denmark
  • France
  • Germany
  • India
  • Ireland
  • Italy
  • Malaysia
  • Mexico
  • Netherlands
  • New Zealand
  • Peoples Republic of China
  • Russia, Singapore
  • South Africa
  • Spain
  • Switzerland
  • United Kingdom
  • United States
For more information about Microsoft Dynamics Management Reporter, go to the following Microsoft website:
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2756533 - Last Review: 17 Feb 2017 - Revision: 3

Microsoft Dynamics AX 2012, Financials General Ledger

Feedback