1/10

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 Data Source Information
  • 2.1.2 Handling Deletions in Siebel Clinical
  • 2.1.3 Adding a New Data Source
  • 2.1.4 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 InForm Auto-merge Matching Rules

• 3.1 W_EMPLOYEE_DS
• 3.2 W_GEO_DS
• 3.3 W_HS_APPLICATION_USER_DS
• 3.4 W_PARTY_PER_DS
• 3.5 W_PRODUCT_DS
• 3.6 W_RXI_PROGRAM_DS
• 3.7 W_RXI_SITE_DS
• 3.8 W_RXI_THERAPEUTIC_AREA_DS

A Troubleshooting

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

Index