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:

• Product Hierarchy from RMFCS using Retail Insights (RI)

• Organization Hierarchy from RMFCS using Retail Insights (RI)

• Calendar Hierarchy from RMFCS using Retail Insights (RI)

• Product Attribute Hierarchy from RMFCS using Retail Insights (RI)

• Item Attributes from Retail Insights (RI)

• Sales Data from Retail Insights (RI)

• Offer Hierarchy from Science (RSP)

• Offer Details from Science (RSP)

• Reward Type Hierarchy from Science (RSP)

• Group Hierarchy from Science (RSP)

• Group Level Hierarchy from Science (RSP)

• Product Attribute Weight from Science (RSP)

• Forecast Import from Science (RSP)

• Base Demand Import from Science (RSP)

• Approved Base Demand Import from Science (RSP)

• Preprocessed Sales Import from Science (RSP)

• Flex Group Import from Science (RSP)

• Export Run Type Batch Setting

• Approved Forecast Export

• Forecast Parameters Export

• Agg/Spread Profile Export

• Flex Group Assignment Export

• New Item Parameters Export

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

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
	STORE_FORMAT	SFMT
	STORE_CLASS	STCL
	LOC_NAME
	DISTRICT_NAME
	REGION_NAME
	AREA_NAME
	CHAIN_NAME
	CO_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.

Item Attributes from Retail Insights (RI)

Table 5-5 lists the interface grouping for Item Attributes from Retail Insights (RI).

Table 5-5 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-6 lists the interface grouping for Sales Data from Retail Insights (RI)

Table 5-6 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

Offer Hierarchy from Science (RSP)

Table 5-7 lists the interface grouping for Offer Hierarchy from Science (RSP).

Table 5-7 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-8 lists the interface grouping for Offer Details from Science (RSP).

Table 5-8 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-9 lists the interface grouping for Offer Sales Details from Science (RSP).

Table 5-9 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-10 lists the interface grouping for Reward Type Hierarchy from Science (RSP).

Table 5-10 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-11 lists the interface grouping for Product Attribute Weight from Science (RSP).

Table 5-11 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-12 lists the interface grouping for Forecast Import from Science (RSP).

Table 5-12 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-13 lists the interface grouping for Base Demand Import from Science (RSP)

Table 5-13 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-14 lists the interface grouping for Approved Base Demand Import from Science (RSP).

Table 5-14 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-15 lists the interface grouping for Preprocessed Sales Import from Science (RSP).

Table 5-15 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-16 lists the interface grouping for Export Run Type Batch Setting.

Table 5-16 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-17 lists the interface grouping for Approved Forecast Export.

Table 5-17 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-18 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-18 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-19 exports the preprocess indicators that could be loaded or calculated through extensibility.

Table 5-19 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-20 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-20 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)