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.
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.
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:
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
<property name="refreshReportData" value="true" />
<task:scheduled ref="reportTaskExecutor" method="run" cron="0 10 21 * * ?" />
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.
Similarly, to change from scheduled to dynamic synchronization, change the value of <property name="refreshReportData" value="false" /> to “true”.
Copyright © 2017 erwin Inc.
All rights reserved.