Analyzing simulation results using SQLs

Step-by-step guide

SQLs may be used to aggregate the simulation results you are interested in. For example, you can produce a grid that illustrates the average flow and velocity across the network, then compare the results with those found in another scenario.

1. From the Model Group, double click SQL Control to open the Baseline simulation results.

Note: If the run icon on the left of the simulation is greyed out, right-click the run and select Re-run.

To create a query illustrating average flow and velocity in the network:

2. Right-click the Stored Query Group and select New > Stored Query.

3. In the popup, name the stored query “Baseline- Average”.
4. In the Model Group, double-click Baseline- Average to open the Stored Query dialog box.
5. From the Object Type drop-down, select Pipe.
6. In the text box, type the following query:

SELECT SUM(length) as “Length”, AVG(sim.flow) as “Average Flow”, AVG(sim._Velocity) as “Average Velocity”

7. Click Test.

A notification appears, indicating valid syntax.

8. Click OK.
9. Click Save.
10. Click Run.

The SQL window closes and a results grid opens, containing the total length of pipes in the network, the average flow, and the average velocity.

11. Close the grid window.

To compare these results with an alternative baseline scenario:

12. From the Model Group, expand the Pipe Break Scenario.
13. Right-click the [Pipe Break] SQL Control simulation and select Open as.
14. In the Select Result dialog box, select As alternate results for comparison.
15. Click OK.
16. In the Model Group, double click Baseline- Average to open the SQL dialog box.

To extend the script to include the second scenario:

17. In the text box, at the end of the last line, type a comma (,).
18. After the comma, type the following, starting with a SPACE:

AVG(sim2.flow) as “Average Flow 2”, AVG(sim2._Velocity) as “Average Velocity 2”

19. Click Test.

A notification appears, indicating valid syntax.

20. Click OK.
21. Click Save.
22. Click Run.

The SQL window closes and a grid opens showing the average flow and average velocity for both simulations, and the total length of pipes in the network.

23. When you are finished comparing the results, Close the grid window.