1/20

Contents

Title and Copyright Information

Preface

• Change Log
• Finding More Information
• Documentation Accessibility

1 Getting Started

• About Application Development
• Defining Objects
  • Predefined Object Types
  • Object Definitions and Instances, and their Containers
• Developing a Business Application
  • Working in a Work Area
  • Mapping Executables to Tables
  • Example of a Business Application
• Developing Standard Definitions and Modular Applications
• Ensuring Data Currency

2 Creating Container Objects

• Selecting a Domain
  • Set a Default Domain in Preferences
  • Select a Domain on the Applications Screen
• Navigating in the Applications Tab
  • Browsing the Main Applications Screen
  • Navigating Using Breadcrumbs
  • Using the Actions Drop-Down
• Creating Domains, Application Areas, Work Areas, and Objects
  • Creating Domains
  • Creating Application Areas
  • Creating Work Areas
  • Creating or Adding Children, including Object Instances
  • Creating Object Definitions
• Modifying Domains, Application Areas, and Work Areas
• Duplicating, Removing, Moving and Promoting Domains
  • Duplicating or Copying a Domain
  • Removing a Domain
  • Moving a Domain
  • Promoting a Domain
• Managing Object Definitions
  • Copying Object Definitions
  • Moving Object Definitions
  • Creating Object Definitions

3 Common Development Tasks

• Creating and Reusing Objects
  • Finding an Appropriate Definition
  • Reusing Existing Definitions
  • Creating an Instance of an Existing Definition
  • Creating a New Definition and Instance
  • Creating and Using Object Descriptions
• Naming Objects
  • Special Characters and Reserved Words
  • Duplicate Names: System Appends _1
  • Automatic Name Truncation
  • Keep Container and Object Names Short for Integrated Development Environments
  • Naming Rules for Specific Object Types
  • Customizable Naming Validation Package
• Viewing Object Instances and Definitions
  • Viewing Object Instances
  • Viewing Object Definitions
• Understanding Object Versions and Checkin/Checkout
  • About Object Versions
  • Checking Out Objects
  • Checking In Objects
  • Undoing Object Checkout
  • Version Labels
  • Version History
  • Versions of Component Objects
• Upgrading Object Instances to a New Definition Version
  • Upgrading One or More Instances from the Definition
  • Upgrading to a Different Definition Version from an Instance
  • Upgrading to the Latest Version
• Copying, Cloning, and Moving Objects
  • Copying Objects
  • Comparison of Copying and Cloning Individual Objects
  • Cloning Objects
  • Moving Objects
  • Pasting Objects
• Removing Objects
  • Rules for Removing Objects
• Classifying Objects and Outputs
  • About Classification
  • Classifying Objects
  • Classifying Outputs
• Applying Security to Objects and Outputs
  • Viewing User Group Assignments
  • Assigning User Groups to an Object
  • Removing User Group Assignments
  • Reassigning a User Group as Inherited
• Validating Objects and Outputs
  • About Object Validation
  • About Output Validation
  • Validation Statuses
  • Changing Objects' Validation Status
  • Changing Outputs' Validation Status
  • Adding Supporting Information
  • Validation Rules
• Reordering and Renumbering Objects
• Defining and Mapping Table Descriptors
  • About Table Descriptors
  • Creating a Table Descriptor
  • Mapping Table Descriptors to Table Instances
  • Mapping Columns
  • Creating and Mapping Table Descriptors and Table Instances at the Same Time
  • Unmapping Table Descriptors
  • Modifying Table Descriptors
• Creating, Modifying, and Submitting Execution Setups
  • About Execution Setups and Templates
  • Creating an Execution Setup
  • Modifying an Execution Setup and Setting Parameters
  • Report Set and Workflow Execution Setups
  • Removing an Execution Setup
  • Activating a Version of an Execution Setup
  • Submitting an Execution Setup
• Viewing Data
  • Viewing Data within the Oracle Life Sciences Data Hub
  • Viewing Data with Visualizations
  • Viewing Data with Program-Generated Reports
  • Viewing Data Through an IDE
• Viewing Jobs
• Viewing All Outputs of a Program or Report Set
  • Viewing All Outputs of an Instance in the Work Area Properties Screen
  • Viewing All Outputs from the My Home or Reports Tab
  • Viewing All Outputs of a Program or Report Set
