| Oracle® Retail Data Model Reference Release 11.3.2 E20361-03 |
|
|
PDF · Mobi · ePub |
| Oracle® Retail Data Model Reference Release 11.3.2 E20361-03 |
|
|
PDF · Mobi · ePub |
This chapter describes the data flow between fact tables and dimension tables of Oracle Retail Data Model relational tables to target materialized views and cubes to support the OLAP module in Oracle Retail Data Model.
For more information, see Chapter 9, "Oracle Retail Data Model OLAP Cubes".
Table 8-1 lists the OLAP dimensions and each dimension description includes the following information:
Levels
Hierarchies
Attributes and Attribute mappings
The dimensional data model is an integral part of On-Line Analytical Processing (OLAP). A dimensional data model is as much a logical model as a physical model. Conceptually, a dimensional data model is composed of cubes, measures, dimensions, hierarchies, levels, and attributes.
For a more complete introduction to the OLAP dimensional models, see Oracle OLAP User's Guide.
Tip:
In general, it is not recommended to modify the dimensions/cubes provided by Oracle Retail Data Model.There are certain changes to existing dimensions, such as defining new attributes, creating additional hierarchies, defining additional dimensions, additional cubes or additional measures in existing cubes which are possible and do not break the existing OLAP model.
You can make these changes; However these changes are not supported in that any issues arising out of the modified model will not be supported or treated as bugs.
At the same time, certain other changes are also possible, such as introducing a new level within an existing hierarchy, modifying the mapping for existing attributes, level definitions, descriptions, and so on. These changes are more disruptive in nature and greater care needs to be exercised while making these changes.
Note that most of these changes would typically impact other modules in Oracle Retail Data Model such as Reporting (corresponding modifications would be needed to the Reporting rpd, Reports, and so on).
This dimension stores the Activity Request Types used in Oracle Retail Data Model.
Default Hierarchy: HACTRQSTTYP
Table 8-2 Activity Request Type Hierarchy (HACTRQSTTYP)
| Level | Description | Activity Request Type Hierarchy (HACTRQSTTYP) |
|---|---|---|
|
TACTRQSTTYP |
Total Activity Request Type |
TACTRQSTTYP |
|
ACTRQSTTYP |
Activity Request Type |
ACTRQSTTYP |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-3 Activity Request Type Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TACTRQSTTYP |
'Total Activity Request Type' |
|
ACTRQSTTYP |
DWL_ACTVTY_RQST_TYP.ACTVTY_RQST_TYP_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Assets Types used in Oracle Retail Data Model.
Default Hierarchy: HASSTTYPE
Table 8-5 Assets Type Hierarchy (HASSTTYPE)
| Level | Description | Assets Type Hierarchy (HASSTTYPE) |
|---|---|---|
|
TASSTTYPE |
Total Assets Type |
TASSTTYPE |
|
ASSTTYPE |
Assets Type |
ASSTTYPE |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-6 Assets Type Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TASSTTYPE |
'Total Assets Type' |
|
ASSTTYPE |
DWL_ASSTS_TYP.ASSTS_TYP_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Business Unit Shifts used in Oracle Retail Data Model.
Default Hierarchy: HBUSHIFT
Table 8-8 Business Unit Shift Hierarchy (HBUSHIFT)
| Level | Description | Business Unit Shift Hierarchy (HBUSHIFT) |
|---|---|---|
|
TBUSHIFT |
Total Business Unit Shift |
TBUSHIFT |
|
SHIFTTYPE |
Shift Type |
SHIFTTYPE |
|
BUSHIFT |
Business Unit Shift |
BUSHIFT |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-9 Business Unit Shift Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TBUSHIFT |
'Total Business Unit Shift' |
|
SHIFTTYPE |
DWL_SHFT_TYP.SHFT_TYP_NAME |
|
BUSHIFT |
DWR_BSNS_UNIT_SHFT.NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Carriers used in Oracle Retail Data Model.
Default Hierarchy: HCARRIER
Table 8-11 Carrier Hierarchy (HCARRIER)
| Level | Description | Carrier Hierarchy (HCARRIER) |
|---|---|---|
|
TCARRIER |
Total Carrier |
TCARRIER |
|
CARRIER |
Carrier |
CARRIER |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-12 Carrier Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCARRIER |
'Total Carrier' |
|
CARRIER |
DWR_CARRIER.CARRIER_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the data relating to the Campaigns, Media used in Oracle Retail Data Model.
Default Hierarchy: HMEDIA
Table 8-14 Media and Campaign Hierarchy (HCMPGN)
| Level | Description | Media Hierarchy (HMEDIA) | Campaign Hierarchy (HCMPGN) |
|---|---|---|---|
|
TCM |
Total Campaign Media |
TCM |
TCM |
|
MEDIA |
Media |
MEDIA |
|
|
CMPGN |
Campaign |
CMPGN |
|
|
CMPGNMEDIA |
Campaign Media |
CMPGNMEDIA |
CMPGNMEDIA |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-15 Campaign Media Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCM |
'Total Campaign Media' |
|
MEDIA |
DWR_MEDIA.MEDIA_NAME |
|
CMPGN |
DWR_CMPGN.CMPGN_NAME |
|
CMPGNMEDIA |
DWR_CMPGN_MEDIA.LNG_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Customers used in Oracle Retail Data Model.
Default Hierarchy: HCUSTTYP
Table 8-17 Customer Type and Customer Cluster Hierarchy
| Level | Description | Customer Type Hierarchy (HCUSTTYP) | Customer Cluster Hierarchy (HCUSTCLSTR) |
|---|---|---|---|
|
TCUST |
Total Customer |
TCUST |
TCUST |
|
CUSTTYP |
Customer Type |
CUSTTYP |
|
|
CLSTR |
Cluster |
CLSTR |
|
|
CUST |
Customer |
CUST |
CUST |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-18 Customer Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCUST |
'Total Customer' |
|
CUSTTYP |
DWL_CUST_TYP.CUST_TYP_DESC |
|
CLSTR |
DWR_CUST_CLSTR.CUST_CLSTR_DESC |
|
CUST |
DWR_CUST.FIRST_NAME || ' ' || DWR_CUST.LAST_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-19 Customer Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCUST |
'Total Customer' |
|
CUSTTYP |
DWL_CUST_TYP.CUST_TYP_NAME |
|
CLSTR |
DWR_CUST_CLSTR.CUST_CLSTR_CD |
|
CUST |
DWR_CUST.CUST_NBR |
Attribute Name: Frequent Shopper Indicator (FS_IND)
Table 8-20 Customer Frequent Shopper Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCUST |
|
|
CUSTTYP |
|
|
CLSTR |
|
|
CUST |
DWR_CUST.FREQ_SHOPR_IND |
Attribute Name: Frequent Shopper Number (FS_NBR)
Table 8-21 Customer Frequent Shopper Number Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCUST |
|
|
CUSTTYP |
|
|
CLSTR |
|
|
CUST |
DWR_CUST.FREQ_SHOPR_NBR |
Attribute Name: Customer Type (CUST_TYP)
Table 8-22 Customer Customer Type Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCUST |
|
|
CUSTTYP |
|
|
CLSTR |
|
|
CUST |
DWR_CUST.CUST_TYP |
Attribute Name: Customer Number (CUST_NBR)
Table 8-23 Customer Number Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCUST |
|
|
CUSTTYP |
|
|
CLSTR |
|
|
CUST |
DWR_CUST.CUST_NBR |
Attribute Name: City (CITY)
Table 8-24 Customer City Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCUST |
|
|
CUSTTYP |
|
|
CLSTR |
|
|
CUST |
DWR_CUST.CITY |
Attribute Name: State (STATE)
Table 8-25 Customer State Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TCUST |
|
|
CUSTTYP |
|
|
CLSTR |
|
|
CUST |
DWR_CUST.STATE |
Attribute Name: Country (COUNTRY)
This dimension stores the Employees used in Oracle Retail Data Model.
Default Hierarchy: HEMPLOYEE
Table 8-27 Employee Hierarchy (HEMPLOYEE)
| Level | Description | Employee Hierarchy (HEMPLOYEE) |
|---|---|---|
|
TEMPLOYEE |
Total Employee |
TEMPLOYEE |
|
EMPLOYEETYPE |
Employee Type |
EMPLOYEETYPE |
|
EMPLOYEE |
Employee |
EMPLOYEE |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-28 Employee Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TEMPLOYEE |
'Total Employee' |
|
EMPLOYEETYPE |
DWL_EMP_TYP.EMP_TYP_NAME |
|
EMPLOYEE |
DWR_EMP.FULL_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Environment Types used in Oracle Retail Data Model.
Default Hierarchy: HENVTYPE
Table 8-30 Environment Type Hierarchy (HENVTYPE)
| Level | Description | Environment Type Hierarchy (HENVTYPE) |
|---|---|---|
|
TENVTYPE |
Total Environment Type |
TENVTYPE |
|
ENVTYPE |
Environment Type |
ENVTYPE |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-31 Environment Type Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TENVTYPE |
'Total Environment Type' |
|
ENVTYPE |
DWL_ENV_TYP.ENV_TYP_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Interaction Reasons used in Oracle Retail Data Model.
Default Hierarchy: HINTRACNRSN
Table 8-33 Interaction Reason Hierarchy (HINTRACNRSN)
| Level | Description | Interaction Reason Hierarchy (HINTRACNRSN) |
|---|---|---|
|
TINTRACNRSN |
Total Interaction Reason |
TINTRACNRSN |
|
INTRACNRSN |
Interaction Reason |
INTRACNRSN |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-34 Interaction Reason Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TINTRACNRSN |
'Total Interaction Reason' |
|
INTRACNRSN |
DWL_INTRACN_RSN.INTRACN_RSN_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Interaction Statuses used in Oracle Retail Data Model.
Default Hierarchy: HINTRACNSTAT
Table 8-36 Interaction Status Hierarchy (HINTRACNSTAT)
| Level | Description | Interaction Status Hierarchy (HINTRACNSTAT) |
|---|---|---|
|
TINTRACNSTAT |
Total Interaction Status |
TINTRACNSTAT |
|
INTRACNSTAT |
Interaction Status |
INTRACNSTAT |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-37 Interaction Status Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TINTRACNSTAT |
'Total Interaction Status' |
|
INTRACNSTAT |
DWL_INTRACN_STAT.INTRACN_STAT_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Interaction Types used in Oracle Retail Data Model.
Default Hierarchy: HINTRACNTYP
Table 8-39 Interaction Type Hierarchy (HINTRACNTYP)
| Level | Description | Interaction Type Hierarchy (HINTRACNTYP) |
|---|---|---|
|
TINTRACNTYP |
Total Interaction Type |
TINTRACNTYP |
|
INTRACNTYP |
Interaction Type |
INTRACNTYP |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-40 Interaction Type Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TINTRACNTYP |
'Total Interaction Type' |
|
INTRACNTYP |
DWL_INTRACN_TYP.INTRACN_TYP_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Inventory Locations used in Oracle Retail Data Model.
Default Hierarchy: HINVLOC
Table 8-42 Inventory Location Hierarchy (HINVLOC)
| Level | Description | Inventory Location Hierarchy (HINVLOC) |
|---|---|---|
|
TINVLOC |
Total Inventory Location |
TINVLOC |
|
INVLOCTYP |
Inventory Location Type |
INVLOCTYP |
|
INVLOC |
Inventory Location |
INVLOC |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-43 Inventory Location Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TINVLOC |
'Total Inventory Location' |
|
INVLOCTYP |
DWL_INV_LOC_TYP.INV_LOC_TYP_NAME |
|
INVLOC |
DWR_INV_LOC.LOC_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Liability Types used in Oracle Retail Data Model.
Default Hierarchy: HLIABTYP
Table 8-45 Liability Type Hierarchy (HLIABTYP)
| Level | Description | Liability Type Hierarchy (HLIABTYP) |
|---|---|---|
|
TLIABTYP |
Total Liability Type |
TLIABTYP |
|
LIABTYP |
Liability Type |
LIABTYP |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-46 Liability Type Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TLIABTYP |
'Total Liability Type' |
|
LIABTYP |
DWL_LIAB_TYP.LIAB_TYP_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Order Types used in Oracle Retail Data Model.
Default Hierarchy: HORDRTYP
Table 8-48 Order Type (HORDRTYP)
| Level | Description | Order Type Hierarchy (HORDRTYP) |
|---|---|---|
|
TORDRTYP |
Total Lia Order Type |
TORDRTYP |
|
ORDRTYP |
Order Type |
ORDRTYP |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-49 Order Type Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORDRTYP |
'Total Order Type' |
|
ORDRTYP |
DWL_ORDR_TYP.ORDR_TYP_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Organizational data used in Oracle Retail Data Model.
Default Hierarchy: HORG
Table 8-51 Organization Levels and Hierarchy
| Level | Description | Organization Hierarchy (HORG) | Organization Division Hierarchy (HDIVISION) | Organization Banner Hierarchy (HBANNER) |
|---|---|---|---|---|
|
TORG |
Total Organization |
TORG |
TORG |
TORG |
|
BANNER |
Banner |
BANNER |
||
|
DIVISION |
Division |
DIVISION |
||
|
COMPANY |
Company |
COMPANY |
||
|
CHAIN |
Chain |
CHAIN |
||
|
AREA |
Area |
AREA |
||
|
REGION |
Region |
REGION |
||
|
DISTRICT |
District |
DISTRICT |
||
|
STORE |
Store |
STORE |
STORE |
STORE |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-52 Organization Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
'Total Organization' |
|
BANNER |
DWR_ORG_BNR.BNR_NAME |
|
DIVISION |
DWR_ORG_DIV.DIV_NAME |
|
COMPANY |
DWR_ORG_CMPNY.CMPNY_NAME |
|
CHAIN |
DWR_ORG_CHAIN.CHAIN_NAME |
|
AREA |
DWR_ORG_AREA.AREA_NAME |
|
REGION |
DWR_ORG_RGN.RGN_NAME |
|
DISTRICT |
DWR_ORG_DSTRCT.DSTRCT_NAME |
|
STORE |
DWR_ORG_BSNS_UNIT.LNG_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-53 Organization Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
'Total Organization' |
|
BANNER |
DWR_ORG_BNR.BNR_CD |
|
DIVISION |
DWR_ORG_DIV.DIV_CD |
|
COMPANY |
DWR_ORG_CMPNY.CMPNY_CD |
|
CHAIN |
DWR_ORG_CHAIN.CHAIN_CD |
|
AREA |
DWR_ORG_AREA.AREA_CD |
|
REGION |
DWR_ORG_RGN.RGN_CD |
|
DISTRICT |
DWR_ORG_DSTRCT.DSTRCT_CD |
|
STORE |
DWR_ORG_BSNS_UNIT.SHORT_DESC |
Attribute Name: Business Unit Code (BSNS_UNIT_CD)
Table 8-54 Organization Business Unit Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.BSNS_UNIT_CD |
Attribute Name: Business Unit Type Code (BSNS_UNIT_TYP_CD)
Table 8-55 Organization Business Unit Type Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.BSNS_UNIT_TYP_CD |
Attribute Name: Store Close Date (STORE_CLOSE_DT)
Table 8-56 Organization Store Close Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_CLS_DT |
Attribute Name: Store Description (STORE_DESC)
Table 8-57 Organization Store Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_NAME |
Attribute Name: Store Manager (STORE_MANAGER)
Table 8-58 Organization Store Manager Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_MGR |
Attribute Name: Store Name (STORE_NAME)
Table 8-59 Organization Store Name Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_NAME |
Attribute Name: Store Open Date (STORE_OPEN_DT)
Table 8-60 Organization Store Open Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_OPEN_DT |
Attribute Name: Store Price Index (STORE_PRICE_INDEX)
Table 8-61 Organization Store Price Index Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_PRICE_INDX |
Attribute Name: Store Receiving Code (STORE_RCV_CD)
Table 8-62 Organization Store Receiving Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
BANNER |
|
|
DIVISION |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_RCVNG_CD |
Attribute Name: Store Type (STORE_TYPE)
This dimension stores the Organizational data along Organization Hierarchy used in Oracle Retail Data Model.
Default Hierarchy: HORG
Table 8-64 Organization Hierarchy (HORG)
| Level | Description | Organization Hierarchy (HORG) |
|---|---|---|
|
TORG |
Total Organization |
TORG |
|
COMPANY |
Company |
COMPANY |
|
CHAIN |
Chain |
CHAIN |
|
AREA |
Area |
AREA |
|
REGION |
Region |
REGION |
|
DISTRICT |
District |
DISTRICT |
|
STORE |
Store |
STORE |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-65 Organization QR Dimension Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
'Total Organization' |
|
COMPANY |
DWR_ORG_CMPNY.CMPNY_NAME |
|
CHAIN |
DWR_ORG_CHAIN.CHAIN_NAME |
|
AREA |
DWR_ORG_AREA.AREA_NAME |
|
REGION |
DWR_ORG_RGN.RGN_NAME |
|
DISTRICT |
DWR_ORG_DSTRCT.DSTRCT_NAME |
|
STORE |
DWR_ORG_BSNS_UNIT.LNG_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-66 Organization Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
'Total Organization' |
|
COMPANY |
DWR_ORG_CMPNY.CMPNY_CD |
|
CHAIN |
DWR_ORG_CHAIN.CHAIN_CD |
|
AREA |
DWR_ORG_AREA.AREA_CD |
|
REGION |
DWR_ORG_RGN.RGN_CD |
|
DISTRICT |
DWR_ORG_DSTRCT.DSTRCT_CD |
|
STORE |
DWR_ORG_BSNS_UNIT.SHORT_DESC |
Attribute Name: Business Unit Code (BSNS_UNIT_CD)
Table 8-67 Organization QR Dimension Business Unit Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.BSNS_UNIT_CD |
Attribute Name: Business Unit Type Code (BSNS_UNIT_TYP_CD)
Table 8-68 Organization QR Dimension Business Unit Type Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.BSNS_UNIT_TYP_CD |
Attribute Name: Store Close Date (STORE_CLOSE_DT)
Table 8-69 Organization QR Dimension Store Close Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_CLS_DT |
Attribute Name: Store Description (STORE_DESC)
Table 8-70 Organization QR Dimension Store Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_NAME |
Attribute Name: Store Manager (STORE_MANAGER)
Table 8-71 Organization QR Dimension Store Manager Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_MGR |
Attribute Name: Store Name (STORE_NAME)
Table 8-72 Organization QR Dimension Store Name Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_NAME |
Attribute Name: Store Open Date (STORE_OPEN_DT)
Table 8-73 Organization QR Dimension Store Open Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_OPEN_DT |
Attribute Name: Store Price Index (STORE_PRICE_INDEX)
Table 8-74 Organization QR Dimension Store Price Index Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_PRICE_INDX |
Attribute Name: Store Receiving Code (STORE_RCV_CD)
Table 8-75 Organization QR Dimension Store Receiving Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TORG |
|
|
COMPANY |
|
|
CHAIN |
|
|
AREA |
|
|
REGION |
|
|
DISTRICT |
|
|
STORE |
DWR_ORG_BSNS_UNIT.STORE_RCVNG_CD |
Attribute Name: Store Type (STORE_TYPE)
This dimension stores the Pay Types used in Oracle Retail Data Model.
Default Hierarchy: HPAYTYPE
Table 8-77 Pay Type Hierarchy (HPAYTYPE)
| Level | Description | Pay Type Hierarchy (HPAYTYPE) |
|---|---|---|
|
TPAYTYPE |
Total Pay Type |
TPAYTYPE |
|
PAYTYPE |
Pay Type |
PAYTYPE |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-78 Pay Type Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPAYTYPE |
'Total Pay Type' |
|
PAYTYPE |
DWL_PAY_TYP.PAY_TYP_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Post Codes used in Oracle Retail Data Model.
Default Hierarchy: HPOSTCD
Table 8-80 Post Code Hierarchy (HPOSTCD)
| Level | Description | Post Code Hierarchy (HPOSTCD) |
|---|---|---|
|
TPOSTCD |
Total Post Code |
TPOSTCD |
|
POSTCD |
Post Code |
POSTCD |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-81 Post Code Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPOSTCD |
'Total Postcode' |
|
POSTCD |
DWR_POSTCD.POSTCD_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Products along Product Hierarchy used in Oracle Retail Data Model.
Default Hierarchy: HPROD
Table 8-83 Product Hierarchy (HPROD)
| Level | Description | Product Hierarchy (HPROD) |
|---|---|---|
|
TPROD |
Total Product |
TPROD |
|
COMPANY |
Company |
COMPANY |
|
DIVISION |
Division |
DIVISION |
|
GROUPFoot 1 |
Group |
GROUP |
|
DEPT |
Department |
DEPT |
|
CLASS |
Class |
CLASS |
|
SUBCLASS |
Sub Class |
SUBCLASS |
|
ITEM |
Item |
ITEM |
|
SKU |
SKU Item |
SKU |
Footnote 1 For Oracle Retail Data Model for OLAP 11g, this level is named GROUP. However, since GROUP is a restricted keyword for Oracle OLAP 11g metadata, in Oracle Retail Data Model for OLAP 11g, this level has been renamed to GROUP1. The Level Description continues to be Group in both versions
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-84 Product QR Dimension Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
'Total Product' |
|
COMPANY |
DWR_ITEM_CMPNY.ITEM_CMPNY_NAME |
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_NAME |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_NAME |
|
DEPT |
DWR_ITEM_DEPT.ITEM_DEPT_NAME |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_NAME |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_NAME |
|
ITEM |
DWR_ITEM.ITEM_DESC |
|
SKU |
DWR_SKU_ITEM.SKU_ITEM_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-85 Product QR Dimension Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
'Total Product' |
|
COMPANY |
DWR_ITEM_CMPNY.ITEM_CMPNY_CD |
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_CD |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_CD |
|
DEPT |
DWR_ITEM_DEPT.ITEM_DEPT_CD |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_CD |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_CD |
|
ITEM |
DWR_ITEM.ITEM_NAME |
|
SKU |
DWR_SKU_ITEM.SKU_ITEM_NAME |
Attribute Name: Buyer Code (BUYER_CODE)
Table 8-86 Product QR Dimension Buyer Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
COMPANY |
|
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_BYR_CD |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_BYR_CD |
|
DEPT |
DWR_ITEM_DEPT.ITEM_DEPT_BYR_CD |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_BYR_CD |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_BYR_CD |
|
ITEM |
|
|
SKU |
Attribute Name: Buyer Name (BUYER_NAME)
Table 8-87 Product QR Dimension Buyer Name Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
COMPANY |
|
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_BYR_NAME |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_BYR_NAME |
|
DEPT |
DWR_ITEM_DEPT.ITEM_DEPT_BYR_NAME |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_BYR_NAME |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_BYR_NAME |
|
ITEM |
|
|
SKU |
Attribute Name: Item Conv Type Code (ITEM_CONV_TYPE_CD)
Table 8-88 Product QR Dimension Item Conv Type Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
COMPANY |
|
|
DIVISION |
|
|
GROUP |
|
|
DEPT |
|
|
CLASS |
|
|
SUBCLASS |
|
|
ITEM |
DWR_ITEM.CONVBL_TYP_CD |
|
SKU |
Attribute Name: Item Discount Indicator (ITEM_DISC_IND)
Table 8-89 Product QR Dimension Item Discount Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
COMPANY |
|
|
DIVISION |
|
|
GROUP |
|
|
DEPT |
|
|
CLASS |
|
|
SUBCLASS |
|
|
ITEM |
DWR_ITEM.DISC_IND |
|
SKU |
Attribute Name: Item Display Unit Type Code (ITEM_DISP_UNIT_TYP_CD)
Table 8-90 Product QR Dimension Item Display Unit Type Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
COMPANY |
|
|
DIVISION |
|
|
GROUP |
|
|
DEPT |
|
|
CLASS |
|
|
SUBCLASS |
|
|
ITEM |
DWR_ITEM.DSPLY_UNIT_TYP_CD |
|
SKU |
Attribute Name: Item Number (ITEM_NBR)
Table 8-91 Product QR Dimension Item Number Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
COMPANY |
|
|
DIVISION |
|
|
GROUP |
|
|
DEPT |
|
|
CLASS |
|
|
SUBCLASS |
|
|
ITEM |
DWR_ITEM.ITEM_NBR |
|
SKU |
Attribute Name: Merchandiser Code (MERC_CODE)
Table 8-92 Product QR Dimension Merchandiser Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
COMPANY |
|
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_CD |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_CD |
|
DEPT |
DWR_ITEM_DEPT.DEPT_MRCHNDSR_CD |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_CD |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_MRCHNDSR_CD |
|
ITEM |
|
|
SKU |
Attribute Name: Merchandiser Name (MERC_NAME)
Table 8-93 Product QR Dimension Merchandiser Name Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
COMPANY |
|
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_NAME |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_NAME |
|
DEPT |
DWR_ITEM_DEPT.DEPT_MRCHNDSR_NAME |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_NAME |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_MRCHNDSR_NAME |
|
ITEM |
|
|
SKU |
Attribute Name: SKU Item Number (SKU_ITEM_NBR)
This dimension stores the Products used in Oracle Retail Data Model.
Default Hierarchy: HPROD
Table 8-95 Product Hierarchy and Cluster Hierarchy
| Level | Description | Product Hierarchy (HPROD) | Product Cluster Hierarchy (HPCLUSTER) |
|---|---|---|---|
|
TPROD |
Total Product |
TPROD |
TPROD |
|
PCLUSTER |
Product Cluster |
PCLUSTER |
|
|
COMPANY |
Company |
COMPANY |
|
|
DIVISION |
Division |
DIVISION |
|
|
GROUPFoot 1 |
Group |
GROUP |
|
|
DEPT |
Department |
DEPT |
|
|
CLASS |
Class |
CLASS |
|
|
SUBCLASS |
Sub Class |
SUBCLASS |
|
|
ITEM |
Item |
ITEM |
ITEM |
|
SKU |
SKU Item |
SKU |
SKU |
Footnote 1 For Oracle Retail Data Model for OLAP 11g, this level is named GROUP. However, since GROUP is a restricted keyword for Oracle OLAP 11g metadata, in Oracle Retail Data Model for OLAP 11g, this level has been renamed to GROUP1. The Level Description continues to be Group in both versions.
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-96 Product Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
'Total Product' |
|
PCLUSTER |
DWR_ITEM_CLSTR.ITEM_CLSTR_DESC |
|
COMPANY |
DWR_ITEM_CMPNY.ITEM_CMPNY_NAME |
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_NAME |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_NAME |
|
DEPT |
DWR_ITEM_DEPT.ITEM_DEPT_NAME |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_NAME |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_NAME |
|
ITEM |
DWR_ITEM.ITEM_DESC |
|
SKU |
DWR_SKU_ITEM.SKU_ITEM_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-97 Product Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
'Total Product' |
|
PCLUSTER |
DWR_ITEM_CLSTR.ITEM_CLSTR_CD |
|
COMPANY |
DWR_ITEM_CMPNY.ITEM_CMPNY_CD |
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_CD |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_CD |
|
DEPT |
DWR_ITEM_DEPT.ITEM_DEPT_CD |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_CD |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_CD |
|
ITEM |
DWR_ITEM.ITEM_NAME |
|
SKU |
DWR_SKU_ITEM.SKU_ITEM_NAME |
Attribute Name: Buyer Code (BUYER_CODE)
Table 8-98 Product Buyer Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
PCLUSTER |
|
|
COMPANY |
|
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_BYR_CD |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_BYR_CD |
|
DEPT |
DWR_ITEM_DEPT.ITEM_DEPT_BYR_CD |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_BYR_CD |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_BYR_CD |
|
ITEM |
|
|
SKU |
Attribute Name: Buyer Name (BUYER_NAME)
Table 8-99 Product Buyer Name Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
PCLUSTER |
|
|
COMPANY |
|
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_BYR_NAME |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_BYR_NAME |
|
DEPT |
DWR_ITEM_DEPT.ITEM_DEPT_BYR_NAME |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_BYR_NAME |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_BYR_NAME |
|
ITEM |
|
|
SKU |
Attribute Name: Item Conv Type Code (ITEM_CONV_TYPE_CD)
Table 8-100 Product Item Conv Type Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
PCLUSTER |
|
|
COMPANY |
|
|
DIVISION |
|
|
GROUP |
|
|
DEPT |
|
|
CLASS |
|
|
SUBCLASS |
|
|
ITEM |
DWR_ITEM.CONVBL_TYP_CD |
|
SKU |
Attribute Name: Item Discount Indicator (ITEM_DISC_IND)
Table 8-101 Product Item Discount Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
PCLUSTER |
|
|
COMPANY |
|
|
DIVISION |
|
|
GROUP |
|
|
DEPT |
|
|
CLASS |
|
|
SUBCLASS |
|
|
ITEM |
DWR_ITEM.DISC_IND |
|
SKU |
Attribute Name: Item Display Unit Type Code (ITEM_DISP_UNIT_TYP_CD)
Table 8-102 Product Item Display Unit Type Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
PCLUSTER |
|
|
COMPANY |
|
|
DIVISION |
|
|
GROUP |
|
|
DEPT |
|
|
CLASS |
|
|
SUBCLASS |
|
|
ITEM |
DWR_ITEM.DSPLY_UNIT_TYP_CD |
|
SKU |
Attribute Name: Item Number (ITEM_NBR)
Table 8-103 Product Item Number Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
PCLUSTER |
|
|
COMPANY |
|
|
DIVISION |
|
|
GROUP |
|
|
DEPT |
|
|
CLASS |
|
|
SUBCLASS |
|
|
ITEM |
DWR_ITEM.ITEM_NBR |
|
SKU |
Attribute Name: Merchandiser Code (MERC_CODE)
Table 8-104 Product Merchandiser Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
PCLUSTER |
|
|
COMPANY |
|
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_CD |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_CD |
|
DEPT |
DWR_ITEM_DEPT.DEPT_MRCHNDSR_CD |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_CD |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_MRCHNDSR_CD |
|
ITEM |
|
|
SKU |
Attribute Name: Merchandiser Name (MERC_NAME)
Table 8-105 Product Merchandiser Name Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TPROD |
|
|
PCLUSTER |
|
|
COMPANY |
|
|
DIVISION |
DWR_ITEM_DIV.ITEM_DIV_MRCHNDSR_NAME |
|
GROUP |
DWR_ITEM_GRP.ITEM_GRP_MRCHNDSR_NAME |
|
DEPT |
DWR_ITEM_DEPT.DEPT_MRCHNDSR_NAME |
|
CLASS |
DWR_ITEM_CLASS.ITEM_CLASS_MRCHNDSR_NAME |
|
SUBCLASS |
DWR_ITEM_SBC.SBC_MRCHNDSR_NAME |
|
ITEM |
|
|
SKU |
Attribute Name: SKU Item Number (SKU_ITEM_NBR)
This dimension stores the Reason Codes used in Oracle Retail Data Model.
Default Hierarchy: HREASON
Table 8-107 Reason Hierarchy (HREASON)
| Level | Description | Reason Hierarchy (HREASON) |
|---|---|---|
|
TREASON |
Total Reason |
TREASON |
|
REASON |
Reason |
REASON |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-108 Reason Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TREASON |
'Total Reason' |
|
REASON |
DWL_RSN.RSN_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Recency, Frequency, Monetary and Profitability (RFMP) Codes used in Oracle Retail Data Model.
Default Hierarchy: HRFMP
Table 8-110 RFMP Hierarchy (HRFMP)
| Level | Description | RFMP Hierarchy (HRFMP) |
|---|---|---|
|
TRFMP |
Total RFMP |
TRFMP |
|
RFMPGRP |
RFMP Group |
RFMPGRP |
|
DRFMP |
RFMP Detail |
DRFMP |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-111 RFMP Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
'Total RFMP' |
|
RFMPGRP |
DWL_RFMP_MTHD.RFMP_GRP_DESC |
|
DRFMP |
DWL_RFMP_MTHD.RFMP_MTHD_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-112 RFMP Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
'Total RFMP' |
|
RFMPGRP |
DWL_RFMP_MTHD.RFMP_GRP |
|
DRFMP |
DWL_RFMP_MTHD.RFMP_MTHD_CD |
Attribute Name: Frequency Segment Method Code (FSM_CD)
Table 8-113 RFMP Frequency Segment Method Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
|
|
RFMPGRP |
|
|
DRFMP |
DWL_RFMP_MTHD.FREQNCY_SGMNT_MTHD_CD |
Attribute Name: Monetary Segment Method Code (MSM_CD)
Table 8-114 RFMP Monetary Segment Method Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
|
|
RFMPGRP |
|
|
DRFMP |
DWL_RFMP_MTHD.MNTRY_SGMNT_MTHD_CD |
Attribute Name: Profitability Segment Method Code (PSM_CD)
Table 8-115 RFMP Profitability Segment Method Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
|
|
DRFMP |
DWL_RFMP_MTHD.PROFBLTY_SGMNT_MTHD_CD |
|
RFMPGRP |
Attribute Name: Recency Segment Method Code (RSM_CD)
Table 8-116 RFMP Recency Segment Method Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
|
|
RFMPGRP |
|
|
DRFMP |
DWL_RFMP_MTHD.RECENCY_SGMNT_MTHD_CD |
Attribute Name: RFMP Method Code (RFMP_MTHD_CD)
Table 8-117 RFMP RFMP Method Code Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
|
|
RFMPGRP |
|
|
DRFMP |
DWL_RFMP_MTHD.RFMP_MTHD_CD |
Attribute Name: RFMP Order (RFMP_ORDR)
Table 8-118 RFMP RFMP Order Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
|
|
RFMPGRP |
|
|
DRFMP |
DWL_RFMP_MTHD.RFMP_ORDR |
Attribute Name: RFMP Score (RFMP_SCR)
Table 8-119 RFMP RFMP Score Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
|
|
RFMPGRP |
|
|
DRFMP |
DWL_RFMP_MTHD.RFMP_SCR |
Attribute Name: RFMP Score Description (RFMP_SCR_DESC)
Table 8-120 RFMP RFMP Score Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRFMP |
|
|
RFMPGRP |
|
|
DRFMP |
DWL_RFMP_MTHD.RFMP_SCR_DESC |
Attribute Name: RFMP Value (RFMP_VAL)
This dimension stores the Request Origin Codes used in Oracle Retail Data Model.
Default Hierarchy: HRQSTORIGIN
Table 8-122 Request Origin Hierarchy (HRQSTORIGIN)
| Level | Description | Request Origin Hierarchy (HRQSTORIGIN) |
|---|---|---|
|
TRQSTORIGIN |
Total Request Origin |
TRQSTORIGIN |
|
RQSTORIGIN |
Request Origin |
RQSTORIGIN |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-123 Request Origin Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TRQSTORIGIN |
'Total Request Origin ' |
|
RQSTORIGIN |
DWL_RQST_ORIGIN.RQST_ORIGIN_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores Time related data used in Oracle Retail Data Model.
Default Hierarchy: HTBSNS
Table 8-125 Time Levels and Hierarchies
| Level | Description | Time Business Hierarchy (HTBSNS) | Time Calendar Hierarchy (HTCLNDR) | Time Calendar Week Hierarchy (HTCLNDRWK) |
|---|---|---|---|---|
|
TTIME |
Total Time |
TTIME |
TTIME |
TTIME |
|
CLNDR_YR |
Calendar Year |
CLNDR_YR |
||
|
CLNDR_HLF_YR |
Calendar Half Year |
CLNDR_HLF_YR |
||
|
CLNDR_QTR |
Calendar Quarter |
CLNDR_QTR |
||
|
CLNDR_MO |
Calendar Month |
CLNDR_MO |
||
|
CLNDR_HLF_MO |
Calendar Half Month |
CLNDR_HLF_MO |
||
|
CLNDR_WK |
Calendar Week |
CLNDR_WK |
CLNDR_WK |
|
|
BSNS_YR |
Business Year |
BSNS_YR |
||
|
BSNS_HLF_YR |
Business Half Year |
BSNS_HLF_YR |
||
|
BSNS_QTR |
Business Quarter |
BSNS_QTR |
||
|
BSNS_MO |
Business Month |
BSNS_MO |
||
|
BSNS_HLF_MO |
Business Half Month |
BSNS_HLF_MO |
||
|
BSNS_WK |
Business Week |
BSNS_WK |
||
|
DAY |
Day |
DAY |
DAY |
DAY |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-126 Time Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.TOT_DESC |
|
CLNDR_YR |
DWR_CLNDR_YR.YR_DESC |
|
CLNDR_HLF_YR |
DWR_CLNDR_HLF_YR.HLF_YR_DESC |
|
CLNDR_QTR |
DWR_CLNDR_QTR.QTR_DESC |
|
CLNDR_MO |
DWR_CLNDR_MO.MO_DESC |
|
CLNDR_HLF_MO |
DWR_CLNDR_HLF_MO.HLF_MO_DESC |
|
CLNDR_WK |
DWR_CLNDR_WK.WK_DESC |
|
BSNS_YR |
DWR_BSNS_YR.YR_DESC |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_DESC |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_DESC |
|
BSNS_MO |
DWR_BSNS_MO.MO_DESC |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_DESC |
|
BSNS_WK |
DWR_BSNS_WK.WK_DESC |
|
DAY |
DWR_DAY.BSNS_DT_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-127 Time Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.TOT_CD |
|
CLNDR_YR |
DWR_CLNDR_YR.YR_CD |
|
CLNDR_HLF_YR |
DWR_CLNDR_HLF_YR.HLF_YR_CD |
|
CLNDR_QTR |
DWR_CLNDR_QTR.QTR_CD |
|
CLNDR_MO |
DWR_CLNDR_MO.MO_CD |
|
CLNDR_HLF_MO |
DWR_CLNDR_HLF_MO.HLF_MO_CD |
|
CLNDR_WK |
DWR_CLNDR_WK.WK_CD |
|
BSNS_YR |
DWR_BSNS_YR.YR_CD |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_CD |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_CD |
|
BSNS_MO |
DWR_BSNS_MO.MO_CD |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_CD |
|
BSNS_WK |
DWR_BSNS_WK.WK_CD |
|
DAY |
DWR_DAY.BSNS_DT_DESC |
Attribute Name: End Date (END_DATE)
Table 8-128 Time End Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.END_DATE |
|
CLNDR_YR |
DWR_CLNDR_YR.YR_END_DT |
|
CLNDR_HLF_YR |
DWR_CLNDR_HLF_YR.HLF_YR_END_DT |
|
CLNDR_QTR |
DWR_CLNDR_QTR.QTR_END_DT |
|
CLNDR_MO |
DWR_CLNDR_MO.MO_END_DT |
|
CLNDR_HLF_MO |
DWR_CLNDR_HLF_MO.HLF_MO_END_DT |
|
CLNDR_WK |
DWR_CLNDR_WK.WK_END_DT |
|
BSNS_YR |
DWR_BSNS_YR.YR_END_DT |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_END_DT |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_END_DT |
|
BSNS_MO |
DWR_BSNS_MO.MO_END_DT |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_END_DT |
|
BSNS_WK |
DWR_BSNS_WK.WK_END_DT |
|
DAY |
DWR_DAY.BSNS_END_DT |
Attribute Name: Time Span (TIME_SPAN)
Table 8-129 Time Time Span Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.TOT_TIME_SPAN |
|
CLNDR_YR |
DWR_CLNDR_YR.YR_TIMESPN |
|
CLNDR_HLF_YR |
DWR_CLNDR_HLF_YR.HLF_YR_TIMESPN |
|
CLNDR_QTR |
DWR_CLNDR_QTR.QTR_TIMESPN |
|
CLNDR_MO |
DWR_CLNDR_MO.MO_TIMESPN |
|
CLNDR_HLF_MO |
DWR_CLNDR_HLF_MO.HLF_MO_TIMESPN |
|
CLNDR_WK |
DWR_CLNDR_WK.WK_TIMESPN |
|
BSNS_YR |
DWR_BSNS_YR.YR_TIMESPN |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_TIMESPN |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_TIMESPN |
|
BSNS_MO |
DWR_BSNS_MO.MO_TIMESPN |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_TIMESPN |
|
BSNS_WK |
DWR_BSNS_WK.WK_TIMESPN |
|
DAY |
DWR_DAY.BSNS_DAY_TIMESPAN |
Attribute Name: Business Holiday Indicator (BSNS_HLDY_IND)
Table 8-130 Time Business Holiday Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
CLNDR_YR |
|
|
CLNDR_HLF_YR |
|
|
CLNDR_QTR |
|
|
CLNDR_MO |
|
|
CLNDR_HLF_MO |
|
|
CLNDR_WK |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.BSNS_HOLIDY_IND |
Attribute Name: Business Weekend Indicator (BSNS_WEND_IND)
Table 8-131 Time Business Weekend Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
CLNDR_YR |
|
|
CLNDR_HLF_YR |
|
|
CLNDR_QTR |
|
|
CLNDR_MO |
|
|
CLNDR_HLF_MO |
|
|
CLNDR_WK |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.BSNS_WEEKEND_IND |
Attribute Name: Business Working Day Indicator (BSNS_WRK_IND)
Table 8-132 Time Business Working Day Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
CLNDR_YR |
|
|
CLNDR_HLF_YR |
|
|
CLNDR_QTR |
|
|
CLNDR_MO |
|
|
CLNDR_HLF_MO |
|
|
CLNDR_WK |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.BSNS_WRKING_DAY_IND |
Attribute Name: Number (NBR)
Table 8-133 Time Number Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
CLNDR_YR |
TO_NUMBER(DWR_CLNDR_YR.YR_NBR) |
|
CLNDR_HLF_YR |
TO_NUMBER(DWR_CLNDR_HLF_YR.HLF_YR_NBR) |
|
CLNDR_QTR |
TO_NUMBER(DWR_CLNDR_QTR.QTR_NBR) |
|
CLNDR_MO |
TO_NUMBER(DWR_CLNDR_MO.MO_NBR) |
|
CLNDR_HLF_MO |
TO_NUMBER(DWR_CLNDR_HLF_MO.HLF_MO_NBR) |
|
CLNDR_WK |
TO_NUMBER(DWR_CLNDR_WK.WK_NBR) |
|
BSNS_YR |
TO_NUMBER(DWR_BSNS_YR.YR_NBR) |
|
BSNS_HLF_YR |
TO_NUMBER(DWR_BSNS_HLF_YR.HLF_YR_NBR) |
|
BSNS_QTR |
TO_NUMBER(DWR_BSNS_QTR.QTR_NBR) |
|
BSNS_MO |
TO_NUMBER(DWR_BSNS_MO.MO_NBR) |
|
BSNS_HLF_MO |
TO_NUMBER(DWR_BSNS_HLF_MO.HLF_MO_NBR) |
|
BSNS_WK |
TO_NUMBER(DWR_BSNS_WK.WK_NBR) |
|
DAY |
TO_NUMBER(DWR_DAY.BSNS_DAY_OF_YR) |
Attribute Name: Calendar Holiday Indicator (CLNDR_HLDY_IND)
Table 8-134 Time Calendar Holiday Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
CLNDR_YR |
|
|
CLNDR_HLF_YR |
|
|
CLNDR_QTR |
|
|
CLNDR_MO |
|
|
CLNDR_HLF_MO |
|
|
CLNDR_WK |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.CLNDR_HOLIDY_IND |
Attribute Name: Calendar Weekend Indicator (CLNDR_WEND_IND)
Table 8-135 Time Calendar Weekend Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
CLNDR_YR |
|
|
CLNDR_HLF_YR |
|
|
CLNDR_QTR |
|
|
CLNDR_MO |
|
|
CLNDR_HLF_MO |
|
|
CLNDR_WK |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.CLNDR_WEEKEND_IND |
Attribute Name: Calendar Working Day Indicator (CLNDR_WRK_IND)
Table 8-136 Time Calendar Working Day Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
CLNDR_YR |
|
|
CLNDR_HLF_YR |
|
|
CLNDR_QTR |
|
|
CLNDR_MO |
|
|
CLNDR_HLF_MO |
|
|
CLNDR_WK |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.CLNDR_WRKING_DAY_IND |
Attribute Name: Identifier (ID)
Table 8-137 Time Identifier Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.TOT_KEY |
|
CLNDR_YR |
DWR_CLNDR_YR.CLNDR_YR_KEY |
|
CLNDR_HLF_YR |
DWR_CLNDR_HLF_YR.CLNDR_HLF_YR_KEY |
|
CLNDR_QTR |
DWR_CLNDR_QTR.CLNDR_QTR_KEY |
|
CLNDR_MO |
DWR_CLNDR_MO.CLNDR_MO_KEY |
|
CLNDR_HLF_MO |
DWR_CLNDR_HLF_MO.CLNDR_HLF_MO_KEY |
|
CLNDR_WK |
DWR_CLNDR_WK.CLNDR_WK_KEY |
|
BSNS_YR |
DWR_BSNS_YR.BSNS_YR_KEY |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_KEY |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_KEY |
|
BSNS_MO |
DWR_BSNS_MO.MO_KEY |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_KEY |
|
BSNS_WK |
DWR_BSNS_WK.WK_KEY |
|
DAY |
DWR_DAY.DAY_KEY |
Attribute Name: Start Date (START_DATE)
Table 8-138 Time Start Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
CLNDR_YR |
DWR_CLNDR_YR.YR_STRT_DT |
|
CLNDR_HLF_YR |
DWR_CLNDR_HLF_YR.HLF_YR_STRT_DT |
|
CLNDR_QTR |
DWR_CLNDR_QTR.QTR_STRT_DT |
|
CLNDR_MO |
DWR_CLNDR_MO.MO_STRT_DT |
|
CLNDR_HLF_MO |
DWR_CLNDR_HLF_MO.HLF_MO_STRT_DT |
|
CLNDR_WK |
DWR_CLNDR_WK.WK_STRT_DT |
|
BSNS_YR |
DWR_BSNS_YR.YR_STRT_DT |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_STRT_DT |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_STRT_DT |
|
BSNS_MO |
DWR_BSNS_MO.MO_STRT_DT |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_STRT_DT |
|
BSNS_WK |
DWR_BSNS_WK.WK_STRT_DT |
|
DAY |
DWR_DAY.BSNS_STRT_DT |
This dimension stores the Time Business Hierarchy related data used in Oracle Retail Data Model.
Default Hierarchy: HTBSNS
Table 8-139 Time Business Hierarchy (HTBSNS)
| Level | Description | Time Business Hierarchy (HTBSNS) |
|---|---|---|
|
TTIME |
Total Time |
TTIME |
|
BSNS_YR |
Business Year |
BSNS_YR |
|
BSNS_HLF_YR |
Business Half Year |
BSNS_HLF_YR |
|
BSNS_QTR |
Business Quarter |
BSNS_QTR |
|
BSNS_MO |
Business Month |
BSNS_MO |
|
BSNS_HLF_MO |
Business Half Month |
BSNS_HLF_MO |
|
BSNS_WK |
Business Week |
BSNS_WK |
|
DAY |
Day |
DAY |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-140 Time QR Dimension Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.TOT_DESC |
|
BSNS_YR |
DWR_BSNS_YR.YR_DESC |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_DESC |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_DESC |
|
BSNS_MO |
DWR_BSNS_MO.MO_DESC |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_DESC |
|
BSNS_WK |
DWR_BSNS_WK.WK_DESC |
|
DAY |
DWR_DAY.BSNS_DT_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
Table 8-141 Time QR Dimension Short Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.TOT_CD |
|
BSNS_YR |
DWR_BSNS_YR.YR_CD |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_CD |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_CD |
|
BSNS_MO |
DWR_BSNS_MO.MO_CD |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_CD |
|
BSNS_WK |
DWR_BSNS_WK.WK_CD |
|
DAY |
DWR_DAY.BSNS_DT_DESC |
Attribute Name: End Date (END_DATE)
Table 8-142 Time QR Dimension End Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.END_DATE |
|
BSNS_YR |
DWR_BSNS_YR.YR_END_DT |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_END_DT |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_END_DT |
|
BSNS_MO |
DWR_BSNS_MO.MO_END_DT |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_END_DT |
|
BSNS_WK |
DWR_BSNS_WK.WK_END_DT |
|
DAY |
DWR_DAY.BSNS_END_DT |
Attribute Name: Time Span (TIME_SPAN)
Table 8-143 Time QR Dimension Time Span Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.TOT_TIME_SPAN |
|
BSNS_YR |
DWR_BSNS_YR.YR_TIMESPN |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_TIMESPN |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_TIMESPN |
|
BSNS_MO |
DWR_BSNS_MO.MO_TIMESPN |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_TIMESPN |
|
BSNS_WK |
DWR_BSNS_WK.WK_TIMESPN |
|
DAY |
DWR_DAY.BSNS_DAY_TIMESPAN |
Attribute Name: Business Holiday Indicator (BSNS_HLDY_IND)
Table 8-144 Time QR Dimension Business Holiday Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.BSNS_HOLIDY_IND |
Attribute Name: Business Weekend Indicator (BSNS_WEND_IND)
Table 8-145 Time QR Dimension Business Weekend Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.BSNS_WEEKEND_IND |
Attribute Name: Business Working Day Indicator (BSNS_WRK_IND)
Table 8-146 Time QR Dimension Business Working Day Indicator Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
BSNS_YR |
|
|
BSNS_HLF_YR |
|
|
BSNS_QTR |
|
|
BSNS_MO |
|
|
BSNS_HLF_MO |
|
|
BSNS_WK |
|
|
DAY |
DWR_DAY.BSNS_WRKING_DAY_IND |
Attribute Name: Number (NBR)
Table 8-147 Time QR Dimension Number Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
BSNS_YR |
TO_NUMBER(DWR_BSNS_YR.YR_NBR) |
|
BSNS_HLF_YR |
TO_NUMBER(DWR_BSNS_HLF_YR.HLF_YR_NBR) |
|
BSNS_QTR |
TO_NUMBER(DWR_BSNS_QTR.QTR_NBR) |
|
BSNS_MO |
TO_NUMBER(DWR_BSNS_MO.MO_NBR) |
|
BSNS_HLF_MO |
TO_NUMBER(DWR_BSNS_HLF_MO.HLF_MO_NBR) |
|
BSNS_WK |
TO_NUMBER(DWR_BSNS_WK.WK_NBR) |
|
DAY |
TO_NUMBER(DWR_DAY.BSNS_DAY_OF_YR) |
Attribute Name: Identifier (ID)
Table 8-148 Time QR Dimension Identifier Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
DWR_TOT_TIME.TOT_KEY |
|
BSNS_YR |
DWR_BSNS_YR.BSNS_YR_KEY |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_KEY |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_KEY |
|
BSNS_MO |
DWR_BSNS_MO.MO_KEY |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_KEY |
|
BSNS_WK |
DWR_BSNS_WK.WK_KEY |
|
DAY |
DWR_DAY.DAY_KEY |
Attribute Name: Start Date (START_DATE)
Table 8-149 Time QR Dimension Start Date Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTIME |
|
|
BSNS_YR |
DWR_BSNS_YR.YR_STRT_DT |
|
BSNS_HLF_YR |
DWR_BSNS_HLF_YR.HLF_YR_STRT_DT |
|
BSNS_QTR |
DWR_BSNS_QTR.QTR_STRT_DT |
|
BSNS_MO |
DWR_BSNS_MO.MO_STRT_DT |
|
BSNS_HLF_MO |
DWR_BSNS_HLF_MO.HLF_MO_STRT_DT |
|
BSNS_WK |
DWR_BSNS_WK.WK_STRT_DT |
|
DAY |
DWR_DAY.BSNS_STRT_DT |
This dimension stores the Touchpoint Codes used in Oracle Retail Data Model.
Default Hierarchy: HTOUCHPOINT
Table 8-150 Touchpoint Hierarchy (HTOUCHPOINT)
| Level | Description | Touchpoint Hierarchy (HTOUCHPOINT) |
|---|---|---|
|
TTOUCHPOINT |
TotalTouchpoint |
TTOUCHPOINT |
|
TOUCHPOINT |
Touchpoint |
TOUCHPOINT |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-151 Touchpoint Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TTOUCHPOINT |
'Total Touchpoint' |
|
TOUCHPOINT |
DWR_TCHPNT.TCHPNT_CD |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Unit of Measure (UOM) Codes used in Oracle Retail Data Model.
Default Hierarchy: HUOM
Table 8-153 Unit of Measure Hierarchy (HUOM)
| Level | Description | Unit of Measure Hierarchy (HUOM) |
|---|---|---|
|
TUOM |
Total Employee |
TUOM |
|
UOMTYPE |
Employee Type |
UOMTYPE |
|
UOM |
Employee |
UOM |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-154 Unit of Measure Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TUOM |
'Total UOM' |
|
UOMTYPE |
DWL_UOM_TYP.UOM_TYP_NAME |
|
UOM |
DWL_UOM.UOM_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Vendors used in Oracle Retail Data Model.
Default Hierarchy: HVENDOR
Table 8-156 Vendor Hierarchy (HVENDOR)
| Level | Description | Vendor Hierarchy (HVENDOR) |
|---|---|---|
|
TVENDOR |
Total Employee |
TVENDOR |
|
VENDORCLASS |
Employee Type |
VENDORCLASS |
|
VNDR |
Employee |
VNDR |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-157 Vendor Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TVENDOR |
'Total Vendor' |
|
VENDORCLASS |
DWL_VNDR_CLASS.VNDR_CLASS_NAME |
|
VNDR |
DWR_VNDR.PRTY_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Vendor Items used in Oracle Retail Data Model.
Default Hierarchy: HVNDRITEM
Table 8-159 Vendor Item Hierarchy (HVNDRITEM)
| Level | Description | Vendor Item Hierarchy (HVNDRITEM) |
|---|---|---|
|
TVNDRITEM |
Total Vendor Item |
TVNDRITEM |
|
VNDRITEM |
Vendor Item |
VNDRITEM |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-160 Vendor Item Long Description Attribute Mappin
| Level | Mapping (Physical Column) |
|---|---|
|
TVNDRITEM |
'Total Vendor Item' |
|
VNDRITEM |
DWR_VNDR_ITEM.VNDR_ITEM_DESC |
Attribute Name: Short Description (SHORT_DESCRIPTION)
This dimension stores the Vendor Sites used in Oracle Retail Data Model.
Default Hierarchy: HVNDRSITE
Table 8-162 Vendor Site Hierarchy (HVNDRSITE)
| Level | Description | Vendor Site Hierarchy (HVNDRSITE) |
|---|---|---|
|
TVNDRSITE |
Total Vendor Site |
TVNDRSITE |
|
VNDRSITE |
Vendor Site |
VNDRSITE |
Attribute Name: Long Description (LONG_DESCRIPTION)
Table 8-163 Vendor Site Long Description Attribute Mapping
| Level | Mapping (Physical Column) |
|---|---|
|
TVNDRSITE |
'Total Vendor Site' |
|
VNDRSITE |
DWR_VNDR_SITE.VNDR_SITE_NAME |
Attribute Name: Short Description (SHORT_DESCRIPTION)
|
 Copyright © 2009, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
