D Appendix: Using Sample Hierarchy and Data

This appendix provides information for using sample hierarchy and data for AIP.

Sample Data

In addition to the sample hierarchy, the AIP-rpas-installer.zip also provides sample data that can be used by the AIP batch process to populate the sample domain created in Chapter 8, "Installing AIP RPAS - Full Version." As mentioned in "Extracting the Installer", when the AIP-rpas-installer.zip is extracted, there is a file data.tar located in the folder [AIP_Installer]/aip/[platform]/env/AIP_INSTALL.

To extract the AIP sample data from data.tar, run the following command from
$AIP_INSTALL:

$ tar -xf data.tar

This command creates $AIP_INSTALL/data folder which contains following sub-folders and data:

• External data (located in $AIP_INSTALL/data/external)

• Forecast data (located in $AIP_INSTALL/data/forecast)

• RMS Extracts data (located in $AIP_INSTALL/data/rms_extracts)

• RMS Transforms data (located in $AIP_INSTALL/data/rms_transforms)

RDF and External Sample Data

The Forecast and External data represent sample data coming from Oracle Retail Demand Forecasting (RDF) or from external source which are in AIP-ready format and which can be loaded directly into the domain using AIP batch process (as described in the Oracle Retail Advanced Inventory Planning Implementation Guide and the Oracle Retail Advanced Inventory Planning Operations Guide).

For detailed information on the format of these files, refer to the chapters, ”RDF Integration” and ”External System Integration” in the Oracle Retail Advanced Inventory Planning Implementation Guide.

RMS Sample Data

The other data folders, RMS Extracts and Transforms data represent sample data coming from RMS. The RMS Transforms data, similar to Forecast and External data, is also in AIP-ready format which can be loaded directly into the domain using AIP batch process without having to use RMS-AIP Transform Script.

Alternatively, the RMS Extracts data needs to be transformed by RMS-AIP Transform Script into the AIP format before it can be used by the AIP batch process. In order to use this data, clients need to run aip_t_master_rms<RMS_version>.ksh to reproduce the RMS Transforms data from the RMS Extracts data, and then use the output data from the RMS-AIP Transformation for AIP batch run.

For detailed information on the data format and transformation scripts, refer to the chapter, ”RMS Integration and Data Mapping” in the Oracle Retail Advanced Inventory Planning Implementation Guide or the chapter, ”AIP Interfaces and Transformation Scripts”, in the Oracle Retail Advanced Inventory Planning Operations Guide.

Using Sample Data

In order to use these sample data with the domain created in Chapter 8, "Installing AIP RPAS - Full Version," refer to these chapters from the Oracle Retail Advanced Inventory Planning Operations Guide:

• ”AIP RPAS Batch Processing”

• ”AIP RPAS Daily Batch Scripts”

For information on loading sample data into the sample domain and for practical use of the AIP batch, refer to these chapters from the Oracle Retail Advanced Inventory Planning Implementation Guide:

• ”System Configuration”

• ”First Day of AIP”

  
  

  Note: In order for the AIP batch to properly generate the plans using the provided sample data set, the following data is needed: RPAS_TODAY is set to a date in 2014 (for example, 20140201) The replenishment method is set to user's desired value along with all supporting measures For information about the replenishment's supporting measures, refer to either the Classic Client or Fusion Client version of the Oracle Retail Advanced Inventory Planning Store and Warehouse Replenishment Planning User Guide.