Product Hierarchy File
File name: prod.hdr.csv.dat
File format: comma-separated values file
The following table describes the fields in this file.
| Name | Label | Hierarchy Type | Parent |
|---|---|---|---|
|
SKU |
Item |
Main |
None |
| SKUP | Style/Color | Main | SKU |
| SKUG | Style | Main | SKUP |
|
SCLS |
Subclass |
Main |
SKUG |
|
CLSS |
Class |
Main |
SCLS |
|
DEPT |
Department |
Main |
CLSS |
|
PGRP |
Group |
Main |
DEPT |
|
DVSN |
Division |
Main |
PGRP |
|
CMPP |
Company |
Main |
DVSN |
|
SCL1 |
Subclass Group 1 |
UDA |
SCLS |
|
SCL2 |
Subclass Group 2 |
UDA |
SCLS |
|
CLSG |
Class Group |
UDA |
CLSS |
|
CONS |
Consignment/Non-Cons |
UDA |
SCLS |
Example:
SKU,SKU_LABEL,SKUP,SKUP_LABEL,SKUG,SKUG_LABEL,SCLS,SCLS_LABEL,SCL1,SCL1_LABEL,SCL2,SCL2_LABEL,CLSS,CLSS_LABEL,CLSG,CLSG_LABEL,DEPT,DEPT_LABEL,PGRP,PGRP_LABEL,DVSN,DVSN_LABEL,CMPP,CMPP_LABEL,CONS,CONS_LABEL 22222222,22222222 Ground De-Caffeinated Can,22222222,22222222 Ground De-Caffeinated Can,22222222,22222222 Ground De-Caffeinated Can,100000,100000 Ground,110000,110000 Brewed,120000,120000 Bag-Jar-Can,10000,10000 Coffee,11001,11001 Coffee,1000,1000 Shelf Stable Beverages,100,100 Shelf Stable Grocery,10,10 Grocery,1,1 Acme,1,Consignment 44444444,44444444 Ground Regular - Caffeinated Can,44444444,44444444 Ground Regular - Caffeinated Can,44444444,44444444 Ground Regular - Caffeinated Can,100000,100000 Ground,110000,110000 Brewed,120000,120000 Bag-Jar-Can,10000,10000 Coffee,11001,11001 Coffee,1000,1000 Shelf Stable Beverages,100,100 Shelf Stable Grocery,10,10 Grocery,1,1 Acme,1,Consignment 11111111,11111111 Ground De-Caffeinated Bag,11111111,11111111 Ground De-Caffeinated Bag,11111111,11111111 Ground De-Caffeinated Bag,100000,100000 Ground,110000,110000 Brewed,120000,120000 Bag-Jar-Can,10000,10000 Coffee,11001,11001 Coffee,1000,1000 Shelf Stable Beverages,100,100 Shelf Stable Grocery,10,10 Grocery,1,1 Acme,1,Consignment 33333333,33333333 Ground Regular - Caffeinated Bag,33333333,33333333 Ground Regular - Caffeinated Bag,33333333,33333333 Ground Regular - Caffeinated Bag,100000,100000 Ground,110000,110000 Brewed,120000,120000 Bag-Jar-Can,10000,10000 Coffee,11001,11001 Coffee,1000,1000 Shelf Stable Beverages,100,100 Shelf Stable Grocery,10,10 Grocery,1,1 Acme,1,Consignment
Note:
In MFP Cloud Service, the lowest level of planning is done at the Subclass level. Partitioning of the Planning Data Schema should be done above the Subclass level. The customer should have balanced data at the partition level to have better performance. The MFP GA is partitioned by default at the department level. MFPCS also needs aggregated actual data only at the Subclass level. The base MFP configuration is defined to load actual data only at the Item level. Data will be visible within the application only at the Subclass level, but the lowest hierarchy level is still defined at the Item Level to support integration in RAP.
Note:
For non-template customers, it is also recommended to align with the GA Product Hierarchy structure for the dimension names for sku, skup, skug, scls, clss, dept, pgrp, dvsn, and cmpp so that they can upgrade/implement other GA solutions in a multi-app environment. They can use different labels. The lowest dimension should be sku and it is mandatory. The rest of the dimensions are optional and their equivalents should be named accordingly.