In this blog post, I would like to explain how you can view and edit the frequency of the Management Reporter Data Mart.
The Data Mart is basically the data provider to integrate information from Dynamics AX operational database. During the installation of Management Reporter, new databases are created [ManagementReporter] and [ManagementReporterDM]. The frequencies of the Data Mart refresh is set up by default for every task.
View the scheduling of your data mart
You can run this simple script in SQL Server Management Studio to see the frequency of the several tasks:
SELECT Task.Name, Trig.Interval,CASE Trig.[UnitOfMeasure]
WHEN 1 THEN 'Seconds'
WHEN 2 THEN 'Minutes'
WHEN 3 THEN 'Hours'
WHEN 4 THEN 'Days'
End as UnitOfMeasure
FROM [Connector].[Map] Map
Inner join [Scheduling].[Task] Task on Map.MapId = Task.Id
Inner join [Scheduling].[Trigger] Trig on Task.TriggerId = Trig.Id
ORDER BY Name desc
For Dynamics AX 2012 R3, the default scheduling is:
Change the frequency of your data mart
If you want to change the values of the scheduling, you need to update the field [Interval] in the [Trigger] table. The following script is an example you can run in SQL Server Management Studio:
First, you need to retrieve the ID of the Task you want to update:
Select [Task].TriggerId , [Task].Name
Where [Task].Name = 'AX 2012 Accounts to Account'
Then you can change the values, for exemple, from 5 to 10 minutes:
Set Interval = ‘10’
Where Id = -- here we can paste the TriggerID retrieved above
When the configuration file is changed, it is necessary to restart the services. But it shouldn't be the case with the frequency changes described in this blog post.
You can find another blog post that describes how to reset the datamart.
Please also keep in mind Management Reporter can be updated on regular basis. You can find the latest Cumulative Update on this customer source page.
Principal Premier Field Engineer