Difference between revisions of "Report Builder"

From Heureka Wiki
Jump to navigation Jump to search
(Created page with 'With the Report Builder you can create templates that will be stored in C:\My documents\Heureka\Common\Reports. At startup, PlanWise checks all files with the file extension "heu�?�')
 
Line 1: Line 1:
With the Report Builder you can create templates that will be stored in C:\My documents\Heureka\Common\Reports. At startup, PlanWise checks all files with the file extension "heurd" in that folder. Each such file holds information of a graph and a table. You can share templates with other users by copying files to that folder. To create a new template do the following:  
+
With the Report Builder you can create templates that will be stored in C:\My documents\Heureka\Common\Reports. At startup, PlanWise checks all files with the file extension "heurd" in that folder. Each such file holds information of a graph and a table. You can share templates with other users by copying files to that folder. To create a new template do the following:
  
1.Select the tab "Optimization Results > Tables and Graphs" (PlanWise) or "Simulation Results > Tables and Graphs" (RegWise).  
+
# Select the tab "Optimization Results > Tables and Graphs" (PlanWise) or "Simulation Results > Tables and Graphs" (RegWise).
2.In the list "Tables and Graphs" to the left, right-click and select "Create New", and "Period Graph"  
+
# In the list "Tables and Graphs" to the left, right-click and select "Create New", and "Period Graph"
3.In the Report Builder, click "Add" to add a variable. You can choose different kind of aggregate functions:  
+
# In the Report Builder, click "Add" to add a variable. You can choose different kind of aggregate functions:  
1.Sum = sum of a variable, for example volume  
+
## Sum = sum of a variable, for example volume
2.Mean = average value of a variable  
+
## Mean = average value of a variable
3.Sum of Area = areal sum, for example area of final felling  
+
## Sum of Area = areal sum, for example area of final felling
4.Area should normally be set as is, that is "Representative area".  
+
<!--## Conditional Sum = conditional sum, for example sum of volume in stand with the condition the site index should be at least a certain value.-->
5.Select the variable you are interested in.  
+
<!--## Conditional Mean = (under implementation) conditional mean, cf. Conditional Sum-->
6.You can add conditions to obtain sub sums, or sub averages. For example, to get teh total volume for stands with site index larger than 20, do the following:  
+
# Area should normally be set as is, that is "Representative area".  
1.Click on "Add Condition".  
+
# Select the variable you are interested in.
2.Select a conditioning variable, in this case example SiteData > Site Index.  
+
# You can add conditions to obtain sub sums, or sub averages. For example, to get teh total volume for stands with site index larger than 20, do the following:
3.Set operator ">=", and type the value 20.  
+
## Click on "Add Condition".
4.Click OK.  
+
## Select a conditioning variable, in this case example SiteData > Site Index.
7.Click OK.  
+
## Set operator ">=", and type the value 20.  
8.Back in the "Report Builder" window, you can select more variables, for example if you want to create stacked bars, consisting of Volume Harvested and Volume After Harvest in the same graph, or different tree species in the same graph. For example, to make a graph that shows species-wise volumes do the following:  
+
## Click OK.
1.Click "Add".  
+
# Click OK.
2.Click "Select Variable" in "Variable"  
+
# Back in the "Report Builder" window, you can select more variables, for example if you want to create stacked bars, consisting of Volume Harvested and Volume After Harvest in the same graph, or different tree species in the same graph. For example, to make a graph that shows species-wise volumes do the following:
3.Select variable "Data per Species" > "Before" > "Volume" > "Pine", and then "OK".  
+
## Click "Add".
4.Repeat step 3 for all the other species. This may seem tedious, but remember that you only have to create the template once.  
+
## Click "Select Variable" in "Variable"
9.Edit the Y-axis label (you should remove "/ha")  
+
## Select variable "Data per Species" > "Before" > "Volume" > "Pine", and then "OK".
10.Name the template and the header.  
+
## Repeat step 3 for all the other species. This may seem tedious, but remember that you only have to create the template once.
11.Set the default type, for example "StackedBar" if you ran steps 3-4 above.  
+
# Edit the Y-axis label (you should remove "/ha")
12.Click OK  
+
# Name the template and the header.
13.The new template will be added to the template list. To view a report, mark a result in the small window above the template list (for example "Max NPV - Strategic", then one or more template, and finally click "View Checked diagrams/reports". If the resulting table or graph is empty, you have problem not included the result variable when you ran the Treatment Program Generator.  
+
# Set the default type, for example "StackedBar" if you ran steps 3-4 above.  
14.You can find more examples of reports here.
+
# Click OK
 +
# The new template will be added to the template list. To view a report, mark a result in the small window above the template list (for example "Max NPV - Strategic", then one or more template, and finally click "View Checked diagrams/reports". If the resulting table or graph is empty, you have problem not included the result variable when you ran the Treatment Program Generator.  
 +
# You can find more examples of reports [[Report_Examples|here]].

Revision as of 09:58, 18 June 2010

With the Report Builder you can create templates that will be stored in C:\My documents\Heureka\Common\Reports. At startup, PlanWise checks all files with the file extension "heurd" in that folder. Each such file holds information of a graph and a table. You can share templates with other users by copying files to that folder. To create a new template do the following:

  1. Select the tab "Optimization Results > Tables and Graphs" (PlanWise) or "Simulation Results > Tables and Graphs" (RegWise).
  2. In the list "Tables and Graphs" to the left, right-click and select "Create New", and "Period Graph"
  3. In the Report Builder, click "Add" to add a variable. You can choose different kind of aggregate functions:
    1. Sum = sum of a variable, for example volume
    2. Mean = average value of a variable
    3. Sum of Area = areal sum, for example area of final felling
  4. Area should normally be set as is, that is "Representative area".
  5. Select the variable you are interested in.
  6. You can add conditions to obtain sub sums, or sub averages. For example, to get teh total volume for stands with site index larger than 20, do the following:
    1. Click on "Add Condition".
    2. Select a conditioning variable, in this case example SiteData > Site Index.
    3. Set operator ">=", and type the value 20.
    4. Click OK.
  7. Click OK.
  8. Back in the "Report Builder" window, you can select more variables, for example if you want to create stacked bars, consisting of Volume Harvested and Volume After Harvest in the same graph, or different tree species in the same graph. For example, to make a graph that shows species-wise volumes do the following:
    1. Click "Add".
    2. Click "Select Variable" in "Variable"
    3. Select variable "Data per Species" > "Before" > "Volume" > "Pine", and then "OK".
    4. Repeat step 3 for all the other species. This may seem tedious, but remember that you only have to create the template once.
  9. Edit the Y-axis label (you should remove "/ha")
  10. Name the template and the header.
  11. Set the default type, for example "StackedBar" if you ran steps 3-4 above.
  12. Click OK
  13. The new template will be added to the template list. To view a report, mark a result in the small window above the template list (for example "Max NPV - Strategic", then one or more template, and finally click "View Checked diagrams/reports". If the resulting table or graph is empty, you have problem not included the result variable when you ran the Treatment Program Generator.
  14. You can find more examples of reports here.