Not sure what version you are on -with MR there have been a lot of bug fixes, so its best to upgrade to latest release.
- see hotfix 3599519 which might apply - Large number of records in GL00100 table causes timeouts in integration and performance issues in Configuration Console
Click the “Refresh” button in the Report Queue, when running reports. The Report Queue only pings the server every 10 seconds to update the report status. By refreshing the report, you’ll see the report move more quickly through the steps, and at the end, pull up 10 seconds faster.
If it only one report that is slow then excessive filters on that report might be a problem.
You can try tweaking the MRServiceHost.settings.config file at C:\Program Files\Microsoft Dynamics AX\60\Management Reporter\2.1\Server\Services -there are several options:
Open the "MRServiceHost.settings.config" file in Notepad
Insert the following line: <add key="CardinalityFilterEnabled" value="false" /> this may speed it up
Extend the timeout in the same MRServiceHost.settings.config file it will not run any faster but it should complete but test in test system first to see just how long
Original value: <add key="DataMartQueryTimeout" value="30" />
Max value: <add key="DataMartQueryTimeout" value="-1" />
Change the IntegrationReaderTimeout to a greater value, or put 0 - which means no time-out
Also look at extending the SqlBulkCopyTimeout
Limit the number of fiscal years data in the Data Mart. The less data in the Data Mart, the faster your reports will run. This will not delete any data in your Dynamics database, but it restricts how much of it is reported. Change it back at any time, to pull more years, when needed. In the same same MRServiceHost.settings.config file add this line to the file:
<add key="IntegrationFiscalYearStart" value="2017" / (Replace “2017” with the year from which to pull data)
You now have to make this effective so click the “Disable Integration” button to disable your MR Data Mart. Click the “Remove” button to remove the MR Data Mart. Open SQL Management Studio, and delete the MR Data Mart database.Go back to the MR Configuration Console, and restart both the MR Application and Process Services
Select File, Configure, and add back the Data Mart. Enable the Data Mart. Log into Management Reporter, Your Fiscal Year options are now limited in your Report Definitions.
