Setting Variable Values in a Step

1. Inherited Variable Values:
• Variables in a step inherit their values from the parent step, which in turn gets its value from the variables specified during the Load Plan startup.
2. Overwriting Variable Values:
• For each step (except Else and When steps), you can overwrite the variable value for that step and its child steps. This allows you to customize the value used for that specific step and all steps within its hierarchy.
3. Variable Value Propagation:
• When a variable value is overwritten or refreshed at a specific step, it is propagated to all descendant steps. The overwritten or refreshed value remains in effect until it is again modified or refreshed in a descendant step.
• Siblings or parent steps are not affected by these changes to the variable values at the current step.

 

Steps to Override Variable Values at the Step Level

1. Open the Load Plan Editor:
• Navigate to the Load Plan editor and go to the Steps tab.
2. Select the Step:
• In the Steps Hierarchy table, select the step where you want to overwrite the variable value.
3. Modify Variables in the Property Inspector:
• In the Property Inspector, go to the Variables section. This section lists all variables defined for the Load Plan.
4. Overwrite or Refresh Variable:
• Choose Overwrite if you want to specify a new variable value for the selected step and its children. Once you select "Overwrite," you can:
• Set a new variable value in the Value field.
• Select Refresh to refresh the variable's value before executing the step. (Note: The Refresh option is available only if the variable has a Select Query defined for refreshing its value).

 

Notes:

• Refreshing Variables:
• If the refresh SQL for a Global or Project variable changes, the corresponding Load Plan variable will not automatically update. To update the variable’s refresh SQL, you can use the Refresh Variable Definition option in the right-click context menu for the variable in the Variables tab of the Load Plan editor.