9 Data Load Validation Task

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

The Data Load Validation task contains the following steps:

• SubClass Data Load Validation

• Department Data Load Validation

• Division-Group Data Load Validation

• Miscellaneous Measures Validation

To use the Data Load Validation workbook, you need to first build the workbook.

Building the Workbook

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

1. Click the New Workbook icon in the Data Load Validation step.

   Figure 9-1 Data Load Validation

   
   

2. 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

   
   

3. The Product Selection step is displayed. Select the items and click Next.

   Figure 9-3 Data Load Validation Workbook Wizard - Product Selection

   
   

4. The Location Selection step is displayed. Select the stores and click Finish.

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

   
   

The Data Load Validation workbook is built.

SubClass Data Load Validation

The SubClass Data Load Validation step includes one view, the Bottom Up Working Plan view. Use this view to validate that the subclass data was updated in the batch process.

Figure 9-5 Bottom Up Working Plan View

The following table lists the measures available on this view:

Table 9-1 Bottom Up Working View Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost.
Wp BOP Inv R	The planned beginning of period inventory in retail value. The period can be a week, month, or any other calendar period.
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp Fcst In-Season U	Working plan in-season forecast demand units.
Wp Fcst Pre-Season U	Working plan preseason forecast demand units.
Wp EOP Inv C	Working Plan End of Period Inventory Cost.
Wp EOP Inv R	Working Plan End Of Period Inventory Retail.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In R	Working Plan miscellaneous In Retail.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out R	Working Plan miscellaneous Out Retail.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp Markdown Perm R	Working plan permanent price markdown for retail.
Wp Markdown Promo R	Working plan promotional price markdown for retail.
Wp Markdown Clr R	Working plan clearance price markdown for retail.
Wp MarkUp R	Working Plan Markup Retail.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order R	Working Plan On Order Retail Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipt Cost.
Wp Receipts R	Working Plan Receipts Retail Value.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink R	Working plan shrink retail.
Wp Shrink U	Working plan shrink units.
Wp Sales Reg R	Working Plan Regular Sales Retail Value.
Wp Sales Clr R	Working Plan Clearance Sales Retail Value.
Wp Sales Promo R	Working Plan Promotional Sales Retail Value.
Wp Sales Reg U	Working Plan Regular Sales Units.
Wp Sales Clr U	Working Plan Clearance Sales Units.
Wp Sales Promo U	Working Plan Promotional Sales Units.

Department Data Load Validation

The Department Data Load Validation step includes one view, the Middle Out Working Plan view. Use this view to validate that the department data was updated in the batch process.

Figure 9-6 Middle Out Working Plan View

The following table lists the measures available on this view.

Table 9-2 Middle Out Working Plan View Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost Value.
Wp BOP Inv R	The planned beginning of period inventory in retail value. The period can be a week, month, or any other calendar period.
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp Fcst In-Season U	Working plan forecast for in-season units.
Wp Fcst Pre-season U	Working plan forecast for preseason units.
Wp EOP Inv C	Working Plan End Of Period Inventory Cost.
Wp EOP Inv R	Working Plan End Of Period Inventory Retail.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In R	Working Plan miscellaneous In Retail.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out R	Working Plan miscellaneous Out Retail.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp Markdown Perm R	Working plan permanent markdown value.
Wp Markdown Promo R	Working plan promotional price markdown for retail.
Wp Markdown Clr R	Working plan clearance price markdown for retail.
Wp MarkUp R	Working Plan Markup Retail.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order R	Working Plan On Order Retail Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipts Cost Value.
Wp Receipts R	Working Plan Receipts Retail Value.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink R	Working Plan Shrink Retail.
Wp Shrink U	Working Plan Shrink Units.
Wp Sales Reg R	Working plan regular sales retail.
Wp Sales Clr R	Working plan clearance sales retail.
Wp Sales Promo R	Working plan promotional sales retail.
Wp Sales Reg U	Working plan regular sales units.
Wp Sales Clr U	Working plan clearance sales units.
Wp Sales Promo U	Working plan promotional sales units.

Division-Group Data Load Validation

The Division-Group Data Load Validation step includes one view, the Top Down Working Plan view. Use this view to validate that the division-group data was updated in the batch process.

