Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Data collection for the Named User License Counts report in Dynamics AX 2012 R3 Cumulative Update 9 and later

You may be already familiar with the blog post of my colleague in which the background of the Named User License Counts report is explained. Using the Named User License Count report In this post, I would like to explain a change that was introduced in relation to this report in Cumulative Update 9 for… Read more

SSRS Report label shown as @SYSxxxx in AX2012

Here in this blog I will share two scenarios when this happening and basic troubleshooting steps when facing this issue. Issue: When you are rendering SSRS report, the data will load correctly, but all AX labels are not resolved: Two known causes of this: SQL Server Reporting service version does not meet AX requirement. You… Read more

Why does converting a report to pre-processing help to resolve timeout issues?

I assume you are familiar with the below post that contains detailed instructions for increasing relevant timeouts to enable long running reports to execute successfully. How To: Addressing SSRS Session Timeouts (Alternatively Tips to help prevent long-running reports from timing out [AX 2012]) The first recommendation in case of reports which use the Report Data… Read more

Configure SSRS for load balancing in your Azure deployment

Using the Cloud-hosted environment tool in Lifecycle Services, you can deploy a High Availability environment. When you deploy a High Availability environment, two BI servers are deployed by default. Each BI server has SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) configured as a unique local instance. Use the following information to… Read more

Troubleshooting that elusive “slowdown” in AX using Performance Analyzer 1.20 for Microsoft Dynamics

It’s 9.30am on Monday morning and you’ve just received reports of a “general slowdown” on Microsoft Dynamics AX. After probing further you find it was all over by 9:15am lasting around 15 minutes, but also happened once before and the users want action taken to prevent it happening again. There are never any guarantees when… Read more

AX Performance Troubleshooting Checklist Part 2

Updated on 09/09/16 for DynamicsPerf v2.0. This is Part 2 of a two part troubleshooting check list for general performance on Microsoft Dynamics AX. This part includes  hardware, indexing, queries,  blocking and code – at a high level. Please note this is just an outline of key areas for general guidance and not an exhaustive… Read more

AX Content: The Compare Tool works with SSRS reports

With cumulative update 7 for Microsoft Dynamics AX 2012 R2, the Compare Tool has been updated to support comparison of two SSRS report designs. This means that when an updated report is released with a cumulative update or hotfix, you can now easily compare the updated report with your existing report to see the differences… Read more

AX Content: Warm up those SSRS servers

Microsoft SQL Server Reporting Services periodically restarts, and each restart clears the Reporting Services cache. After this cache has been cleared, it may take some time for the next report that is run to display. For example, you may have noticed that it takes a really long time for the first report that is run… Read more

AX Content: Multiple instances of SQL Server Reporting Services (SSRS) on one computer

Do you have multiple instances of SQL Server Reporting Services that run on the same computer? Do you want to integrate those instances with Microsoft Dynamics AX? If so, a Windows PowerShell command is now available with cumulative update 7 for Microsoft Dynamics AX 2012 R2 that makes the integration process a whole lot easier! … Read more

Microsoft Dynamics AX 2012 Reporting – tips how to improve performance

There are some tips we can use to improve performance of reports for Dynamics AX 2012. Use static reports. The deployment of static reports is described here: In this way we will safe several calls to Metadata service to get labels values and correct formatting of dates and numbers. Install application hotfix KB 2879661… Read more