Skip Headers
Oracle® Business Intelligence Applications Installation and Configuration Guide
Version 7.9.4
E10742-01
Library
Product
Index
Next
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Getting Started
1
What's New in This Version
1.1
What's New In Oracle Business Intelligence Applications Version 7.9.4?
2
Overview of Oracle Business Intelligence Applications
2.1
What is Oracle Business Intelligence Applications?
2.2
Oracle Business Analytics Warehouse Overview
2.3
Oracle Business Analytics Warehouse Architecture
2.3.1
Oracle Business Analytics Warehouse Architecture Components
2.4
Roadmap To Installing, Configuring, and Customizing Oracle BI Applications
3
Pre-installation and Predeployment Requirements for Oracle BI Applications
3.1
Oracle Business Analytics Warehouse Deployment Configuration
3.2
Operating System, Driver, and Connectivity Requirements for Oracle Business Analytics Warehouse
3.3
General Guidelines for Setting Up Oracle Business Analytics Warehouse
3.4
IBM DB2 UDB-Specific Database Guidelines for Oracle Business Analytics Warehouse
3.5
IBM DB2 UDB zOS and OS/390 and Z/os-Specific Database Guidelines for Oracle Business Analytics Warehouse
3.6
Oracle-Specific Database Guidelines for Oracle Business Analytics Warehouse
3.7
Additional Suggestions for Optimizing Oracle Performance in Oracle Business Analytics Warehouse
3.8
SQL Server-Specific Database Guidelines for Oracle Business Analytics Warehouse
3.8.1
Setting the ANSI NULL Option
3.8.2
Modifying the DB Library Options Setting
3.8.3
Recommended SQL Server Database Parameters
3.9
Teradata-Specific Database Guidelines for Oracle Business Analytics Warehouse
3.9.1
General Guidelines for Teradata Deployments
3.9.2
Best Practices For Teradata Deployments
3.10
Deploying Oracle Business Analytics Warehouse in Latin-1 General, Unicode and Non-English Environments
3.10.1
Code Page Overview
3.10.2
Source and Data Warehouse Code Pages for Latin-1 General (7-bit ASCII) to Latin-1 General (7-bit ASCII)
3.10.3
Source and Data Warehouse Code Pages for Latin-1 General (8-bit ASCII) to Latin-1 General (8-bit ASCII)
3.10.4
Source and Data Warehouse Code Pages for Unicode to Unicode
3.10.5
Source and Data Warehouse Code Pages for Code Page to Unicode
3.10.6
Source and Data Warehouse Code Pages for Code Page to Code Page
3.10.7
Setting the NLS_LANG Environment Variable for Oracle Databases
3.10.8
Setting the DB2CODEPAGE Environment Variable for DB2 Databases
3.11
Miscellaneous Information About Oracle Business Intelligence Applications Deployments
3.11.1
Preconfigured Mapping for the SA System Subject Area
3.11.2
Using Initialization Blocks
3.11.3
Performance Improvements for Change Capture for Incremental ETL Run
3.11.4
Running an ETL with a Non-English OLTP Data Source
Part II Installation and Post-Installation Steps For BI Applications
4
Installing and Configuring Oracle BI Applications on Windows
4.1
Installation and Configuration Process Task List for Windows
4.2
How to Install the Java SDK
4.3
How to Install Oracle Business Intelligence Applications (Windows)
4.3.1
Prerequisites to Running The Oracle Business Intelligence Applications Installation Wizard
4.3.2
How to Run The Oracle Business Intelligence Applications Installation Wizard
4.4
How to Install Informatica PowerCenter and Required Patches (Windows)
4.4.1
How to Install Informatica PowerCenter
4.4.2
How to Install the Informatica EBF Patch 2
4.4.3
(Teradata specific) How to Install Informatica Patch1
4.5
How to Set Up the Informatica Server and Informatica Repository Server
4.5.1
About migrating the Informatica repository
4.5.2
How to Set Up Informatica Data Code Pages Validation
4.5.3
How to Set Up The Informatica Server
4.5.4
How to Set Up The Informatica Repository Server
4.5.5
How to Copy Source Files and Lookup Files
4.5.6
How to Start the Informatica Services
4.5.7
How to Create ODBC Database Connections
4.6
How to Set Environment Variables on Windows
4.6.1
How to Set the PATH Environment Variable for the Informatica Server and Informatica Repository Server
4.6.2
How to Set Siebel UnicodeDB Environment Variables on Windows
4.6.3
How to Set the Bulk Load Registry for DB2/390 Databases
4.7
How to Copy Hibernate Libraries
4.8
How to Configure the DAC Client
4.8.1
How to Configure the DAC Config.bat File
4.8.2
How to Install JDBC Drivers for DAC Database Connectivity
4.9
How to Create the Required Databases
4.10
How to Create the DAC Metadata Repository
4.10.1
How to Create a DAC Connection
4.10.2
How to Log Into the DAC
4.10.3
How to Import Metadata into the DAC repository
4.11
How to Configure the DAC Metadata Repository
4.11.1
How to Set Up DAC System Properties
4.11.2
How to Specify Transactional and Data Warehouse Data Sources in the DAC
4.11.3
How to Configure Email Recipients in the DAC Client
4.11.4
How to Activate Join Indices for Teradata Databases
4.12
How to Configure the Oracle Business Analytics Warehouse Database
4.12.1
How to Create the SSE Role
4.12.2
How to Create Data Warehouse Tables
4.12.3
How to Create Data Warehouse Tables on a Teradata Database
4.13
How to Register Informatica Servers in the DAC Client
4.13.1
How to Register Informatica Servers in the DAC Client
4.14
How to Configure and Manage the Informatica Repository
4.14.1
About the Versioned Informatica Repository
4.14.2
How to Register the Informatica Repository Server
4.14.3
How to Load the Pre-Built Repository Into Informatica
4.14.4
How to Configure the Informatica Repository in Workflow Manager
4.14.5
How to Stop and Start the Informatica Repository (Optional)
4.14.6
How to Back Up and Restore the Informatica Repository (Optional)
4.15
How to Set the Code Page File Property for Unicode Environments on Teradata Databases
4.16
How to Set Up the HOSTS File for Teradata Installations on Windows
4.17
How to Verify the Informatica Repository Configuration
4.18
How to Configure the DAC Server
4.18.1
How to Configure the Connection Between the DAC Server and DAC Repository
4.18.2
How to Configure Email in the DAC Server (Optional)
4.18.3
How to Set DAC Source System Parameters
4.18.4
How to Start the DAC Server
4.19
How to Start the Informatica Server
4.20
How to Update Siebel Transactional Database Schema Definitions
4.20.1
How to Run the DDLIMP Tool From The Command Line
4.20.2
How to Apply Siebel (CRM) and Oracle E-Business Suite Schema Changes For Oracle, DB2/UDB, MSSQL
4.20.3
How to Apply CRM Schema Changes For DB2 on 390 or z/os
4.20.4
How to Verify the Siebel (CRM) and Oracle E-Business Suite Schema Changes
4.20.5
About Delete Triggers
4.21
How to Create Stored Procedures for DB2-UDB
4.21.1
How to Verify the existence of stored procedures
4.21.2
How to Create DB2 stored procedures
4.22
Teradata-Specific Installation and Configuration Checklist (Windows)
4.23
Upgrade Issues for Oracle BI Applications
4.23.1
Moving From a Test Environment to a Production Environment
4.23.2
Migrating Seed Data from an Siebel Source System to the Oracle BI Repository
5
Installing Oracle BI Applications on Unix
5.1
Overview of Installing and Configuring Oracle BI Applications on UNIX
5.2
Installation and Configuration Process Task List for UNIX
5.3
How to Install Oracle BI Applications on UNIX
5.4
How to Install and Configure the Informatica Repository Server on UNIX
5.4.1
How to install and configure the Informatica Repository Server
5.4.2
How to specify the Informatica Repository Server as an environment variable
5.5
How to Install and Configure the Informatica Server on UNIX
5.6
How to Update the Informatica License Files on UNIX
5.7
How to Install the Informatica Patch on UNIX
5.8
How to Create Database Connections for Teradata Installations
5.9
How to Set Environment Variables for the Informatica Server on UNIX
5.9.1
How to Add setenv Variables to .cshrc
5.9.2
How to Set the Code Page for Non_ENU Operating Systems on UNIX
5.9.3
How to Set Siebel UnicodeDB on the Informatica Server if source and target databases are Unicode on UNIX
5.9.4
How to Disable the bulk loader for DB2/390 databases
5.10
How to Set Up the HOSTS File for Teradata Installations on UNIX
5.11
How to Start the Informatica Repository Server on UNIX
5.12
How to Stop the Informatica Repository Server on UNIX
5.13
About the DAC Server on UNIX
5.13.1
How to configure the DAC server on UNIX
5.14
How to Stop and Start the Informatica Server on UNIX
5.14.1
Requirements
5.14.2
How to Start the Informatica Server on UNIX
5.14.3
How to Start the Informatica Server On UNIX
5.15
How to Run the DAC Server on UNIX
5.15.1
How to Start the DAC server on UNIX
5.15.2
How to Run the DAC server in the background
5.16
How to Stop the DAC Server on UNIX
5.17
Teradata-Specific Installation and Configuration Checklist for UNIX
Part III Customization and Security in Oracle BI Applications
6
Customizing the Oracle Business Analytics Warehouse
6.1
Oracle Business Analytics Warehouse Customization Scenarios
6.1.1
Types of Customizations
6.1.2
Upgrade Consideration
6.2
Category 1 Customizations: Adding Columns to Existing Fact or Dimension Tables
6.2.1
About Extending Mappings
6.2.2
Impact of Customization on Upgrade
6.2.3
Typical Steps to Extend Mappings in the Oracle Business Analytics Warehouse
6.2.4
Scenario for Extending the Oracle Business Analytics Warehouse
6.3
Other Types of Customizations Requiring Special Handling
6.3.1
Modifying Category 2 SCD Triggers
6.3.2
Adding Dimensions to Existing Facts
6.3.3
Adding Date Dimensions to Existing Facts
6.3.4
Adding Currencies to an Existing Table
6.4
Category 2 Customizations: Adding Additional Tables
6.4.1
About Creating New Dimension or Fact Tables
6.4.2
Using Custom Folders in the Oracle Business Analytics Warehouse
6.4.3
Creating Custom Informatica Workflows
6.4.4
Important Notes About Customizing the Oracle Business Analytics Warehouse
6.4.5
Including a Source Table for Change Capture Process
6.4.6
Adding a New Dimension in the Oracle Business Analytics Warehouse
6.4.7
Adding a New Fact Table in the Oracle Business Analytics Warehouse
6.4.8
Adding a New Dimension Table for a New Fact Table in the Oracle Business Analytics Warehouse
6.5
Category 3 Customizations: Adding New Data as a Whole Row into a Standard Dimension Table
6.6
Configuring Extracts
6.6.1
Extracting Additional Data
6.6.2
Setting Up the Delimiter for Source Files
6.6.3
Configuring a Source Adapter Mapplet
6.7
Configuring Loads
6.7.1
Filtering and Deleting Records
6.7.2
About Primary Extract and Delete Mappings Process
6.7.3
About Working with Primary Extract and Delete Mappings
6.8
Configuring Slowly Changing Dimensions
6.8.1
About Identifying Historically Significant Attributes
6.8.2
Type I and Type II Slowly Changing Dimensions
6.9
About Stored Lookups
6.10
Codes Lookup
6.10.1
W_CODES Table
6.10.2
Codes Mappings
6.10.3
Codes Mapplets
6.10.4
Configuring Extension Column Code Description Lookups
6.11
About Resolving Dimension Keys
6.11.1
Resolving the Dimension Key Using Lookup
6.12
About Domain Values
6.12.1
About the Domain Value Conversion Process
6.12.2
About the Importance of Domain Values
6.12.3
About Extending the Domain Value Set
6.13
Configuring the Domain Value Set with CSV Worksheet Files
6.14
Configuring the Domain Value Set Using PowerCenter Designer
6.15
Configuring Conformed Dimensions
6.15.1
Configuring Conformed Dimensions for Universal Source
7
Integrated Security for Oracle BI Applications
7.1
Types of Security in Oracle Business Intelligence Applications
7.1.1
Checking Oracle Business Intelligence Applications User Responsibilities
7.1.2
Registering a New User Responsibility in Oracle Business Intelligence
7.1.3
Default Security Settings in Oracle Business Intelligence
7.2
Integrating Data Security with Oracle E-Business Suite
7.2.1
Authorization
7.2.2
Operating Unit-Based Security With Oracle EBS
7.2.3
Inventory Organization-Based Security With Oracle EBS
7.2.4
Company Org-based Security Against Oracle EBS
7.2.5
Ledger Security Against Oracle EBS
7.2.6
Business Group Org-based Security Against Oracle EBS
7.2.7
Employee Based Security with Oracle EBS
7.3
Integrating Data Security with Oracle's PeopleSoft Enterprise Applications
7.3.1
Authorization
7.3.2
About Operating Unit-based Security Against PeopleSoft Financials
7.3.3
About Company Org-based Security Against PeopleSoft Financials or PeopleSoft HR
7.3.4
About Ledger-based Security against Oracle's PeopleSoft Enterprise Applications
7.3.5
About HR Org-based Security Against PeopleSoft HR
7.3.6
About Payables Org-based security Against PeopleSoft Financials
7.3.7
About Receivables Org-based Security Against PeopleSoft Financials
7.3.8
About SET ID-based Security Against PeopleSoft Financials
7.3.9
About Human Resource Personnel Data Analyst Security Against PeopleSoft HR
7.3.10
Employee Based Security Against PeopleSoft Application
7.4
Metadata Object-Level Security in Oracle BI Applications
7.4.1
Metadata Object-Level Security (Repository Groups)
7.5
Integrating Data Security with the Siebel CRM Application
7.5.1
Primary Position based Security
7.5.2
Primary Position Based Security for CRM Vertical applications
7.5.3
Team Based Visibility
7.5.4
Embedded Oracle Business Intelligence support for Changing Positions
7.5.5
Business Unit based Security
7.5.6
Primary Owner Security
7.6
Data-Level Security In Oracle BI Applications
7.6.1
Data-Level Security in Oracle Business Intelligence Applications
7.6.2
Implementing Data-Level Security in the Oracle BI Applications Repository
7.6.3
Initialization Blocks Used For Security Oracle BI Applications
Part IV Configuring Your Analytical Applications
8
Configuring Common Areas and Dimensions
8.1
Source Independent Configuration Steps
8.1.1
Configuration Required Before A Full Load
8.1.2
Configuration Steps for Controlling Your Data Set for All Source Systems
8.2
Oracle EBS-Specific Configuration Steps
8.2.1
Configuration Required Before A Full Load for Oracle EBS
8.2.2
Configuration Steps for Controlling Your Data Set for Oracle EBS
8.3
PeopleSoft-Specific Configuration Steps
8.3.1
Configuration Required Before A Full Load for PeopleSoft
8.3.2
Configuration Steps for Controlling Your Data Set for PeopleSoft
8.4
Siebel-Specific Configuration Steps
8.4.1
Configuration Required Before A Full Load for Siebel Source Systems
8.4.2
Configuration Steps for Controlling Your Data Set for Siebel Source Systems
9
Configuring Oracle's Supply Chain Family of Products
9.1
Overview of Oracle's Supply Chain Analytics Family of Products
9.1.1
Procurement and Spend Analytics Module
9.1.2
Supplier Performance Analytics Module
9.1.3
Inventory Analytics Module
9.2
Configuration Required Before A Full Load for Supply Chain Analytics
9.2.1
Configuration Steps for Supply Chain For All Source Systems
9.2.2
Configuration Steps for Supply Chain For Oracle EBS
9.2.3
Configuration Steps for Supply Chain For PeopleSoft
9.2.4
Configuration Steps for Supply Chain For Universal
9.2.5
Configuration Steps for Controlling Your Data Set
10
Configuring Oracle Financial Analytics
10.1
Overview of Oracle Financial Analytics
10.2
Configuration Required Before A Full Load for Financial Analytics
10.2.1
Configuration Steps for Financial Analytics For All Source Systems
10.2.2
Configuration Steps for Financial Analytics For Oracle EBS
10.2.3
Configuration Steps for Financial Analytics For PeopleSoft
10.2.4
Configuration Steps for Financial Analytics For Universal
10.2.5
Configuration Steps for Controlling Your Data Set
11
Configuring Oracle Order Management and Fulfillment Analytics
11.1
Overview of Oracle Order Management and Fulfillment Analytics
11.2
Configuration Required Before A Full Load for Oracle Order Management and Fulfillment Analytics
11.2.1
Configuration Steps for Oracle Order Management and Fulfillment Analytics For All Source Systems
11.2.2
Configuration Steps for Oracle Order Management and Fulfillment Analytics For Oracle EBS
11.2.3
Configuration Steps for Oracle Order Management and Fulfillment Analytics For PeopleSoft
11.2.4
Configuration Steps for Oracle Order Management and Fulfillment Analytics For Universal
11.2.5
Configuration Steps for Controlling Your Data Set
12
Configuring Oracle HR Analytics
12.1
Overview of Oracle HR Analytics
12.2
Configuration Required Before A Full Load for Oracle HR Analytics
12.2.1
Configuration Steps for Oracle HR Analytics For All Source Systems
12.2.2
Configuration Steps for Oracle HR Analytics For Oracle EBS
12.2.3
Configuration Steps for Oracle HR Analytics For PeopleSoft
12.2.4
Configuration Steps for Oracle HR Analytics For Universal
12.2.5
Configuration Steps for Controlling Your Data Set
13
Configuring Oracle Sales Analytics
13.1
Overview
13.2
Configuration Required Before A Full Load
13.2.1
How to Deploy Stored Procedures
13.2.2
Configuration Steps for Controlling Your Data Set
14
Configuring Oracle Contact Center Telephony Analytics
14.1
Overview of Oracle Contact Center Telephony Analytics
14.2
Configuration Required Before A Full Load for Contact Center Telephony Analytics
14.2.1
About the Dimension Key Resolution Process for Universal Source
14.2.2
How to Load the Dimension Table
14.2.3
How to Load the Fact Table
14.2.4
Setting Up The DATASOURCE_NUM_ID Parameter For The Universal Adapter
14.2.5
About Configuring the Event Type Columns
14.2.6
About Configuring The Contact Reason Column
14.2.7
About Configuring Contact Status Type Column
14.2.8
Setting Up the Representative Activities Table
14.2.9
Setting Up the Contact Center Performance Table
14.2.10
Setting Up the Benchmarks and Targets Table
14.2.11
Logical Delete of Records From Fact Tables
14.2.12
How to Configure Dates and Times
14.2.13
Configuring Flags for Oracle Contact Center Telephony Analytics
14.2.14
How to Exclude Representative Data for Post-Load Processing
14.2.15
How to Configure Alternate Load Plan to Enable Direct Load to the Entry-Level Rep Activity Aggregates
14.2.16
How to Configure Alternate Load Plan to Enable Direct Load to the Entry-Level Contact Performance Aggregates
14.2.17
How to Set Up the Integration_Id of the Contact Center Telephony Facts in the Warehouse
14.2.18
Setting Up the IVR Menu and IVR Navigation Profile Tables
14.2.19
How to View Duration Metrics in hh:mm:ss Format in Oracle BI Answers
14.2.20
Configuration Steps for Controlling Your Data Set
15
Configuring the Oracle BI Applications Repository
15.1
Modifying the Oracle BI Repository for Siebel version 6.3 and version 7.5 applications
15.2
Configuring the Oracle BI Repository Connections
15.2.1
About The Predefined Connection Pools In The Oracle Business Analytics Warehouse
15.2.2
How to Configure Oracle BI Applications Repository Connections
15.2.3
How to Configure Oracle BI Applications Repository Variables
15.3
Setting up Date Specific Metrics
15.4
Setting Up Additional Time Series Metrics for Oracle Business Analytics Warehouse
15.5
Setting Up Additional Dimension Tables for Oracle Business Analytics Warehouse
15.6
About the Period Ago Keys for Oracle Business Analytics Warehouse
15.7
About Oracle BI Time Repository Variables
15.8
About User Authentication
15.9
About the Security or Visibility Configuration
15.10
About the Group Variable
15.11
About Configuring Usage Tracking for Oracle Business Analytics Warehouse
15.12
About the Incremental Deployment of the Oracle BI Applications Repository
Part V Appendices
A
Installing the Usage Accelerator Application
A.1
What is Usage Accelerator?
A.1.1
About Configuring Usage Accelerator
A.1.2
About Deployment Date
A.1.3
About Metric Definitions and Variables
A.2
About Installing the Usage Accelerator
A.3
Usage Accelerator Application Integration with Siebel 7.5.3 CRM Application
A.4
Usage Accelerator-Analytics Adapter Files
B
Localizing Oracle Business Intelligence Deployments
B.1
Process of Maintaining Translation Tables for Oracle BI
B.1.1
Upgrading Oracle Business Intelligence Seed Data for Non-English Locales
B.1.2
Externalizing Customer Metadata Strings
B.1.3
Adding Custom Translations to the W_LOCALIZED_STRING_G Table
B.2
About Translating Presentation Services Strings
B.3
Changing the Default Currency in Analytics Applications
C
Integrating Interactive Dashboards and Operational Applications Data
C.1
Importing Oracle's Siebel Industry Applications Seed Data
C.2
Completing the Initialization in the Siebel Operational Application
C.2.1
Updating the Siebel Operational Application
C.2.2
Reapplying Customized Style Sheets
C.2.3
How to Configure Oracle Business Intelligence with Oracle's Siebel Web Extension (SWE)
C.2.4
Creating a Virtual IP Address for the SWE and Oracle BI Presentation Services
C.2.5
Testing the Virtual IP Configuration for Oracle Business Intelligence and the SWE
C.2.6
How to Configure Oracle BI Action Links
C.2.7
Testing Action Links
C.2.8
Process of Integrating Analytics and Oracle's Siebel Operational Applications
C.2.9
Accessing Optional Analytics Applications
C.2.10
Configuring the Browser Settings for Operational Applications
C.2.11
Process of Customizing Oracle BI Application Home Page and Dashboards
C.2.12
Customizing Oracle BI Content on the Siebel Operational Application Home Page
C.2.13
Determining the Oracle BI Report Path Argument
C.2.14
Adding Views for Custom Oracle BI Interactive Dashboards
C.2.15
Verifying NQHOST Setup for Pharma Disconnected Analytics Client
C.2.16
Integrating the Pharma Application Home Page with the Pharma Disconnected Analytics Client
C.2.17
Importing Pharma Application Target Lists to the Pharma Disconnected Analytics Client
C.3
Viewing Information About Preconfigured Dashboards
C.3.1
Exposing Dashboards and Requests
C.3.2
Locating Dashboard and Page Names
D
Configuring Metadata for Analytics Applications
D.1
What Are Oracle's Siebel Operational Applications?
D.2
Updating Financial Analytics Logical Table Sources
D.3
Externalizing Financial Services Metadata Translation Strings
D.4
Disabling the Financial Analytics Logical Table Sources
D.5
Developing and Deploying Predictive Scores
D.6
Analytics Metadata Requirements for Oracle's Siebel Industry Applications
D.6.1
Oracle's Siebel Consumer Sector Dashboards and Pages
D.6.2
Oracle's Siebel Consumer Sector Data Requirements
D.6.3
Oracle's CME family of products (Oracle Communications, Media and Energy Sales Analytics
D.6.4
Oracle's Siebel CME Dashboards and Pages
D.6.5
Oracle's Siebel CME Data Requirements
D.6.6
Oracle Pharma Sales Analytics Dimensions
D.6.7
Dimensions Specific to Subject Areas in Oracle Pharma Sales Analytics and Oracle Pharma Marketing Analytics
E
Oracle Business Analytics Warehouse for Life Sciences Data Considerations
E.1
What's New for Pharma Analytics in Version 7.9
E.2
Oracle Business Analytics Warehouse for Life Sciences Overview
E.3
Importing Syndicated Data into Oracle Business Analytics Warehouse
E.3.1
Syndicated Loading Definitions
E.3.2
Data Types Supported in the Oracle Business Analytics Warehouse
E.3.3
Loading Syndicated Data into the Oracle Business Analytics Warehouse
E.4
Syndicated Data Flat File Formats
E.4.1
Syndicated Data Flat File for Direct Sales Data
E.4.2
Syndicated Data Flat File for Indirect Sales Data
E.4.3
Syndicated Data Flat File for Prescription Data
E.4.4
Syndicated Data Flat File for Plan Level Rx Data
E.4.5
Syndicated Data Flat File for Physician Plan Level Rx Data
E.4.6
Syndicated Data Flat File for Weekly Early View Data
E.4.7
Syndicated Market Flat File for Indirect Sales Data
E.4.8
Syndicated Market Flat File for Prescription Data
E.4.9
Syndicated Market Flat File for Plan Level Rx Data
E.4.10
Syndicated Market Flat File for Physician Plan Level Rx Data
E.4.11
Syndicated Market Flat File for Weekly Early View Data
E.4.12
Flat File Cross-Reference Data Population Rules
E.5
Life Sciences Data Loading Issues with Oracle Business Analytics Warehouse
E.5.1
Known Issues with the Syndicated Data Fact Tables
E.6
Incremental Updates in the Oracle Business Analytics Warehouse LS Dimension Tables
E.6.1
W_ALIGNMT_DH
E.6.2
W_ALIGNVER_DH
F
Pharma Disconnected Analytics Administration - Supplemental Information
F.1
About Pharma Disconnected Analytics
F.2
Sourcing Reports for Oracle's Pharma Disconnected Analytics
G
Using Oracle Business Analytics Warehouse Exception Reports
G.1
Understanding Oracle Business Analytics Warehouse Exceptions
G.1.1
List of Values Exceptions
G.1.2
Cost List Exceptions
G.1.3
Products Without a Cost List
G.1.4
Exchange Rate Exceptions
G.1.5
Invalid Hierarchy Exceptions
G.1.6
Circular Hierarchy Exceptions
G.2
Executing Oracle Business Analytics Warehouse Exception Reports
G.2.1
Cleansing Data
G.2.2
Using the List of Values View
G.2.3
Using the Exchange Rates View
G.2.4
Using the Cost List View
G.2.5
Using the ETL History View
G.2.6
Additional Exceptions
H
Troubleshooting Oracle Business Intelligence Applications
H.1
Oracle Business Analytics Warehouse Installation and Initial Configuration Issues
H.2
Informatica and Loading Issues
H.3
Unicode Issues with Informatica and the Oracle Business Analytics Warehouse
H.4
UNIX Installation Issues with the Oracle Business Analytics Warehouse
H.5
Oracle Business Analytics Warehouse Upgrade Issues
H.6
Oracle BI Interactive Dashboard Issues
H.7
ETL Issues
Index