Output Relate in InfoSewer
The Output Relate option is used to establish relationships between modeling input data and modeling results. Once a relate (link) is established, you can then apply queries against the current project based on modeling inputs and simulation results simultaneously. Click here to learn more about output relates.
Creating Output Relates
To create an Output Relate, from the Operation Data tab under the Control Center dialog box, select and highlight Output Relate. Right-mouse click on the folder and select New. At this point the user is asked to provide a name and description for the new output relate table. When created, the user is then shown the Output Relate dialog box as shown below:
Click on any portion of the box to learn more.
Automatically Update Output Relate Contents
When this option is ON (checked), the relate table will be automatically updated every time you run a simulation when the relate’s Target Scenario and Target Simulation are active.
For example, you define a relate based on the BASE EPS simulation and then set this option to ON. The next time you load the BASE scenario and run an EPS simulation, the contents of the relate table are automatically updated with the most recent simulation results.
If this option is OFF, the relate table contains simulation result data from when the relate was created or at the time you last updated the relate contents by choosing one of the buttons at the bottom of this dialog box. If you re-run the simulation (BASE EPS in the example above), the results from the previous run remain in the relate table.
Select the scenario upon which the output relate is based. Data from the selected Target Simulation for the selected Target Scenario will be written to the output relate table.
You may choose from among the active (currently loaded) or any other custom-developed (output source) scenarios.
(Note: If you have not developed any custom scenarios with the H2OMAP Sewer scenario management feature, the only available scenario will be *ACTIVE* scenario representing BASE conditions.)
Select the simulation type (steady-state, steady-state design, EPS) upon which the output relate is based. Data from the selected Target Simulation for the selected Target Scenario will be written to the output relate table.
Desired Output Report
Each output relate contains one single relate table. Choose the relate table that you would like to associate with the current output relate. The list of available tables will vary depending on which Target Simulation type you have chosen.
(Note: If you wish to store simulation results for all network component types (gravity mains, force mains, pumps, manholes, wet wells, outlets and chamber manholes) in output relates, create seven separate relates, select the same Target Scenario, Target Simulation, and Report Page for each relate, and then choose the desired output report table for each relate.)
Desired Report Page (Timestep)
Output relates store simulation results for a specific modeling condition. For an EPS model, there are two methods by which you may select a time period for which simulation results will be written to the output report table:
- Report Page - Choose the extended period simulation report timestep by its index (page) number. The first simulation timestep is page/index 0 (zero), the second simulation timestep is page/index 1, and so on. Use this option when there are no available simulation timesteps.
- Available Timesteps - Choose the extended period simulation report timestep by its clock time from the beginning of the simulation. Timesteps are not available until you have successfully run a simulation of the selected Target Simulation type for the selected Target Scenario. If your hydraulic timestep is more than 1, the available timesteps may not match the report page. For example if your hydraulic timestep is two hours, the following relationship exists between report page and available timesteps:
|Report Page||Available Timestep|
Use the Simulation Time option under the Operation Data tab under the Control Center to specify hydraulic, report, and other extended period simulation time steps.
Update Current Relate Now
Updates the contents of the output relate table with simulation results from the most recent run of the associated Target Simulation Type for the associated Target Scenario. Simulation results are written for the associated Report Page or Report Timestep.
Update All Defined Relates
Updates the contents of all currently defined output relate table with simulation results from the most recent run of each output relates’ associated Target Simulation Type for each associated Target Scenario. Simulation results are written for the associated Report Page or Report Timestep.
Output Relates provide a method of temporarily transferring simulation result data to H2OMAP Sewer’s model input database to support database operations (such as queries) using the output data. When you execute an Output Relate, simulation results stored in a standard output source you select are written to the desired output report table (e.g., Manhole Report, Pipe Report, etc.). The table contains simulation results for all network components at a single extended period simulation timestep. Refer to the Output Report Manager for more information on the format and contents of each output report.
Each output relate is identified by a name and narrative description and may be accessed by that name when developing query statements using several H2OMAP Sewer commands and tools.
The data transferred as a result of the relate is a “snapshot” of simulation results and will therefore be static regardless of subsequent simulation runs. To update the contents of an output relate with results from a more recent simulation run, use either the Update Current Relate Now or Update All buttons. The Update operation replaces the original related output data with the new output data. You must specify the Target Simulation (output source such as steady-state, steady-state design, EPS) and the Desired Output Report (Manhole Report, Pipe Report, etc.) which the output data will be mapped to. The related output will remain intact for later use (i.e., after the project is closed). Both the Query Set command and the Query Builder dialog box can access output relate data for use in developing query sets and query statements.
Results in an output relate can be made static, as a permanent snapshot of a single model run, or can be automatically updated every time you rerun a simulation for a given scenario. To make updates automatic, from the Tools menu, select Preferences. Under the Operation tab, select Auto Output Relate Update.
Output relates are stored in an external database file that can be linked to in a third party GIS software to view analysis results. Click here to learn more about viewing results in a GIS platform.