1/9

Contents

Title and Copyright Information

Preface

• Where to Find More Information
• Documentation Accessibility

1 Advanced Conditions Extensibility

• 1.1 Configuring CMN_FIELDS Table
• 1.2 Configuring CMN_FIELD_CONFIGURATION Table
  • 1.2.1 Configuring SMQ_NARROW Field Type
  • 1.2.2 Configuring SMQ_BROAD Field Type
  • 1.2.3 Configuring MEDDRA Field Type
  • 1.2.4 Configuring WHO Field Type
  • 1.2.5 Configuring COMPANY_DRUG Field Type
  • 1.2.6 Configuring INGREDIENT Field Type
  • 1.2.7 Configuring MINUTES_CALCULATOR Field Type
  • 1.2.8 Configuring LITERATURE Field Type
  • 1.2.9 Configuring EVENT_LICENSE Field Type
  • 1.2.10 Configuring STUDY_DRUG Field Type
  • 1.2.11 Configuring CLINICAL_STUDY_LOOKUP Field Type
  • 1.2.12 Configuring BATCH_LOT_NO Field Type
  • 1.2.13 Configuring INVESTIGATIONAL_DRUG Field Type
  • 1.2.14 Configuring CO_DRUG_CODE_WITH_STUDY Field Type
  • 1.2.15 Configuring DVB Field Type
  • 1.2.16 Configuring GENERIC Field Type
  • 1.2.17 Configuring PATIENT_HISTORY Field Type
  • 1.2.18 Configuring PARTIAL_DATE Field Type
  • 1.2.19 Configuring CLOB Field Type
  • 1.2.20 Configuring PARENT_HISTORY Field Type
• 1.3 Configuring CMN_COMPLEXFIELD_CONFIGURATION Table
• 1.4 Writing Custom SQL in Advance Condition
  • 1.4.1 Writing Custom SQL for Argus Insight Advance Condition
  • 1.4.2 Writing Custom SQL for Argus Mart Advance Condition
    • 1.4.2.1 Current Data Point-in-Time Query
    • 1.4.2.2 As of Date Point-in-Time Query
    • 1.4.2.3 At Lock Point-in-Time Query
    • 1.4.2.4 Last Locked Revision as of a Point in Time Query
    • 1.4.2.5 Last Locked Revision for a Version in a Period (Case Receipt Date) Point-in-Time Query
    • 1.4.2.6 Last Locked Revision for a Version in a Period (Case Locked Date) Point-in-Time Query
    • 1.4.2.7 Last Locked Revision for a Version in a Period (Case Creation Date) Point-in-Time Query
    • 1.4.2.8 Aggregate Queries

2 Case Series Extensibility

• 2.1 Creating New Merge Option

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.1.1 Context Setting
      • 5.1.4.1.2 Case Series Data Population
    • 5.1.4.2 Line Listing Package
      • 5.1.4.2.1 Generic Parameters
      • 5.1.4.2.2 Adding New Parameter in Package
      • 5.1.4.2.3 Populating Data for Generic Line Listing Report
      • 5.1.4.2.4 Log (Audit) Table
      • 5.1.4.2.5 User Exits
      • 5.1.4.2.6 Lexical Parameters
  • 5.1.5 Data Model
    • 5.1.5.1 Data Sets
      • 5.1.5.1.1 Adding New Column in Existing Data Set
      • 5.1.5.1.2 Adding New Data Set
    • 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.1.1 Modifying Database View
      • 5.3.5.1.2 Modifying Logical View
    • 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