Scenario Tables
These are used to insert actions, selections, and updates into the back end of the process compared to the standard process of building scenarios through Gains Architect. Both processes work, however, we would recommend that this should only be used for advanced users in the Supply Chain Management field.
dbo.Scenarios
Field | Data type | Description |
BaseScenario | Text | Base scenario name |
OutputScenario | Text | Output scenario name |
Action | Text | Action name, for example “Set existing Sites to FRC” |
ActionNum | Int | Ordinal action number within the scenario. Action order matters because actions are applied to the base scenario in the order specified by the ActionNum |
Solver | Text | Solver to be used for this scenario. Choose one of the following: NEO – Network Optimization COG – Center of Gravity VRO – Vehicle Route Optimization |
dbo.ScenarioActions
Field | Data Type | Description |
Action | Text | Action name, for example “Set Existing Sites to FRC” |
Selection | Text | Selection name, which defines the BaseScenario rows to be updated by this action. For example, “Existing Sites” |
Update | Text | Update name, which defines the update to be applied to the rows selected by Selection. For example, “Force” |
dbo.ScenarioSelections
Field | Data Type | Description |
Selection | Text | Selection name, e.g. “Existing Sites” |
SelectionTable | Text | Table that selection applies to, e.g. “Sites” |
SelectionSQL | Text | SQL WHERE clause defining the rows to be selected for update, e.g. prefix=’DCE’ |
dbo.ScenarioUpdates
Field | Data Type | Description |
Update | Text | Update name, e.g. “Force” |
UpdateSQL | Text | SQL Update clause, e.g. [SolverInclude]=’FRC’ |