Reports › Create Reports Using Report Designer › Schedule Mart Report Synchronization

Schedule Mart Report Synchronization

In the Workgroup Edition, the model data and model report data are stored in separate internal tables. The model report data table (m9ReportData) includes only those columns that are required to generate model-specific reports. When you update a model and save the changes, both the tables are updated. Although erwin® Data Modeler displays a message that the model is saved, the corresponding model report data table is still being updated in the background. In this scenario, if you try to generate a report, the report may not include the details that you have just updated. This means, there is a delay in the synchronization of model data and the model report data tables.

From this release onward, you can synchronize the tables dynamically or schedule the synchronization for a later time. Typically such synchronizations are scheduled for a time when there is minimum traffic on the server. The default is dynamic synchronization.

Dynamic Synchronization

Specifies that the model report data table is updated as and when the corresponding model is updated. You can see the reporting status of the source models in the Report Status column of the Mart Open dialog.

Scheduled Synchronization

Specifies that the model report data table is updated at the scheduled time. You can see the reporting status of the source models in the Report Status column of the Mart Open dialog.

Follow these steps:

1. Log out of the Mart and stop the Mart Server service.
2. Navigate to the \webapps\MartServer\WEB-INF folder on the computer where erwin Mart Server is installed. Typically, the path for this folder is as follows:

   For a 32-bit version:

   <installation folder>\erwin\Mart Server r9\Tomcat\Webapps\Mart Server\WEB-INF 
   

   For a 64-bit version:

   <installation folder>\erwin\Mart Server r9\Tomcat64\Webapps\Mart Server\WEB-INF 
   

3. Open the rest-context.xml file in a text editor such as Notepad and search for the following line:

   <property name="refreshReportData" value="true" />
   

4. Change the value to “false”.
5. Navigate to the following line:

   <task:scheduled ref="reportTaskExecutor" method="run" cron="0 10 21 * * ?" />
   

6. Change the value for cron.

   Here, cron indicates the scheduled time. In this example, cron="0 10 21 * * ?" indicates that the models are synchronized for report generation at 9:10 pm every day.

7. Save the XML file.
8. Start the Mart Server service and log in to the Mart.

Similarly, to change from scheduled to dynamic synchronization, change the value of <property name="refreshReportData" value="false" /> to “true”.