Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introducing Oracle Retail Data Model

• What is Oracle Retail Data Model?
• Scope of Retail Organizations That Oracle Retail Data Model Supports
• Oracle Products That Make Up Oracle Retail Data Model
• What Are the Components of Oracle Retail Data Model
  • Oracle Retail Data Model Logical and Physical Models
    • Logical Model
    • Physical Model
• Where Oracle Retail Data Model Fits in a Data Warehousing Project

2 Introduction to Customizing Oracle Retail Data Model

• Prerequisite Knowledge for Customizers
• Performing Fit-Gap Analysis
• Overview: Customization Steps
• Dependencies When Customizing the Physical Model

3 Populating the Oracle Retail Data Model Warehouse

• Overview: Populating an Oracle Retail Data Model Warehouse
• Populating Reference, Lookup, and Base Relational Tables
• Populating Derived and Aggregate Relational Tables and Views
  • Executing the Intra-ETL for Oracle Retail Data Model
    • Executing the Intra-ETL in Oracle Warehouse Builder
    • Explicitly Executing the Intra-ETL Package
  • Monitoring the Execution of the Intra-ETL Process
  • Recovering an Intra_ETL Process
• Implementing Oracle Retail Data Model Data Mining Models
  • Populating the Data Mining Source Tables
  • Creating the Data Mining Models
• Populating OLAP Cubes

4 Analysis and Reporting in Oracle Retail Data Model

• Reports Delivered with Oracle Retail Data Model
  • Sample Associate Basket Analysis Model Report
  • Sample Associate Loss Analysis Model Reports
  • Sample Associate Sales Analysis Model Report
  • Sample Customer Product Category Mix Analysis Model Report
  • Sample Customer Loyalty Analysis Model Report
  • Sample Item Basket Analysis Model Report
  • Sample Item Point of Sale (POS) Loss Analysis Model Report
• Customizing the Reports Delivered with Oracle Retail Data Model
• Writing Your Own Queries and Reports on Relational Data
• Writing Your Own Queries and Reports on OLAP Cube Data
  • Writing Reports on Time-Series and Ranking Analysis
  • Writing Forecasting Reports

5 Maintaining an Oracle Retail Data Model Warehouse

• Overview: Maintaining an Oracle Retail Data Model
• Maintaining Relational Tables and Views
• Refreshing OLAP Cube Data
  • Sample Incremental Load
  • OLAP Incremental Load Recovery
  • Updating Forecast Cubes
  • Creating a New Forecast

A Operations Scripts

• Calendar Population Script
• Bitmap Index for Fact Tables Script
• Partition Append Scripts
• Create Dimensions Script
• Foreign Key Manipulation Scripts
• Lookup Value Population Scripts
• The Out of Stock Script
• RFMP Calculation Script

Index