9 Data Load Validation

The Data Validation task contains all measures that are either loaded or touched during the batch calculation process. This task is used by the administrator only to verify the results of data loads and batch processes.

The Data Validation task contains the following steps:

Assortment Planning Measures View
Default Measures View
Item Planning Measures View
MFP Measures View

Building the Data Validation Workbook

To build a Data Validation workbook, perform the following steps:

Click the New Workbook icon in the Data Validation step.

Figure 9-1 Data Load Validation
The workbook wizard opens at the Calendar Selection step. Select the weeks you want to validate and click Next.

Figure 9-2 Data Load Validation Workbook Wizard - Calendar Selection
The Product Selection step appears. Select the style/colors and click Next.

Figure 9-3 Data Load Validation Workbook Wizard - Product Selection
The Location Selection step appears. Select the stores and click Finish.

Figure 9-4 Data Load Validation Workbook Wizard - Location Selection

The Data Validation workbook is built.

Assortment Planning Measures View

Use the Assortment Planning Measures view to validate that the Assortment Planning data was updated in the batch process.

Figure 9-5 Assortment Planning Measures View

The following table lists the measures available on this view.

Table 9-1 Assortment Planning View Measures

Measure	Description
BOP Inv Cost	Assortment Planning Current Plan Beginning of Period Inventory Cost.
BOP Inv Retail	Assortment Planning Current Plan Beginning of Period Inventory Retail.
BOP Inv Units	Assortment Planning Current Plan Beginning of Period Inventory Units.
Product Cost	The cost of the product.
EOP Inv Cost	End of Period Inventory Cost.
AP Cp EopPerStr U%	Assortment Planning Current Plan EOP Per Store Unit %.
EOP Inv Retail	End of Period Inventory Retail.
EOP Inv Units	End of Period Inventory Units.
Exit Date	Date that inventory should be removed from sales floor.
AP Cp Gross Margin	Assortment Planning Current Plan Gross Margin.
AP Cp GP R%	Assortment Planning Current Plan Gross Profit Retail %.
Clearance Markdown Retail	Assortment Planning Current Plan Clearance Markdowns - Price reduction used to clear aged or slow moving inventory at Retail.
Perm Markdown Retail	Permanent Markdowns representing a permanent retail decrease to the owned inventory price of merchandise for strategic downward re-pricing decisions at Retail.
Promo Markdown Retail	Promotional Markdowns representing the temporary reduction to the owned inventory price for promotional purposes expressed at Retail.
Pack Size	Quantity of style / color or styles purchased from Supplier as a pack.
AP Cp Price AUC	Assortment Planning Current Plan Average Unit Cost.
AP Cp Price AUR	Assortment Planning Current Plan Average Unit Retail.
AP Cp Price Clr AUC	Assortment Planning Current Plan Price Clearance Average Unit Cost.
AP Cp Price Clr AUR	Assortment Planning Current Plan Price Clearance Average Unit Retail.
Clearance Price Change %	Assortment Planning Current Plan Clearance Price Change %.
Clearance Price Retail	Assortment Planning Current Plan Clearance Price Retail.
Perm Price Change %	Permanent Price Change expressed as a rate.
Product Original Ticket Price	Initial retail of product.
Promo Price Change %	Assortment Planning Current Plan Promotional Price Change %.
Promo Price Retail	Promotional Price Average Unit Retail.
Perm Price Retail	Average Unit Retail resulting from a Permanent Price Change.
AP Cp Price Reg AUC	Assortment Planning Current Plan Price Regular Average Unit Cost.
AP Cp Price Reg AUR	Assortment Planning Current Plan Price Regular Average Unit Retail.
AP Cp Receipts AUC	Assortment Planning Current Plan Receipts Average Unit Cost.
AP Cp Receipts AUR	Assortment Planning Current Plan Receipts Average Unit Retail.
Receipts Cost	Assortment Planning Current Plan Receipts Cost.
AP Cp Average Recpts Per Str	Assortment Planning Current Plan Average Receipts per store.
Receipts Retail	Assortment Planning Current Plan Receipts Retail.
Receipts Units	Receipts expressed as Units.
AP Cp Receipts U%	Assortment Planning Current Plan Receipts Units rate.
AP Cp Sls C	Assortment Planning Current Plan Sales Cost.
Clearance Sales Cost	Assortment Planning Current Plan Clearance Sales Cost.
Clearance Sales Retail	Assortment Planning Current Plan Clearance Sales Retail.
Clearance Sales Units	See Clearance Sell Thru %.
AP Cp Avg Sls Per Str U	Assortment Planning Current Plan Average Sales per store represented in units.
AP Cp Sls R	Assortment Planning Current Plan Sales Retail.
Regular Sales Cost	Assortment Planning Current Plan Regular Sales Cost.
Regular Sales Retail	Assortment Planning Current Plan Regular Sales Retail.
Regular Sales Units	Assortment Planning Current Plan Regular Sales Units.
Start Sales Date	The date the product is expected to start selling.
AP Cp Sls U	Assortment Planning Current Plan Sales Units.
Sell Thru %	Assortment Planning Current Plan Sell Thru representing the percent of total available Inventory sold in a period of time Change %.
Store Count	Count of Stores.
Number of weeks at Clearance Price	Number of weeks the item is expected to sell at Clearance Price.
Number of Weeks at Regular Price	Number of weeks the item is expected to sell at Regular Price.

