Transferring Data from Analytical Model to ESM Model

You can now transfer data from Analytical Model to ESM. Previously, we could transfer Analytical Model data to Analytical Model, and ESM data to ESM or Analytical Model. In the Source Model drop-down list, you can now see Analytical and ESM options which you can map to the Target ESM.

In Practice: To Transfer Data

1. In SpotlightXL, select the Model task> External Source Model> Source Map.
2. Enter the name of the Source Map and add the description.
3. Select the type as Data for loading external source data.
4. Select the Analytical model you want to map the target ESM.
5. Select any of the following in the Maps To column:
   • DimensionFilter: This filter indicates that there is no field present in the Source ESM to map to the Target ESM. You will have to specify a value in the Default Value Column.
   • Value: indicates that this field in the external source is a value to be copied as is to the specified field in the target ESM.
6. Run the Source Map to check the data in the ESM.