Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle Communications Data Model

• What is Oracle Communications Data Model?
• Oracle Communications Data Model Logical and Physical Models
• Oracle Products That Make Up Oracle Communications Data Model
• Where Oracle Communications Data Model Fits in a Data Warehousing Project
• Prerequisite Knowledge for Customizers

2 Customizing the Oracle Communications Data Model

• Overview: Customization Steps
• Performing Fit-Gap Analysis
• Discovering the Oracle Communications Data Model Metadata
  • Measure-Entity tab
  • Entity-Measure tab
  • Program-Table tab
  • Table-Program tab
• Example: Modifying the Logical Model Based on Fit-Gap Analysis
  • Steps: Extending the Logical Model to Support Multiple Levels for CONTENT
  • Steps: Modifying the Logical Model

3 Populating an Oracle Communications Data Model Warehouse

• Pre-population Tasks
• Overview: The ETL for an Oracle Communications Data Model Warehouse
• Estimating Space for Oracle Communications Data Model
• Performing an Initial Load of the Warehouse
  • Updating the Parameters of the DWC_ETL_PARAMETER Table for an Initial Load
  • Updating DWC_OLAP_ETL_PARAMETER Table for an Initial Load
  • Executing the Intra-ETL for Oracle Communications Data Model
    • Executing the INTRA_ETL_FLW Workflow Within Oracle Warehouse Builder
    • Manually Executing the Intra-ETL
• Performing Incremental Data Loading of the Warehouse
  • Incremental Loading of Relational Tables and Views
  • Incremental Loading of OLAP Cubes
    • Updating DWC_OLAP_ETL_PARAMETER Table for an Incremental Load
    • Executing the Oracle Communications Data Model OLAP ETL Mapping
    • Recovering from Errors During an Incremental Load of OLAP Cubes
  • Refreshing Data Mining Models
• Managing Errors During Intra-ETL Execution
  • Monitoring the Execution of the Intra-ETL Process
  • Recovering an Intra ETL Process
  • Troubleshooting Intra-ETL Performance
    • Checking the Execution Plan
    • Monitoring PARALLEL DML Executions
  • Troubleshooting Data Mining Model Creation

4 Working with an Oracle Communications Data Model Warehouse

• Customizing the Reports Delivered with Oracle Communications Data Model
  • Tools for Customizing Reports
  • Troubleshooting Reporting Performance
• Writing Your Own Queries and Reports
• Modifying and Creating New OLAP Cubes
  • Enabling Cube Materialized Views
  • Changing an Oracle Communications Data Model OLAP Cube
  • Working with Forecast Cubes
• Modifying Data Mining Models
• Changing the Tablespaces and Partitions Used by Tables
  • Diverting Partitions into New Tablespaces
  • Changing an Existing Tablespace
• Working with Compression
• Working with Parallelization
  • Enabling Parallel Execution for a Session
  • Enabling Parallel Execution of DML Operations
  • Enabling Parallel Execution at the Table Level
• Working with User Privileges

Index