Go to main content
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
Scripting on this page enhances content navigation, but does not change the content in any way.