• Using the Actions Drop-Down List
• Defining Planned Outputs

4 Defining Tables

• About Tables
• Creating a Table
  • Creating a New Table Definition and Instance
  • Creating an Oracle LSH Table From a SAS Data Set
  • Creating a New Instance of an Existing Table Definition
• Setting and Modifying Table Attributes
• Using the Table Properties Screen
  • Instance Properties
  • Definition Properties
  • Buttons
• Defining Table Columns
  • Create a New Column and Variable
  • Create a Column from an Existing Variable
• Defining Table Constraints and Indexes
  • About Constraints
  • Check Constraint
  • Non-Unique Index
  • Primary Key
  • Unique Key
• Modifying Tables
  • Modifying Table Instance Properties
  • Modifying Table Definition Properties

5 Defining Programs

• About Programs
• Creating a Program
  • Creating a New Program Definition and Instance
  • Creating an Instance of an Existing Program Definition
• Using the Program Properties Screen
  • Instance Properties
  • Definition Properties
  • Buttons
• Defining Table Descriptors
• Defining Source Code
  • About Source Code
  • Creating Source Code
  • Calling APIs from Source Code
  • Creating and Using Static Reference Source Code
  • Upgrading Source Code And Undoing Source Code Upgrades
• Defining Parameters
• Defining Planned Outputs
  • About Planned Outputs
  • Defining a Planned Output
• Defining PL/SQL Programs
  • Writing Primary Source Code in PL/SQL
  • Testing PL/SQL Source Code
  • Creating a PL/SQL Package Storage Program
  • Using a Sharable PL/SQL Package
  • Compiling and Executing a PL/SQL Program
  • Manipulating Documents through a PL/SQL Program
• Defining View Programs
  • Creating Source Code for a View Program
  • About View Table Instances
  • About Table Descriptors in View Programs
• Defining SAS Programs
  • SAS Program Development Process
  • Connecting to SAS
  • SAS Program and Source Code Types
  • Writing SAS Primary Source Code
  • Creating a SAS Macro Catalog
  • About SAS Format Catalogs in the Oracle Life Sciences Data Hub
  • Creating a SAS Format Catalog
  • Calling an API to Capture Output Parameter Values
• Defining Oracle Reports Programs
• Defining Informatica Programs
  • Creating a New Informatica Program
  • Using Your Existing Informatica Mappings and Workflows
  • Creating and Synchronizing Source Code
  • Using PL/SQL Source Code in an Oracle LSH Informatica Program
  • Updating Table Descriptors
  • Setting Informatica Program Parameters
  • Selective Index Management
  • Adding Planned Outputs
  • Informatica Integration
• Defining Oracle Business Intelligence Publisher Programs
  • Integration with Oracle BI Publisher
  • About Oracle BI Publisher Program Source Code
  • About Oracle BI Publisher Program Planned Outputs
  • Setting Oracle BI Publisher Program Parameters
• Installing Program Instances
• IDE Launch Settings
  • About Launch Settings
  • Setting the Blind Break Value
  • Setting the Shared Snapshot Label Value
• Modifying Programs
  • Modifying Program Instance Properties
  • Modifying Program Definition Properties
• Setting Up Integrated Development Environments (IDEs)
  • Setting Up Oracle SQL Developer or SQL*Plus as an IDE
  • Setting Up SAS as an IDE
  • Setting Up Informatica as an IDE

6 Defining Variables and Parameters

• About Variables, Parameters, and Columns
• Defining Variables
  • Creating Variables Automatically
  • Creating Variables Manually
  • Modifying Variables
• Using the Variable Properties Screen
  • Definition Properties
  • Buttons
• Defining Columns
• Defining Parameters
  • About Parameters
  • Creating a Parameter
  • Defining Parameter Details
• Using the Parameter Properties Screen
  • About the Parameter Properties Screen
  • Instance Properties
  • Define Values
  • Validate Values
  • Definition Properties
  • Variable Properties
  • Buttons
• Setting Up Parameter Value Propagation
  • About Parameter Value Propagation
  • Setting Up Value Propagation from the Source Parameter
  • Setting Up Value Propagation from the Target Parameter
• Defining and Using Parameter Sets
  • Explicitly Defining Parameter Sets
• Defining Programatically Generated Lists of Values and Value Validation
• Modifying Parameters
  • Modifying a Parameter Instance
  • Modifying a Parameter Definition

