External Source Model DLR Integration- Calculations tab Introduced

We now have a Calculations tab in the Define Overall Rule Settings screen for ESM data load via DLRs. This will enable users to select a calculation from any model which needs to be run as soon as the data load rule is successfully run. This will automate the calculation run process every time the ESM DLR is run, and a notification would be sent to the users after the calculation is complete.

In Practice: Calculations in DLR

1. Navigate to Maintenance > Data Load Rules.
2. Click the New Data Load Rule available in the side navigation.
3. Enter a Name for the Data Load Rule.
4. Select External Source Model Load Item and Load Sub Item from the drop-down list.
5. Fill in all the details in the Select Sample Input File screen.
6. In the Define Overall Rule Settings screen, fill the following details:
   • Select External Source Model details, in the General tab.
   • Select Model and Calculation from the calculations list.
7. The functionality in the Manipulate Input File screen tab will remain the same. Click Next.
8. You need to map fields in the Source Column to values available in the Maps To field drop-down lists, click Next.
9. You can select the Execute Calculation check box in the Load Data screen.
10. Click Finish, and you will either receive a Data Load success message or an exception report.
11. Calculation will run in the background and upon completion, you will be notified.