& Construction
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing
Professional CAD/CAM tools built on Inventor and AutoCAD
Analyze simulation results using an SQL query.
Tutorial resources
These downloadable resources will be used to complete this tutorial:
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.
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:
SELECT SUM(length) as “Length”, AVG(sim.flow) as “Average Flow”, AVG(sim._Velocity) as “Average Velocity”
A notification appears, indicating valid syntax.
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.
To compare these results with an alternative baseline scenario:
To extend the script to include the second scenario:
AVG(sim2.flow) as “Average Flow 2”, AVG(sim2._Velocity) as “Average Velocity 2”
A notification appears, indicating valid syntax.
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.