List of Figures

• 2-1 Layers of an Oracle Retail Data Model Warehouse
• 2-2 Partitioning for Join Performance
• 2-3 Parallel Execution of a Full Partition-Wise Join Between Two Tables
• 2-4 Partial Partition-Wise Join
• 3-1 Oracle SQL Developer with ORDM_SYS Schema
• 3-2 Applying Filters
• 3-3 Review Tables to Ensure Valid Data
• 3-4 Checking the Result
• 3-5 Star Schema Diagram
• 3-6 Diagram of the OLAP Dimensional Model
• 4-1 ETL Flow Diagram
• 4-2 ORDM Main Intra-ETL Process Flow
• 4-3 Intra-ETL Derived Process Flow
• 4-4 Intra-ETL Independent MV Process Flow
• 4-5 Intra-ETL Aggregate Process Flow
• 4-6 OLAP Map Process Flow
• 4-7 Mining Flow Process
• 5-1 New Dashboard Start: BIEE Home
• 5-2 New Dashboard: Enter Name
• 5-3 New Dashboard: Catalog View
• 5-4 New Dashboard: Catalog View with New Reports Vertical
• 5-5 New Dashboard: Catalog View with New Reports Horizontal
• 5-6 New Dashboard: Select Name for Page
• 5-7 New Dashboard: Enter New Page Name
• 5-8 New Dashboard: Rename Page Dialog
• 5-9 New Dashboard: Display with Two New Reports
• 5-10 Analysis Report: Welcome Page with New Menu
• 5-11 Analysis Report: Welcome Page with Select Subject Area Menu
• 5-12 Analysis Report: Welcome Page with Selected Columns
• 5-13 Analysis Report: Results View of Report
• 5-14 New Report: Create New View
• 5-15 New Report: Final View of New Reports
• 7-1 Currency and Transaction Amount Data Flow in Oracle Retail Data Model