3 Physical Data Model of Oracle Retail Data Model

This chapter provides information about the physical model of Oracle Retail Data Model. It contains the following topics:

Reference Tables
Lookup Tables
Database Sequences
Base Tables
Derived Tables
Aggregate Tables and Relational Materialized Views
Physical Data Model of the Data Mining Component
Physical Data Model of the OLAP Component

Introduction to the Oracle Retail Data Model Physical Model

The physical data model of the Oracle Retail Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, and relational materialized views have been added to aid performance.

The core physical data model for Oracle Retail Data Model is defined in the bia_rtl schema. It contains definitions for the following:

Aggregate Tables and Relational Materialized Views

Additionally, Oracle Retail Data Model provides the following optional components:

Data Mining component. The physical model of the data mining component is defined by the bia_rtl_mining schema and discussed in "Physical Data Model of the Data Mining Component".
OLAP Component. The physical model of the OLAP component is defined by the bia_rtl_olap schema and discussed in "Physical Data Model of the OLAP Component".

Important:

Do not make changes to the schemas as such changes are not supported.

When examining the predefined physical model, keep in mind the naming convention using DW (Data Warehouse) prefixes and suffixes to identify the types of tables and views:

Suffix or prefex	Description
DWR_	Reference data table
DWL_	Lookup table
DWB_	Base transaction table
DWD_	Derived (data mining) table
DW_	Aggregate (ROLAP or MOLAP) table
_MV	Relational materialized view

Reference Tables

The Reference tables are briefly described in Table 3-1.

Table 3-1 Reference Tables, Descriptions, and Notes