Figure 9-7 Top Down Working Plan View

The following table lists the measures available on this view.

Table 9-3 Top Down Working Plan View Measures

Measure	Description
Wp BOP Inv C	Working Plan Beginning of Period Inventory Cost Value.
Wp BOP Inv R	The planned beginning of period inventory in retail value. The period can be a week, month, or any other calendar period.
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp Fcst In-Season U	Working plan in-season forecast units.
Wp Fcst Pre-Season U	Working plan preseason forecast units.
Wp EOP Inv C	Working Plan End Of Period Inventory Cost.
Wp EOP Inv R	Working Plan End Of Period Inventory Retail.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In R	Working Plan miscellaneous In Retail.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out R	Working Plan miscellaneous Out Retail.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp Markdown R	Working Plan Markdown Retail.
Wp MarkUp R	Working Plan Markup Retail.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order R	Working Plan On Order Retail Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipts Cost Value.
Wp Receipts R	Working Plan Receipts Retail Value.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink R	Working Plan Shrink Retail.
Wp Shrink U	Working Plan Shrink Units.

Miscellaneous Measures Validation

The Misc. Measures Validation step includes one view, the Misc. Measures view. Use this view to validate that the measures were loaded in the batch process.

Figure 9-8 Misc. Measures View

The following table lists the measures available on this view.

Table 9-4 Misc Measures View Measures

Measure	Description
Wp Start Date	Working plan start date.
Wp BOP Unelapsed	Bottom up working plan beginning of period unelapsed (time).
Wp Unelapsed	Bottom up working plan unelapsed (time).
Wp BOP Unelapsed	Middle out working plan beginning of period unelapsed (time).
Wp Unelapsed	Middle out working plan unelapsed (time).
Wp BOP Unelapsed	Top down working plan beginning of period unelapsed (time).
Wp BOP Unelapsed	Top down working plan unelapsed (time).
Ty Clearance BOP Inv C	This Year Clearance Beginning of Period Inventory Cost.
Ty Clearance BOP Inv R	This Year Clearance Beginning of Period Inventory Retail.
Ty Clearance BOP Inv U	This Year Clearance Beginning of Period Inventory Unit.
Ty Regular BOP Inv C	This Year Regular Beginning of Period Inventory Cost.
Ty Regular BOP Inv R	This Year Regular Beginning of Period Inventory Retail Value.
Ty Regular BOP Inv U	This Year Regular Beginning of Period Inventory Units.
Ty Clearance EOP Inv C	This Year Clearance End of Period Inventory Cost.
Ty Clearance EOP Inv R	This Year Clearance End of Period Inventory Retail.
Ty Clearance EOP Inv U	This Year Clearance End of Period Inventory Units.
Ty Regular EOP Inv C	This Year Regular End of Period Inventory Cost.
Ty Regular EOP Inv R	This Year Regular End of Period Inventory Retail Value.
Ty Regular EOP Inv U	This Year Regular End of Period Inventory Units.
Ty Misc In R	This Year Miscellaneous In Retail Value.
Ty Misc In U	This Year Miscellaneous In Units.
Ty Misc Out R	This Year Miscellaneous Out Retail Value.
Ty Misc Out U	This Year Miscellaneous Out Units.
Ty Markdown Perm R	This year's permanent price markdown for retail.
Ty Markdown Promo R	This year's promotional price markdown for retail.
Ty Markdown Clr R	This year's clearance price markdown for retail.
Ty MarkUp R	This Year Markup Retail Value.
Ty On Order C	This Year On Order Cost.
Ty On Order R	This Year On Order Retail.
Ty On Order U	This Year On Order Units.
Ty Receipts C	This Year Receipt Cost.
Ty Receipts R	This Year Receipt Retail Value.
Ty Receipts U	This Year Receipt Units.
Ty Shrink R	This Year Shrink Retail Value.
Ty Shrink U	This Year Shrink Units.
Ty Sales Clr R	This year's clearance sales.
Ty Sales Clr U	This year's clearance sales units.
Ty Sales Promo R	This year's promotional sales.
Ty Sales Promo U	This Year promotional sales units.
Ty Sales Reg R	This year's regular sales.
Ty Sales Reg U	This year's regular sales units.