Benchmark Report (Business Analyst)
概要
A comparative report that benchmarks two or more trade areas based on selected volumetric data (typically demographic data).
使用法
-
When selecting more than a handful of variables or trade areas to be displayed as columns, choose the export option for Excel instead of a Crystal Report .RPT due to formatting restrictions.
-
All results will automatically be stored in the Project/Reports folder.
-
The Benchmarks can only be made on variables that exist in both trade areas being compared.
-
Variables and trade areas can be shown as either rows or columns.
-
When benchmarking all trade areas against a single trade area, the average or the median of all the trade areas is calculated and used as the benchmark.
構文
| パラメータ | 説明 | データ タイプ |
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,...] （オプション） |
The fields of the trade areas that will appear on the report. | String |
IN_BENCHMARK_OPTIONS （オプション） |
Determines the desired approach to compare the trade area values against a benchmark.
| String |
ReportFormats （オプション） |
Select the desired report output format.
| String |
IN_BENCHMARK_TA （オプション） |
The trade used as the benchmark to compare against all other trade areas. | String |
InLayoutOptions （オプション） |
Determines the orientation of the selected variables in the report.
| String |
InSortTA （オプション） |
Defines how the report will be sorted.
| Boolean |
InSortTADescend （オプション） |
Determines if the trade areas will be sort in descending order.
| Boolean |
InSortTAField （オプション） |
The field in the trade area that will be used for sorting. | String |
OutFolder （オプション） |
The report output directory folder. | Folder |
NeedReportOutput （オプション） |
Determines if a formatted report will be generated.
| Boolean |
OutReportName （オプション） |
The name that will appear on the report. | String |
Benchmark Report （オプション） |
Names the report for use/access in the Business Analyst reports wizard. | String |
NeedExcelOutput （オプション） |
Select this option to export the report as an Excel output.
| Boolean |
NeedTableOutput （オプション） |
Select this option to export the report as a dBASE output.
| Boolean |
コード サンプル
# 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)