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 Repository and Warehouse

• Maintaining the Oracle Health Sciences Clinical Development Analytics Repository
  • Modifying the Repository
    • Details for Selected Modifications
  • Merging Changes Into a New Oracle-supplied Repository
• Maintaining the Oracle Health Sciences Clinical Development Analytics Data Warehouse
  • Derivations
  • Extensions
  • Substitutions
  • Modifying Data Warehouse Tables

2 Implementing Security

• About Security in Oracle Health Sciences Clinical Development Analytics
  • Example
• Setting Up User Authentication
  • Creating User Accounts
  • Creating Database Accounts
• Setting Up User Authorization
  • Using Predefined User Groups in OBIEE and Creating New Ones
    • Predefined OBIEE User Groups
    • Creating User Groups in OBIEE
    • Assigning OBIEE User Groups to Dashboards and Reports
  • Creating User Groups in Oracle LSH
  • Creating Roles in Oracle LSH
    • Role for CDA End User Groups
    • Role for CDA Programmers
    • Roles for LSH Programmers
    • Roles for Administrators
  • Assigning Roles to Oracle LSH User Groups
  • Assigning Oracle LSH User Groups to Objects
  • Assigning Users to Oracle LSH User Groups
  • Example Summary
• Setting Up Study and Study Site Data Access for Users
  • Setting the Systemwide Access Variables
  • Data Access Tables
  • Importing Study and Study Site Data Access Privileges
    • Modifying the Data Access Programs
    • Running the Template Data Access Control ETL Programs
  • Study-Site Access Example

3 Extract Transform Load Programs

• ETL Architecture
  • Adding a New Source System in LSH
    • Creating Remote Location for New Source OLTP Pass-through Views
    • Creating Clone and Configuring New Replica of OC source Pass Through View's Work Area
    • Creating Clone and Configuring New Replica of the OC SDE Work Area and Programs
    • Modifying Pool Program to Include the New Source-specific Stage Tables
  • Oracle Health Sciences Clinical Development Analytics Domain Structure in Oracle Life Sciences Data Hub
  • ETL Mapping Hierarchy
• Executing the ETL Programs
  • ETL Execution for Full Data Warehouse Load
    • Full Load Without Deduplication
    • Full Load With Deduplication
  • ETL Execution for Incremental Data Warehouse Load
    • Incremental Load Without Deduplication
    • Incremental Load With Deduplication
• Customizing an ETL Program
• Creating an ETL Program
• Modifying an ETL Program
• Scheduling an ETL Program
• Setting Up the Target Load Type

4 Multi-Source Integration

• Overview
  • Foreign Key Adjustment
  • Unit of Work
  • Necessity of Deduplication
  • Coordinated Dimensions
  • Layering and Options
    • Oracle Health Sciences Clinical Data Analytics and Oracle Healthcare Master Person Index
  • Intersection of Deduplication Paths
  • Initial Load and Incremental Load
  • Oracle Healthcare Master Person Index Deduplication Process
    • Match Engine and Master Index
    • Matching Rules using Project Configuration
  • Components of the Deduplication Path
    • Bulk Extracting, Cleansing, and Loading
    • Extractor
    • Deduplication Program
    • Matching Rules Specification
    • Data Stewardship
    • Master Index
    • Dimension MDM SDE
    • Persistent Master Staging Table
• Preliminaries to Using Oracle Healthcare Master Person Index Deduplication Projects
  • Installation Results
  • Oracle Healthcare Master Person Index File Structure
• Processes for Using Oracle Healthcare Master Person Index Deduplication Projects
  • Adding Sources to the Project
  • Adjusting Project Configuration
  • Promoting an Attribute to Being a Match Field
  • Preparing the Master Index Database Schema
  • Generating and Deploying the Master Data Index Manager Application
  • Initial Load Processes
    • Extract
    • Profile
    • Cleanse
    • Running Bulk Match in Analysis Mode and Adjusting Match Rules
    • Bulk Load
  • Incremental Load Processes
    • Using MIDM Steward Loaded Data
• Handling Fact Data after Dimension Deduplication
  • Merged Fact Records Consequent to LOV Dimension Merge
  • General Case: Discovered Duplicate Fact Records
    • Impact of Dimension Deduplication on Fact Tables
• Rules and Recommendations
  • Rules
  • Recommendations
• Oracle Health Sciences Clinical Development Analytics' Match Rules
  • Policies for Creating Shipped Match Rules
  • Configurations
• User-supplied Deduplication System
• Extending the Warehouse
  • Adding a Column to the Persistent Staging Table
• Informatica Mappings used in Multi-Source Integration

A Troubleshooting

• Deleting Control Table Entries
• Sorting and Displaying of Null Values in Reports
• Cancelling Jobs in Oracle Life Sciences Data Hub
• Errors in Reports

Glossary

Index