Benchmark Report (Business Analyst)

License Level:BasicStandardAdvanced

Summary

A comparative report that benchmarks two or more trade areas based on selected volumetric data (typically demographic data).

Usage

Syntax

BenchmarkReport_ba (IN_IN_BDS_FEATURE_LAYER, IN_SELECTED_SUMMARIZATIONS, BOUNDARY_LAYERS, {IN_TA_FIELDS}, {IN_BENCHMARK_OPTIONS}, {ReportFormats}, {IN_BENCHMARK_TA}, {InLayoutOptions}, {InSortTA}, {InSortTADescend}, {InSortTAField}, {OutFolder}, {NeedReportOutput}, {OutReportName}, {Benchmark Report}, {NeedExcelOutput}, {NeedTableOutput})
ParameterExplanationData Type
IN_IN_BDS_FEATURE_LAYER

The input layer containing the variables to be used in the report.

Feature Layer
IN_SELECTED_SUMMARIZATIONS
[IN_SELECTED_SUMMARIZATIONS,...]

The selected variables from the Input Data Layer to be used in the report.

String
BOUNDARY_LAYERS
[[Layer, {Area ID Field}, {Store Name Field}, {Area Description Field}, {Selection}, {Single ID}],...]

The trade area(s) or boundary layers to be used for benchmarking.

Value Table
IN_TA_FIELDS
[IN_TA_FIELDS,...]
(Optional)

The fields of the trade areas that will appear on the report.

String
IN_BENCHMARK_OPTIONS
(Optional)

Determines the desired approach to compare the trade area values against a benchmark.

  • NONECompares the selected variables in the report against the totals of those variables in all the trade areas.
  • USE_AVERAGECompares the selected variables in the report against an average of those variables in all trade areas.
  • USE_MEDIANCompares the selected variables in the report against a median of those variables in all trade areas.
  • USE_TRADE AREACompares the selected variables in the report against the totals of those variables in a selected trade area.
String
ReportFormats
(Optional)

Select the desired report output format.

  • Simple XML
  • PDF
  • HTML
  • CSV
  • ZIP
  • XLSV
  • Stripped XLSX
String
IN_BENCHMARK_TA
(Optional)

The trade used as the benchmark to compare against all other trade areas.

String
InLayoutOptions
(Optional)

Determines the orientation of the selected variables in the report.

  • VARIABLES_IN_COLUMNSOutputs the report with the variables in columns and the trade areas in row.
  • VARIABLES_IN_ROWSOutputs the report with the variables in rows and the trade areas in columns.
String
InSortTA
(Optional)

Defines how the report will be sorted.

  • TrueSorts the report by the trade area.
  • FalseDoes not sort the trade area.
Boolean
InSortTADescend
(Optional)

Determines if the trade areas will be sort in descending order.

  • TrueThe trade areas will be sorted in descending order.
  • FalseThe trade areas will not be sorted in descending order.
Boolean
InSortTAField
(Optional)

The field in the trade area that will be used for sorting.

String
OutFolder
(Optional)

The report output directory folder.

Folder
NeedReportOutput
(Optional)

Determines if a formatted report will be generated.

  • CREATE_REPORTSelect this option to generate a formatted report.
  • DONT_CREATE_REPORTWill not generate a formatted report.
Boolean
OutReportName
(Optional)

The name that will appear on the report.

String
Benchmark Report
(Optional)

Names the report for use/access in the Business Analyst reports wizard.

String
NeedExcelOutput
(Optional)

Select this option to export the report as an Excel output.

  • CREATE_EXCELOutput is in Excel format.
  • DONT_CREATE_EXCELOutput will not be in Excel format.
Boolean
NeedTableOutput
(Optional)

Select this option to export the report as a dBASE output.

  • CREATE_TABLEOutput is in dBASE format.
  • DONT_CREATE_TABLEOutput will not be in dBASE format.
Boolean

Code Sample

BenchmarkReport Example (Stand-alone Script)
# Name: BenchmarkReport.py
# Description: Benchmarks current total households and current year total population from drive time trade areas generated for the same location from different years.
# Author: ESRI

# Import system modules
import arcview
import arcpy

arcpy.ImportToolbox("C:\Program Files\ArcGIS\Desktop10.0\ArcToolbox\Toolboxes\Business Analyst Tools.tbx")
 
try:
# Acquire extension license 
arcpy.CheckOutExtension("Business") 
 
# Define input and output parameters for the Benchmark Report tool
InputPath = "C:/Program Files/ArcGIS/Desktop10.0/Business Analyst/Data/BDS/esri_bg.bds"
Vars = "TOTHH_CY;TOTHH_FY"
TAnew = "C:/My Output Data/Projects/Default Projects/Trade Areas/Drive Time New.shp' AREA_ID;NAME;AREA_DESC;ALL"
TAold = "C:/My Output Data/Projects/Default Projects/Trade Areas/Drive Time Old.shp' AREA_ID;NAME;AREA_DESC;ALL"
   
 
# Create Benchmark Report output file
arcpy.BenchmarkReport_ba(InputPath, Vars, TAnew, TAold)
 
# Release extension license 
arcpy.CheckInExtension("Business") 
 
except:
  print arcpy.GetMessages(2)

Environments

This tool does not use any geoprocessing environments

Related Topics

Licensing Information

ArcGIS for Desktop Basic: Requires Business Analyst
ArcGIS for Desktop Standard: Requires Business Analyst
ArcGIS for Desktop Advanced: Requires Business Analyst
5/21/2013