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
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
*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
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
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
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
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
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