Target Summary Report

The Target Summary Report (also called Target Values) also contains raw data related to all defined accounts, however there are some differences between the Summary and Status reports. The most significant difference is that each account has been broken down into periods. The information in the Summary Report is for each account, in each period of the planning horizon, with the associated values for weights and target levels. Simply put the Target Status reports indicated whether the account and target levels are ACTIVE, and the Target Summary Report contains the actual values of each constraint and weight for each planning period. A Target Summary table can be extremely large depending on the number of accounts and planning periods in the horizon.

A Target Summary Report will automatically create a CSV format report. It is important that NO file extension is included when defining the filename parametre since the ".csv" file is automatically created. The file will appear in the scenario folder when the current scenario is saved.

The CSV sub-report contains comma separated text values which can be read into a text editor or spreadsheet application. This sub-report contains the simplest formatting, with the first row containing the column headings and subsequent rows containing values for each period. The first column in the table contains the period number, with a column heading of 'PERIOD'. Subsequent columns contain the unique attribute names sorted in alphabetical order, and the final column contains row totals with a column heading of 'TOTAL'.

The following is an example of a Target Summary Report. The first row contains column headings starting with the Account name, period number, value of the minimum and maximum target levels, summary, and value of minimum and maximum weights. All values are rounded to one decimal place in the table (period is a string value).



In this example there are 20 periods, however initial conditions are also represented here by P:0. Each individual account in this particular dataset will be listed 21 times, with exact values for each period.

All of the values contained in the Target Summary Report are derived from the values in the Target Charts. The Target Charts provide an easy to use tool for viewing and manipulating the numbers seen in the CSV report. When a scenario is saved, the exact values from each Target Chart, for each period are used to populate the CSV report. Likewise, when the scenario is reloaded the raw data in the CSV report is used to set each target to the exact position it was when the scenario was saved.

The Summary value contained in the Target Summary Report provides you with an opportunity to set weights and constraints as percentages as opposed to absolute values. A Summary value can be defined as the maximum value to be expected for that particular account. For example, if the target represented a particular area in the dataset, the total amount of area could be used as the 'summary'. If a summary value exists the target chart can be flipped to 'Percentages', where the summary value will equal 100%. This way you are able to set constraints and weights as percentages, as opposed to absolute unit values (which may be conceptually easier!).

Figure 129. Target Summary Report Constructor

	    public TargetSummaryReport(String filename,                1
	    String title,                   2
	    AttributeStore as)              3


filename - The basename to be used for output from this report. This name must be unique with respect to other reports added to the report writer. The name should NOT contain a filename extension since the report will automatically add ".csv". If the report is to be grouped into a folder, the folder should also appear here ("folder/subfolder/filename").


title - The report will appear in the directory tree with this title, as well as in the Index Report it belongs to.


as - A reference to the target table.