Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Business Intelligence and Retail Analytics

2 Setup and Configuration

• Sizing Information
  • Factors to Consider
    • Data Seeding of Positional Facts
• Data Migration from a Legacy Data Warehouse System
• Reporting Scenarios
• Data Initial Load from RMS
  • Inventory Position Initial Loading
  • Pricing Initial Loading
  • Net Cost Initial Loading
  • Base Cost Initial Loading
• Rendering Item Images

3 Internationalization

• Translation
• Multi-Language Setup
  • Scenario 1
    • Data Scenario 1a
    • Data Scenario 1b
  • Scenario 2
    • Data Scenario 2a
  • Scenario 3

4 Compression and Partitioning

• Overview of Compression
  • What Compression Does
  • Mechanics of Compression
  • Compressed Tables and 'CURRENT' Tables
  • Coping with Slowly Changing Dimension Type 2
    • Fact Close Program (factcloseplp.ksh)
    • Fact Open Program (factopenplp.ksh)
• Oracle Table Compression
• Overview of Partitioning Strategies
  • Implementing Retail Analytics Partitioning
  • Setup and Maintenance for Partitioning Retail Analytics Compressed Inventory Table
    • Implementing Partitioning for Compressed Inventory Table
  • How Oracle Implements Partitions
  • Summary

5 Performance

• Key Factors in Performance
  • Purging and Archiving Strategy
  • Flexible Aggregates
  • ETL Programs Performance
    • Setting ETL Program Multi-threading
    • ODI Configuration
    • ETL Batch Scheduling
    • Additional Considerations
  • Report Design
  • Additional Factors
  • Partitioning Strategy
  • Data Base Configuration
  • Adequate Hardware Resources
• Leading Practices
  • Customizations
  • ODI Best Practices
  • Oracle BI EE Best Practices
  • Batch Schedule Best Practices
    • Automation
    • Recoverability
  • Retail Analytics Loading Batch Execution Catch-Up
    • High Availability
    • Batch Efficiency
• Aggregates List

6 Retail Analytics Aggregation Framework

• Overview of Retail Analytics Aggregation Framework
  • Aggregation Framework Initial Setup and Daily Execution
    • Importing ODI Components for Aggregation Framework
    • Importing Aggregation Framework Shell script
    • Initial Aggregation Framework Setup
    • Aggregation Framework Verification
  • Aggregation Framework Configuration
    • Creating Customized Aggregation Table
    • Configuring Framework in W_RTL_AGGREGATION_DAILY_TMP
  • Populating the Customized Aggregation Table
    • Batch Process
    • Batch Status Control
    • Batch Logging
• Aggregation Framework Data Flow

7 Retail Analytics Universal Adapter

• Overview of RA Universal Adapter Framework
  • Benefits
• Universal Adapter Installation and Configuration
  • File Manifest
  • Installation Steps
  • Configuration Steps
• Universal Adapter Execution
• Universal Adapter Process Flow

8 Frequently Asked Questions