Default Measures View

Use the Default Measures view to validate that the default measure data was updated in the batch process.

Figure 9-6 Default Measures View

The following table lists the measures available on this view.

Table 9-2 Default Measures View Measures

Measure	Description
DR Ty EOP Clr C	Default Role Used for Loading Measures This Year End of Period Clearance Inventory Cost.
DR Ty EOP Clr R	Default Role Used for Loading Measures This Year End of Period Clearance Inventory Retail.
DR Ty EOP Clr U	Default Role Used for Loading Measures This Year End of Period Clearance Inventory Units.
DR Ty EOP Reg C	Default Role Used for Loading Measures This Year End of Period Regular Inventory Cost.
DR Ty EOP Reg R	Default Role Used for Loading Measures This Year End of Period Regular Inventory Retail.
DR Ty EOP Reg U	Default Role Used for Loading Measures This Year End of Period Regular Inventory Units.
DR Ty On Order C	Default Role Used for Loading Measures This Year On Order Cost.
DR Ty MD Allowance R	Default Role Used for Loading Measures This Year Markdown Allowances Retail.
DR Ty On Order R	Default Role Used for Loading Measures This Year On Order Retail.
DR Ty On Order U	Default Role Used for Loading Measures This Year On Order Units.
DR Ty Receipts C	Default Role Used for Loading Measures This Year Receipts Cost.
DR Ty Receipts R	Default Role Used for Loading Measures This Year Receipts Retail.
DR Ty Receipts U	Default Role Used for Loading Measures This Year Receipts Units.
DR Ty Sls Clr C	Default Role Used for Loading Measures This Year Clearance Sales Cost.
DR Ty Sls Clr R	Default Role Used for Loading Measures This Year Clearance Sales Retail.
DR Ty Sls Clr U	Default Role Used for Loading Measures This Year Clearance Sales Units.
DR Ty Sls Promo C	Default Role Used for Loading Measures This Year Promotional Sales Cost.
DR Ty Sls Promo R	Default Role Used for Loading Measures This Year Promotional Sales Retail.
DR Ty Sls Promo U	Default Role Used for Loading Measures This Year Promotional Sales Units.
DR Ty Sls Reg C	Default Role Used for Loading Measures This Year Regular Sales Cost.
DR Ty Sls Reg R	Default Role Used for Loading Measures This Year Regular Sales Retail.
DR Ty Sls Reg U	Default Role Used for Loading Measures This Year Regular Sales Units.

