Microsoft Dynamics 365 Blog

SSRS Report label shown as @SYSxxxx in AX2012 

2 min read

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: As we can see AOS has already processed the label resolve request, and all results has…Read more

0 Comments

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

4 min read

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

0 Comments

Configure SSRS for load balancing in your Azure deployment 

5 min read

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

0 Comments

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

2 min read

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

0 Comments

AX Performance Troubleshooting Checklist Part 2 

13 min read

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

0 Comments

AX Content: The Compare Tool works with SSRS reports 

1 min read

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

0 Comments

AX Content: Warm up those SSRS servers 

1 min read

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

0 Comments

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

1 min read

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

0 Comments

Microsoft Dynamics AX 2012 Reporting – tips how to improve performance 

5 min read

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: http://technet.microsoft.com/en-us/library/hh496446.aspx 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

0 Comments

We want to hear from you! Participate in the Microsoft Dynamics AX product suggestions program 

1 min read

Make your opinion count! Give us your product suggestions and help to make future versions of the Microsoft Dynamics AX applications better. Use this Microsoft Connect site to submit your product suggestions for Microsoft Dynamics products. Search existing suggestions and vote on suggestions submitted by others. Your feedback counts – future versions and enhancements of…Read more

0 Comments