5 RAP Integration
The Retail Demand Forecasting (RDF) solution is built on top of
the Planning Data Store (PDS) and is integrated with Retail Science
(RSP) and Retail Insights (RI) with in the Retail Analytical Platform
(RAP). All three solutions (RSP, RI, PDS) within RAP can share data
using RAP Data Exchange (RDX) using RAP interfaces. RDF gets the foundation
data from RI and forecast from RSP through RDX. RDF being an extensible
solution, retailers can customize the interface using the interface.cfg
file to map dimensions and facts from the
RAP interface tables. For additional information refer to the Retail
Predictive Application Server Cloud Edition Implementation Guide.
Figure 5-1 Retail Analytical Platform (RAP) Integration
Interfaces Available in the RDF Template
Following is the pre-defined grouping of interfaces available in the RDF template version within RAP integration:
-
Organization Hierarchy from RMFCS using Retail Insights (RI)
-
Product Attribute Hierarchy from RMFCS using Retail Insights (RI)
Product Hierarchy from RMFCS using Retail Insights (RI)
Table 5-1 lists the interface grouping for Product Hierarchy from RMFCS using Retail Insights (RI).
Table 5-1 Product Hierarchy from RMFCS using Retail Insights (RI)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
W_PDS_PRODUCT_D |
ITEM |
SKU |
ITEM_PARENT_DIFF |
SKUP |
|
ITEM_PARENT |
SKUG |
|
SUBCLASS_ID |
SCLS |
|
CLASS_ID |
CLSS |
|
DEPT |
DEPT |
|
GROUP_NO |
PGRP |
|
DIVISION |
DVSN |
|
COMPANY |
CMPP |
|
SUPPLIER |
VNDR |
|
ITEM_DESC |
||
ITEM_PARENT_DIFF_DESC |
||
ITEM_PARENT_DESC |
||
SUB_NAME |
||
CLASS_NAME |
||
DEPT_NAME |
||
GROUP_NAME |
||
DIV_NAME |
||
CO_NAME |
||
SUP_NAME |
||
PACK_FLG (Filter) |
PCKFLGVAL |
Organization Hierarchy from RMFCS using Retail Insights (RI)
Table 5-2 lists the interface grouping for Organization Hierarchy from RMFCS using Retail Insights (RI).
Table 5-2 Organization Hierarchy from RMFCS using Retail Insights (RI)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
W_PDS_ORGANIZATION_D |
LOCATION |
STOR |
DISTRICT |
DSTR |
|
REGION |
REGN |
|
AREA |
CHNL |
|
CHAIN |
CHAN |
|
COMPANY |
COMP |
|
LOC_TYPE |
LOCT |
|
STORE_FORMAT |
SFMT |
|
STORE_CLASS |
STCL |
|
LOC_NAME |
||
DISTRICT_NAME |
||
REGION_NAME |
||
AREA_NAME |
||
CHAIN_NAME |
||
CO_NAME |
||
LOC_TYPE_NAME |
||
STORE_FORMAT_NAME |
||
STORE_CLASS_DESCRIPTION |
Calendar Hierarchy from RMFCS using Retail Insights (RI)
Table 5-3 lists the interface grouping for Calendar Hierarchy from RMFCS using Retail Insights (RI).
Table 5-3 Calendar Hierarchy from RMFCS using Retail Insights (RI)
Interface Name | Interface Field Name | PDS Field Mapping |
---|---|---|
W_PDS_CALENDAR_D |
DAY |
DAY |
WEEK |
WEEK |
|
MNTH |
MNTH |
|
QRTR |
QRTR |
|
HALF |
HALF |
|
YEAR |
YEAR |
|
WOYR |
WOYR |
|
DOW |
DOW |
|
DAY_LABEL |
||
WEEK_LABEL |
||
MNTH_LABEL |
||
QRTR_LABEL |
||
HALF_LABEL |
||
YEAR_LABEL |
||
WOYR_LABEL |
||
DOW_LABEL |
Note:
The W_PDS_CALENDAR interface is populated from an internal view 'VW_CLND_HIER' from where the labels are added.Product Attribute Hierarchy from RMFCS using Retail Insights (RI)
Table 5-4 lists the interface grouping for Product Attribute Hierarchy from RMFCS using Retail Insights (RI).
Table 5-4 Product Attribute Hierarchy from RMFCS using Retail Insights (RI)
Interface Name | Interface Field Name | PDS Field Mapping |
---|---|---|
W_PDS_UDA_D |
PROD_ATTR_VALUE |
PATV |
PROD_ATTR |
PATT |
|
PROD_ATTR_VALUE_DESC |
||
PROD_ATTR_DESC |
Note:
The W_PDS_UDA_D interface is populated from an internal view 'VW_PATR_HIER' where in the attribute hierarchy data is pulled in from the following RDX tables by concatenating all of them as product attributes:-
W_PDS_UDA_D
-
W_PDS_DIFF_D
-
W_PDS_SUPPLIER_D
-
W_PDS_BRAND_D
It also concatenates the product attribute name with the product attribute values using ‘_’ to make the product attribute values unique. The Product Attribute name for Supplier (W_PDS_SUPPLIER_D) is used as ‘supp’ and Brand (W_PDS_BRAND_D) is used as ‘brnd’.
Only Product attributes with UDA_TYPE_CODE as ‘LV’ from W_PDS_UDA_D are included in the view.
Supplier Hierarchy from RMFCS using Retail Insights (RI)
Table 5-5 lists the interface grouping for Supplier Hierarchy from RMFCS using Retail Insights (RI).
Table 5-5 Interface Grouping for Supplier Hierarchy from RMFCS using Retail Insights (RI)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
W_PDS_SUPPLIER_D |
SUPPLIER |
SUPP |
W_PDS_SUPPLIER_D |
SUP_NAME |
Item Attributes from Retail Insights (RI)
Table 5-6 lists the interface grouping for Item Attributes from Retail Insights (RI).
Table 5-6 Item Attributes from Retail Insights (RI)
Interface Name | Interface Field Name | PDS Field Mapping |
---|---|---|
W_PDS_PRODUCT_ATTR_D |
ITEM |
SKU |
PROD_ATTR |
PATT |
|
PROD_ATTR_VALUE |
RDF_PRDATTT |
Note:
The W_PDS_PRODUCT_ATTR_D is populated from an internal view 'VW_PATR_DATA' from where the item attribute mapping is pulled in from the RDX table W_PDS_PRODUCT_ATTR_D and SUPPLIER, BRAND_NAME, DIFF_1, DIFF_2, DIFF_3, DIFF_4 fields from W_PDS_PRODUCT_D table.Sales Data from Retail Insights (RI)
Table 5-7 lists the interface grouping for Sales Data from Retail Insights (RI)
Table 5-7 Sales Data from Retail Insights (RI)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
W_PDS_GRS_SLS_IT_LC_WK_A |
EOW_DATE |
WEEK |
ITEM |
SKU |
|
LOCATION |
STOR |
|
SALES_UNITS |
RDF_RSAL |
|
SLS_TYPE (FILTER) |
R |
|
EOW_DATE |
WEEK |
|
ITEM |
SKU |
|
LOCATION |
STOR |
|
SALES_UNITS |
RDF_PSAL |
|
SLS_TYPE (FILTER) |
P |
|
EOW_DATE |
WEEK |
|
ITEM |
SKU |
|
LOCATION |
STOR |
|
SALES_UNITS |
RDF_CSAL |
|
SLS_TYPE (FILTER) |
C |
Pack Assortment from Retail Insights (RI)
Table 5-8 lists the interface grouping for Pack Assortment from Retail Insights (RI).
Table 5-8 Pack Assortment from Retail Insights (RI)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
W_PDS_PRODUCT_PACK_D |
PACK_ITEM |
SKU |
COMP_ITEM |
SKUR |
|
PACK_QTY |
RDF_LPPMPCKSKUASSU |
Inventory Data from Retail Insights (RI)
Table 5-9 lists the interface grouping for Inventory Data from Retail Insights (RI).
Table 5-9 Inventory Data from Retail Insights (RI)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
VW_LIP_INV_DATA |
DAY_DATE |
DAY |
ITEM |
SKU |
|
LOCATION |
STOR |
|
INV_CO_RSV_QTY |
RDF_LPINCUSTORDRESU |
|
INV_CO_BO_RSV_QTY |
RDF_LPINCUSTORDBCKU |
|
INV_ON_ORD_QTY |
LPINONORDINU |
|
INV_IN_TRAN_QTY |
LPININTRNSU |
|
INV_SOH_QTY |
LPINONHANDU |
Replenishment Attributes from Retail Insights (RI)
Table 5-10 lists the interface grouping for Replenishment Attributes from Retail Insights (RI).
Table 5-10 Replenishment Attributes from Retail Insights (RI)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
W_PDS_REPL_ATTR_IT_LC_D |
ITEM |
SKU |
LOCATION |
STOR |
|
REPL_PRES_STOCK |
LPINDSPQU |
Offer Hierarchy from Science (RSP)
Table 5-11 lists the interface grouping for Offer Hierarchy from Science (RSP).
Table 5-11 Offer Hierarchy from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_OFFER_HIER_EXP |
OFFER_ID |
OFFD |
PROMO_ID |
PRMD |
|
CAMPAIGN_ID |
CAMD |
|
OFFER_ID |
OFFA |
|
CAMPAIGN_ID |
CAMA |
|
OFFER_LABEL |
||
PROMO_LABEL |
||
CAMPAIGN_LABEL |
||
OFFER_ALIAS |
||
CAMPAIGN_ALIAS |
Offer Details from Science (RSP)
Table 5-12 lists the interface grouping for Offer Details from Science (RSP).
Table 5-12 Offer Details from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_OFFER_DTL_EXP |
OFFER_ID |
OFFD |
OFFER_START_DT |
OFFSTARTDT |
|
OFFER_END_DT |
OFFENDDT |
|
REWARD_TYPE_ID |
REWARDTYPE |
Offer Sales Details from Science (RSP)
Table 5-13 lists the interface grouping for Offer Sales Details from Science (RSP).
Table 5-13 Offer Sales Details from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_OFFER_SALES_EXP |
PROD_EXT_KEY |
SKU |
LOC_EXT_KEY |
STOR |
|
OFFER_ID |
OFFD |
|
OFFER_SALES_QTY |
OFFERSLS |
|
EFFECTIVE_DISCOUNT_PCT |
EFFDISCOUNT |
Reward Type Hierarchy from Science (RSP)
Table 5-14 lists the interface grouping for Reward Type Hierarchy from Science (RSP).
Table 5-14 Reward Type Hierarchy from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_REWARD_TYPE_HIER_EXP |
REWARD_TYPE_ID |
RDTP |
REWARD_TYPE_LABEL |
Product Attribute Weight from Science (RSP)
Table 5-15 lists the interface grouping for Product Attribute Weight from Science (RSP).
Table 5-15 Product Attribute Weight from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_ATTR_WGT_EXP |
PROD_EXT_KEY |
CLSS |
LOC_EXT_KEY |
CHNL |
|
PROD_ATTR_GRP_EXT_KEY |
PATT |
|
ATTR_WGT |
PATTWGT |
|
CUSTSEG_EXT_KEY |
||
CLS |
||
AREA |
Forecast Import from Science (RSP)
Table 5-16 lists the interface grouping for Forecast Import from Science (RSP).
Table 5-16 Forecast Import from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_FCST_DEMAND_DTL_CAL_EXP |
FCST_DATE_FROM |
llc_frcst_CF_:CLND |
PROD_EXT_KEY |
llc_frcst_CF_:PROD |
|
LOC_EXT_KEY |
llc_frcst_CF_:LOC |
|
BASELINE_FCST_QTY |
rdf_sysbaseline_CF_ |
|
DEMAND_FCST_QTY |
rdf_sysfrcst_CF_ |
|
EVENT_PEAK_QTY |
rdf_syspeak_CF_ |
|
EVENT_CLND |
rdf_eventfut_CF_ |
|
PRICE_DISC_PERCENT |
rdf_prcdiscfut_CF_ |
|
rdf_rserunid_CF_ (Filter) |
RUN_ID |
|
BASELINE_FCST_QTY (Filter) |
Note:
-
llc_frcst_CF_:CLND —refers to Calendar dimension of the corresponding forecast level
-
llc_frcst_CF_:PROD —refers to Product dimension of the corresponding forecast level
-
llc_frcst_CF_:LOC —refers to Location dimension of the corresponding forecast level
Base Demand Import from Science (RSP)
Table 5-17 lists the interface grouping for Base Demand Import from Science (RSP)
Table 5-17 Base Demand Import from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_FCST_DEMAND_DTL_EXP |
PROD_EXT_KEY |
llc_frcstTS_CF_:PROD |
LOC_EXT_KEY |
llc_frcstTS_CF_:LOC |
|
BASE_DEMAND_QTY |
rdf_basedemand_CF_ |
|
PRICE_ELASTICITY |
rdf_priceelas_CF_ |
|
rdf_rserunid_CF_ (Filter) |
RUN_ID |
|
BASE_DEMAND_QTY (Filter) |
Note:
-
llc_frcstTS_CF_:PROD —refers to Product dimension of the corresponding forecast level
-
llc_frcstTS_CF_:LOC —refers to Location dimension of the corresponding forecast level
Approved Base Demand Import from Science (RSP)
Table 5-18 lists the interface grouping for Approved Base Demand Import from Science (RSP).
Table 5-18 Approved Base Demand Import from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_FCST_APPR_BASE_DMD_EXP |
PROD_EXT_KEY |
llc_frcstTS_CF_:PROD |
LOC_EXT_KEY |
llc_frcstTS_CF_:LOC |
|
APPR_BASE_DEMAND_QTY |
rdf_appchosenlevel_CF_ |
|
rdf_rserunid_CF_ (Filter) |
RUN_ID |
|
APPR_BASE_DEMAND_QTY (Filter) |
Note:
-
llc_frcstTS_CF_:PROD —refers to Product dimension of the corresponding forecast level
-
llc_frcstTS_CF_:LOC —refers to Location dimension of the corresponding forecast level
Preprocessed Sales Import from Science (RSP)
Table 5-19 lists the interface grouping for Preprocessed Sales Import from Science (RSP).
Table 5-19 Preprocessed Sales Import from Science (RSP)
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RSE_FCST_DEMAND_SRC_EXP |
DATE_FROM |
llc_frcst_CF_:CLND |
PROD_EXT_KEY |
llc_frcst_CF_:PROD |
|
LOC_EXT_KEY |
llc_frcst_CF_:LOC |
|
STOCKOUT_IND |
rdf_outageind_CF_ |
|
LOST_SLS_QTY |
rdf_outageadj_CF_ |
|
OUTLIER_IND |
rdf_outlierind_CF_ |
|
OUTLIER_SLS_QTY |
rdf_outlieradj_CF_ |
|
PROMO_SLS_QTY |
rdf_depromoadj_CF_ |
|
CLR_SLS_QTY |
rdf_deprice_CF_ |
|
PREPROCESSED_SLS_QTY |
rdf_totadjsls_CF_ |
|
rdf_rserunid_CF_ (Filter) |
RUN_ID |
|
PREPROCESSED_SLS_QTY (Filter) |
Note:
-
llc_frcst_CF_:CLND —refers to Calendar dimension of the corresponding forecast level
-
llc_frcst_CF_:PROD —refers to Product dimension of the corresponding forecast level
-
llc_frcst_CF_:LOC —refers to Location dimension of the corresponding forecast level
Export Run Type Batch Setting
Table 5-20 lists the interface grouping for Export Run Type Batch Setting.
Table 5-20 Export Run Type Batch Setting
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_RUN_TYPE_PARM_EXP |
RDF_RUN_TYPE_KEY |
v |
ENABLE_NEW_ITEM |
rdf_runnewitem_CF |
|
ENABLE_FORECAST |
rdf_runfrcst_CF_ |
Approved Forecast Export
Table 5-21 lists the interface grouping for Approved Forecast Export.
Table 5-21 Approved Forecast Export
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_APPR_FCST_CAL_EXP |
llc_frcst_CF_:CLND |
|
PROD_EXT_KEY |
llc_frcst_CF_:PROD |
|
LOC_EXT_KEY |
llc_frcst_CF_:LOC |
|
BOP_DATE |
rdf_bopdate_CF_ |
|
APPR_BASELINE_FCST |
rdf_appbaseline_CF_ |
|
APPR_DEMAND_FCST |
rdf_appfrcst_CF_ |
|
APPR_CUMINT |
rdf_appcumint_CF_ |
|
rdf_exportmask_CF_ (Filter) |
Note:
-
llc_frcst_CF_:CLND —refers to Calendar dimension of the corresponding forecast level
-
llc_frcst_CF_:PROD —refers to Product dimension of the corresponding forecast level
-
llc_frcst_CF_:LOC —refers to Location dimension of the corresponding forecast level
Forecast Parameters Export
Table 5-22 exports the basic forecast parameters like Forecast Start Date, Forecast End Date and History length (used to calculate base demand) at the RUN TYPE intersection.
Table 5-22 Forecast Parameters Export: Basic Forecast Parameters
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_FCST_PARM_EXP |
PROD_EXT_KEY |
llc_frcstTS_CF_:PROD |
LOC_EXT_KEY |
llc_frcstTS_CF_:LOC |
|
FCST_HIST_LENGTH |
rdf_hislen_CF_ |
|
FCST_START_DATE |
rdf_frcststartdt_CF_ |
|
FCST_END_DATE |
rdf_frcstenddt_CF_ |
|
rdf_expfcstmaskts_CF_ (Filter) |
Note:
-
llc_frcstTS_CF_:PROD —refers to Product dimension of the corresponding forecast level
-
llc_frcstTS_CF_:LOC —refers to Location dimension of the corresponding forecast level
Table 5-23 exports the preprocess indicators that could be loaded or calculated through extensibility.
Table 5-23 Forecast Parameters Export: Preprocess Indicators
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_FCST_PARM_CAL_EXP |
llc_frcst_CF_:CLND |
|
PROD_EXT_KEY |
llc_frcst_CF_:PROD |
|
LOC_EXT_KEY |
llc_frcst_CF_:LOC |
|
BOP_DATE |
rdf_bopdate_CF_ |
|
USER_OVERRIDE |
rdf_totadjslsovr_CF_ |
|
PPS_OUTAGE_IND |
rdf_outageind_CF_ |
|
PPS_OUTLIER_IND |
rdf_outlierind_CF_ |
|
rdf_expparmask_CF_ (Filter) |
Note:
-
llc_frcst_CF_:CLND —refers to Calendar dimension of the corresponding forecast level
-
llc_frcst_CF_:PROD —refers to Product dimension of the corresponding forecast level
-
llc_frcst_CF_:LOC —refers to Location dimension of the corresponding forecast level
New Item Parameters Export
Table 5-24 exports the strategy to be applied to generate forecast for new items and new stores. These parameters are applicable for all Run Types that have ENABLE_NEW_ITEM field set to TRUE in the RDF_RUN_TYPE_PARM_EXP table.
Table 5-24 New Item Parameters Export
RDX Table | RDX Field Name | PDS Field Mapping |
---|---|---|
RDF_NIT_PARM_EXP |
PROD_EXT_KEY |
NIT_SKUSTR_INTX:PROD |
LOC_EXT_KEY |
NIT_SKUSTR_INTX:LOC |
|
NIT_SKUSTR_INTX:PROD |
PROD_HIER_LEVEL |
|
NIT_SKUSTR_INTX:LOC |
LOC_HIER_LEVEL |
|
NIT_SUB_METHOD |
rdf_fcpsubm |
|
NIT_ROS_USER_IN |
rdf_fcpros |
|
NIT_LIKE_ITEM |
rdf_nitapplkitm1 |
|
NIT_LIKE_STOR |
rdf_nstapplkstr1 |
|
ADJUSTMENT_FACTOR |
rdf_fcpadj |
|
rdf_fcpsubm (Filter) |