Microsoft Dynamics AX Support

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

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

View a full breakdown of cost per item using the Inventory Value Statement with Standard Cost Breakdowns report in Dynamics AX

*Disclaimer: This blog only applies to items using a Standard Cost item model group.   Many customers have the need to view a full breakdown of costs for individual items that they produce, but have difficulty generating a report that accurately and cleanly breaks down this information.  This can easily be achieved by effectively utilizing… 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: 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: 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

Microsoft Dynamics AX 2012 Reporting extensions: Error System.Security.Permissions.EnvironmentPermission while running report

We run into issue that whenever we used a Microsoft Dynamics AX configuration file with a Reporting Services instance (as mentioned in here: http://technet.microsoft.com/en-us/library/hh389774.aspx) the following error was reported the first time a report was run after the restart of the SQL Reporting Services instance: “The DefaultValue expression for the report parameter ‘AX_CompanyName’ contains an error: Request for… Read more