Benchmark Report (Business Analyst)

概要

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

使用法

構文

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})
パラメータ説明データ タイプ
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.

  • 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
(オプション)

Select the desired report output format.

  • Simple XML
  • PDF
  • HTML
  • CSV
  • ZIP
  • XLSV
  • Stripped XLSX
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.

  • 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
(オプション)

Defines how the report will be sorted.

  • TrueSorts the report by the trade area.
  • FalseDoes not sort the trade area.
Boolean
InSortTADescend
(オプション)

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
(オプション)

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.

  • CREATE_REPORTSelect this option to generate a formatted report.
  • DONT_CREATE_REPORTWill not generate a formatted report.
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.

  • CREATE_EXCELOutput is in Excel format.
  • DONT_CREATE_EXCELOutput will not be in Excel format.
Boolean
NeedTableOutput
(オプション)

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

コード サンプル

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)

環境

このツールは、ジオプロセシング環境では使用できません

関連項目

ライセンス情報

ArcView: 要 Business Analyst
ArcEditor: 要 Business Analyst
ArcInfo: 要 Business Analyst

10/4/2010