List of Tables

• 1-1 Oracle Development Tools Used with Oracle Retail Data Model
• 2-1 Certificate Entity Descriptions
• 2-2 Competitor Retail Item Entity Descriptions
• 2-3 Customer Entity Descriptions
• 2-4 Customer Cluster Item Entity Descriptions
• 2-5 Employee Entity Descriptions
• 2-6 Item Entity Descriptions
• 2-7 Item Cluster Customer Entities
• 2-8 Item Market Data Descriptions
• 2-9 Location Geography Entity Descriptions
• 2-10 Media Entity Descriptions
• 2-11 Organization Entity Description
• 2-12 Promotion Entity Descriptions
• 2-13 SKU Item Entity Descriptions
• 2-14 SKU Business Unit Selling Price Assignment
• 2-15 Time Entity Description
• 2-16 Time of Day Entity Descriptions
• 2-17 Time Transformation Entity Description
• 2-18 Touchpoint Entity Descriptions
• 2-19 Vendor Entity Descriptions
• 2-20 Vendor SKU Business Unit Assignment Entity Description
• 2-21 Lookup Entity Descriptions
• 2-22 Base Entity Descriptions
• 2-23 Derived Entity Descriptions
• 2-24 Aggregate Entity Descriptions
• 3-1 Reference Tables, Descriptions, and Notes
• 3-2 Lookup Table Names, Descriptions, and Notes
• 3-3 Database Sequences
• 3-4 Base Table Names, Descriptions, and Notes
• 3-5 Derived Table Names, Descriptions, and Notes
• 3-6 Source-Target Table Level Mappings for Derived Tables
• 3-7 Aggregate Table and Relational Materialized Views Names, Descriptions, and Notes
• 3-8 Source to Target Mapping for Aggregate Tables
• 3-9 Data Mining Model and Views Containing Model Rules
• 3-10 Organization Dimension
• 3-11 Product Dimension
• 3-12 Time Dimension
• 3-13 Measures in the Sales Cube
• 3-14 Measures in the Sales Forecast Cube
• 3-15 Measures in the Inventory Cube
• 3-16 Measures in the Inventory Forecast Cube
• 3-17 Relational Views Used When Populating OLAP Dimensions
• 4-1 Entity Mapping Table
• 5-1 Intra-ETL Scripts for Database Packages
• 5-2 Relational Materialized View Scripts
• 5-3 Data Mining Packages in Oracle Retail Data Model
• 5-4 OLAP_ETL_AW_LOAD Package Subprograms
• 5-5 OLAP_ETL_AW_BUILD Procedure Parameters
• 5-6 OLAP_ETL_AW_CUBES Procedure Parameters
• 5-7 OLAP_ETL_AW_DIMBUILD Procedure Parameters
• 5-8 OLAP_ETL_AW_CUBEBUILD Procedure Parameters
• 5-9 OLAP_ETL_AW_REPL_DEFN Procedure Parameters
• 5-10 OLAP_ETL_AW_BUILD Procedure Parameters
• 6-1 Oracle Retail Data Model Data Model Types