External Source Model DLR- Calculations tab Introduced
  • 1 Minute to read
  • Dark
    Light
  • PDF

External Source Model DLR- Calculations tab Introduced

  • Dark
    Light
  • PDF

Article summary

We now have a Calculations tab in the Define Overall Rule Settings screen for ESM data load via DLRs. Users can now select a calculation from any model as soon as the data load rule is successfully run, automating the calculation process every time the ESM DLR is run. You will receive a notification after the calculation is complete.

Note
This update is only applicable for File load and Copy-paste load types.

In Practice: Executing 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 you will be notified upon completion.

Was this article helpful?