ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Assign Customers by SOLAP Data

  • Summary
  • Syntax
  • Code Sample
  • Environments
  • Licensing Information

Summary

This tool is designed to use multiple SALES fields, which are extracted from the OLAP cube to build criteria for assigning customers to the stores.

Usage

Syntax

AssignCustomersBySOLAP_ba (CustomerLayer, InStoreDimension, InSelectedHierarchyLevels, WayToDefineLinkField, LinkField, {VBSScriptString}, {InAssignToOneStore}, {CreateNewFeatureClass}, {OutputFeatureClass})
ParameterExplanationData Type
CustomerLayer

The customer layer used to make the customer assignments to each store.

Feature Layer
InStoreDimension

Select the store dimension in the customer layer. A dimension is an axis of an OLAP cube.

String
InSelectedHierarchyLevels

Select the hierarchy level to process. Hierarchies categorize a dimension into a number of levels. More than one hierarchy can be associated with the same dimension.

String
WayToDefineLinkField

Determines how store is selected.

  • CREATE NEW —Creates a new Store ID field.
  • USE EXISTING —Uses an existing Store ID field.
String
LinkField

The store ID field that will be used to assign customers.

String
VBSScriptString
(Optional)

Input a custom VBS script assigning customers to stores based on the dimensions in the customer layer.

String
InAssignToOneStore
(Optional)

Allows the user to decide if the assignment of a customer to a store will be influenced by which store he/she shops at most.

  • True —Assigns the customer to the store he/she shops at most.
  • False —Will not assign the customer to the store he/she shops at most.
Boolean
CreateNewFeatureClass
(Optional)

Generates a new feature class based on the existing layer or uses the existing layer.

  • True —Creates a new feature class.
  • False —Does not create a new feature class. The original layer will be used.
Boolean
OutputFeatureClass
(Optional)

The feature class that will contain the customer features.

Feature Class

Code Sample

AssignCustomersBySOLAP Example (Stand-alone Script)
# Name: AssignCustomersBySOLAP.py
# Description: Assigns customers in the San Francisco area to their designated store.
# Author: Esri

# Import system modules
import arcview
import arcpy

arcpy.ImportToolbox("C:\Program Files (x86)\ArcGIS\Desktop10.3\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx")
 
 
try:
# Acquire extension license 
  arcpy.CheckOutExtension("Business") 
 
# Define the parameters for the Assign Customers by SOLAP Data tool

  CustPath = "C:\My Output Data\Projects\Default Project\CustLayers\OLAP\Customer.shp"
  StoreDim = "Product"
  Hierarchy = "(All)"
  StoreId = "STORE_ID"
 
# Assign Customers by SOLAP Data
  arcpy.AssignCustomersBySOLAP_ba(CustPath, StoreDim, Hierarchy, CREATE_NEW, StoreId)
 
# Release extension license 
  arcpy.CheckInExtension("Business")
     
except:
  print arcpy.GetMessages(2)

Environments

This tool does not use any geoprocessing environments

Licensing Information

  • ArcGIS for Desktop Basic: Requires Business Analyst
  • ArcGIS for Desktop Standard: Requires Business Analyst
  • ArcGIS for Desktop Advanced: Requires Business Analyst

Related Topics

  • An overview of the Customer Setup toolset
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal