Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Oracle Documentation
• Conventions

1 Introduction

2 Advanced Conditions Extensibility

• 2.1 Configuring CMN_FIELDS Table
• 2.2 Configuring CMN_FIELD_CONFIGURATION Table
  • 2.2.1 Configuring SMQ_NARROW Field Type
  • 2.2.2 Configuring SMQ_BROAD Field Type
  • 2.2.3 Configuring MEDDRA Field Type
  • 2.2.4 Configuring WHO Field Type
  • 2.2.5 Configuring COMPANY_DRUG Field Type
  • 2.2.6 Configuring INGREDIENT Field Type
  • 2.2.7 Configuring MINUTES_CALCULATOR Field Type
  • 2.2.8 Configuring LITERATURE Field Type
  • 2.2.9 Configuring EVENT_LICENSE Field Type
  • 2.2.10 Configuring STUDY_DRUG Field Type
  • 2.2.11 Configuring CLINICAL_STUDY_LOOKUP Field Type
  • 2.2.12 Configuring BATCH_LOT_NO Field Type
  • 2.2.13 Configuring INVESTIGATIONAL_DRUG Field Type
  • 2.2.14 Configuring CO_DRUG_CODE_WITH_STUDY Field Type
  • 2.2.15 Configuring DVB Field Type
  • 2.2.16 Configuring GENERIC Field Type
  • 2.2.17 Configuring PATIENT_HISTORY Field Type
  • 2.2.18 Configuring PARTIAL_DATE Field Type
  • 2.2.19 Configuring CLOB Field Type
  • 2.2.20 Configuring PARENT_HISTORY Field Type
• 2.3 Configuring CMN_COMPLEXFIELD_CONFIGURATION Table

3 Code List Extensibility

• 3.1 Configuring Flexible Data Recategorization with a New Natural Language
• 3.2 Configuring Flexible Data Recategorization with a New Custom Language

4 ETL Extensibility

• 4.1 Viewing Argus Insight Custom Routines
• 4.2 Executing Argus Insight Custom Routines

5 Reporting Extensibility

• 5.1 Business Intelligence Publisher Extensibility
  • 5.1.1 Assumptions
  • 5.1.2 Business Purpose
  • 5.1.3 Global Temporary Tables
  • 5.1.4 Report Package Features
    • 5.1.4.1 Generic Package
    • 5.1.4.2 Line Listing Package
  • 5.1.5 Data Model
    • 5.1.5.1 Data Sets
    • 5.1.5.2 Report Parameters
    • 5.1.5.3 Event Triggers
    • 5.1.5.4 Adding Lexical Parameter in Data Model
  • 5.1.6 BI Publisher Report Templates
    • 5.1.6.1 Layout Editor
    • 5.1.6.2 Rich Text File Template
    • 5.1.6.3 BI Publisher Logs
  • 5.1.7 BI Publisher Reporting Tips
    • 5.1.7.1 Adding Column in Global Temporary Tables
    • 5.1.7.2 Populating New Column in User Exit Package
    • 5.1.7.3 Adding New Column in Data Set
    • 5.1.7.4 Adding New Column in Layout Report
• 5.2 BusinessObjects Extensibility
  • 5.2.1 Assumptions
  • 5.2.2 Applying Argus Data Security
  • 5.2.3 Applying Blinded Security
  • 5.2.4 BusinessObjects Reports on Case Series/Power Queries
    • 5.2.4.1 Modifying BusinessObjects Universe
    • 5.2.4.2 Modifying BusinessObjects Reports
• 5.3 Cognos Extensibility
  • 5.3.1 Assumptions
  • 5.3.2 Applying Argus Data Security
  • 5.3.3 Applying Enterprise Security
  • 5.3.4 Applying Blinded Security
  • 5.3.5 Cognos Reports on Case Series/Power Queries
    • 5.3.5.1 Modifying Cognos Model
    • 5.3.5.2 Modifying Cognos Reports
  • 5.3.6 Recommendations
• 5.4 OBIEE Extensibility
  • 5.4.1 Assumptions
  • 5.4.2 RPD Architecture
    • 5.4.2.1 Physical Layer
    • 5.4.2.2 BMM Layer
    • 5.4.2.3 Presentation Layer
  • 5.4.3 Adding New Dimension Using Flex Bucketing
  • 5.4.4 Creating Custom Dashboards and Prompts

A Appendix: Dimensions and their Mapping

Index