9 Data Load Validation

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 workbook 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 appears. Select the items and click Next.

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

   
   

4. The Location Selection step appears. Select the channel 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

Table 9-1 Bottom Up Working View Worksheet Measures

Measure	Description
Wp BOP Inv U	Working Plan Beginning of Period Inventory Units.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In C	Working Plan miscellaneous In Cost.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out C	Working Plan miscellaneous Out Cost.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipt Cost.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink C	Working plan shrink Cost.
Wp Shrink U	Working plan shrink units.
Wp Sales C	Working Plan Regular Sales Cost Value.
Wp Sales U	Working Plan Clearance Sales Unit Value.

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 U	Working Plan Beginning of Period Inventory Units.
Wp EOP Inv C	Working Plan End Of Period Inventory Cost.
Wp EOP Inv U	Working Plan End Of Period Inventory Units.
Wp Misc In C	Working Plan miscellaneous In Cost.
Wp Misc In U	Working Plan miscellaneous In Unit.
Wp Misc Out C	Working Plan miscellaneous Out Cost.
Wp Misc Out U	Working Plan miscellaneous Out Unit.
Wp On Order C	Working Plan On Order Cost Value.
Wp On Order U	Working Plan On Order Units.
Wp Receipts C	Working Plan Receipts Cost Value.
Wp Receipts U	Working Plan Receipts Units.
Wp Shrink C	Working Plan Shrink Cost.
Wp Shrink U	Working Plan Shrink Units.
Wp Sales C	Working Plan Sales Cost.
Wp Sales U	Working Plan 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 EOP Inv C	Working Plan End Of Period Inventory Cost.
Wp Misc In C	Working Plan miscellaneous In Cost.
Wp Misc Out C	Working Plan miscellaneous Out Cost.
Wp On Order C	Working Plan On Order Cost Value.
Wp Receipts C	Working Plan Receipts Cost Value.
Wp Shrink C	Working Plan Shrink Cost.
Wp Sales C	Working Plan Sales Cost.

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 Forecast Start Date	Working plan forecast 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).