Import DT Parameters from AI Foundation
The previous version of APCS used Demand Transference (DT) from AI Foundation to suggest and optimize the assortments. DT is based on Item attributes, Attribute Weights, Functional Fit for Attributes, Assortment Elasticity, and Rate of Sale of Items. Item Attributes and Rate of Sale of item are available from RI interfaces. Other DT parameters such as Attribute Weights, Functional Fit for Attributes, and Assortment Elasticity are interfaced from AI Foundation through RAP integration. The APCS template version gets the DT parameters from RAP at the Sub-Class/Channel level, so it needs to be defined in AI Foundation at that level.
In order to get DT parameters from AI Foundation, during implementation, some initial setups need to be done in the AI Foundation platform. AI Foundation needs a customer segment to be defined for DT interfaces. AI Foundation can use multiple customer segments, so those customer segments need to be loaded as the CSGH hierarchy, in order for AP to interface DT parameters. AP is not directly using customer segments in planning workbooks, but the user can choose the Customer Segment to use for a Sub-Class in the Planning Admin workbook. Only those selected Customer Segments DT Parameters for the Sub-Class will be used in the AP workbooks. For more details, see the Oracle Retail Analytics and Planning Integration Implementation Guide.
The following table shows the interface table column details from AI Foundation in RDX used for the interface and the corresponding mapping of columns in APCS. Only mapped columns are used by the APCS template version. If RAP integration is enabled and if Enable RSE DT Integration is set to true, then this interface will run as part of the weekly batch.
The current version of AP is not using the below interface but still kept the details for non-template customers to customize and use the same if they are still using this integration.
Interface Name: RSE_ASSORT_ELASTICITY_EXP
| Table Column | Data Type | Comments | Dimension / Measure / Value Mapping |
|---|---|---|---|
|
RUN_ID |
Number(10) |
The export Run ID as obtained from the RAP_INTF_UTIL. |
|
|
LOC_HIER_LEVEL |
Varchar2(30) |
The location hierarchy level data is for COMPANY, CHAIN, AREA, REGION, DISTRICT, LOCATION, and CHANNEL_COUNTRY. |
CHANNEL_COUNTRY |
|
PROD_HIER_LEVEL |
Varchar2(30) |
The product hierarchy level the data is for CMP, DIV, GRP, DEPT, CLS, SBC, STYLE, STYLE_COLOR, and ITEM. |
SBC |
|
LOC_EXT_KEY |
Varchar2(80) |
The external id of the location. It will use the integration ids as provided to RI. |
CHNC |
|
PROD_EXT_KEY |
Varchar2(80) |
The external id of the product hierarchy. It will use the integration ids as provided to RI (preferably the RMS id, and not an integration id such as CLS~123~456~789). |
SCLS |
|
CUSTSEG_EXT_KEY |
Varchar2(80) |
The external id of the customer segment. |
CSGD |
|
ASSORT_ELASTICITY |
Number(38,20) |
The assortment elasticity which DT has calculated. |
DRTYASSRTELASV |
|
EFFECTIVE_DT_FROM |
Date |
The date when this data was activated. |
Interface Name: RSE_ASSORT_ATTR_WGT_EXP
| Table Column | Data Type | Comments | Dimension / Measure / Value Mapping |
|---|---|---|---|
|
RUN_ID |
Number(10) |
The export Run ID as obtained from the RAP_INTF_UTIL. |
|
|
LOC_HIER_LEVEL |
Varchar2(30) |
The location hierarchy level data is for COMPANY, CHAIN, AREA, REGION, DISTRICT, LOCATION, and CHANNEL_COUNTRY. |
CHANNEL_COUNTRY |
|
PROD_HIER_LEVEL |
Varchar2(30) |
The product hierarchy level the data is for CMP, DIV, GRP, DEPT, CLS, SBC, STYLE, STYLE_COLOR, and SKU. |
SBC |
|
LOC_EXT_KEY |
Varchar2(80) |
The external id of the location. It will use the integration ids as provided to RI (preferably the RMS id, and not an integration id such as AREA~123). |
CHNL |
|
PROD_EXT_KEY |
Varchar2(80) |
The external id of the product hierarchy. It will use the integration ids as provided to RI (preferably the RMS id, and not an integration id such as CLS~123~456~789). |
SCLS |
|
CUSTSEG_EXT_KEY |
Varchar2(80) |
The external id of the customer segment. It will be NULL if not applicable. |
CSGD |
|
PROD_ATTR_GRP_EXT_KEY |
Varchar2(80) |
The external ID for the product attribute. |
PATT |
|
ATTR_WGT |
Number(38,20) |
The attribute weight. |
DRTYATTRWGTV |
|
FUNC_ATTR_FLG |
Varchar2(1) |
Y/N Flag indicating this is a functional attribute. A functional attribute is one which fits a specific purpose and cannot be substituted by other products with other values for this attribute. |
DRTYFUNCFITB |