Difference between revisions of "Category:Results"

# Note that the template has now been added to the list of templates. To view a report, mark a result in the small window above the template list (for example "Highest Net Present Value", then one or more template, and finally click "View Checked diagrams/reports"

# Note that the template has now been added to the list of templates. To view a report, mark a result in the small window above the template list (for example "Highest Net Present Value", then one or more template, and finally click "View Checked diagrams/reports"

If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Server Management Studio. The results consists of several tables that must be joined. Below is one example of a query that creates a list of stand-level treatments for a selected optimization. To run this script, open SQL Server Management Studio, connect to the database server, and right-click "My_Heureka_Results" (or corresponding). Choose "New Query", paste the script below and click on "Execute". To see what value to use in the condition for "OPTIMIZATION.OptimizationNo" and "SIMULATION.SimNo", open the tables dbo.Optimization and dbo.Simulation, respectively, and look for the correct result sets.

If you are interested in results that you for some reason cannot obtain with the tools available in the applications, you can always run queries in SQL Server Management Studio. The results consists of several tables that must be joined. Below is one example of a query that creates a list of stand-level treatments for a selected optimization. To run this script, open SQL Server Management Studio, connect to the database server, and right-click "My_Heureka_Results" (or corresponding). Choose "New Query", paste the script below and click on "Execute". To see what value to use in the condition for "OPTIMIZATION.OptimizationNo" and "SIMULATION.SimNo", open the tables dbo.Optimization and dbo.Simulation, respectively, and look for the correct result sets.