Item Planning Measures View

Use the Item Planning Measures view to validate that the Item Planning data was updated in the batch process.

Figure 9-7 Item Planning Measures View

The following table lists the measures available on this view.

Table 9-3 Item Planning Measures View Measures

Measure	Description
WP BOP Clr C	Working Plan Clearance Beginning of Period Inventory Cost.
WP BOP Clr R	Working Plan Clearance Beginning of Period Inventory Retail.
WP BOP Clr U	Working Plan Clearance Beginning of Period Inventory Units.
WP BOP Reg C	Working Plan Regular Beginning of Period Inventory Cost.
WP BOP Reg R	Working Plan Regular Beginning of Period Inventory Retail.
WP BOP Reg U	Working Plan Regular Beginning of Period Inventory Units.
Wp EOP Clr C	Working Plan End of Period Clearance Inventory Cost.
Wp EOP Clr R	Working Plan End of Period Clearance Inventory Retail.
Wp EOP Clr U	Working Plan End of Period Clearance Inventory Units.
Wp EOP Reg C	Working Plan End of Period Regular Inventory Cost.
Wp EOP Reg R	Working Plan End of Period Regular Inventory Retail.
Wp EOP Reg U	Working Plan End of Period Regular Inventory Units.
Wp Inv Adj Clr C	Working Plan adjusted inventory cost for clearance.
Wp Inv Adj Clr R	Working Plan adjusted inventory retail for clearance.
Wp Inv Adj Clr U	Working Plan adjusted inventory units for clearance.
Wp Inv Adj Reg C	Working Plan adjusted inventory cost for regular price.
Wp Inv Adj Reg R	Working Plan adjusted inventory retail for regular price.
Wp Inv Adj Reg U	Working Plan adjusted inventory units for regular price.
Wp MD Allowance R	Working Plan Markdown Allowances Retail.
Wp On Order C	Working Plan On Order Cost.
Wp On Order R	Working Plan On Order Retail.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipts Cost.
Wp Receipts R	Working Plan Receipts Retail.
Wp Receipts U	Working Plan Receipts Units.
Wp Sls Clr C	Working Plan Clearance Sales Cost.
Wp Sls Clr R	Working Plan Clearance Sales Retail.
Wp Sls Clr U	Working Plan Clearance Sales Units.
Wp Sls Promo C	Working Plan Promotional Sales Cost.
Wp Sls Promo R	Working Plan Promotional Sales Retail.
Wp Sls Promo U	Working Plan Promotional Sales Units.
Wp Sls Reg C	Working Plan Regular Sales Cost.
Wp Sls Reg R	Working Plan Regular Sales Retail.
Wp Sls Reg U	Working Plan Regular Sales Units.

MFP Measures View

Use the MFP Measures view to validate that the MFP data was updated in the batch process.

Figure 9-8 MFP Measures View

The following table lists the measures available on this view.

Table 9-4 MFP Measures View Measures

