Go to primary content
Oracle® Argus Insight Extensibility Guide
Release 8.1
E68411-01
Index
Next
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
2.4
Writing Custom SQL in Advance Condition
2.4.1
Writing Custom SQL for Argus Insight Advance Condition
2.4.2
Writing Custom SQL for Argus Mart Advance Condition
2.4.2.1
Current Data Point-in-Time Query
2.4.2.2
As of Date Point-in-Time Query
2.4.2.3
At Lock Point-in-Time Query
2.4.2.4
Last Locked Revision as of a Point in Time Query
2.4.2.5
Last Locked Revision for a Version in a Period (Case Receipt Date) Point-in-Time Query
2.4.2.6
Last Locked Revision for a Version in a Period (Case Locked Date) Point-in-Time Query
2.4.2.7
Last Locked Revision for a Version in a Period (Case Creation Date) Point-in-Time Query
2.4.2.8
Aggregate Queries
3
Case Series Extensibility
3.1
Creating New Merge Option
4
Code List Extensibility
4.1
Configuring Flexible Data Recategorization with a New Natural Language
4.2
Configuring Flexible Data Recategorization with a New Custom Language
5
ETL Extensibility
5.1
Viewing Argus Insight Custom Routines
5.2
Executing Argus Insight Custom Routines
6
Reporting Extensibility
6.1
Business Intelligence Publisher Extensibility
6.1.1
Assumptions
6.1.2
Business Purpose
6.1.3
Global Temporary Tables
6.1.4
Report Package Features
6.1.4.1
Generic Package
6.1.4.2
Line Listing Package
6.1.5
Data Model
6.1.5.1
Data Sets
6.1.5.2
Report Parameters
6.1.5.3
Event Triggers
6.1.5.4
Adding Lexical Parameter in Data Model
6.1.6
BI Publisher Report Templates
6.1.6.1
Layout Editor
6.1.6.2
Rich Text File Template
6.1.6.3
BI Publisher Logs
6.1.7
BI Publisher Reporting Tips
6.1.7.1
Adding Column in Global Temporary Tables
6.1.7.2
Populating New Column in User Exit Package
6.1.7.3
Adding New Column in Data Set
6.1.7.4
Adding New Column in Layout Report
6.2
BusinessObjects Extensibility
6.2.1
Assumptions
6.2.2
Applying Argus Data Security
6.2.3
Applying Blinded Security
6.2.4
BusinessObjects Reports on Case Series/Power Queries
6.2.4.1
Modifying BusinessObjects Universe
6.2.4.2
Modifying BusinessObjects Reports
6.3
Cognos Extensibility
6.3.1
Assumptions
6.3.2
Applying Argus Data Security
6.3.3
Applying Enterprise Security
6.3.4
Applying Blinded Security
6.3.5
Cognos Reports on Case Series/Power Queries
6.3.5.1
Modifying Cognos Model
6.3.5.2
Modifying Cognos Reports
6.3.6
Recommendations
6.4
OBIEE Extensibility
6.4.1
Assumptions
6.4.2
RPD Architecture
6.4.2.1
Physical Layer
6.4.2.2
BMM Layer
6.4.2.3
Presentation Layer
6.4.3
Adding New Dimension Using Flex Bucketing
6.4.4
Creating Custom Dashboards and Prompts
A
Appendix: Dimensions and their Mapping
Index
