Location Attributes Hierarchy File

The Location Attributes hierarchy represents attributes associated with locations. These attributes are used to group locations to plan in the Location Clustering.

This hierarchy is intended to capture all location attributes for all locations. The attributes are then assigned to individual locations. This assignment is used when processing the dynamic rollups in the location planning templates.

Name	Label	Hierarchy Type	Aggs
SATV	Loc Attribute Value	Main	None
SATT	Loc Attribute	Main	SATV

File name: satr.hdr.csv.dat

File format: comma-separated values file

The following table describes the fields in this file.

Name	Description
Loc Attribute Value	The various values that an attribute might have. For example, the climate attribute might take the values cold, hot, or humid.
Loc Attribute	The name of a location attribute, such as climate, store volume, and so on.

Note: This hierarchy data needs hard-coded values of two attributes z_grade for Sales Perf Group and z_space for Space Group with hard-coded Loc Attribute values as shown in the Example below that is used by AP Location Clustering, rest of the attributes can be customer data.

Note: This hierarchy data can be imported as part of RAP integration from RMFCS or the customer can also directly provide the location attribute hierarchy with at least one valid data. If the customer is importing Location Attributes data for AP GA, then they need to set to the Integration Environment variable 'SATR_GROUP' to 'Y' in order to include hard-coded Location Attributes used by AP GA during import.

Example:

satv,satv_label,satt,satt_label
G_01,A,z_grade,Sales Perf Group
G_02,B,z_grade,Sales Perf Group
G_03,C,z_grade,Sales Perf Group
G_04,D,z_grade,Sales Perf Group
G_05,E,z_grade,Sales Perf Group
S_01,A,z_space,Space Group
S_02,B,z_space,Space Group
S_03,C,z_space,Space Group
S_04,D,z_space,Space Group
S_05,E,z_space,Space Group
clmt1,Marine,clmt,Climate
clmt2,Cold,clmt,Climate
clmt3,Very Cold,clmt,Climate
clmt4,Hot Dry,clmt,Climate
clmt5,Mixed Dry,clmt,Climate
clmt6,Mixed Humid,clmt,Climate
clmt7,Hot Humid,clmt,Climate
clmt8,Mediterranean,clmt,Climate