General Improvements in v2.18

Calculations - Improvement to Output Mapping

The way a formula is mapped to an output drop-down list has been changed. Previously there were two separate wizard steps for picking your picking your output answer and then viewing its answer options, but these steps have now been embedded into the editor in the Output mapping tab, so you can pick and change your output answer and quickly view the effect in the Preview tab. The Preview tab will show you which output answer option the calculation will result in alongside the calculated answer.

Auto ETL Improvements

• The staging database validator has been refactored to only do source system linking or validation for records that have been modified since the last ETL run. This provides a significant reduction in ETL run times when doing relatively small updates to large sets of data.
• The guided resolution stored procedure has been updated to use temp tables instead of table variables to help mitigate any performance issues from table variables.
• If the staging database AutoETL hasn’t completed successfully the ETL process will now stop when run to allow for correcting problems with the upgrade.