1/8

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.2 Executing the ETL Load Plans
  • 2.2.1 Executing CDA - Complete Warehouse Load Plan
  • 2.2.2 Executing CDA - Inform Automerge Load Plan
• 2.3 Customizing an ETL Load Plan
• 2.4 Creating an ETL Load Plan
• 2.5 Modifying an ETL Load Plan
• 2.6 Scheduling an ETL Load Plan

A Troubleshooting

• A.1 Sorting and Displaying of Null Values in Reports
• A.2 Aborting a Load Plan