Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Documentation on Oracle Technology Network
• Related Documents
• Conventions

1 Maintaining the OBIEE Repository and Warehouse

• 1.1 Maintaining the Oracle Health Sciences Clinical Development Analytics OBIEE Repository
  • 1.1.1 Modifying the Repository
    • 1.1.1.1 Details for Selected Modifications
  • 1.1.2 Merging Changes into a New Oracle-supplied Repository
• 1.2 Maintaining the Oracle Health Sciences Clinical Development Analytics Data Warehouse
  • 1.2.1 Extensions
  • 1.2.2 Substitutions
  • 1.2.3 Modifying Data Warehouse Tables
• 1.3 Derivations

2 Extract Transform Load Programs

• 2.1 ETL Architecture
  • 2.1.1 Adding a New Data Source
  • 2.1.2 Oracle Health Sciences Clinical Development Analytics Hierarchy
• 2.2 Executing the ETL Execution Plans
• 2.3 Customizing an ETL Execution Plan
• 2.4 Creating an ETL Execution Plan
• 2.5 Modifying an ETL Execution Plan
• 2.6 Scheduling an ETL Execution Plan

3 Multi-Source Integration

• 3.1 Overview
  • 3.1.1 Foreign Key Adjustment
  • 3.1.2 Unit of Work
  • 3.1.3 Necessity of Deduplication
  • 3.1.4 Coordinated Dimensions
  • 3.1.5 Layering and Options
    • 3.1.5.1 Oracle Clinical Data Analytics and Oracle Healthcare Master Person Index
  • 3.1.6 Intersection of Deduplication Paths
  • 3.1.7 Initial Load and Incremental Load
  • 3.1.8 Oracle Healthcare Master Person Index Deduplication Process
    • 3.1.8.1 Match Engine and Master Index
    • 3.1.8.2 Matching Rules Using Project Configuration
  • 3.1.9 Components of the Deduplication Path
    • 3.1.9.1 Bulk Extracting, Cleansing, and Loading
    • 3.1.9.2 Extractor
    • 3.1.9.3 Deduplication Program
    • 3.1.9.4 Matching Rules Specification
    • 3.1.9.5 Data Stewardship
    • 3.1.9.6 Master Index
    • 3.1.9.7 Dimension MDM SDE
    • 3.1.9.8 Persistent Master Staging Table
• 3.2 Preliminaries to Using Oracle Healthcare Master Person Index Deduplication Projects
  • 3.2.1 Installation Results
  • 3.2.2 Oracle Healthcare Master Person Index File Structure
• 3.3 Processes for Using Oracle Healthcare Master Person Index Deduplication Projects
  • 3.3.1 Adding Sources to the Project
  • 3.3.2 Adjusting Project Configuration
  • 3.3.3 Promoting an Attribute to Being a Match Field
  • 3.3.4 Preparing the Master Index Database Schema
  • 3.3.5 Generating and Deploying the Master Data Index Manager Application
  • 3.3.6 Initial Load Processes
    • 3.3.6.1 Extract
    • 3.3.6.2 Profile
    • 3.3.6.3 Cleanse
    • 3.3.6.4 Running Bulk Match in Analysis Mode and Adjusting Match Rules
    • 3.3.6.5 Bulk Load
  • 3.3.7 Incremental Load Processes
    • 3.3.7.1 Using MIDM Steward Loaded Data
• 3.4 Handling Fact Data after Dimension Deduplication
  • 3.4.1 Merged Fact Records Consequent to LOV Dimension Merge
  • 3.4.2 General Case: Discovered Duplicate Fact Records
    • 3.4.2.1 Impact of Dimension Deduplication on Fact and Target Tables
• 3.5 Rules and Recommendations
  • 3.5.1 Rules
  • 3.5.2 Recommendations
• 3.6 Oracle Health Sciences Clinical Development Analytics' Match Rules
  • 3.6.1 Policies for Creating Shipped Match Rules
  • 3.6.2 Configurations
• 3.7 User-supplied Deduplication System
• 3.8 Extending the Warehouse
  • 3.8.1 Adding a Column to the Persistent Staging Table
• 3.9 Informatica Mappings used in Multi-Source Integration

A Troubleshooting

• A.1 Oracle Business Intelligence Data Warehouse Administration Console Task Fails due to Missing Parameter File
• A.2 Sorting and Displaying of Null Values in Reports
• A.3 Aborting a Workflow

Glossary

Index