Measure	Description
MFP Cp BOP Inv C	MFP Current Plan Beginning of Period Inventory Cost.
MFP Cp BOP Inv R	MFP Current Plan Beginning of Period Inventory Retail.
MFP Cp BOP Inv U	MFP Current Plan Beginning of Period Inventory Units.
MFP Cp COGS C	MFP Current Plan Cost of Goods Sold Cost.
MFP Cp EOP Inv C	MFP Current Plan End of Period Inventory Cost.
MFP Cp EOP Inv R	MFP Current Plan End of Period Inventory Retail.
MFP Cp EOP Inv U	MFP Current Plan End of Period Inventory Units.
MFP Cp GPM	MFP Current Plan Gross Margin.
MFP Cp MD Clr R	MFP Current Plan Clearance Markdowns Retail.
MFP Cp MD Perm R	MFP Current Plan Permanent Markdowns Retail.
MFP Cp MD Promo R	MFP Current Plan Promotional Markdowns Retail.
MFP Cp MD R	MFP Current Plan Total Markdowns (Clearance + Promotional + Regular) Retail.
MFP Cp Receipts C	MFP Current Plan Receipts Cost.
MFP Cp Receipts R	MFP Current Plan Receipts Retail.
MFP Cp Receipts U	MFP Current Plan Receipts Units.
MFP Cp Ttl Sls C	MFP Current Plan Total Sales Cost.
MFP Cp Sls Clr C	MFP Current Plan Clearance Sales Cost.
MFP Cp Sls Clr R	MFP Current Plan Clearance Sales Retail.
MFP Cp Sls Clr U	MFP Current Plan Clearance Sales Units.
MFP Cp Sales Net VAT R	MFP Current Plan Sales Net Value Added Tax Retail.
MFP Cp Sls Promo C	MFP Current Plan Promotional Sales Cost.
MFP Cp Sls Promo R	MFP Current Plan Promotional Sales Retail.
MFP Cp Sls Promo U	MFP Current Plan Promotional Sales Units.
MFP Cp Ttl Sls R	MFP Current Plan Total Sales Retail.
MFP Cp Sls Reg C	MFP Current Plan Regular Sales Cost.
MFP Cp Sls Reg R	MFP Current Plan Regular Sales Retail.
MFP Cp Sls Reg U	MFP Current Plan Regular Sales Units.
MFP Cp Ttl Sls U	MFP Current Plan Total Sales Units.
MFP Op BOP Inv C	MFP Original Plan Beginning of Period Inventory Cost.
MFP Op BOP Inv R	MFP Original Plan Beginning of Period Inventory Retail.
MFP Op BOP Inv U	MFP Original Plan Beginning of Period Inventory Units.
MFP Op COGS C	MFP Original Plan Cost of Goods Sold Cost.
MFP Op EOP Inv C	MFP Original Plan End of Period Inventory Cost.
MFP Op EOP Inv R	MFP Original Plan End of Period Inventory Retail.
MFP Op EOP Inv U	MFP Original Plan End of Period Inventory Units.
MFP Op GM	MFP Original Plan Gross Margin.
MFP Op MD Clr R	MFP Original Plan Clearance Markdowns Retail.
MFP Op MD Perm R	MFP Original Plan Permanent Markdowns Retail.
MFP Op MD Promo R	MFP Original Plan Promotional Markdowns Retail.
MFP Op MD R	MFP Original Plan Total Markdowns (Clearance + Promotional + Regular) Retail.
MFP Op Receipts C	MFP Original Plan Receipts Cost.
MFP Op Receipts R	MFP Original Plan Receipts Retail.
MFP Op Receipts U	MFP Original Plan Receipts Units.
MFP Op Ttl Sls C	MFP Original Plan Total Sales Cost.
MFP Op Sls Clr C	MFP Original Plan Clearance Sales Cost.
MFP Op Sls Clr R	MFP Original Plan Clearance Sales Retail.
MFP Op Sls Clr U	MFP Original Plan Clearance Sales Units.
MFP Op Sales Net VAT R	MFP Original Plan Sales Net Value Added Tax Retail.
MFP Op Sls Promo C	MFP Original Plan Promotional Sales Cost.
MFP Op Sls Promo R	MFP Original Plan Promotional Sales Retail.
MFP Op Sls Promo U	MFP Original Plan Promotional Sales Units.
MFP Op Ttl Sls R	MFP Original Plan Total Sales Retail.
MFP Op Sls Reg C	MFP Original Plan Regular Sales Cost.
MFP Op Sls Reg R	MFP Original Plan Regular Sales Retail.
MFP Op Sls Reg U	MFP Original Plan Regular Sales Units.
MFP Op Ttl Sls U	MFP Original Plan Total Sales Units.