7 Defining Load Sets

• About Load Sets
• Creating a Load Set
  • Creating a New Load Set Definition and Instance
  • Creating an Instance of an Existing Load Set Definition
• Using the Load Set Properties Screen
  • Instance Properties
  • Definition Properties
  • Load Set Attributes
  • Buttons
• Defining Table Descriptors
• Setting Load Set Parameters
• About Load Set Planned Outputs
• Defining Different Load Set Types
  • Oracle Tables and Views
  • SAS
  • Text
  • Oracle Clinical Stable Interface
  • Oracle Clinical Data Extract SAS Views
  • Oracle Clinical Data Extract Views
  • Oracle Clinical Design and Definition
  • Oracle Clinical Global Metadata
  • Oracle Clinical Labs
  • Oracle Clinical Randomization
  • Oracle Clinical Study Data
• Installing Load Set Instances
• Modifying Load Sets
  • Modifying Load Set Instance Properties
  • Modifying Load Set Definition Properties

8 Defining Data Marts

• About Data Marts
• Creating a Data Mart
  • Creating a New Data Mart Definition and Instance
  • Creating an Instance of an Existing Data Mart
• Using the Data Mart Properties Screen
  • Instance Properties
  • Definition Properties
  • Data Mart Attributes
  • Buttons
• Defining Table Descriptors
• Setting Data Mart Parameter Values
• About Data Mart Planned Outputs
• Defining Different Types of Data Marts
  • Defining Text Data Marts
  • Defining SAS Data Marts
  • Defining Oracle Export Data Marts
• Installing Data Mart Instances
• Modifying Data Marts
  • Modifying Data Mart Instance Properties
  • Modifying Data Mart Definition Properties

9 Defining Report Sets

• About Report Sets
• How to Work on a Report Set
• Creating Overlay Templates
  • About Overlay Templates
  • Creating Template Files
  • Creating an Overlay Template Definition
  • Creating an Overlay Template File Definition
• Creating a Report Set
  • Creating a New Report Set Definition and Instance
  • Creating an Instance of an Existing Report Set Definition
• Using the Report Set Properties Screen
  • Instance Properties
  • Definition Properties
  • Buttons
• Using the Report Set Structure View
  • Navigating to the Report Set Structure View
  • Building and Modifying the Report Set
• Creating and Setting Report Set Parameters
  • Setting Overlay Template Parameter Values
  • Setting Post-Processing Parameter Values
  • Setting Program Parameter Values
  • Creating Parameters for Sharing Values within the Report Set
• Defining Report Set Entries
  • Creating Multiple Report Set Entries
  • Setting Report Set Entry Properties
  • Adding Narratives
• Defining Programs to Generate Reports
  • About Programs in Report Sets
  • Assigning a Planned Output to a Report Set Entry
  • Options from the Report Set Program View Screen
  • Viewing Planned Output Assignments
  • Passing Report Set Entry Values to and from Programs
• Installing Report Sets
  • Installing the Report Set as a Whole with All Programs Checked In
  • Installing the Report Set as a Whole with Some Programs Checked Out
  • Installing a Single Program Instance in the Report Set
• Validating Report Set Definitions and Outputs
  • Output Reuse
  • Program Output Validation Flag
  • Report Set Validation Status
  • Summary Output Validation Status
  • Output-Oriented Validation
  • Definition-Oriented Validation
  • Changing Validation Status
• About Report Set Planned Outputs
• Modifying Report Sets
  • Modifying Report Set Instance Properties
  • Modifying Report Set Definition Properties

10 Defining Workflows

• About Workflows
• Creating a Workflow
  • Creating a New Workflow Definition and Instance
  • Creating an Instance of an Existing Workflow
• Using the Workflow Properties Screen
  • Instance Properties
  • Definition Properties
  • Buttons
• Adding Executables
  • About Executables as Workflow Activities
  • Adding an Executable to a Workflow
  • Mapping Table Descriptors within a Workflow
• Adding Workflow Structures
  • About Workflow Structures
  • Types of Workflow Structures
  • Adding Structures
• Defining Notifications
  • About Notifications
  • Using Approvals
  • Creating a Notification
  • Modifying Notifications
• Defining Transitions
  • About Transitions
  • Creating Transitions