Table Name	Description	Notes
DWR_ADDR_LOC	Address Location	Address for an individual location. Reference Entity, from the Location Geography ERD.
DWR_ADDR_LOC_HIST	Address location history	Captures history of the names and addresses associated with a party or customers.
DWR_ADDR_PHONE	Address Telephone	Address Telephone contains all the phone numbers for a specific address.
DWR_ADDR_RLTD	Address related	This entity associates addresses with other addresses. Address can be associated in many ways. For example, one address is an alternate for another address for those locations with multiple addresses.
DWR_ADVR_PERIOD	Advertising Period	Captures information relating to a Period in an Advertising Calendar.
DWR_ADVR_QTR	Advertising Quarter	Captures information relating to a Quarter in an Advertising Calendar.
DWR_ADVR_WK	Advertising week	Captures information relating to a Week in an Advertising Calendar.
DWR_ADVR_YR	Advertising year	Captures information relating to a Year in an Advertising Calendar.
DWR_ALTVE_ITEM	Alternative item	A cross reference of items that may be substituted or offered in place of another item.
DWR_APPT_CALNDR	Appointment Calender	Captures the exact time of appointment.
DWR_BASE_DAY	Vertical Day table	Base Table of the Time hierarchy in all Calendars.
DWR_BRND	Brand	The selling and promotional name used to identify a product for advertising and name recognition purposes.
DWR_BSNS_ENT_SLNG_RULE	Business Entity Selling Rule	Identifies the organization's Business Entity Rule.
DWR_BSNS_ENT_TNDR_RSTRCT_RULE	Business Entity Tender Restriction Rule	Identifies the organization's Business Entity Tender Restriction Rule.
DWR_BSNS_HLF_MO	Business Half Month	Captures information relating to a Fortnight in a Business Calender.
DWR_BSNS_HLF_YR	Business Half Year	Captures information relating to half year in a Business Calender.
DWR_BSNS_MO	Business Month	Captures information relating to a month in a Business Calender.
DWR_BSNS_QTR	Business Quarter	Captures information relating to a quarter in a Business Calender.
DWR_BSNS_UNIT_CLNDR	Business Unit Calendar	Operating Calendar for the Business Unit, allocated for each day of the year.
DWR_BSNS_UNIT_JB_RL	Business Unit Job Role	Captures The specific job role for a organization.
DWR_BSNS_UNIT_SHFT	Business Unit Shift	Work shift associated with the Business Unit, mapped to the Employee job roles for the allocation for these shifts.
DWR_BSNS_WK	Business Week	Captures information relating to a week in a Business Calender.
DWR_BSNS_YR	Business Year	Captures information relating to a year in a Business Calender.
DWR_CARRIER	Carrier	Captures the information about the carrier, logistic company or the transporter of goods.
DWR_CERTIFICATE	Certificate	Holds the information of a certificate given by retail store for different purpose. For example, a Gift Certificate.
DWR_CLNDR_HLF_MO	Calender Half Month	Captures information relating to a Fortnight in a Normal Calendar.
DWR_CLNDR_HLF_YR	Calender Half Year	Captures information relating to half year in a Normal Calendar.
DWR_CLNDR_MO	Calender Month	Captures information relating to a month in a Normal Calendar.
DWR_CLNDR_QTR	Calender Quarter	Captures information relating to a quarter in a Normal Calendar.
DWR_CLNDR_WK	Calender Week	Captures information relating to a week in a Normal Calendar.
DWR_CLNDR_YR	Calender Year	Captures information relating to a year in a Normal Calender.
DWR_CMPGN	Campaign	Campaigns are the entire communication strategy for a specific marketing communications program. The marketing communications program is frequently in support of promotional events and individual promotions but can be standalone. Retailers execute several different types of campaigns, including advertising, direct marketing and in-store marketing. There are several sub-types within each category as well. Advertising includes (1) traditional broadcast, (2) direct response and (3) online. Direct marketing includes (1) individually tracked and (2) summary tracking. In-store includes (1) broadcast and (2) 1:1. The 1:1 is usually performed in call centers or on Web sites. Each campaign consists of 1 to n communications, which is the lowest level of the campaign object.
DWR_CMPGN_CUST_ASGNMNT	Cost Campaign Customer Assignment	Deals with cost of media and is an assignment entity among Campaign Execution Message, Customer, and Campaign Message Rendering.
DWR_CMPGN_EXECUTION_MSG	Campaign Execution Message	Holds details about the execution message used in a campaign.
DWR_CMPGN_MEDIA	Campaign Media	Holds details about the media through which the Campaign is launched.
DWR_CMPGN_MEDIA_LAUNCH	Campaign Media Launch	Holds details about how a media is launched, for a campaign.
DWR_CMPGN_MEDIA_SLNG_ITEM	Campaign Media Selling Item	The items for which the Campaign is launched through a media.
DWR_CMPGN_MSG_DPCT	Campaign Message Depiction	Holds details about how the execution message is depicted, for a campaign.
DWR_CMPGN_MSG_RNDRNG	Campaign Message Rendering	Holds details about how the execution message is to be rendered, for a campaign. Cost - The total spent for goods or services including money and time and labor. Value measured by what must be given or done or undergone to obtain something. Target - Medium on which the campaign message is rendered.
DWR_CMPNY	Company	Top level of the product and organization hierarchy. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_CMPTR	Competitor	A retailer with a product range and customer base similar to those for the store.
DWR_CMPTR_LOC	Competitor Location	This entity holds non-historical information about competitors and their individual locations
DWR_CMPTR_LOC_ASGNMNT	Competitor Location Assignment	This entity holds the relationship between competitor locations and business unit locations. For example, a competitor grocery store may contain a bank, a florist, and a pharmacy. Competitors can be either primary or secondary.
DWR_CMPTR_RTL_ITEM	Competitor retail item	RETAIL ITEM which is stocked by a COMPETITOR and is perceived by the customer to have no discernible difference in terms of form, fit or function -- but may be sold at a different retail price.
DWR_CREA	Creatives	Information about the creative content of the message
DWR_CUST	Customer Quick Facts Profile individual Profile organization Customer	Collection of Customer related measures. Profile attributes of an individual. Sub type of Profile. Profile attributes for an organization. Captures the information about the customers.
DWR_CUST_ACCT	Customer Account	A charge account or other accounting relationship a customer has with the store or enterprise. An account exists to allow the store to record a series of transactions with the same customer and keep an ongoing record of monies owed by the customer and monies due to the customer.
DWR_CUST_ADDR	Customer address	Assigns the address location to a Profile, customer or a party
DWR_CUST_AFFLTN	Customer Affiliation	Associates a customer with a customer group
DWR_CUST_CLSTR	Customer Cluster	This entity holds all customer clusters and their descriptions. The data must come from an external source.
DWR_CUST_CLSTR_ITEM_ASGNMNT	Customer Cluster Item Assignment	Maps Customer Cluster with Item
DWR_CUST_GRP	Customer Group	A group of customers based on specific demographic and marketing attributes and properties. Examples include over 65 year old customers, students, unions, and other associations.
DWR_CUST_GRP_ITEM	Customer Group Item	An association of Item and Customer Group, the data for this should come from external source.
DWR_CUST_OCCSN	Customer Occasion	Stores an event celebrated or observed by a customer.
DWR_CUST_PREF	Customer preference	A description of the merchandise preferences of a Key Customer, for classes of items or other general categories.
DWR_CUST_RLTNSHP	Customer Relationship	This identifies the relationship between two customers. Example associating the Husband - Wife relationship.
DWR_CUST_RSTRCTD_INFO	Customer Restricted Information	Captures the restricted information for the customer or prospects
DWR_CUST_STATUS	Customer Status	Captures the current status of a prospect, customer or a profile.
DWR_DAY	Horizontal Day Table	Day level in the normal calendar. Reference Entity. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_DAY_TODATE_TRANS	Day To Date Transformation	Cumulative time transformations at the day level. For example: this day last year, this day last month and other day level measures.
DWR_DAY_TRANS	Day transformations	Transformation for a day. For example: this day last year, this day last month, this day with any last time frame.
DWR_DEMOG_ATTR	Demographic attribute	A sub-level group or category further qualifying a set of data (Profile Group) collected about a customer to assist in marketing efforts. Examples include NC - Number of Children, EDL - Education Level,.
DWR_DEMOG_GRP	Demographic Group	The domain of classifications used to group profile information about a Party. Examples: CH - Credit History, ED- Education, EM - Employment, EQ- Equipment, HB - Hobbies, HH - Household, OR - Organization, and other relevant demographics and psychographics.
DWR_DPST_RULE	Deposit Rules	Entity that defines the rules governing the deposit payment that must be paid by the customer at the time the item is purchased and the refund that must be made to the customer upon return of the item package or container. This rule is most often related to bottles, aluminum cans, crates and other containers which must be returned for reuse or recycling.
DWR_DRVD_VAL	Derived Value	This entity stores the derived value of the customer. These value could have multiple value types or value measures.
DWR_DSCRPNCY_TOLRNC_RULE	Discrepancy Tolerance Rule	A rule that defines permissible variance between the total inventory control document cost (based on the suppliers cost) and the stores receiving total (based on the stores record of supplier item cost). Any variance that exceeds the discrepancy threshold triggers an invoice or item-level reconciliation.
DWR_EMAIL_ADDR	E-mail Address	Captures address containing Electronic Addresses that can be accessed with a computer such as an Internet address.
DWR_EMP	Employee	An individual that works for a retail store, accepts direction from the retail store management and satisfies the statutory criteria requiring that payroll taxes and benefit contributions be paid by the retailer.
DWR_EMP_ACT_LBR_HRLY	Employee Actual Labour hourly	This table records the actual shifts the hourly employees have worked in.
DWR_EMP_ACT_LBR_SAL	Employee Actual Labour Salaried	This table records the actual shifts worked by the salaried employees.
DWR_EMP_ADDR	Employee Address	This table serves as a mapping table between the employee table and the address location table. It records the various addresses of an employee and the type of address it is.
DWR_EMP_DESIG	Employee Designation	The table stores the various designations present in an organization for the employees
DWR_EMP_DISC_GRP	Employee Discount Group	A group of EMPLOYEEs who share the same employee discount privilege.
DWR_EMP_DISC_GRP_ASGNMNT	Employee Discount Group Assignment	An association between an employee and an employee discount group which makes the employee eligible for the price reductions available to the discount group.
DWR_EMP_JOB_ROLE_ASGNMNT	Employee Job Role Assignment	This entity indicates the matching of the various job roles present in the organization with the employees
DWR_EMP_RSTRCTD_INFO	Employee Restricted Information	This entity stores confidential information regarding the employees, like the date of birth or national identifier of an employee.
DWR_EMP_SCHL	Employee Schedule	This entity stores the planned schedule for an employee, which consists of the store, job role and shift the employee is planned to work.
DWR_EMP_TRNG_REC	Employee Training Record	A record that a particular employee has been trained in performing a particular Task.
DWR_EVNT	Event	Events provide retailers with an umbrella to consolidate and coordinate related marketing and promotion tactics into a cohesive strategy. Events vary by retail segment, with store sales popular in apparel while weekly discounts (or TPR's) are more common in grocery. The event ensures that the costs and results of disparate marketing and promotional activity can be analyzed and compared against other event strategies as a single entity. Events are comprised of promotions and are communicated through campaigns.
DWR_EXTRNL_DPSTRY	Tender Repository Derived External Depository	Holds tender details in different repositories like Safe, Till, or External Depository. Depository external to the store to which funds can be transferred or received from, such as a bank
DWR_FCTR_CMPNY	Factor company	Stores the information about the factor company. Factor is the financial instrument to raise the money by factoring the bills.
DWR_FSCL_HLF_MO	Fiscal Half Month	Half-month level in the fiscal calendar.
DWR_FSCL_HLF_YR	Fiscal Half Year	Half-year level in the fiscal calendar.
DWR_FSCL_MO	Fiscal Month	Month level in the fiscal calendar.
DWR_FSCL_QTR	Fiscal Quarter	Quarter level in the fiscal calendar.
DWR_FSCL_WK	Fiscal Week	Week level in the fiscal calendar.
DWR_FSCL_YR	Fiscal Year	Year level in the fiscal calendar.
DWR_GEOG_DEMOG_ATTR	Geography Demography Attributes	A classification for a Geography Profile Group. Example for the profile group RACE: Percent White Percent Black Percent Native American Percent Pacific Islander or Asian Percent Persons Of Hispanic Origin Percent Asian Indian Percent Japanese Percent Chinese Percent Filipino Percent Korean Percent Vietnamese Percent Hawaiian
DWR_GEOG_DEMOG_GRP	Geography Demographic Group	A classification for a Geographic and Demographic Profile attribute. Groups include: Population Characteristics Urban or Rural Gender Race Ethnic Background Age Age: Children 0-17 Age: Adults 18-75+ Household Characteristics Population Age 65+ Household Size Characteristics Marital Status Household Size Housing Units Housing Group Quarters Home Value Amounts Rent
DWR_GEOG_DEMOG_VAL	Geography demographic value	Stores the value of the Geography demography Profile. For example, the value for Population (say, 102977) is stored here.
DWR_GEOG_ENT	Geography Entities	Describes the various physical geography entities that can be created. For example Geographic Entities could be: Sales Region North State country city geography EMEA Americas
DWR_GEOG_HRCHY	Geography hierarchy	Stores the details of a Geographical hierarchy; for example, Geography sales hierarchy Geography customer hierarchy, or Geography purchase hierarchy.
DWR_GEOG_HRCHY_LVL	Geographical hierarchy level	Associative entity for Geography Hierarchy and Geography Levels, mapping levels to hierarchies.
DWR_GEOG_HRCHY_LVL_ASGNMNT	Geography entity hierarchy level assignment	Associative entity for Geography Hierarchy Level and Geography Entities; assigns geography values to hierarchy levels.
DWR_GEOG_HRCHY_VRSN	Geography hierarchy version	The version table for the hierarchies.
DWR_GEOG_LVL	Geography levels	This Entity stores all the Geographical levels as required by the analytics. Level definitions could be as simple as Level 1 or level 2, or could be Geography 1 or Geography 2.
DWR_GEOG_LVL_ATTR	Geography level attributes	Stores the attributes at a specific geographical level such as Population.
DWR_GEOG_LVL_ATTR_VAL	Geography level attributes value	This entity stores the various geography level attributes. So for example in a Sales hierarchy you have North sales region and you want to store the population of that region. It can stored here in this entity.
DWR_HH	HouseHold	Captures household information about an individual.
DWR_HLF_HR	Half Hour	This table contains information at the half hour level.
DWR_HLF_MO_TODATE_TRANS	Half Month To Date Transformation	Holds cumulative time transformations at the half month level.
DWR_HLF_MO_TRANS	Half Month Transformation	Transformations for a half month. Example: this half month last year, this year last half month and others.
DWR_HLF_YR_TODATE_TRANS	Half Year To Date Transformation	Cumulative time transformations at the half year level.
DWR_HLF_YR_TRANS	Half Year Transformation	Transformations for a half year. For example, this half year last year, this year last half year and others.
DWR_HR	Hour	This table contains information at the hour level.
DWR_INDVL_DEMOG_VAL	Individual demography value	This entity stores the detailed information and its value collected about customers. For example age has Demography group as AGE, Attribute as various bands and value as 15 years which are stored in this entity.
DWR_INV_LOC	Inventory Location	A physical place the retailer stores merchandise. It may be co-located at a Site with Retail Store, Distribution Center, or Administrative Center. It does not include containers, ships and trucks that are in transit.
DWR_ITEM	Item table	Item table is the lowest level for the Item dimension and has actual item values such as handset models, starter kit packages and recharge vouchers. The sales fact stores the data at item level for item dimension The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ITEM_CLASS	Item Class	Class within a department in the product hierarchy, as it was at a given point in time. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ITEM_CLSTR	Item Cluster	This entity holds all item clusters and their descriptions. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ITEM_CLSTR_CUST_ASGNMNT	Item Cluster Customer Assignment	Maps Item Cluster with Customer
DWR_ITEM_CTGRY	Item Category table	Category within a subClass in the product hierarchy, as it was at a given point in time.
DWR_ITEM_DEPT	Item Department	Departments within a group in the product hierarchy, as it was at a given point in time. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ITEM_DIV	Item Division	Divisions within a company in the product hierarchy, as it was at a given point in time. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ITEM_GRP	Item Group	Group within a division in the product hierarchy, as it was at a given point in time. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ITEM_HRCHY	Item hierarchy	Hierarchy names and descriptions for item dimension
DWR_ITEM_HRCHY_LVL	Item hierarchy level	Hierarchy level name and description
DWR_ITEM_HRCHY_LVL_ASGNMNT	Item hierarchy level assignment	Item Level assignments within an Item Hierarchy
DWR_ITEM_HRCHY_VRSN	Item Hierarchy Version	The version table for the hierarchies.
DWR_ITEM_LVL	Item level	Name and Description for Item Levels
DWR_ITEM_LVL_ATTR	Item level attribute	Names of Attributes associated with an item hierarchy level
DWR_ITEM_LVL_ATTR_VAL	Item level attribute value	Values for Attributes associated with an item hierarchy level.
DWR_ITEM_MKT_DATA	Item Market Data	This entity holds Market Items.Market items refers to the flow of goods through distribution channels authorized by the manufacturer or producer.
DWR_ITEM_SBC	Item Subclass	Subclass within a class in the product hierarchy, as it was at a given point in time. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ITEM_SBDEPT	Item Sub department table	Item SubDepartment within a Department in the product hierarchy, as it was at a given point in time. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ITEM_SEASON	Item Season	Associative entity for Item, Season, and Phase; maps items to seasons and phases.
DWR_ITEM_SHELF_LABEL	Item shelf label	A type of ITEM LABEL that provides a means of conveying information about a RETAIL ITEM to the CUSTOMER, the EMPLOYEE, or both. The label is sited adjacent to the item, usually in front of the merchandise where it can easily be seen by the customer.
DWR_ITEM_SLNG_RULE	Item selling rule	A set of commonly used selling rules for Items
DWR_ITEM_SPIFF_RULE	Item SPIFF Rule	Rule or condition to explain when an employee can receive a reward, or SPIFF.
DWR_ITEM_TNDR_RSTRCT_GRP	Item tender restriction group	A collection of ITEMs which share a common restriction on the kind of tender that may be used to pay for them at a store.
DWR_ITEM_TNDR_RSTRCT_RULE	Item tender restriction rule	An association between ITEM TENDER RESTRICTION GROUP and TENDER which constrains the use of a specific type of tender in the settlement of a sale for a specific ITEM.
DWR_JB_RL	Job Roles	Job roles present in an organization.
DWR_LCL_TAX_AUTH	Local tax authority	Government authority that levies sales taxes, imposes rules or statutory compliances
DWR_LYLTY_AWARD	Loyalty awards	The identification of a reward that the customer receives for satisfying the requirements of a promotion. Examples include premium gifts given when a customer has purchased a set dollar value of merchandise over a promotional period.
DWR_MBRSHIP_ACCT	Membership account	Details for frequent shopper or membership points accounts.
DWR_MEDIA	Media	Specific mass communication, such as Times Of India, Femina, PowerFM, or StarTV. Promotions are communicated through Media.
DWR_MEDIA_DPCT_ITEM_ASGNMNT	MEDIA DEPICTION ITEM ASSIGNMENT	Associate Media Depiction with Item.
DWR_MKT_AREA	Market Area	Market Area denotes a geographic area for which resident demographic data is available. Market Area may not contain a store. Trade Area and Market Area have been used interchangeably in this model. The definition of a trade or market area is the geographic region from which a town draws most of its retail customers. Here are some ways to define a trade area: Study traffic flow Use a retail gravity model Use a zip code method Use commuting data to define the trade area boundaries
DWR_MKT_AREA_LVL	Market Area Level	Level of classification inside the market areas. this classification can be based on: Community which is the one set of demographic attributes as described in the demography entity. Geographic User defined criteria
DWR_MKT_ITEM_DEPT	Market Item Department	This entity holds Market Categories (corresponds to departments in product dimension).
DWR_MKT_ITEM_DEPT_ASGNMNT	Market Item Department Assignment	Maps owned (organization) departments to market departments.
DWR_MNFCTR	Manufacturer	The external party that manufactures the ITEM.
DWR_MNFCTR_CPN_FMLY	MANUFACTURER COUPON FAMILY	This lookup holds code assigned by the manufacturer to classify product for promotion purposes. Examples: Raincheck Coupon, Manufacturer Coupon, Electronic Coupon
DWR_MNT	Minute	This table contains information at the minute level.
DWR_MO_TODATE_TRANS	Month ToDate Transformation	Cumulative time transformations at the month level.
DWR_MO_TRANS	Month transformations information.	Transformations for a month. Example: this month last year, this year last month and others.
DWR_ORG_AREA	Organization Area	Areas within an organization chain The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ORG_BNR	Organization Banner	Holds the information about different organization banners under which the items are sold The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ORG_BSNS_ENT	Organization business entity	Business Entity in an Organization represent any logical entity that is recognized as an enterprise for Business analysis and transactions. Possible classifications for a Business Entity can include, Company, Operation Units, Stores, or Warehouse.
DWR_ORG_BSNS_UNIT	Distribution Center Organization Catalogue Organization Warehouse Organization Store Organization Web Store Organization Business Unit	Business units include: A Distribution Center for a set of products is a warehouse or other specialized building with refrigeration or air conditioning which are supplied by transport, such as aircraft, truck, rail or ship, and then re-distributed to retailers or wholesalers. An Organization Catalogue is a publication, such as a book or pamphlet, containing list or itemized display of titles, course offerings, or articles for exhibition or sale, usually including descriptive information or illustrations. For example, a catalog of fall fashions; a seed catalog. A place in which goods or merchandise are stored; a storehouse. An Organization Store is a fixed location from where goods and merchandise are sold for personal or household consumption. An Organization Web Store is a Web site owned or commissioned by the organization from where goods and merchandise are sold for personal or household consumption. An Organization Business Unit is a place from where organization conducts its business which could be a store, distribution center, warehouse, web-store or catalogue. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ORG_CHAIN	Organization Chain	Chain of outlets through which the organization conducts business. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ORG_DEMOG_VAL	Organization demography value	Stores the Demography Values for the Organization. The demographic values for organization can be: Start date of Organization Revenue band Profit band Product or Service Category Head count Number of offices or sites
DWR_ORG_DEPT	Organization department	A specialized section of a store
DWR_ORG_DIV	Organization division	Organization Division within Organization hierarchy. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ORG_DSTRCT	Organization District	Holds districts within a company, chain, area, region. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_ORG_HRCHY	Organization hierarchy	Master list of all the hierarchies inside an organization.
DWR_ORG_HRCHY_LVL	Organization hierarchy levels	The association table for the hierarchies and levels.
DWR_ORG_HRCHY_LVL_ASGNMNT	Organization hierarchy level assignment	Assignment table for Hierarchy levels to the Business Entities.
DWR_ORG_HRCHY_VRSN	Organization hierarchy version	The version table for the hierarchies.
DWR_ORG_LVL	Organization level	List of all the business levels inside the organization.
DWR_ORG_LVL_ATTR	Organization Level Attributes	Attributes applicable only to the corresponding level in the organization. Possible values that can be stored in this entity can be, Regional Language
DWR_ORG_LVL_ATTR_VAL	Organization Level Attribute Value	Attributes of a business entity
DWR_ORG_MKT_DATA	Organization Market Data	Market related information about an Organization.
DWR_ORG_RGN	Organization Region	Holds region within a company, chain area. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_PAY_DTL	Pay Detail	Payouts from the payroll department. The payout could be compensation amount given to an employee under a payroll category and type, or it could be a contribution from the company toward the employee, under a payroll category and type.
DWR_PERIOD_TODATE_TRANS	Period To Date Transformation	Transformation rules for a period. Example: this period last year, this year last period and others.
DWR_PERIOD_TRANS	Period transformation	Holds time transformations at the period level.
DWR_PHS	Phase	Periods of time within a season. Each day should fall within no more than one phase
DWR_PLNG_PERIOD	Planning period	Period level in the planning calendar.
DWR_PLNG_QTR	Planning quarter	Quarter level in the planning calendar.
DWR_PLNG_SEASON	Planning Season	Captures plan season information.
DWR_PLNG_SEASON_WK_ASGNMNT	Plan Season Week Assignment	Captures information about plan season and respective week relationships.
DWR_PLNG_WK	Planning week	Week level in the planning calendar.
DWR_PLNG_YR	Planning year	Year level in the planning calendar.
DWR_POSTCD	Post Code	Postal codes of interest to the Retail Organization
DWR_POS_DEPT	POS Department	A grouping of items with similar point of sale control and processing attributes.This entity type may also be used to control sales that are not properly identified at the item level
	POS Identity	A simple cross-reference between the barcode, point of sale scan code or other keyed identifying number used at the Point of Sale (POS) and the internal stock keeping Item ID for the item. The POS Item ID is typically filled with the Global Trade Item Number (GTIN) (Universal Product Code [UPC], European Article Number [EAN], and others) for an item, but it is not mandatory. A retailer may develop and maintain its own set of POS identifiers.
DWR_PRICE_DRVTN_RULE	Price Derivation Rule	The specification of a method to be used to transform the current sell unit retail amount to the retail price actually paid by a customer at the point of sale.
DWR_PRMTN	Promotion	The promotion reflects the tactics a retailer undertakes to generate increased incremental sales volume for specific item-store combinations within a promotional event. Promotions are frequently communicated as part of a marketing campaign to ensure that awareness is generated with the target audience.
DWR_PRMTN_SLNG_ITEM	Promotion Item Sale Item	The items on promotion that are actually sold. There could be many items which are on promotion. Out of which some items are actually sold and some are not (as perhaps they do not worth, in terms of extra sales generated, time spent and effort) This dimension holds only those items which are sold.
DWR_PROD_ENT	Product entity	Identifying information for Item at the various levels it may be referred to, such as SKU, Item Number, Item Department.
DWR_PRSPCT	Prospect quick facts, prospect individual, prospect organization, or prospect profile	Prospect quick facts: Collection of Prospect related measures Prospect individual: Prospect attributes of an individual. Sub type of Prospect. Product organization: Prospect attributes for an organization. Prospect profiles: List of the prospects, that is, prospective customers
DWR_PRSPCT_RSTRCT_INFO	Prospect Restricted Info	This tables stores confidential information regarding the prospect, like the date of birth or national identifier of an employee.
DWR_QTR_HR	Quarter Hour	This table contains information at the Quarter hour level.
DWR_QTR_TODATE_TRANS	Quarter Todate Transformation	Cumulative time transformations at the quarter level.
DWR_QTR_TRANS	Quarter Transformation	Transformation for a quarter. Example: this quarter last year, this year last quarter and others.
DWR_RL_HRCHY	Roles Hierarchy	Hierarchy among the job roles within an organization
DWR_RSTRCT_VALID_QUES	Restriction Validation Question	A standard question that may be asked of a Customer as part of the process of negotiating a SalesRestriction that has been placed upon a class of items.
DWR_SEASON	Season	Holds seasons and their attributes. Seasons are arbitrary periods of time around which some retailers organize their buying and selling patterns. Each day should fall within no more than one season.
DWR_SKU_ITEM	SKU Item, Stock Item, Prepared, Select Group, Service, Aggregate	A SKU Item or Stock Keeping Unit is the unit identification (typically the UPC) that is used to track store inventory and sales. Each SKU is attached to an item, variant, product line, bundle, service, fee or attachment. SKU subtypes are: Stock Item is a SKU item that is booked into inventory. Prepared: A sub-type of SKU Item that is manufactured (or prepared) for sale from a set of Bulk Items with a Recipe which is different from Stock Item because a Prepared Item is not booked into inventory when the item is manufactured; nor is it removed from inventory when it is sold; rather the inventory for the Bulk Item constituent parts as defined by the recipe is reduced when the Prepared Item is sold. Select Group: A type of SKU Item that indicates a grouping of items from which the customer may choose for the designated price. The choice of item(s) is made by the customer at the POS. Service: A type of SKU that provides a detailed identifier and description for a service offered for sale to a customer in the retail store. This entity also identifies and describes rental items and other tangible items that are used by a customer for a contracted period, but not purchased. Aggregate: A sub-type of SKU that is an aggregation of one or more constituent SKUs. The constituent items may be sold individually. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWR_SKU_ITEM_BSNS_UNIT_INV_RL	SKU Item Business Unit Inventory Rules	Maps SKU Item with Vendor and Organization Business Unit.
DWR_SKU_ITEM_BU_SL_PRC	SKU Item Business Unit Selling Price	Selling Price related information for a SKU item at a particular business unit
DWR_SKU_ITEM_CHOICE	Sku Item Choice	A mapping from a parent GroupSelectItem to Item denoting a choice that may be made by the customer at the time of sale for a Group Select sale, package deal, or bill of material, in which several items are bundled under a single price, and the customer can make substitutions for some items from a list of choices for the bundle. Example: Ski package where the customer can choose one of several ski's, one of several ski poles, one of several goggles.
DWR_SKU_ITEM_COLLCTN	SKU Collection	Optional relationship between an item and its components and affiliates where the components consist of other SKUs. Note that this data structure is intended to support one and only one level of decomposition, affiliation, or both, between an SKU parent and its SKU's children.
DWR_SKU_ITEM_CONSTRUCTION	SKU Item Construction	An item fashioned or devised systematically
DWR_SKU_ITEM_SHELF_ATTR	Sku Item Shelf Attributes	Specifications of the shelf on which the SKU items are kept.
DWR_SKU_ITEM_SUB	Sku Item substitution	Refers to SKU Item which could be considered as a substitute for the SKU item in question. There may be cases; especially for complex items like "Car", which is a combination of several items; where the user would have the choice to pick different kinds of components. A corresponding price adjustment would happen depending on the component selection. In the case of Car example, Car is made up of several components which can be sold individually. Select tire component and one can substitute tire with several other brands of tire. In this example, SKU COLLECTION has one row and default tire brand given. Car would be a row in SKU entity and SKU substitution has as many rows as there are different brands available which can substitute the different brand.
DWR_SKU_ITEM_VRTY_ASGNMNT	SKU Item variety assignment	Captures item attributes other than size, weight and style, such as color. If apparel can come in two colors, say red and blue, then this entity has two rows.
DWR_SKU_ITEM_WT	Weight	Captures the weights the SKU is available in.
DWR_SLNG_LOC	Selling Location	An area of floor space or shelf space within the Retail Store to which sales can be assigned. This space may be assigned to or rented to a Vendor.
DWR_SLS_RSTRCT	Age restriction rule Item sales prohibition period rule License Sales Restriction Sales Restriction	Defines a rule that restricts the sale of an SKU to customers that must be a minimum age and by the employee that must be a minimum age. Rules restricting the sale of an item. Examples: day, time, age of customer, age of operator for alcohol sales A restriction or limitation on the sales of a class of SKUs based on the purchasers profession, license, or other certification. A limitation that restricts the sale of a particular class of Item
DWR_SRVC_TERM	Service Term	Terms and conditions for services provided by the store or by a third party. Normally the terms are in a separate document that the customer signs.
DWR_STATUS	Status	Status for a particular status type
DWR_STORE_SAFE	Tender Repository Derived Store safe	Holds tender details in different repositories like Safe, Till, or External Depository. A repository within the store for safekeeping TENDER removed from the TILL. Also used to secure petty cash and till loans
DWR_TAX_EXMPT_CD	Tax exempt code	Entities represent a tax exemption for each item, customer and location combination
DWR_TCHPNT	Store Workstation Call Center Touchpoint	A device used as an interface to any store business function. This includes the capture and storage of transactions and operational performance reporting, a department within a company or a third-party organization that handles telephone sales or service, a place where transactions occur, or a meeting point for customer and organization. Can be both logical and physical
DWR_TNDR_RPSTRY	Tender Repository table	The types of physical tender containers used in the retail enterprise. Tender repository generally includes assets like store safe(s) or tills.
DWR_TIME_PLNG_SEASON_TD_BY_WK	Time Planning Season ToDate By Week	Holds time transformation of plan season to date data by week.
DWR_TIME_STNDRD_BY_DAY	Time Standard By Day	Relationship between a given day and all days of a season up to that given day.
DWR_TIME_STNDRD_BY_WK	Time Standard By Week	Relationship between a given week and all days of a given season up to that week.
DWR_TNDR	Tender	Tender includes all the forms of payment that are accepted by the RETAIL STORE in settling sales and other transactions. Policies applicable for each tender type
DWR_TRD_AREA	Trade Area	The geographic area serviced by a retail store or proposed retail store (a prospective location). The trade area is basically dictated by whether a consumer shops at the store. A retailer may have multiple trade areas for the site (primary, secondary, tertiary). Trade areas are defined so that retailers can determine the demographic, psychographic, or population data for the geography served by the store. This data is pulled from market area data, which is usually based on census blocks in the U.S. Basically the trade area provides a mechanism to map market area data to a specific store because the census blocks (or whatever is used to store the market area data) does not map to the geographic area served by a store. The definition of a trade or market area is the geographic region from which a town draws most of its retail customers. Examples of ways to define a trade area include Study traffic flow, Use a retail gravity model, Use a zip code method, and Use commuting data to define the trade area boundaries
DWR_TRD_AREA_COVRG	Trade Area Coverage	Demographic and accessibility data for a given trade area.
DWR_TRMS_MASTER	Terms Master	Master data of terms of business with the vendor
DWR_USERS	User	Associative entity for Employee, Job Role, and Employee Actual Labor Hourly; associates a unique ID for every job role that an employee performs at a particular store. An employee appears only once in the Employee table, but in this table, the employee appears once for each job role at each store.
DWR_VALID_QUES_ASGNMNT	Validation Question Assignment	Associates Restriction Validation Question to Sales Restriction
DWR_VAL_MSR	Value measure	Value measure stores the measure of the value. For example a customer or a profile can be valued in terms of monetary value or time (he is our customer for next 3 years). This table also stores the Recency, Frequency, and Monetary Value (RFM) score value measures, like the number of visits.
DWR_VNDR	Vendor	External source for merchandise and goods that the retail store offers or for supplies and goods that the store uses.
DWR_VNDR_APNMNT	Vendor appointment	This entity store the vendor appointment details. Vendor appoints are the regular visits by vendor's representative to the retail organization site
DWR_VNDR_CARRIER_ASGNMNT	Vendor Carrier	Associative entity for Vendor and Carrier; maps vendors and their various carriers
DWR_VNDR_CNTRCT	Vendor Contract	The details of contract with Vendor.
DWR_VNDR_FCTR_CMPNY_ASGNMNT	Vendor Factor	This captures the information of the various factor companies used by the vendor.
DWR_VNDR_ITEM	Vendor Item	Associative entity between Vendor and Item; maps a vendor-specific item to a retail item and provides the vendor-specific attributes to the item. Used for ordering from a vendor price list, catalog, or other resource. Provides the vendor's view of the item and uses the vendor's description of item attributes.
DWR_VNDR_ITEM_BSNS_UNIT_ASGN	Vendor Item Business Unit Assignment	This entity shows relationship between vendor, Item and Organization Business Unit.
DWR_VNDR_ITEM_SKU_ASGNMNT	Vendor Item Sku Assignment	Associates vendor with item SKU.
DWR_VNDR_MNFCTR_BRAND	Vendor Manufacturer Brand	Associative entity for Vendor, Manufacturer, and Brand.
DWR_VNDR_RTNG	Vendor Rating	This entity captures the rating of the vendor
DWR_VNDR_SITE	Vendor Site	This entity captures the information of various vendor sites. For example a vendor might have multiple offices, warehouse, despatch centres, or liaison offices.
DWR_VNDR_SITE_ADDR	Vendor address	Vendor address is an association table between the Vendor Site or Vendor and the address location
DWR_VNDR_SKU_BSNS_UNIT_ASGNMNT	Vendor SKU Business Unit Assignment	This entity shows relationship between SKU Item, Vendor and Organization Business Unit.
DWR_VNDR_STATUS	Vendor status	Status of a vendor. Indicates if the vendor is presently being used or on suspension.
DWR_VRTY	Variety	Item attribute other than size, weight, and style, such as color.
DWR_WKDAY	WeekDay	Holds information relating to calendar weekdays. It is used to relate weekdays to day identifiers.
DWR_WK_TODATE_TRANS	Week ToDate Transformation	Cumulative time transformations at the week level.
DWR_WK_TRANS	Week transformation	Transformation for a week. Example: this week last year, this year last week and others.
DWR_WRKSTN_DISP	Work Station Display	A physical display for Items near the workstation, usually intended for impulse purchases. Examples include magazines, candy, gift cards, and calendars.
DWR_YR_TRANS	Year transformations	Holds time transformations at the year level.

Lookup Tables

The Lookup tables are listed in Table 3-2.

Table 3-2 Lookup Table Names, Descriptions, and Notes

Table Name	Description	Notes
DWL_ANALYSIS_DURATION	Analysis Duration	A period of time. Can extend over 2 or more days
DWL_CERTIFICATE_AGE_BND	Certificate Age Band	This lookup table holds static Certificate age bands. These age bands are used to categorize based on their age. Each age band is a client-defined range of age in days. The age of a certificate is used to determine the age band into which it falls.
DWL_CODE_MASTER	Code Master Table	Contains non-hierarchical lookup types and corresponding values.
DWL_COMUNICTN_TYP	Communication Type	Type of communication, for example, telephone, paper or e-mail. This entity holds the name of communication and the format along with the communication code.
DWL_CRNCY	Currency	Specifies the national designation and quantitative value of monetary media used as tender in the processing of this TENDER LINE ITEM.
DWL_DENMTN	Denomination	Specifies the quantitative value of the referenced CURRENCY media
DWL_DISC_TYP	Discount types	Captures the various types of discount. Examples of discount types include quantity discount or cash discount.
DWL_INV_STATUS	Inventory Status	Captures different states of the inventory like work-in-progress, manufactured, or finished.
DWL_MEDIA_TYP	Media Type	Description of Media Type. Examples include TV, radio, newspaper, and list.
DWL_MNFCTR_CPN_FMLY	Manufacturer Coupon Family	Code assigned by the manufacturer to classify product for promotion purposes.
DWL_ORDR_STATUS	Order Status	Lookup for the different types of Order Status like Already Shipped, Delivered, Processing, or Partially Delivered.
DWL_ORDR_STATUS_TYP	Order Status Type	Lookup for the different types of order status type.
DWL_PAY_TYP	Pay Type	Various pay types under the different categories.
DWL_RFMP_MTHD	RFMP Method	Lookup to hold the different methods of calculating the Recency Frequency Monetary and Profitability Scores
DWL_RSN	Reason	Reason codes and descriptions
DWL_RSN_CTGRY	Reason Category	This lookup holds reason type codes and their descriptions. Example in include Urgent, Quality, or Other.
DWL_STORE_FINCL_LDGR_ACCT	Store Financial Ledger Account	Journal Accounts for the accumulation of certain transactions and charges.
DWL_SZ	Size	Captures the size details of the SKU.
DWL_TAXBL_GRP	Tax Group	A group of Items for which a TaxAuthority defines TaxGroupRules
DWL_TAX_AUTH	Tax Authority	A government authority that levies sales taxes and on whose behalf the store collects these sales taxes.
DWL_TAX_EXMPTN	Term Code	Holds information of different terms like sales.
DWL_TIME_ZN	Time Zone	Location in the world relative to Greenwich Mean Time (GMT) in Greenwich, England.
DWL_TNDR_TYP	Tender Type	Holds all the tender type IDs and their parent tender type groups. The tender type dimension is composed of one table (TNDR_TYPE_DM) and one view (TNDR_TYPE_GRP_DM). An example of a tender type group is Credit Card". Examples of tender type IDs that belong to this group are "American Express", "Master Card" or "Discover Card".
DWL_TRX_TYP	Transaction Type	A specific designator that indicates what type of transaction has been captured through a work station. Examples include Sale, Return, Sale Reversal, or Return Reversal.
DWL_UOM	Unit of Measure	Identifies and describes valid units of measure that are used throughout the model.

Database Sequences

Database sequences for Oracle Retail Data Model are listed in Table 3-3.

Table 3-3 Database Sequences

Sequence Name	Generates the Physical Key for This Table
ADDR_LOC_HIST_SEQ	DWR_ADDR_LOC_HIST
ADDR_LOC_SEQ	DWR_ADDR_LOC
ADDR_PHONE_SEQ	DWR_ADDR_PHONE
ADDR_RLTD_SEQ	DWR_ADDR_RLTD
ADVR_PERIOD_SEQ	DWR_ADVR_PERIOD
ADVR_QTR_SEQ	DWR_ADVR_QTR
ADVR_WK_SEQ	DWR_ADVR_WK
ADVR_YR_SEQ	DWR_ADVR_YR
ALTVE_ITEM_SEQ	DWR_ALTVE_ITEM
APNMNT_SEQ	DWR_APNMNT
BRND_SEQ	DWR_BRND
BSNS_ENT_SLNG_RULE_SEQ	DWR_BSNS_ENT_SLNG_RULE
BSNS_ENT_TNDR_RSTRCT_RULE_SEQ	DWR_BSNS_ENT_TNDR_RSTRCT_RULE
BSNS_MO_SEQ	DWR_BSNS_MO
BSNS_QTR_SEQ	DWR_BSNS_QTR
BSNS_UNIT_JB_RL_SEQ	DWR_BSNS_UNIT_JB_RL
BSNS_UNIT_SEQ	DWR_BSNS_UNIT
BSNS_UNIT_SHFT_SEQ	DWR_BSNS_UNIT_SHFT
BSNS_WK_SEQ	DWR_BSNS_WK
BSNS_YR_SEQ	DWR_BSNS_YR
CARRIER_SEQ	DWR_CARRIER
CERTIFICATE_SEQ	DWR_CERTIFICATE
CLNDR_HLF_MO_SEQ	DWR_CLNDR_HLF_MO
CLNDR_HLF_YR_SEQ	DWR_CLNDR_HLF_YR
CLNDR_MO_SEQ	DWR_CLNDR_MO
CLNDR_QTR_SEQ	DWR_CLNDR_QTR
CLNDR_WK_SEQ	DWR_CLNDR_WK
CLNDR_YR_SEQ	DWR_CLNDR_YR
CMPGN_CUST_ASGNMNT_SEQ	DWR_CMPGN_CUST_ASGNMNT
CMPGN_EXECUTION_MSG_SEQ	DWR_CMPGN_EXECUTION_MSG
CMPGN_MEDIA_LAUNCH_SEQ	DWR_CMPGN_MEDIA_LAUNCH
CMPGN_MEDIA_SEQ	DWR_CMPGN_MEDIA
CMPGN_MEDIA_SLNG_ITEM_SEQ	DWR_CMPGN_MEDIA_SLNG_ITEM
CMPGN_MSG_DPCT_SEQ	DWR_CMPGN_MSG_DPCT
CMPGN_MSG_RNDRNG_SEQ	DWR_CMPGN_MSG_RNDRNG
CMPGN_SEQ	DWR_CMPGN
CMPNY_SEQ	DWR_CMPNY
CMPTR_LOC_SEQ	DWR_CMPTR_LOC
CMPTR_RTL_ITEM_SEQ	DWR_CMPTR_RTL_ITEM
CMPTR_SEQ	DWR_CMPTR
CREA_SEQ	DWR_CREA
CUST_ACCT_SEQ	DWR_CUST_ACCT
CUST_ADDR_SEQ	DWR_CUST_ADDR
CUST_AFFLTN_SEQ	DWR_CUST_AFFLTN
CUST_CLSTR_SEQ	DWR_CUST_CLSTR
CUST_GRP_ITEM_SEQ	DWR_CUST_GRP_ITEM
CUST_GRP_SEQ	DWR_CUST_GRP
CUST_OCCSN_SEQ	DWR_CUST_OCCSN
CUST_PREF_SEQ	DWR_CUST_PREF
CUST_RLTNSHP_SEQ	DWR_CUST_RLTNSHP
CUST_RSTRCTD_INFO_SEQ	DWR_CUST_RSTRCTD_INFO
CUST_SEQ	DWR_CUST
CUST_STATUS_SEQ	DWR_CUST_STATUS
DAY_SEQ	DWR_DAY
DAY_TODATE_TRANS_SEQ	DWR_DAY_TODATE_TRANS
DAY_TRANS_SEQ	DWR_DAY_TRANS
DEAL_SEQ	DWB_DEAL
DEAL_VNDR_ITEM_SEQ	DWR_DEAL_VNDR_ITEM
DEMOG_ATTR_SEQ	DWR_DEMOG_ATTR
DEMOG_GRP_SEQ	DWR_DEMOG_GRP
DPST_RULE_SEQ	DWR_DPST_RULE
DRVD_VAL_SEQ	DWR_DRVD_VAL
DSCRPNCY_TOLRNC_RULE_SEQ	DWR_DSCRPNCY_TOLRNC_RULE
EMAIL_ADDR_SEQ	DWR_EMAIL_ADDR
EMP_ACT_LBR_HRLY_SEQ	DWR_EMP_ACT_LBR_HRLY
EMP_ACT_LBR_SAL_SEQ	DWR_EMP_ACT_LBR_SAL
EMP_ADDR_SEQ	DWR_EMP_ADDR
EMP_DESIG_SEQ	DWR_EMP_DESIG
EMP_DISC_GRP_SEQ	DWR_EMP_DISC_GRP
EMP_RSTRCTD_INFO_SEQ	DWR_EMP_RSTRCTD_INFO
EMP_SCHL_SEQ	DWR_EMP_SCHL
EMP_SEQ	DWR_EMP
EMP_TRNG_REC_SEQ	DWR_EMP_TRNG_REC
EVNT_SEQ	DWR_EVNT
FCTR_CMPNY_SEQ	DWR_FCTR_CMPNY
FSCL_HLF_MO_SEQ	DWR_FSCL_HLF_MO
FSCL_HLF_YR_SEQ	DWR_FSCL_HLF_YR
FSCL_MO_SEQ	DWR_FSCL_MO
FSCL_QTR_SEQ	DWR_FSCL_QTR
FSCL_WK_SEQ	DWR_FSCL_WK
FSCL_YR_SEQ	DWR_FSCL_YR
GEOG_DEMOG_ATTR_SEQ	DWR_GEOG_DEMOG_ATTR
GEOG_DEMOG_GRP_SEQ	DWR_GEOG_DEMOG_GRP
GEOG_DEMOG_VAL_SEQ	DWR_GEOG_DEMOG_VAL
GEOG_ENT_SEQ	DWR_GEOG_ENT
GEOG_HRCHY_LVL_SEQ	DWR_GEOG_HRCHY_LVL
GEOG_HRCHY_SEQ	DWR_GEOG_HRCHY
GEOG_HRCHY_VRSN_SEQ	DWR_GEOG_HRCHY_VRSN
GEOG_LVL_ATTR_SEQ	DWR_GEOG_LVL_ATTR
GEOG_LVL_ATTR_VAL_SEQ	DWR_GEOG_LVL_ATTR_VAL
GEOG_LVL_SEQ	DWR_GEOG_LVL
HH_SEQ	DWR_HH
HLF_HR_SEQ	DWR_HLF_HR
HLF_MO_SEQ	DWR_HLF_MO
HLF_MO_TODATE_TRANS_SEQ	DWR_HLF_MO_TODATE_TRANS
HLF_MO_TRANS_SEQ	DWR_HLF_MO_TRANS
HLF_YR_SEQ	DWR_HLF_YR
HLF_YR_TODATE_TRANS_SEQ	DWR_HLF_YR_TODATE_TRANS
HLF_YR_TRANS_SEQ	DWR_HLF_YR_TRANS
HR_SEQ	DWR_HR
INDVL_DEMOG_VAL_SEQ	DWR_INDVL_DEMOG_VAL
INV_LOC_SEQ	DWR_INV_LOC
ITEM_CLASS_SEQ	DWR_ITEM_CLASS
ITEM_CLSTR_SEQ	DWR_ITEM_CLSTR
ITEM_CTGRY_SEQ	DWR_ITEM_CTGRY
ITEM_DEPT_SEQ	DWR_ITEM_DEPT
ITEM_DIV_SEQ	DWR_ITEM_DIV
ITEM_GRP_SEQ	DWR_ITEM_GRP
ITEM_HRCHY_LVL_ASGNMNT_SEQ	DWR_ITEM_HRCHY_LVL_ASGNMNT
ITEM_HRCHY_LVL_SEQ	DWR_ITEM_HRCHY_LVL
ITEM_HRCHY_SEQ	DWR_ITEM_HRCHY
ITEM_HRCHY_VRSN_SEQ	DWR_ITEM_HRCHY_VRSN
ITEM_LVL_ATTR_SEQ	DWR_ITEM_LVL_ATTR
ITEM_LVL_ATTR_VAL_SEQ	DWR_ITEM_LVL_ATTR_VAL
ITEM_LVL_SEQ	DWR_ITEM_LVL
ITEM_MKT_DATA_SEQ	DWR_ITEM_MKT_DATA
ITEM_SBC_SEQ	DWR_ITEM_SBC
ITEM_SBDEPT_SEQ	DWR_ITEM_SBDEPT
ITEM_SEASON_SEQ	DWR_ITEM_SEASON
ITEM_SEQ	DWR_ITEM
ITEM_SHELF_LABEL_SEQ	DWR_ITEM_SHELF_LABEL
ITEM_SLNG_RULE_SEQ	DWR_ITEM_SLNG_RULE
ITEM_SPIFF_RULE_SEQ	DWR_ITEM_SPIFF_RULE
ITEM_TNDR_RSTRCT_GRP_SEQ	DWR_ITEM_TNDR_RSTRCT_GRP
ITEM_TNDR_RSTRCT_RULE_SEQ	DWR_ITEM_TNDR_RSTRCT_RULE
JB_RL_SEQ	DWR_JB_RL
LCL_TAX_AUTH_SEQ	DWR_LCL_TAX_AUTH
LYLTY_AWARD_SEQ	DWR_LYLTY_AWARD
MBRSHIP_ACCT_SEQ	DWR_MBRSHIP_ACCT
MEDIA_DPCT_ITEM_ASGNMNT_SEQ	DWR_MEDIA_DPCT_ITEM_ASGNMNT
MEDIA_SEQ	DWR_MEDIA
MEDIA_SLNG_ITEM_DPCT_SEQ	DWR_MEDIA_SLNG_ITEM_DPCT
MEDIA_TYP_SEQ	DWR_MEDIA_TYP
MKT_AREA_LVL_SEQ	DWR_MKT_AREA_LVL
MKT_AREA_SEQ	DWR_MKT_AREA
MKT_ITEM_DEPT_SEQ	DWR_MKT_ITEM_DEPT
MNFCTR_SEQ	DWR_MNFCTR
MNT_SEQ	DWR_MNT
MO_TODATE_TRANS_SEQ	DWR_MO_TODATE_TRANS
MO_TRANS_SEQ	DWR_MO_TRANS
ORG_AREA_SEQ	DWR_ORG_AREA
ORG_BNR_SEQ	DWR_ORG_BNR
ORG_BSNS_ENT_SEQ	DWR_ORG_BSNS_ENT
ORG_BSNS_UNIT_SEQ	DWR_ORG_BSNS_UNIT
ORG_CHAIN_SEQ	DWR_ORG_CHAIN
ORG_DEMOG_VAL_SEQ	DWR_ORG_DEMOG_VAL
ORG_DEPT_SEQ	DWR_ORG_DEPT
ORG_DSTRCT_SEQ	DWR_ORG_DSTRCT
ORG_HRCHY_LVL_ASGNMNT_SEQ	DWR_ORG_HRCHY_LVL_ASGNMNT
ORG_HRCHY_LVL_SEQ	DWR_ORG_HRCHY_LVL
ORG_HRCHY_SEQ	DWR_ORG_HRCHY
ORG_HRCHY_VRSN_SEQ	DWR_ORG_HRCHY_VRSN
ORG_LVL_ATTR_SEQ	DWR_ORG_LVL_ATTR
ORG_LVL_ATTR_VAL_SEQ	DWR_ORG_LVL_ATTR_VAL
ORG_LVL_SEQ	DWR_ORG_LVL
ORG_MKT_DATA_SEQ	DWR_ORG_MKT_DATA
ORG_RGN_SEQ	DWR_ORG_RGN
PAY_DTL_SEQ	DWR_PAY_DTL
PAY_TYP_SEQ	DWR_PAY_TYP
PERIOD_TODATE_TRANS_SEQ	DWR_PERIOD_TODATE_TRANS
PERIOD_TRANS_SEQ	DWR_PERIOD_TRANS
PHS_SEQ	DWR_PHS
PLNG_PERIOD_SEQ	DWR_PLNG_PERIOD
PLNG_QTR_SEQ	DWR_PLNG_QTR
PLNG_SEASON_SEQ	DWR_PLNG_SEASON
PLNG_WK_SEQ	DWR_PLNG_WK
PLNG_YR_SEQ	DWR_PLNG_YR
POSTCD_SEQ	DWR_POSTCD
POS_DEPT_SEQ	DWR_POS_DEPT
POS_IDNT_SEQ	DWR_POS_IDNT
PRICE_DRVTN_RULE_SEQ	DWR_PRICE_DRVTN_RULE
PRMTN_ITM_SEQ	DWR_PRMTN_ITM
PRMTN_MEDIA_COST_SEQ	DWR_PRMTN_MEDIA_COST
PRMTN_PRICE_DRVTN_SEQ	DWR_PRMTN_PRICE_DRVTN
PRMTN_SEQ	DWR_PRMTN
PRMTN_SLNG_ITEM_SEQ	DWR_PRMTN_SLNG_ITEM
PROD_ENT_SEQ	DWR_PROD_ENT
PRSPCT_RSTRCT_INFO_SEQ	DWR_PRSPCT_RSTRCT_INFO
QTR_HR_SEQ	DWR_QTR_HR
QTR_TODATE_TRANS_SEQ	DWR_QTR_TODATE_TRANS
QTR_TRANS_SEQ	DWR_QTR_TRANS
RL_HRCHY_SEQ	DWR_RL_HRCHY
RSTRCT_VALID_QUES_SEQ	DWR_RSTRCT_VALID_QUES
SEASON_SEQ	DWR_SEASON
SKU_ITEM_BSNS_UNT_SLNG_PRC_SEQ	DWR_SKU_ITEM_BSNS_UNT_SLNG_PRC
SKU_ITEM_CHOICE_SEQ	DWR_SKU_ITEM_CHOICE
SKU_ITEM_COLLCTN_SEQ	DWR_SKU_ITEM_COLLCTN
SKU_ITEM_CONSTRUCTION_SEQ	DWR_SKU_ITEM_CONSTRUCTION
SKU_ITEM_SEQ	DWR_SKU_ITEM
SKU_ITEM_SHELF_ATTR_SEQ	DWR_SKU_ITEM_SHELF_ATTR
SKU_ITEM_SLNG_PRICE_HIST_SEQ	DWR_SKU_ITEM_SLNG_PRICE_HIST
SKU_ITEM_SLNG_PRICE_SEQ	DWR_SKU_ITEM_SLNG_PRICE
SKU_ITEM_SUB_SEQ	DWR_SKU_ITEM_SUB
SKU_ITEM_WT_SEQ	DWR_SKU_ITEM_WT
SKU_ITM_BSNS_UNT_INV_RULES_SEQ	DWR_SKU_ITM_BSNS_UNT_INV_RULES
SLNG_LOC_SEQ	DWR_SLNG_LOC
SLS_RSTRCT_SEQ	DWR_SLS_RSTRCT
SRVC_TERM_SEQ	DWR_SRVC_TERM
STATUS_SEQ	DWR_STATUS
SZ_SEQ	DWR_SZ
TAX_EXMPT_CD_SEQ	DWR_TAX_EXMPT_CD
TCHPNT_SEQ	DWR_TCHPNT
TIME_PLNG_SEASON_TODATE_WK_SEQ	DWR_TIME_PLNG_SEASON_TODATE_WK
TIME_STNDRD_BY_DAY_SEQ	DWR_TIME_STNDRD_BY_DAY
TIME_STNDRD_BY_WK_SEQ	DWR_TIME_STNDRD_BY_WK
TIME_ZN_SEQ	DWR_TIME_ZN
TNDR_SEQ	DWR_TNDR
TRD_AREA_COVRG_SEQ	DWR_TRD_AREA_COVRG
TRD_AREA_SEQ	DWR_TRD_AREA
TRMS_MASTER_SEQ	DWR_TRMS_MASTER
USERS_SEQ	DWR_USERS
VAL_MSR_SEQ	DWR_VAL_MSR
VNDR_ADDR_SEQ	DWR_VNDR_ADDR
VNDR_APNMNT_SEQ	DWR_VNDR_APNMNT
VNDR_CARRIER_ASGNMNT_SEQ	DWR_VNDR_CARRIER_ASGNMNT
VNDR_CLASS_SEQ	DWR_VNDR_CLASS
VNDR_CNTRCT_SEQ	DWR_VNDR_CNTRCT
VNDR_FCTR_SEQ	DWR_VNDR_FCTR
VNDR_ITEM_BSNS_UNT_ASGNMNT_SEQ	DWR_VNDR_ITEM_BSNS_UNT_ASGNMNT
VNDR_ITEM_SEQ	DWR_VNDR_ITEM
VNDR_ITEM_SKU_ASGNMNT_SEQ	DWR_VNDR_ITEM_SKU_ASGNMNT
VNDR_MNFCTR_BRAND_SEQ	DWR_VNDR_MNFCTR_BRAND
VNDR_RTNG_SEQ	DWR_VNDR_RTNG
VNDR_SEQ	DWR_VNDR
VNDR_SITE_SEQ	DWR_VNDR_SITE
VNDR_SKU_BSNS_UNIT_ASGNMNT_SEQ	DWR_VNDR_SKU_BSNS_UNIT_ASGNMNT
VNDR_STATUS_SEQ	DWR_VNDR_STATUS
VRTY_SEQ	DWR_VRTY
WKDAY_SEQ	DWR_WKDAY
WK_TODATE_TRANS_SEQ	DWR_WK_TODATE_TRANS
WK_TRANS_SEQ	DWR_WK_TRANS
WRKSTN_DISP_SEQ	DWR_WRKSTN_DISP
YR_TRANS_SEQ	DWR_YR_TRANS

Base Tables

The Base tables are listed in Table 3-4.

Table 3-4 Base Table Names, Descriptions, and Notes

Table Name	Description	Notes
DWB_CERTIFICATE_ESCHTD_DAY	Certificate Escheated Day	The date and count of escheated vouchers. When a voucher escheats, the retailer releases all liability of the voucher to the appropriate governmental authority. The quantity of escheated vouchers and the dates on which they escheated are captured on this table. Vouchers escheat on set days throught the year, typically only a few times a year.
DWB_CERTIFICATE_LI	Certificate Line Item Sub Type Of Retail Transaction Line Item	A detail line item of a Retail Transaction that records the business conducted between the retail store and another party involving the exchange in ownership, accountability, or both for merchandise, tender, or both or involving the exchange of tender for services. A type of RETAIL TRANSACTION LINE ITEM that records the sale of redeemable form of tender for a predetermined monetary value of sellable merchandise in the store. Creates a liability for the retailer in the amount denoted on the face value of the certificate
DWB_CUST_ORDR	Customer Order	Captures information about Orders placed by customers
DWB_CUST_ORDR_LI	Customer Order Line Item	Holds customer order line information. This table only holds customer order lines that have been fully shipped or canceled. This table is only used for Extract, Transform, and Load (ETL) processing. Views are built from this table for analytical reporting.
DWB_CUST_ORDR_LI_STATE_ASSIGN	Customer Order Line Item State Assign	Record of a customer order line item being in a particular state for a period.
DWB_CUST_ORDR_STATE	Customer Order State	Record of a customer order line item being in a particular state for a period
DWB_CUST_SRVC_RQST	Customer Service Request	Holds activity request transactions at the individual activity request, day, and minute level.
DWB_DAY_ACT_CONDITION	Day Actual Conditions	Various conditions like weather, internal, external affecting a day.
DWB_DEAL	Deal	A deal refers to a special offer from a supplier to the store. The deal generally provides allowances, discounts, special favorable terms of payment or other incentives to motivate the store to buy more products or services from a supplier.
DWB_DEAL_VNDR_ITEM_ASGNMNT	Deal Vendor Item	Identifies a specific VENDOR ITEM that is offered as part of a deal to the store and defines how the deal cost is to be handled.
DWB_DISC_LI	Discount Line Item SubType of Retail Transaction Line Item	A detail line item of a Retail Transaction that records the business conducted between the retail store and another party involving the exchange in ownership, accountability, or both for merchandise, tender, or both, involving the exchange of tender for services. A special kind of retail line item set up to record and keep track of discounts taken in a transaction
DWB_EMP_LBR	Employee Labor	Contains information, like days of attendance, leave taken, and other information regarding Employees
DWB_EXCHNG_RATE_CRNCY_DAY	Exchange Rate Currency Rate	Holds exchange rates for particular currencies in different locations
DWB_INV_CNTRL_DOC	Return And Transfer In Out Document Packing Slip ReturnAuthorization Request Receiving Document INVENTORY CONTROL TRANSACTION	A type of INVENTORY CONTROL DOCUMENT that is completed during Return item to the Supplier or Transfer item without any Purchase Order within a difference. Store A document that identifies the merchandise items a supplier claims to be shipping to the store against one or more purchase orders. A type of INVENTORY CONTROL DOCUMENT that makes a request to a supplier to grant permission to return merchandise that is received and found to be unsuitable for sale or other use at the store A type of INVENTORY CONTROL DOCUMENT that is used by a store to record its acceptance of items shipped to it by a supplier against an ORDER and the SUPPLIERs packing slip. A type of Transaction that records Inventory Control functions being performed.
DWB_INV_CNTRL_DOC_LI	INVENTORY CONTROL TRANSACTION DETAIL	A type of Transaction that records Inventory Control detail being performed.
DWB_INV_ITEM_STATE	Inventory Item State	A unit record of a particular Stock Item, held in a particular Inventory Location, in a particular Inventory State and controlled or managed by a particular Revenue Center
DWB_MKT_SLS_ITEM_WK	Market Sales Item Level Week	Contains weekly total sales detail of the market item.
DWB_PCHSE_ORDR	Purchase Order	Information about a Purchase Order that has been placed.
DWB_PCHSE_ORDR_LI	Purchase Order Line Item Base table	Holds Purchase order line information. This table only holds Purchase order lines that have been fully shipped or canceled.
DWB_PCHSE_ORDR_LI_STATE	Purchase Order Line Item State	Record of a Purchase Order line item being in a particular state for a period.
DWB_PCHSE_ORDR_STATE	Purchase Order State	The state of a Purchase Order Line Item during a period.
DWB_PRICE_ITEM_LOC_DAY	Price Item Locaiton Day	Prices by item, location, and day. All values on this table are non-aggregatable.
DWB_PRMTN_ITM	Promotion Item	This entity captures the information about promotion at Item level.
DWB_PRMTN_MEDIA_COST	Promotion Media Cost	The cost of media for promotion.
DWB_PRMTN_PRICE_DRVTN	Promotion Price Derivation	Price for the specific promotion.
DWB_PYMT_ON_ACCT	Retail Transaction Line Item	A detail line item of a Retail Transaction that records the business conducted between the retail store and another party involving the exchange in ownership, accountability, or both for merchandise, tender, or both, or involving the exchange of tender for services.
DWB_RTL_SLS_RETRN_LINE_ITEM	Sale or Return Line Item	Retail Transaction Line Items for sale or return of goods
DWB_RTL_SL_RETRN_PRMTN_LI	Retail Sale Return Promotion Line Item	A detail line item of TRANSACTION that records the crediting or debiting of a CUSTOMER PROMOTIONAL ACCOUNT with points, dollars, or miles.
DWB_RTL_TRX_MISC_LI	Retail Transaction Miscellaneous Line Item	A detail line item of a RetailTransaction which records the business conducted between the retail store and another party involving the exchange in ownership or accountability for merchandise or tender or involving the exchange of tender for services. This table hosts all other retail transaction line items without a specific subentity.
DWB_SKU_ITEM_SLNG_PRICE	SKU Item Selling Price	Selling Price related information for a SKU item at a particular business unit.
DWB_SKU_ITEM_SLNG_PRICE_HIST	SKU Item Selling Price History	The historical archive of the retail-selling unit price at which a given SKU Item was actually sold at POS, net of markdowns, markups and other price changes that modify the cumulative mark on for an SKU item.
DWB_STORE_TRFC_LOC_DAY	Store Traffic Location Day	Holds store traffic data. Store traffic is the number of visitors to a store on a given day.
DWB_TILL_HIST	Till History	A collection of monetary and operational totals used to track the activity volume of a till between Till Settlement Transactions. The period covered by Till History is delineated by a Till Settlement Transaction which, when initiated, sets a Till state to reconciling and, when completed, resets the state of a Till to cleared for business.
DWB_TILL_TAX_HIST	Till Tax History	A collection of tax totals for a tax authority by till for a tender reconciliation period.
DWB_TILL_TNDR_HIST	Till Tender History	A collection of tender type accumulators by till tender accumulation period. This entity is used to support till tender accountability.
DWB_TNDR_CHNG_LI	Tender Change Line Item	Holds details of tender change in a transaction.
DWB_VNDR_SKU_COST_PRFT_DAY	Cost Item Vendor Location Day	Contains cost change information for an item, vendor, and location combination on a given day. All values in this table are non-aggregatable.
DWB_SL_FRCST_ITEM_ORG_HRCHY_WK	ForeCast Item Organization Hierarchy Week	Holds sales forecast information at the Item, location, and week hierarchy level.
DWB_SL_PLAN_ITEM_ORG_HRCHY_WK	Plan Item Organization Hierarchy Week	Plan Item Organization Hierarchy Week

Derived Tables

The Derived tables are described in Table 3-5, "Derived Table Names, Descriptions, and Notes".

Table 3-6, "Source-Target Table Level Mappings for Derived Tables". outlines the source to target table mappings for derived tables.

The scripts that populate the derived tables are described in "Intra-ETL Packages for Populating Derived Tables".

Table 3-5 Derived Table Names, Descriptions, and Notes

Table Name	Description	Notes
DWD_CERTIFICATE_ACTVTY_TRX	Certificate Activity Transaction Derived	This would be populated from retail transaction line item sub type certificate for issue and retail tender line item sub type certificate tender for redemption
DWD_CTLG_RQST_BY_DAY	Catalog Request By Day Derived	Catalog request transactions at the individual catalog request and day level.
DWD_CUST_EMP_RLTNSHP_DAY	Customer Relationship Employee Day Derived	Captures information about employee and customer and loss prevention in that respect in Day level
DWD_CUST_ORDR_ITEM_DAY	Order Item Day Derived	Captures item and day customer order information
DWD_CUST_ORDR_LI_STATE	Customer Order Line Item State Derived	Derived information from Customer Order Line Item State
DWD_CUST_RFMP_SCR	Customer RFMP Value Score	Captures the Recency, Frequency, Monetary, Profitability Value Score of a customer
DWD_CUST_SKU_SL_RETRN_DAY	Frequent Shopper	Holds transaction information regarding customers who are classified as frequent shoppers
DWD_INV_ADJ_BY_ITEM_DAY	Inventory Adjustment by Item Day Derived	Holds the inventory adjustment data at the item-location-day-reason level.
DWD_INV_POSN_BY_ITEM_DAY	Inventory Position by Item Day Derived	Contains end of day inventory levels and status for an item and location combination on a given day. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWD_INV_UNAVL_BY_ITEM_DAY	Inventory Unavailable By Item Day	Fact containing the details of the items marked as nonsellable or unavailable at day level.
DWD_POS_CNTRL	POS TRANSACTION FLOW POS Retail	A set of time-bounded totals used to track the operational performance of a workstation primarily for workforce planning and service level planning. The time-bounded totals typically are for 5, 10 or 15 minute intervals.
DWD_POS_RTL	POS TRANSACTION FLOW Pos Control	A set of time-bounded totals used to track the operational performance of a workstation primarily for workforce planning and service level planning. The time-bounded totals typically are for 5, 10 or 15 minute intervals.
DWD_POS_STORE_FINCL	POS TRANSACTION FLOW POS Store Financial	A set of time-bounded totals used to track the operational performance of a workstation primarily for workforce planning and service level planning. The time-bounded totals typically are for 5, 10 or 15 minute intervals. Information regarding financial operations at the POS
DWD_POS_TNDR_FLOW	POS Tender flow	A historical record of ITEM and TRANSACTION movement by pre-defined time intervals to measure WORKSTATION productivity.
DWD_RTL_SL_RETRN_ITEM_DAY	Sales Returns by Item, Day, and Retail Type	Holds sales and returns information at the item, location, day and retail type level. The `bia_rtl_schema` used by the Oracle Retail Data Model optional OLAP component defines relational views that depends on this table. See "Relational Views Used When Loading the Analytic Workspace" .
DWD_RTV_ITEM_DAY	Inventory Return To Vendor Item Location Day	Holds data on inventory returned to vendor or supplier at the item, location and day level.
DWD_SPACE_UTLZTN_ITEM_DAY	SKU Item Space Day Derived	This would be updated from inventory item state; max and min would be populated from recursive selling location; allocated space is computed from the consumer package size UOM and current unit
DWD_TILL	Tender Repository Derived Till	Holds tender details in different repositories like Safe, Till, or External Depository. A type of TENDER REPOSITORY that is a drawer insert, operationally associated with a WORKSTATION and optionally an EMPLOYEE. It is used to keep cash and other TENDER collected through RETAIL TRANSACTIONS and used to make change.

Table 3-6 Source-Target Table Level Mappings for Derived Tables

Target Table	Source Table (Transaction)
DWD_CERTIFICATE_ACTVTY_TRX	DWB_CERTIFICATE_TNDR DWR_CERTIFICATE
DWD_CTLG_RQST_BY_DAY	DWB_RTL_SLS_RETRN_LINE_ITEM DWR_ORG_BSNS_UNIT
DWD_CUST_EMP_RLTNSHP_DAY	DWB_RTL_SLS_RETRN_LINE_ITEM
DWD_CUST_ORDR_ITEM_DAY	DWB_CUST_ORDR_LI DWB_CUST_ORDR_LI_STATE_ASSIGN DWR_ DAY
DWD_CUST_ORDR_LI_STATE	DWB_CUST_ORDR_LI DWB_CUST_ORDR_LI_STATE_ASSIGN
DWD_CUST_RFMP_SCR	DWB_RTL_SLS_RETRN_LINE_ITEM
DWD_CUST_SKU_SL_RETRN_DAY	DWB_RTL_SLS_RETRN_LINE_ITEM DWB_CUST_ORDR_LI, DWR_USERS DWR_CUST,DWR_CUST_RSTRCTD_INFO DWR _DAY
DWD_INV_ADJ_BY_ITEM_DAY	DWB_INV_ITEM_STATE DWR_SKU_ITEM_SLNG_PRICE DWR_SKU_ITEM,DWR _DAY
DWD_INV_POSN_BY_ITEM_DAY	DWB_INV_ITEM_STATE DWB_INV_CNTRL_DOC_LI DWB_RCVNG_DOC DWB_PRICING_ITEM_LOC_DAY DWR_DAY
DWD_INV_UNAVL_BY_ITEM_DAY	DWB_INV_ITEM_STATE DWR_SKU_ITEM_SLNG_PRICE, DWR_SKU_ITEM, DWR_DAY
DWD_POS_CNTRL	DWB_TILL_HIST DWB_RTL_TRX DWB_TILL_TNDR_HIST DWR_EMP
DWD_POS_RTL	DWB_TILL_HIST DWB_RTL_TRX DWR_EMP
DWD_POS_STORE_FINCL	DWB_TILL_TNDR_HIST DWB_TILL_HIST DWB_RTL_TRX DWR_EMP
DWD_POS_TNDR_FLOW	DWB_CHECK_TNDR DWB_RTL_TRX
DWD_RTL_SL_RETRN_ITEM_DAY	DWB_RTL_SLS_RETRN_LINE_ITEM DWB_DISC_LI DWB_RTL_TRX DWB_CR_DEBIT_CARD_TNDR
DWD_RTV_ITEM_DAY	DWB_PCHSE_ORDR_LI DWB_PCHSE_ORDR_LI_STATE DWR_ DAY
DWD_SPACE_UTLZTN_ITEM_DAY	DWB_RTL_SLS_RETRN_LINE_ITEM DWB_DISC_LI DWR_SLNG_LOC

Aggregate Tables and Relational Materialized Views

The Aggregate tables and relational materialized views are described in Table 3-7, "Aggregate Table and Relational Materialized Views Names, Descriptions, and Notes"..

Table 3-8, "Source to Target Mapping for Aggregate Tables". outlines the source to target table mappings for aggregate tables.

The scripts for defining and populating aggregate tables and relational materialized views are described in "Intra-ETL Scripts for Populating Aggregate Tables and Relational Materialized Views".

Table 3-7 Aggregate Table and Relational Materialized Views Names, Descriptions, and Notes

Name	Description	Notes
DWA_CARRIER_CMPLNC_WK_MV	Carrier Compliance Week Aggregate Relational Materialized View	Record of a carrier's delivery performance during a given week. Delivery performance is measured by how many times they were late, early or on-time, and how late or early they were in hours or days
DWA_CERTIFICATE_ACTVTY_DAY_MV	Certificate Activity Day Aggregate Relational Materialized View	Day Aggr of Certificate Activity Transaction Derived
DWA_CERTIFICATE_ACTVTY_WK_MV	Certificate Activity Week Aggregate Relational Materialized View	Week Aggr of Certificate Activity Transaction Derived
DWA_CUST_EMP_RLTNSHP_MO_MV	Customer Employee Relationship Month Relational Materialized View	Captures monthly information regarding information about employee and customer and loss prevention.
DWA_CUST_EMP_SL_RETRN_MO_MV	Customer Employee Sale Return Month Aggregate Relational Materialized View	Month Aggregation of Customer SKU Sale Return Derived
DWA_CUST_EMP_SL_RETRN_WK_MV	Customer Employee Sale Return Month Relational Materialized View	Captures sale return transaction level at Customer, Employee and week level.
DWA_CUST_ORDR_DEPT_DAY_MV	Order Department Day Aggregate Relational Materialized View	Captures department and day customer order information
DWA_CUST_ORDR_ITEM_MO_MV	Order Department Month Aggregate Relational Materialized View	Captures department and month customer order information
DWA_CUST_ORDR_ITEM_WK_MV	Order Item Week Aggregate Relational Materialized View	Captures item and week customer order information
DWA_CUST_ORDR_SBC_DAY_MV	Order Subclass Day Aggregate Relational Materialized View	Captures customer order information by subclass, day
DWA_CUST_ORDR_SBC_MO_MV	Order Subclass Month Aggregate Relational Materialized View	Captures customer order information by subclass, month
DWA_CUST_ORDR_SBC_WK_MV	Order Subclass Week Aggregate Relational Materialized View	Captures customer order information by subclass, week
DWA_INV_BDGT_BY_WK	Inventory Budget By Week Aggregate	Holds information regarding the budgeted quantity and cost of the inventory
DWA_INV_ITEM_STATE_HIST_WK_MV	Inventory Item State History Week Relational Materialized View	Weekly historical data regarding the item state
DWA_INV_POSN_BY_DEPT_DAY_MV	Inventory Position by Department Day Aggregate Relational Materialized View	Contains end of day inventory levels and status for a department, location, and retail type combination on a given day.
DWA_INV_POSN_BY_DEPT_WK_MV	Inventory Position by Department Week Aggregate	Contains end of week inventory levels and status for a department, location, and retail type combination on a given week.
DWA_INV_POSN_BY_ITEM_WK_MV	Inventory Position by Item Week Aggregate Relational Materialized View	Contains end of day inventory levels and status for an item and location combination for a given week.
DWA_INV_POSN_BY_SBC_DAY_MV	Inventory Position By Subclass Day Aggregate Relational Materialized View	Holds end of day inventory levels and status for a subclass, location, product season, and retail type combination on a given day.
DWA_INV_POSN_BY_SBC_WK_MV	Inventory Position By Subclass Week Aggregate Relational Materialized View	Contains end of week inventory levels and status for a subclass, location, product season, and retail type combination on a given week.
DWA_INV_RCPT_BY_ITEM_DAY_MV	Inventory Receipt by Item Day Aggregate Relational Materialized View	Holds inventory receipts at the Item, location and day level.
DWA_INV_RCPT_BY_ITEM_WK_MV	Inventory Receipt by Item Week Aggregate Relational Materialized View	Holds inventory receipts at the Item, location and week level.
DWA_INV_RCPT_BY_SBC_DAY_MV	Inventory Receipt by SubClass Day Aggregate Relational Materialized View	Holds inventory receipts at the subclass, location and day level.
DWA_INV_RCPT_BY_SBC_WK_MV	Inventory Receipt by SubClass Week Aggregate Relational Materialized View	Holds inventory receipts at the subclass, location and week level.
DWA_INV_TRNSFR_BY_ITEM_DAY_MV	Inventory Transfer By Item Day Aggregate Relational Materialized View	Holds inventory transfers at the item, to location, from location, transfer type, and day level.
DWA_INV_TRNSFR_BY_ITEM_WK_MV	Inventory Transfer By Item Week Aggregate Relational Materialized View	Holds inventory transfers at the item, to location, from location, transfer type, and week level.
DWA_INV_TRNSFR_BY_SBC_DAY_MV	Inventory Transfer By Subclass Day Aggr Relational Materialized View	Aggregate fact containing Inventory transfer details at Subclass and Day level.
DWA_MKT_SLS_DEPT_WK_MV	Inventory Transfer By Subclass Week Aggr Relational Materialized View	Contains weekly total sales detail of the market item (by department).
DWA_PRMTN_COST_CNTRBTN_WK	Promotion Cost Contribution	Contribution of items in promotion
DWA_PRMTN_SLS_MRGN_WK	Promotion Sales margin Week Aggr	Information regarding sales and margin of items in promotion
DWA_RTL_MRKDN_DEPT_DAY_MV	Retail Markdown Department Day Aggregate Materialized View	Holds department markdown details at day level.
DWA_RTL_MRKDN_DEPT_WK_MV	Retail Markdown Department Week Aggregate Materialized View	Holds department markdown details at week level.
DWA_RTL_MRKDN_ITEM_DAY_MV	Retail Markdown Item Day Aggregate Materialized View	Holds item markdown details at day level.
DWA_RTL_SL_RETRN_DEPT_DAY_MV	Retail Sale Return Department Day Aggr Materialized View	Holds sales and returns information at the department, location, day, and retail type level.
DWA_RTL_SL_RETRN_DEPT_WK_MV	Retail Sale Return Department Day Aggr Materialized View	Holds sales and returns information at the department, location, week, and retail type level.
DWA_RTL_SL_RETRN_ITEM_MO_MV	Retail Sale Return Item Month Aggregate Materialized View	Holds sales and returns information at the item, location, month and retail type level.
DWA_RTL_SL_RETRN_ITEM_WK_MV	Retail Sale Return Item Week Aggregate Materialized View	Holds sales and returns information at the item, location, week and retail type level.
DWA_RTL_SL_RETRN_ORG_HRCHY_DAY	Retail Sale Return Organization Hierarchy Day table	Holds information regarding item sale and return (by day).
DWA_RTL_SL_RETRN_SBC_DAY_MV	Retail Sale Return Subclass Day Aggregate Materialized View	Holds sales and returns information at the subclass, location, day and retail type level.
DWA_RTL_SL_RETRN_SBC_MO_MV	Retail Sale Return Subclass Month Aggregate Materialized View	Holds sales and returns information at the subclass, location, month and retail type level.
DWA_RTL_SL_RETRN_SBC_WK_MV	Retail Sale Return Subclass Week Aggregate Materialized View	Holds sales and returns information at the subclass, location, week and retail type level.
DWA_RTL_SL_RT_ORG_HRCHY_DAY_MV	Retail Sale Return Organization Hierarchy Day Materialized View	Holds information regarding item sale and return (by day).
DWA_RTL_TRX_EMP_WRKSTN_MV	Retail Transaction Employee Workstation Aggregate Materialized View	Records the Employee and the workstation involved in serving the customer purchasing the merchandise or services identified in the Retail Transaction.
DWA_SPACE_UTLZTN_DEPT_DAY_MV	Space Allocation Department Loc Day Materialized View	Holds the information about the amount of space allocated for each department at a particular location.The space is measured in one, two or three dimensional space (linear, square, cubic).
DWA_STCK_LDGR_BY_SBC_MO	Inventory Value Subclass Location Month	Contains the inventory values such as Beginning and Ending Stock on Hand, Cost amounts, or Markdown Values at Subclass, Location, and Month Level.
DWA_STCK_LDGR_BY_SBC_WK	Inventory Value Subclass Location Week	Contains the inventory values such as Beginning and Ending Stock on Hand, Cost amounts, or Markdown Values at Subclass, Location, and Week Level.
DWA_TILL_HIST_WRKSTN_MV	Till History Workstation Aggregate Relational Materialized View	Holds till history for workstation.
DWA_TILL_TNDR_HIST_EMP_MV	Till Tender History Employee Aggregate Relational Materialized View	A collection of tender type accumulators by till tender accumulation period and employee. This entity is used to support till tender accountability.
DWA_VNDR_AVLBLTY_ITEM_DAY	Vendor Availability Item Day Aggr	Objective of this entity is to support Reports. Table data is populated from Purchase Order
DWA_VNDR_CMPLNC_ITEM_WK_MV	Relational Materialized View	Holds timeliness, quantity and quality control supplier compliance information at the item-location-week-shipment-po level.
DWA_VNDR_CMPLNC_WK_MV	Relational Materialized View	Holds timeliness, quantity and quality control supplier compliance information at the location-week-shipment-po level.
DWA_VNDR_CNTRCT_ITEM_DAY	Vendor Contract Item Day Aggr	Objective of this entity is to support Reports Table data is populated from Purchase Order

Table 3-8 Source to Target Mapping for Aggregate Tables

Target Table Name	Source Table Names
DWA_CUST_EMP_SL_RETRN_WK	DWD_CUST_SKU_SL_RETRN_DAY DWR_DAY
DWA_CUST_ORDR_ITEM_WK	DWD_CUST_ORDR_ITEM_DAY DWR_DAY
DWA_CUST_ORDR_SBC_DAY	DWD_CUST_ORDR_ITEM_DAY DWR_SKU_ITEM
DWA_INV_RCPT_BY_ITEM_WK	DWA_INV_RCPT_BY_ITEM_DAY DWR_DAY
DWA_INV_RCPT_BY_SBC_DAY	DWA_INV_RCPT_BY_ITEM_DAY DWR_SKU_ITEM
DWA_INV_TRNSFR_BY_ITEM_WK	DWA_INV_TRNSFR_BY_ITEM_DAY DWR_DAY
DWA_INV_TRNSFR_BY_SBC_DAY	DWA_INV_TRNSFR_BY_ITEM_DAY DWR_SKU_ITEM
DWA_RTL_MRKDN_ITEM_DAY	DWD_RTL_SL_RETRN_ITEM_DAY
DWA_RTL_SL_RETRN_ITEM_WK	DWD_RTL_SL_RETRN_ITEM_DAY DWR_DAY
DWA_RTL_SL_RETRN_SBC_DAY	DWD_RTL_SL_RETRN_ITEM_DAY DWR_SKU_ITEM
DWA_RTL_TRX_EMP_WRKSTN	DWB_TILL_HIST DWR_DAY DWB_TILL_TNDR_HIST DWD_POS_CNTRL DWD_POS_RTL
DWA_SPACE_UTLZTN_DEPT_DAY	DWD_SPACE_UTLZTN_ITEM_DAY DWR_SKU_ITEM DWR_SEASON
DWA_TILL_HIST_WRKSTN	DWB_TILL_HIST DWV_TIME_DAY DWR_EMP
DWA_TILL_TNDR_HIST_EMP	DWB_TILL_TNDR_HIST DWR_EMP DWR_USERS
DWA_INV_POSN_BY_ITEM_WK	DWD_INV_POSN_BY_ITEM_DAY DWR_DAY
DWA_INV_POSN_BY_SBC_DAY	DWD_INV_POSN_BY_ITEM_DAY DWR_SKU_ITEM
DWA_CERTIFICATE_ACTVTY_DAY	DWD_CERTIFICATE_ACTVTY_TRX
DWA_CARRIER_CMPLNC_WK	DWB_INV_CNTRL_DOC DWB_INV_CNTRL_DOC_LI DWR_DAY
DWA_CUST_EMP_RLTNSHP_MO	DWD_CUST_EMP_RLTNSHP_DAY DWR_DAY DWR_CUST
DWA_INV_ITEM_STATE_HIST_WK	DWB_INV_ITEM_STATE DWR_DAY
DWA_INV_RCPT_BY_ITEM_DAY	DWB_INV_CNTRL_DOC_LI DWB_INV_CNTRL_DOC DWR_SKU_ITEM_SLNG_PRICE DWR_SKU_ITEM DWR_DAY DWR_ITEM_SEASON
DWA_INV_TRNSFR_BY_ITEM_DAY	DWB_INV_CNTRL_DOC DWB_INV_CNTRL_DOC_LI DWR_DAY DWR_SKU_ITEM_SLNG_PRICE DWR_SKU_ITEM DWR_ITEM_SEASON
DWA_CUST_EMP_SL_RETRN_MO	DWD_CUST_SKU_SL_RETRN_DAY DWR_DAY DWR_BSNS_WK
DWA_CUST_ORDR_DEPT_DAY	DWD_CUST_ORDR_ITEM_DAY DWR_SKU_ITEM DWR_ITEM_SBC
DWA_CUST_ORDR_ITEM_MO	DWD_CUST_ORDR_ITEM_DAY DWR_DAY DWR_BSNS_WK
DWA_CUST_ORDR_SBC_WK	DWD_CUST_ORDR_ITEM_DAY DWR_SKU_ITEM DWR_DAY
DWA_INV_RCPT_BY_SBC_WK	DWA_INV_RCPT_BY_ITEM_DAY, DWR_SKU_ITEM,DWR_DAY
DWA_INV_TRNSFR_BY_SBC_WK	DWA_INV_TRNSFR_BY_ITEM_DAY, DWR_SKU_ITEM, DWR_DAY
DWA_RTL_MRKDN_DEPT_DAY	DWD_RTL_SL_RETRN_ITEM_DAY, DWR_SKU_ITEM
DWA_RTL_MRKDN_ITEM_WK	DWD_RTL_SL_RETRN_ITEM_DAY, DWV_TIME_DAY
DWA_RTL_SL_RETRN_DEPT_DAY	DWD_RTL_SL_RETRN_ITEM_DAY, DWR_SKU_ITEM,DWR_ITEM_SBC
DWA_RTL_SL_RETRN_ITEM_MO	DWD_RTL_SL_RETRN_ITEM_DAY, DWR_DAY, DWR_BSNS_WK
DWA_RTL_SL_RETRN_SBC_WK	DWD_RTL_SL_RETRN_ITEM_DAY, DWR_DAY, DWR_SKU_ITEM
DWA_INV_POSN_BY_SBC_WK	DWD_INV_POSN_BY_ITEM_DAY, DWR_SKU_ITEM,DWR_DAY
DWA_INV_POSN_BY_DEPT_DAY	DWD_INV_POSN_BY_ITEM_DAY, DWR_SKU_ITEM
DWA_RTL_SL_RETRN_ORG_HRCHY_DAY	DWD_RTL_SL_RETRN_ITEM_DAY, DWR_SKU_ITEM, DWR_ITEM_SBC
DWA_RTL_MRKDN_DEPT_WK	DWD_RTL_SL_RETRN_ITEM_DAY, DWR_SKU_ITEM,DWR_DAY
DWA_RTL_SL_RETRN_DEPT_WK	DWD_RTL_SL_RETRN_ITEM_DAY, DWR_SKU_ITEM, DWR_ITEM_SBC, DWR_DAY
DWA_RTL_SL_RETRN_SBC_MO	DWD_RTL_SL_RETRN_ITEM_DAY, DWR_DAY, DWR_BSNS_WK DWR_SKU_ITEM
DWA_CUST_ORDR_SBC_MO	DWD_CUST_ORDR_ITEM_DAY DWR_SKU_ITEM DWR_DAY DWR_BSNS_WK
DWA_INV_POSN_BY_DEPT_WK	DWD_INV_POSN_BY_ITEM_DAY DWR_SKU_ITEM DWR_ITEM_SBC DWR_DAY
DWA_CERTIFICATE_ACTVTY_WK	DWD_CERTIFICATE_ACTVTY_TRX DWR_DAY
DWA_CUST_ORDR_DEPT_MO	DWD_CUST_ORDR_ITEM_DAY DWR_SKU_ITEM DWR_DAY DWR_BSNS_WK DWR_ITEM_SBC
DWA_MKT_SLS_DEPT_WK	DWB_MKT_SLS_ITEM_WK DWR_ITEM_MKT_DATA

Physical Data Model of the Data Mining Component

When you have the Data Mining component of Oracle Retail Data Model installed, Oracle Retail Data Model creates data mining models. The physical model of the Oracle Retail Data Model Data Mining component is defined bia_rtl_mining schema. The definitions in that schema include definitions for tables and views.

Tables defined in the bia_rtl_mining schema

The definitions in the schema include definitions for tables that have name ending in "_SRC" (for example, ASSOCIATE_LOSS_SRC and CUST_CATEGORY_MIX_SRC). These tables contain source input data for the data mining models.

Views defined in the bia_rtl_mining schema

After you create the mining models, the following database views are created that hold the information used for accessing the mining rules and signatures for each data mining model:

For the models corresponding to type ABN and DT, Oracle Retail Data Model has two views. One view corresponds to the Model Signature. The other view corresponds to the Model Rules. These target views are defined based on two tables: RBIW_DM_MODEL_SIGN and RBIW_DM_RULES.
For the models corresponding to type APASS, Oracle Retail Data Model has a single view corresponding to the Model Rules (Association details) with additional attributes which serve to qualify the Rule (Category Basket). These views are based on the table: RBIW_DM_APASS_RULES.

Target views are selections on a generic model rules table based on a particular model. There is one target view for each model. Within the target view, the performance measure column contains the name or entry for the target variable used by the model.

The models for each type of analysis and the corresponding views containing the model rules are outlined in Table 3-9, "Data Mining Model and Views Containing Model Rules".

Table 3-9 Data Mining Model and Views Containing Model Rules

Data Mining Model (Analysis)	Model Type	View Containing Model Rules
Associate Basket Analysis Model	ABN, DT	ASSOCIATE_BASKET_RULES
Associate Loss Analysis Model	ABN, DT	ASSOCIATE_LOSS_RULES
Associate Sales Analysis Model	ABN, DT	ASSOCIATE_SALES_RULES
Customer Category Mix Analysis Model	ABN, DT	CUST_CATEGORY_MIX_RULES
Customer Category Mix Analysis Model	APASS	CUST_CATEGORY_MIX_APASS_RULES
Customer Loyalty Analysis Model	ABN, DT	CUSTOMER_LOYALTY_RULES
Frequent Shopper Category Mix Analysis Model	ABN,DT	FS_CATEGORY_MIX_RULES
Frequent Shopper Category Mix Analysis Model	APASS	FS_CATEGORY_MIX_APASS_RULES
Item Basket Analysis Model	ABN, DT	ITEM_BASKET_RULES
Item POS Loss Analysis Model	ABN, DT	ITEM_POS_LOSS_RULES
POS Flow Analysis Model	ABN, DT	POS_FLOW_RULES
Store Loss Analysis Model	ABN, DT	STORE_LOSS_RULES

Physical Data Model of the OLAP Component

When you have the OLAP component of Oracle Retail Data Model installed, your Oracle Retail Data Model data warehouse includes OLAP multidimensional cubes that support OLAP analysis and forecasting

The physical model of the Oracle Retail Data Model OLAP component is defined by the bia_rtl_olap schema. The defintions in that schema include definitions for:

Analytic Workspaces Used by the OLAP Component
OLAP Data Model in Oracle Retail Data Model
Relational Views Used for the OLAP Component

Analytic Workspaces Used by the OLAP Component

An analytic workspace is a container for storing related OLAP cubes. Analytic workspaces are stored in tables in the Oracle database. The names of these tables always begin with AW$.

The analytic workspaces used in the Oracle Retail Data Model OLAP environment vary depending on whether you are working with Oracle Database 10g or Oracle Database 11g:

Analytic Workspaces for Oracle Retail Data Model with Oracle Database 10g
Analytic Workspaces for Oracle Retail Data Model with Oracle Database 11g

Analytic Workspaces for Oracle Retail Data Model with Oracle Database 10g

The Oracle Retail Data Model OLAP environment for Oracle Database 10g Release 2 is managed through two analytic workspaces:

ESLSINV: Inactive analytic workspace (Repository or Backup)

ESLSINV is the structural analytic workspace without any data loaded in it.
PSLSINV: Active analytic workspace (Production)

PSLSINV is the active analytic workspace with the data loaded in it. OLAP Reporting occurs off this analytic workspace.

Analytic Workspaces for Oracle Retail Data Model with Oracle Database 11g

OLAP metada in Oracle 11g Release 1 does not support the use of multiple analytic workspaceswith the same structure or OLAP model to exist in the same schema. Consequently, the Oracle Retail Data Model OLAP environment for Oracle Database 11g Release 1 is managed through a single analytic workspace:

PSLSINV: Active analytic workspace (Production).

PSLSINV is the active analytic workspace with the data loaded in it. OLAP Reporting occurs off this analytic workspace.

OLAP Data Model in Oracle Retail Data Model

The dimensional data model is an integral part of On-Line Analytical Processing, or 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.

OLAP Dimensions in Oracle Retail Data Model

There are three dimensions:

Organization
Product
Time

Tip:

Changed or new dimensions are not supported by Oracle Retail Data Model. Consequently, do not change the dimensions that are defined and delivered with Oracle Retail Data Model, but, instead, define new ones.

Organization

The organization dimension has three hierarchies:

Organization
Organization Division
Organization Banner

Table 3-10, "Organization Dimension" lists the levels in the organization dimension.

Table 3-10 Organization Dimension

S. No.	LEVEL	Organization Hierarchy (HORG)	Organization Division Hierarchy (HDIVISION)	Organization Banner Hierarchy (HBANNER)
1.	TORG (Total Organization)	TORG	TORG	TORG
2.	BANNER (Banner)			BANNER
3.	DIVISION (Division)		DIVISION
4.	COMPANY (Company)	COMPANY
5.	CHAIN (Chain)	CHAIN
6.	AREA (Area)	AREA
7.	REGION (Region)	REGION
8.	DISTRICT (District)	DISTRICT
9.	STORE (Store)	STORE	STORE	STORE

Figure 3-1 Organization Dimension

Description of "Figure 3-1 Organization Dimension"

Product

The product dimension has two hierarchies:

Product
Product Cluster

Table 3-11, "Product Dimension" lists the levels in the organization dimension.

Table 3-11 Product Dimension

S. No.	LEVEL	Product Hierarchy (HPROD)	Product Cluster Hierarchy (HPCLUSTER)
1.	TPROD (Total Product)	TPROD	TPROD
2.	PCLUSTER (Product Cluster)		PCLUSTER
3.	COMPANY (Company)	COMPANY
4.	DIVISION (Division)	DIVISION
5.	GROUP^Foot 1 (Group)	GROUP
6.	DEPT (Department)	DEPT
7.	CLASS (Class)	CLASS
8.	SUBCLASS (Sub Class)	SUBCLASS
9.	ITEM (Item)	ITEM	ITEM
10.	SKU (SKU Item)	SKU	SKU

^Footnote 1For 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.

Figure 3-2 Product Dimension

Description of "Figure 3-2 Product Dimension"

Time

The time dimension has three hierarchies.

Time Business
Time Calendar
Time Calendar Week

Table 3-12, "Time Dimension" lists the levels in the organization dimension.

Table 3-12 Time Dimension

S. No.	LEVEL	Time Business Hierarchy (HTBSNS)	Time Calendar Hierarchy (HTCLNDR)	Time Calendar Week Hierarchy (HTCLNDRWK)
1.	TTIME (Total Time)	TTIME	TTIME	TTIME
2.	CLNDR_YR (Calendar Year)		CLNDR_YR
3.	CLNDR_HLF_YR (Calendar Half Year)		CLNDR_HLF_YR
4.	CLNDR_QTR (Calendar Quarter)		CLNDR_QTR
5.	CLNDR_MO (Calendar Month)		CLNDR_MO
6.	CLNDR_HLF_MO (Calendar Half Month)		CLNDR_HLF_MO
7.	CLNDR_WK (Calendar Week)			CLNDR_WK
8.	BSNS_YR (Business Year)	BSNS_YR
9.	BSNS_HLF_YR (Business Half Year)	BSNS_HLF_YR
10.	BSNS_QTR (Business Quarter)	BSNS_QTR
11.	BSNS_MO (Business Month)	BSNS_MO
12.	BSNS_HLF_MO (Business Half Month)	BSNS_HLF_MO
13.	BSNS_WK (Business Week)	BSNS_WK
14.	DAY (Day)	DAY	DAY	DAY

Figure 3-3 Time Dimension

Description of "Figure 3-3 Time Dimension"

OLAP Cubes and Measures in Oracle Retail Data Model

There are four OLAP cubes that store measures. These are the:

Sales Cube
Sales Forecast Cube
Inventory Cube
Inventory Forecast Cube

Sales Cube

The Sales cube, named OOS_SALES, contains 4 stored measure and 52 calculated measures.

Table 3–13, " Measures in the Sales Cube" describes the measures that are in the OOS_SALES cube.

Table 3-13 Measures in the Sales Cube

Measure Name	Measure Description	Measure Type	Data Type
S_VALUE	Sales Value	CALCULATED	DECIMAL
S_VALUE_YTD	Sales Value YTD	CALCULATED	NUMBER
S_VALUE_YTD_LY	Sales Value YTD Last Year	CALCULATED	DECIMAL
S_VALUE_YTD_LY_PCT_CHG	Sales Value YTD % Chg Last Year	CALCULATED	DECIMAL
S_VALUE_YTD_LY_CHG	Sales Value YTD Chg Last Year	CALCULATED	DECIMAL
S_VALUE_RANK_U	Sales Value Rank Unique	CALCULATED	INTEGER
S_VALUE_RANK_NU	Sales Value Rank Non-Unique	CALCULATED	INTEGER
S_VALUE_PROD_SHR_TOT	Sales Value Share of Total Prod	CALCULATED	DECIMAL
S_VALUE_PROD_SHR_PRNT	Sales Value Share of Prod Parent	CALCULATED	NUMBER
S_VALUE_PROD_SHR_DEPT	Sales Value Share of Prod Dept	CALCULATED	NUMBER
S_VALUE_ORG_TIME_RANK_UNAL	Sales Value Org Time Rank Unique	CALCULATED	INTEGER
S_VALUE_ORG_SHR_TOT	Sales Value Share of Total Org	CALCULATED	DECIMAL
S_VALUE_ORG_SHR_PRNT	Sales Value Share of Org Parent	CALCULATED	NUMBER
S_VALUE_ORG_SHR_AREA	Sales Value Share of Org Area Ancestor	CALCULATED	NUMBER
S_VALUE_ORG_RANK_U	Sales Value Org Rank Unique	CALCULATED	INTEGER
S_VALUE_ORG_RANK_UNAL	Sales Value Org Rank Unique NALAST	CALCULATED	INTEGER
S_VALUE_ORG_RANK_UNAF	Sales Value Org Rank Unique NAFIRST	CALCULATED	INTEGER
S_VALUE_LY	Sales Value Last Year	CALCULATED	DECIMAL
S_VALUE_LY_PCT_CHG	Sales Value % Chg Last Year	CALCULATED	DECIMAL
S_VALUE_LY_CHG	Sales Value Change Last Year	CALCULATED	DECIMAL
S_VALUE_LP	Sales Value Last Period	CALCULATED	DECIMAL
S_VALUE_LP_PCT_CHG	Sales Value % Chg Last Period	CALCULATED	DECIMAL
S_VALUE_LP_CHG	Sales Value Change Last Period	CALCULATED	DECIMAL
S_UNITS	Sales Units	CALCULATED	INTEGER
S_UNITS_YTD	Sales Units YTD	CALCULATED	NUMBER
S_UNITS_YTD_LY	Sales Units YTD Last Year	CALCULATED	INTEGER
S_UNITS_YTD_LY_PCT_CHG	Sales Units YTD % Chg Last Year	CALCULATED	DECIMAL
S_UNITS_YTD_LY_CHG	Sales Units YTD Chg Last Year	CALCULATED	INTEGER
S_UNITS_RANK_U	Sales Units Rank Unique	CALCULATED	INTEGER
S_UNITS_RANK_NU	Sales Units Rank Non-Unique	CALCULATED	INTEGER
S_UNITS_PROD_SHR_TOT	Sales Units Share of Total Prod	CALCULATED	DECIMAL
S_UNITS_PROD_SHR_PRNT	Sales Units Share of Prod Parent	CALCULATED	NUMBER
S_UNITS_PROD_SHR_DEPT	Sales Units Share of Prod Dept	CALCULATED	NUMBER
S_UNITS_ORG_TIME_RANK_UNAL	Sales Units Org Time Rank Unique	CALCULATED	INTEGER
S_UNITS_ORG_SHR_TOT	Sales Units Share of Total Org	CALCULATED	DECIMAL
S_UNITS_ORG_SHR_PRNT	Sales Units Share of Org Parent	CALCULATED	NUMBER
S_UNITS_ORG_SHR_AREA	Sales Units Share of Org Area Ancestor	CALCULATED	NUMBER
S_UNITS_ORG_RANK_U	Sales Units Org Rank Unique	CALCULATED	INTEGER
S_UNITS_ORG_RANK_UNAL	Sales Units Org Rank Unique NALAST	CALCULATED	INTEGER
S_UNITS_ORG_RANK_UNAF	Sales Units Org Rank Unique NAFIRST	CALCULATED	INTEGER
S_UNITS_LY	Sales Units Last Year	CALCULATED	INTEGER
S_UNITS_LY_PCT_CHG	Sales Units % Chg Last Year	CALCULATED	DECIMAL
S_UNITS_LY_CHG	Sales Units Change Last Year	CALCULATED	INTEGER
S_UNITS_LP	Sales Units Last Period	CALCULATED	INTEGER
S_UNITS_LP_PCT_CHG	Sales Units % Chg Last Period	CALCULATED	DECIMAL
S_UNITS_LP_CHG	Sales Units Change Last Period	CALCULATED	INTEGER
RETURN_VALUE	Return Value	STORED	DECIMAL
RETURN_UNITS	Return Units	STORED	INTEGER
HOW_IS_S_VALUE_YTD_G_YOY	How is Sales Value YTD Growth YoY	CALCULATED	TEXT
HOW_IS_S_VALUE_G_YOY	How is Sales Value Growth YoY	CALCULATED	TEXT
HOW_IS_S_VALUE_G_POP	How is Sales Value Growth PoP	CALCULATED	TEXT
HOW_IS_S_UNITS_YTD_G_YOY	How is Sales Units YTD Growth YoY	CALCULATED	TEXT
HOW_IS_S_UNITS_G_YOY	How is Sales Units Growth YoY	CALCULATED	TEXT
HOW_IS_S_UNITS_G_POP	How is Sales Units Growth PoP	CALCULATED	TEXT
GROSS_SALES_VALUE	Gross Sales Value	STORED	DECIMAL
GROSS_SALES_UNITS	Gross Sales Units	STORED	INTEGER

Sales Forecast Cube

The Sales Forecast cube, named OOS_SALES_FCST, contains 34 stored measures and 30 calculated measures.

Table 3–14, " Measures in the Sales Forecast Cube" describes the measures that are in the OOS_SALES_FST cube.

Table 3-14 Measures in the Sales Forecast Cube

Measure Name	Measure Description	Measure Type	Data Type
SALES_VALUE_TREND_10	Sales Value Trend Forecast	STORED	DECIMAL
SALES_VALUE_TREND_10_WKENDDAY	Sales Value Trend (Weekend Days) Forecast	STORED	DECIMAL
SALES_VALUE_TREND_10_WKDAY	Sales Value Trend (Week Days) Forecast	STORED	DECIMAL
SALES_VALUE_MAVG_50	Sales Value Moving Average 500 Forecast	STORED	DECIMAL
SALES_VALUE_MAVG_3	Sales Value Moving Average 3 Forecast	STORED	DECIMAL
SALES_VALUE_MAVG_10	Sales Value Moving Average 10 Forecast	STORED	DECIMAL
SALES_VALUE_MAVG_10_WKENDDAY	Sales Value Moving Average 10 (Weekend Days) Forecast	STORED	DECIMAL
SALES_VALUE_MAVG_10_WKDAY	Sales Value Moving Average 10 (Week Days) Forecast	STORED	DECIMAL
SALES_VALUE_HW_364	Sales Value Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	DECIMAL
SALES_VALUE_HW_364_WKENDDAY	Sales Value Holt-Winters Forecast (weekend days) using 364 time periods periodicity	STORED	DECIMAL
SALES_VALUE_HW_364_WKDAY	Sales Value Holt-Winters Forecast (weekdays) using 364 time periods periodicity	STORED	DECIMAL
SALES_VALUE_HW_364_05E_1	Sales Value Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	DECIMAL
SALES_VALUE_HW_364_05E_1_WKEND	Sales Value Holt-Winters Forecast (weekend days) using 364 time periods periodicity	STORED	DECIMAL
SALES_VALUE_HW_364_05E_1_WKDAY	Sales Value Holt-Winters Forecast (weekdays) using 364 time periods periodicity	STORED	NUMBER
SALES_VALUE_EXPO_10	Sales Value Exponential Forecast	STORED	DECIMAL
SALES_VALUE_EXPO_10_WKENDDAY	Sales Value Exponential (Weekend Days) Forecast	STORED	DECIMAL
SALES_VALUE_EXPO_10_WKDAY	Sales Value Exponential (Week Days) Forecast	STORED	DECIMAL
SALES_UNITS_TREND_10	Sales Units Trend Forecast	STORED	INTEGER
SALES_UNITS_TREND_10_WKENDDAY	Sales Units Trend (Weekend Days) Forecast	STORED	INTEGER
SALES_UNITS_TREND_10_WKDAY	Sales Units Trend (Week Days) Forecast	STORED	INTEGER
SALES_UNITS_MAVG_50	Sales Units Moving Average 500 Forecast	STORED	INTEGER
SALES_UNITS_MAVG_3	Sales Units Moving Average 3 Forecast	STORED	INTEGER
SALES_UNITS_MAVG_10	Sales Units Moving Average 10 Forecast	STORED	INTEGER
SALES_UNITS_MAVG_10_WKENDDAY	Sales Units Moving Average 10 (Weekend Days) Forecast	STORED	INTEGER
SALES_UNITS_MAVG_10_WKDAY	Sales Units Moving Average 10 (Week Days) Forecast	STORED	INTEGER
SALES_UNITS_HW_364	Sales Units Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	INTEGER
SALES_UNITS_HW_364_WKENDDAY	Sales Units Holt-Winters Forecast (Weekend days) using 364 time periods periodicity	STORED	INTEGER
SALES_UNITS_HW_364_WKDAY	Sales Units Holt-Winters Forecast (Week days) using 364 time periods periodicity	STORED	INTEGER
SALES_UNITS_HW_364_05E_1	Sales Units Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	INTEGER
SALES_UNITS_HW_364_05E_1_WKEND	Sales Units Holt-Winters Forecast (Weekend days) using 364 time periods periodicity	STORED	INTEGER
SALES_UNITS_HW_364_05E_1_WKDAY	Sales Units Holt-Winters Forecast (Week days) using 364 time periods periodicity	STORED	INTEGER
SALES_UNITS_EXPO_10	Sales Units Exponential Forecast	STORED	INTEGER
SALES_UNITS_EXPO_10_WKENDDAY	Sales Units Exponential (Weekend Days) Forecast	STORED	INTEGER
SALES_UNITS_EXPO_10_WKDAY	Sales Units Exponential (Week Days) Forecast	STORED	INTEGER
OOS_UNITS_TREND_10	Units Out-of-Stock: Trend	CALCULATED	INTEGER
OOS_UNITS_TREND_10_WKE	Units Out-of-Stock: Weekend Trend	CALCULATED	INTEGER
OOS_UNITS_TREND_10_WKE_SITU	Units Out-of-Stock Situation: Weekend Trend	CALCULATED	TEXT
OOS_UNITS_TREND_10_WKD	Units Out-of-Stock: Weekday Trend	CALCULATED	INTEGER
OOS_UNITS_TREND_10_WKD_SITU	Units Out-of-Stock Situation: Weekday Trend	CALCULATED	TEXT
OOS_UNITS_TREND_10_SITU	Units Out-of-Stock Situation: Trend	CALCULATED	TEXT
OOS_UNITS_MAVG_10	Units Out-of-Stock: Mov Avg	CALCULATED	INTEGER
OOS_UNITS_MAVG_10_WKE	Units Out-of-Stock: Weekend Mov Avg	CALCULATED	INTEGER
OOS_UNITS_MAVG_10_WKE_SITU	Units Out-of-Stock Situation: Weekend Mov Avg	CALCULATED	TEXT
OOS_UNITS_MAVG_10_WKD	Units Out-of-Stock: Weekday Mov Avg	CALCULATED	INTEGER
OOS_UNITS_MAVG_10_WKD_SITU	Units Out-of-Stock Situation: Weekday Mov Avg	CALCULATED	TEXT
OOS_UNITS_MAVG_10_SITU	Units Out-of-Stock Situation: Mov Avg	CALCULATED	TEXT
OOS_UNITS_HW_364	Units Out-of-Stock: Holt-Winters	CALCULATED	INTEGER
OOS_UNITS_HW_364_WKE	Units Out-of-Stock: Weekend Holt-Winters	CALCULATED	INTEGER
OOS_UNITS_HW_364_WKE_SITU	Units Out-of-Stock Situation: Weekend Holt-Winters	CALCULATED	TEXT
OOS_UNITS_HW_364_WKD	Units Out-of-Stock: Weekday Holt-Winters	CALCULATED	INTEGER
OOS_UNITS_HW_364_WKD_SITU	Units Out-of-Stock Situation: Weekday Holt-Winters	CALCULATED	TEXT
OOS_UNITS_HW_364_SITU	Units Out-of-Stock Situation: Holt-Winters	CALCULATED	TEXT
OOS_UNITS_HW_364_05E	Units Out-of-Stock: Holt-Winters (param: 0.5)	CALCULATED	INTEGER
OOS_UNITS_HW_364_05E_WKE	Units Out-of-Stock: Weekend Holt-Winters (param: 0.5)	CALCULATED	INTEGER
OOS_UNITS_HW_364_05E_WKE_SITU	Units Out-of-Stock Situation: Weekend Holt-Winters (param: 0.5)	CALCULATED	TEXT
OOS_UNITS_HW_364_05E_WKD	Units Out-of-Stock: Weekday Holt-Winters (param: 0.5)	CALCULATED	INTEGER
OOS_UNITS_HW_364_05E_WKD_SITU	Units Out-of-Stock Situation: Weekday Holt-Winters (param: 0.5)	CALCULATED	TEXT
OOS_UNITS_HW_364_05E_SITU	Units Out-of-Stock Situation: Holt-Winters (param: 0.5)	CALCULATED	TEXT
OOS_UNITS_EXPO_10	Units Out-of-Stock: Exponential	CALCULATED	INTEGER
OOS_UNITS_EXPO_10_WKE	Units Out-of-Stock: Weekend Exponential	CALCULATED	INTEGER
OOS_UNITS_EXPO_10_WKE_SITU	Units Out-of-Stock Situation: Weekend Exponential	CALCULATED	TEXT
OOS_UNITS_EXPO_10_WKD	Units Out-of-Stock: Weekday Exponential	CALCULATED	INTEGER
OOS_UNITS_EXPO_10_WKD_SITU	Units Out-of-Stock Situation: Weekday Exponential	CALCULATED	TEXT
OOS_UNITS_EXPO_10_SITU	Units Out-of-Stock Situation: Exponential	CALCULATED	TEXT

Inventory Cube

The Inventory cube, named OOS_INV, contains 6 stored measures and 12 calculated measures.

Table 3–15, " Measures in the Inventory Cube" describes the measures that are in the OOS_INV cube.

Table 3-15 Measures in the Inventory Cube

Measure Name	Measure Description	Measure Type	Data Type
HOW_IS_EOP_SOH_VALUE_G_YOY	How is EOP SOH Value (Cost) Growth YoY	CALCULATED	TEXT
HOW_IS_EOP_SOH_UNITS_G_YOY	How is EOP SOH Units Growth YoY	CALCULATED	TEXT
HOW_IS_EOP_SOH_RTL_VALUE_G_YOY	How is EOP SOH Value (Retail) Growth YoY	CALCULATED	TEXT
EOP_SOH_VALUE	EOP SOH Value (Cost)	STORED (10gR2), CALCULATED (11gR1)	DECIMAL
EOP_SOH_VALUE_LY	EOP SOH Value (Cost) Last Year	CALCULATED	DECIMAL
EOP_SOH_VALUE_LY_PCT_CHG	EOP SOH Value (Cost) % Chg Last Year	CALCULATED	DECIMAL
EOP_SOH_VALUE_LY_CHG	EOP SOH Value (Cost) Change Last Year	CALCULATED	DECIMAL
EOP_SOH_UNITS	EOP SOH Units	STORED (10gR2), CALCULATED (11gR1)	INTEGER
EOP_SOH_UNITS_LY	EOP SOH Units Last Year	CALCULATED	INTEGER
EOP_SOH_UNITS_LY_PCT_CHG	EOP SOH Units % Chg Last Year	CALCULATED	DECIMAL
EOP_SOH_UNITS_LY_CHG	EOP SOH Units Change Last Year	CALCULATED	INTEGER
EOP_SOH_RTL_VALUE	EOP SOH Value (Retail)	STORED (10gR2), CALCULATED (11gR1)	DECIMAL
EOP_SOH_RTL_VALUE_LY	EOP SOH Value (Retail) Last Year	CALCULATED	DECIMAL
EOP_SOH_RTL_VALUE_LY_PCT_CHG	EOP SOH Value (Retail) % Chg Last Year	CALCULATED	DECIMAL
EOP_SOH_RTL_VALUE_LY_CHG	EOP SOH Value (Retail) Change Last Year	CALCULATED	DECIMAL
BOP_SOH_VALUE	BOP SOH Value (Cost)	STORED (10gR2), CALCULATED (11gR1)	DECIMAL
BOP_SOH_UNITS	BOP SOH Units	STORED (10gR2), CALCULATED (11gR1)	INTEGER
BOP_SOH_RTL_VALUE	BOP SOH Value (Retail)	STORED (10gR2), CALCULATED (11gR1)	DECIMAL

Inventory Forecast Cube

The Inventory Forecast cube, named OOS_INV_FCST, contains 51 stored measures.

Table 3–16, " Measures in the Inventory Forecast Cube" describes the measures that are in the OOS_INV_FCST cube.

Table 3-16 Measures in the Inventory Forecast Cube

Measure Name	Measure Description	Measure Type	Data Type
EOP_SOH_VAL_TREND_10	EOP SOH Value (Cost) Trend Forecast	STORED	INTEGER
EOP_SOH_VAL_TREND_10_WKEND	EOP SOH Value (Cost) Trend (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_VAL_TREND_10_WKDAY	EOP SOH Value (Cost) Trend (Week Days) Forecast	STORED	INTEGER
EOP_SOH_VAL_MAVG_50	EOP SOH Value (Cost) Moving Average 500 Forecast	STORED	INTEGER
EOP_SOH_VAL_MAVG_3	EOP SOH Value (Cost) Moving Average 3 Forecast	STORED	INTEGER
EOP_SOH_VAL_MAVG_10	EOP SOH Value (Cost) Moving Average 10 Forecast	STORED	INTEGER
EOP_SOH_VAL_MAVG_10_WKEND	EOP SOH Value (Cost) Moving Average 10 (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_VAL_MAVG_10_WKDAY	EOP SOH Value (Cost) Moving Average 10 (Week Days) Forecast	STORED	INTEGER
EOP_SOH_VAL_HW_364	EOP SOH Value (Cost) Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_VAL_HW_364_WKEND	EOP SOH Value (Cost) Holt-Winters Forecast (Weekend Days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_VAL_HW_364_WKDAY	EOP SOH Value (Cost) Holt-Winters Forecast (Week Days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_VAL_HW_364_05E_1	EOP SOH Value (Cost) Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_VAL_HW_364_05E_1_WKE	EOP SOH Value (Cost) Holt-Winters Forecast (Weekend days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_VAL_HW_364_05E_1_WKD	EOP SOH Value (Cost) Holt-Winters Forecast (Week days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_VAL_EXPO_10	EOP SOH Value (Cost) Exponential Forecast	STORED	INTEGER
EOP_SOH_VAL_EXPO_10_WKEND	EOP SOH Value (Cost) Exponential (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_VAL_EXPO_10_WKDAY	EOP SOH Value (Cost) Exponential (Week Days) Forecast	STORED	INTEGER
EOP_SOH_UNITS_TREND_10	EOP SOH Units Trend Forecast	STORED	INTEGER
EOP_SOH_UNITS_TREND_10_WKEND	EOP SOH Units Trend (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_UNITS_TREND_10_WKDAY	EOP SOH Units Trend (Week Days) Forecast	STORED	INTEGER
EOP_SOH_UNITS_MAVG_50	EOP SOH Units Moving Average 500 Forecast	STORED	INTEGER
EOP_SOH_UNITS_MAVG_3	EOP SOH Units Moving Average 3 Forecast	STORED	INTEGER
EOP_SOH_UNITS_MAVG_10	EOP SOH Units Moving Average 10 Forecast	STORED	INTEGER
EOP_SOH_UNITS_MAVG_10_WKEND	EOP SOH Units Moving Average 10 (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_UNITS_MAVG_10_WKDAY	EOP SOH Units Moving Average 10 (Week Days) Forecast	STORED	INTEGER
EOP_SOH_UNITS_HW_364	EOP SOH Units Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_UNITS_HW_364_WKEND	EOP SOH Units Holt-Winters Forecast (Weekend Days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_UNITS_HW_364_WKDAY	EOP SOH Units Holt-Winters Forecast (Week Days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_UNITS_HW_364_05E_1	EOP SOH Units Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_UNITS_HW_364_05E_1_WKE	EOP SOH Units Holt-Winters Forecast (Weekend days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_UNITS_HW_364_05E_1_WKD	EOP SOH Units Holt-Winters Forecast (Week days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_UNITS_EXPO_10	EOP SOH Units Exponential Forecast	STORED	INTEGER
EOP_SOH_UNITS_EXPO_10_WKEND	EOP SOH Units Exponential (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_UNITS_EXPO_10_WKDAY	EOP SOH Units Exponential (Week Days) Forecast	STORED	INTEGER
EOP_SOH_RTVAL_TREND_10	EOP SOH Value (Retail) Trend Forecast	STORED	INTEGER
EOP_SOH_RTVAL_TREND_10_WKEND	EOP SOH Value (Retail) Trend (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_RTVAL_TREND_10_WKDAY	EOP SOH Value (Retail) Trend (Week Days) Forecast	STORED	INTEGER
EOP_SOH_RTVAL_MAVG_50	EOP SOH Value (Retail) Moving Average 500 Forecast	STORED	INTEGER
EOP_SOH_RTVAL_MAVG_3	EOP SOH Value (Retail) Moving Average 3 Forecast	STORED	INTEGER
EOP_SOH_RTVAL_MAVG_10	EOP SOH Value (Retail) Moving Average 10 Forecast	STORED	INTEGER
EOP_SOH_RTVAL_MAVG_10_WKEND	EOP SOH Value (Retail) Moving Average 10 (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_RTVAL_MAVG_10_WKDAY	EOP SOH Value (Retail) Moving Average 10 (Week Days) Forecast	STORED	INTEGER
EOP_SOH_RTVAL_HW_364	EOP SOH Value (Retail) Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_RTVAL_HW_364_WKEND	EOP SOH Value (Retail) Holt-Winters Forecast (Weekend Days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_RTVAL_HW_364_WKDAY	EOP SOH Value (Retail) Holt-Winters Forecast (Week Days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_RTVAL_HW_364_05E_1	EOP SOH Value (Retail) Holt-Winters Forecast (day) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_RTVAL_HW_364_05E_1_WKE	EOP SOH Value (Retail) Holt-Winters Forecast (Weekend days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_RTVAL_HW_364_05E_1_WKD	EOP SOH Value (Retail) Holt-Winters Forecast (Week days) using 364 time periods periodicity	STORED	INTEGER
EOP_SOH_RTVAL_EXPO_10	EOP SOH Value (Retail) Exponential Forecast	STORED	INTEGER
EOP_SOH_RTVAL_EXPO_10_WKEND	EOP SOH Value (Retail) Exponential (Weekend Days) Forecast	STORED	INTEGER
EOP_SOH_RTVAL_EXPO_10_WKDAY	EOP SOH Value (Retail) Exponential (Week Days) Forecast	STORED	INTEGER

Relational Views Used for the OLAP Component

The bia_rtl_olap schema defines several relational views that are used by the OLAP component. There are two types of relational views defined in the bia_rtl_olap schema:

Relational Views Used When Loading the Analytic Workspace
Relational Views of the OLAP Cubes Used for SQL Query and Reporting

Relational Views Used When Loading the Analytic Workspace

The bia_rtl_olap schema defines relational views used by Oracle Retail Data Model when loading the analytic workspace:

Relational views used when populating OLAP dimensions
Relational views used when populating the OLAP Sales cube
Relational views used when populating the OLAP Inventory cube

Relational views used when populating OLAP dimensions

Table 3-17 outlines the relational views in the in bia_rtl_olap schema that are used when loading OLAP dimensions.

Table 3-17 Relational Views Used When Populating OLAP Dimensions

Relational View	OLAP Dimension	Defined using these `bia_rtl` relational tables
DWV_PROD_DIM	Product	DWR_CMPNY DWR_ITEM_DIV DWR_ITEM_GRP DWR_ITEM_DEPT DWR_ITEM_SBDEPT DWR_ITEM_CLASS DWR_ITEM_SBC DWR_ITEM_CLSTR DWR_ITEM DWR_SKU_ITEM
DWV_ORG_DIM	Organization	DWR_CMPNY DWR_ORG_CHAIN DWR_ORG_AREA DWR_ORG_RGN DWR_ORG_DSTRC DWR_ORG_DIV DWR_ORG_BNR DWR_ORG_BSNS_UNIT
DWV_TIME_DIM	Time	DWR_DAY

Relational views used when populating the OLAP Sales cube

To control population of the OLAP Sales cube, the following relational views are defined in the bia_rtl_olap schema:

DWV_SALES_ITEM_DAY_CURR

The OLAP Sales cube is mapped to this relational view.
DWV_SALES_ITEM_DAY_FULL and DWV_SALES_ITEM_DAY_INCR

These relational views are designed to cover contiguous date ranges that are controlled through the start and end date parameters specified in the BIA_RTL.DWC_ETL_PARAMETER table for process name "RBIA-INTRA-ETL-OLAP":
- For an historical load, the DWV_SALES_ITEM_DAY_CURR relational view points to the DWV_SALES_ITEM_DAY_FULL relational view.
- For an incremental load, the DWV_SALES_ITEM_DAY_CURR relational view points to the DWV_SALES_ITEM_DAY_INCR relational view.

All of the relational views depend on:

bia.rtl.DWD_RTL_SL_RETRN_ITEM_DAY table

bia_rtl_olap.DWV_TIME_DIM view

Relational views used when populating the OLAP Inventory cube

To control population of the OLAP Inventory cube, the following relational views are defined in the bia_rtl_olap schema:

DWV_INV_POSN_ITEM_DAY_CURR

The OLAP Inventory cube is mapped to this relational view.
DWV_INV_POSN_ITEM_DAY_FULL and DWV_INV_POSN_ITEM_DAY_INCR

These relational views are designed to cover contiguous date ranges that are controlled through the start and end date parameters specified in the BIA_RTL.DWC_ETL_PARAMETER table for process name "RBIA-INTRA-ETL-OLAP":
- For an historical load, the DWV_INV_POSN_ITEM_DAY_CURR relational view points to the DWV_INV_POSN_ITEM_DAY_FULL relational view.
- For an incremental load, the DWV_INV_POSN_ITEM_DAY_CURR relational view points to the DWV_INV_POSN_ITEM_DAY_INCR relational view.

All of the relational views depend on:

bia.rtl.DWD_INV_POSN_BY_ITEM_DAY table

bia_rtl_olap.DWV_TIME_DIM view

Relational Views of the OLAP Cubes Used for SQL Query and Reporting

The bia_rtl_olap schema defines the relational views that you can use to access the OLAP cubes using SQL. The relational views that are provided vary depending on Oracle Database version.

Relational views for SQL access of OLAP cube data in both Oracle Database 10g and Oracle Database 11g The bia_rtl_olap schema for both of these Oracle Database releases defines a relational view named, OOS_CUBEVIEW . OOS_CUBEVIEW is a relational view of all of the data in all of the cubes in the analytic workspace presented in a completely "flat" form. The "key" columns of this view are the tuples of all of the OLAP dimensions and levels defined in the PSLSINV analytic workspace. The data columns of this view are all of the OLAP measures.

You can use OOS_CUBEVIEW to access the data in the OLAP cube using SQL tools. For example, you can use this view create an Oracle Business Intelligence Enterprise Edition (OBIEE) repository that will allow the OBIEE Server (and therefore any OBIEE client, including as Dashboards, Answers, Delivers and the MS Office Plug-in) to query the Oracle Retail Data Model OLAP cubes.the Oracle Retail Data Model.

Note:

The sample reports delivered with Oracle Retail Data Model were developed using OBIEE Dashboard using the sample repository file RBIAII.rpd. The RBIAII repository contains a physical area named RBIAII OLAP that utilizes the OOS_CUBEVIEW relational view.

Relational views for SQL access of OLAP cube data in Oracle Database 11g In addition to the default SQL reporting view OOS_CUBEVIEW, the bia_rtl_olap schema for Oracle Database 11g also defines relational views with a _VIEW suffix. These are relational views that parallel the Analytic Workspace Manager perspective of the PSLSINV analytic workspace. These relational views include views of :

OLAP dimensions and hierarchies (for example, PRODUCT_VIEW, PRODUCT_HPROD_VIEW, TIME_VIEW, TIME_HTBSNS_VIEW, and TIME_HTCLNDR_VIEW).
OLAP cubes (that is, OOS_SALES_VIEW, OOS_INV_CUBE_VIEW, OOS_SALES_FCST_VIEW, and OOS_INV_FCST_VIEW).

Using these views, it is possible to model the OLAP dimension and cube views as a relational star schema.

Also, when using the OLAP component in Oracle Database 11g you can use the OBIEE Plug-in for Analytic Workspace Manager (AWM) to quickly create an OBIEE repository that will allow you to query the Oracle Retail Data Model OLAP cubes.

Note:

The OBIEE Plug-in for AWM is available for download from the Oracle Technology Network Web site at http://www.oracle.com/technology/index.html.