page contents

How to change your Management Reporter Data Mart scheduling for Dynamics AX 2012


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:

USE ManagementReporter
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
From [ManagementReporter].[Scheduling].[Task]
Where [Task].Name = ‘AX 2012 Accounts to Account’

Then you can change the values, for exemple, from 5 to 10 minutes:

Update Scheduling.[Trigger]
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.

 

Regards,

@BertrandCaillet
Principal Premier Field Engineer

 

 

 


Comments (3)

  1. Marc Gougeon says:

    Merci Bertrand. Faut-il prévoir une analyse afin de trouver le bon équilibre entre la fréquence et le volume de données ? En effet,
    sur un aspect purement performance (sans prendre en compte l’aspect fonctionnel d’avoir des données fraîches), faut-il mieux interroger toutes les minutes la base AX en ramenant peu de lignes ou tous les quarts d’heure avec plus de volume ? Ou toutes les heures ?

    1. Hi Marc,

      The Data Mart only retrieves the relevant data from the Dynamics AX database in incremental way thanks to the change tracking feature of SQL Server.

      The default scheduling has been set up for performance best practice and I will only suggest to tune the frequencies if clear bottleneck has been identified.

      Regards,
      Bertrand

Skip to main content