• Defining Workflow Parameters
• Workflow Planned Outputs
• Installing Workflow Instances
• Modifying Workflows
  • Modifying Workflow Instance Properties
  • Modifying Workflow Definition Properties

11 Defining Business Areas for Visualizations

• About Visualizations
• Creating a Business Area
  • Creating a New Business Area Definition and Instance
  • Creating an Instance of an Existing Business Area Definition
• Using the Business Area Properties Screen
  • Instance Properties
  • Definition Properties
  • Business Area Attributes
  • Buttons
• Defining Table Descriptors
• Defining Joins
  • Defining a Join at the Table Level
  • Defining a Join at the Column Level
• Defining Business Area Hierarchies
• Understanding Business Area Source Code
• Setting Business Area Attributes and Parameters
• Defining Oracle Business Intelligence Business Areas
  • About OBIEE Business Areas
  • Defining an OBIEE Business Area
  • Manually Deploying the Master RPD File
  • Starting the WebLogic Server
  • Visualizing Business Area Data using OBIEE Answers
  • OBIEE Security
  • Installing and Setting Up Oracle Business Intelligence Administration Tool
• Defining Generic Visualization Business Areas
  • Generic Visualization Business Area Instance Properties
  • Assigning Security Privileges to Business Area Data
• Launching Visualizations
  • Creating a Visualization
  • Setting Data Currency and Blinding Values
• Installing Business Area Instances
• Modifying Business Areas
  • Modifying Business Area Instance Properties
  • Modifying Business Area Definition Properties

12 Using, Installing, and Cloning Work Areas

• Using the Work Area Properties Screen
  • Work Area Properties
  • Viewing a Work Area's Installation History
  • Viewing a Work Area's Version History
  • Changing a Work Area's Usage Intent
  • Object Instance Information
  • Object Instance Actions
  • Adding Object Instances to a Work Area
  • Managing Table Instance Snapshot Labels in a Work Area
• Personalizing Your Work Area Properties Screen
• Installing a Work Area and Its Objects
  • About Work Area Installation
  • Running a Work Area Installation
  • Installing Individual Objects
  • Viewing Installation Results
  • What Happens During a Work Area Installation
• Cloning Work Areas for Testing and Production
  • Application Life Cycle
  • Cloning a Work Area

13 Execution and Data Handling

• About Execution
• Submitting Jobs for Execution
• Data Processing Types
  • Processing Types Summary
  • Transactional Processing
  • Reload Processing
  • Staging Processing
  • Transactional High Throughput Processing
  • SQL*Loader Processing for SAS Programs
  • Using Tables as Pass-Through Views
• Data Auditing, Snapshots and Refresh Groups
  • Data Auditing
  • Data Snapshots
  • Refresh Groups
• Processing Data Subsets
• Forward Chaining
• Backchaining
  • How Backchaining Works
  • Backchaining Rules
  • Backchaining Tips
• Managing Blinded Data
  • Loading Real and Dummy Data
  • Managing Blinding Along the Data Flow
  • Unblinding Table Instances
• Using Message-Triggered Submission from External Systems
  • About Message-Triggered Submission
  • Setup Required
  • XML Message Requirements

14 System Reports

• Running and Saving System Reports
• Alphabetical Listing of Reports
• Security Reports
  • Blinding Rights Report
  • Operations for a Role Report
  • User Group Assignments Report
  • Users in Group Report
• Data Blinding Reports
  • Blind Breaks Report
  • Blinded Table Instances Audit Report
  • Blinded Table Instances Report
  • Unblinded Outputs Report
• Container Reports
  • Application Area Library Report
  • Domain Library Report
  • Work Area - All Instances Report
  • Work Area Cloning Report
  • Work Area Installation History Report
  • Work Area Version History Report
• Object Metadata Reports
  • Common Header Information
  • All Instances of a Definition Report
  • Data Mart Report
  • Data Mart Instance Report
  • Load Set Report
  • Load Set Instance Report
  • Object Validation Report
  • Object Version History Report
  • Program Report
  • Program Instance Report
  • Report Set Report
  • Report Set Instance Report
  • Table Report
  • Table Instance Report
  • Workflow Report
  • Workflow Instance Report

A Installation Requirements for Each Object Type

• Installable Instances and their Definitions
• Component Object Types
• Organizational Objects

B Object Ownership

• Domains
• Application Areas
• Work Areas

Glossary