Skip Headers
Oracle® Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
Version 7.9.5.1
Part Number E13765-01
Home
Book List
Index
Contact Us
Next
View PDF
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Getting Started
1
What's New in This Release
What's New in
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
?
2
Overview of Oracle BI Applications
What Is Oracle BI Applications?
Oracle Business Analytics Warehouse Overview
Oracle Business Analytics Warehouse Architecture
Oracle Business Analytics Warehouse Architecture Components
Roadmap to Installing and Setting Up Oracle BI Applications
Using Oracle BI Repository Documentation
Part II Installation and Set Up Steps for Oracle BI Applications
3
Preinstallation and Predeployment Requirements for Oracle BI Applications
Operating System, Driver, and Connectivity Requirements for Oracle Business Analytics Warehouse
General Guidelines for Setting Up Oracle Business Analytics Warehouse
IBM DB2 UDB-Specific Database Guidelines for Oracle Business Analytics Warehouse
IBM DB2 UDB zOS and OS/390 and z/OS-Specific Database Guidelines for Oracle Business Analytics Warehouse
SQL Server-Specific Database Guidelines for Oracle Business Analytics Warehouse
Setting the ANSI NULL Option
Modifying the DB Library Options Setting
Recommended SQL Server Database Parameters
Teradata-Specific Database Guidelines for Oracle Business Analytics Warehouse
Installation of Required JDBC Driver for Teradata Databases
General Guidelines for Teradata Deployments
Best Practices For Teradata Deployments
LEFT OUTER JOIN Issue
Additional Statistics Required
Oracle-Specific Database Guidelines for Oracle Business Analytics Warehouse
Additional Suggestions for Optimizing Oracle Performance in Oracle Business Analytics Warehouse
Miscellaneous Information About Oracle BI Applications Deployments
Preconfigured Mapping for the SA System Subject Area
Using Initialization Blocks
Creating Custom Indexes in Siebel Source Databases for Incremental Load Performance
An Example of Change Capture SQL and Required Indexes
Creating Custom Indexes in Oracle EBS Source Database for Incremental Load Performance
Creating Indexes for Category 1 Tables
Creating Indexes for Category 2 Tables
Running an ETL with a Non-English OLTP Data Source
Partitioning Guidelines For Large Fact Tables
Introduction to Partitioning Large Fact Tables
How to Partition Large Fact Tables
Configure DAC to Support ETL for Partitioned Tables
Example XML Files
Pre_W_REVN_F_ini.xml - Pre SQL XML File Name for Full Load
Post_W_REVN_F_ini.xml - Post SQL XML File Name for Full Load
Pre_W_REVN_F_incr.xml- Pre SQL XML File Name for Incremental Load
Post_W_REVN_F_incr.xml- Post SQL XML File Name for Incremental Load
4
Installing and Setting Up Oracle BI Applications
About Oracle BI Applications Topologies
High-Level Installation and Configuration Task List
Mandatory Requirements and Preinstallation Tasks
Oracle Business Intelligence Infrastructure Requirements
Informatica PowerCenter Requirements
Code Page and Data Movement Requirements
Preinstallation Tasks
Create Databases for Oracle BI Applications and Informatica PowerCenter Components
Install Database Connectivity Software
Create ODBC Database Connections
Set Environment Variables
Download and Install the Java JDK
Download Hibernate Libraries
Running the Oracle BI Applications Installer on Windows
Installing Informatica PowerCenter Services Software
Installing Informatica PowerCenter Client Tools (Windows)
Installing Informatica PowerCenter Services
Restoring the Prebuilt Informatica Repository
Configuring Informatica PowerCenter Components
Copying Source Files and Lookup Files
Setting PowerCenter Integration Services Relaxed Code Page Validation
Setting PowerCenter Integration Services Custom Properties
Installing an Additional Instance of the DAC Client on Windows
Configuring the DAC Client
Copying Hibernate Files to the DAC Directories
Installing JDBC Drivers for DAC Database Connectivity
Configuring the DAC Config.bat File
Enabling DAC Client Communication with Informatica PowerCenter
How to Install Informatica pmcmd and pmrep Command Line Programs
How to Define the Informatica Domains File Path in the DAC Client Environment Variables
How to Verify the DAC Client Is Able to Use pmrep and pmcmd
Logging into DAC for the First Time and Creating the DAC Repository
Logging into DAC
Creating the DAC Repository Schema
Importing Metadata into the DAC Repository
Creating the Oracle Business Analytics Warehouse Tables
Creating Data Warehouse Tables
Creating Data Warehouse Tables on a Teradata Database
Installing the DAC Server
Installing an Additional Instance of the DAC Server on Windows
Installing the DAC Server on UNIX
Configuring the DAC Server
Configuring the Connection Between the DAC Server and DAC Repository
How to Configure the DAC Server Repository Connection Using the DAC Client (Windows)
How to Configure the DAC Server Repository Connection Using serverSetupPrompt Scripts (Windows, UNIX or Linux)
Enabling DAC Server Communication with Informatica PowerCenter
How to Set Environment Variables on Windows
How to Set Environment Variables on UNIX or Linux
How to Verify Java JDK Availability and Version
Starting the DAC Server
Activating Join Indexes for Teradata Databases
Configuring DAC Integration Settings
Setting DAC System Properties
Registering Informatica Services in DAC
Setting Physical Data Sources
Configuring Relational Connections in Informatica Workflow Manager
Logging Into Informatica PowerCenter Workflow Manager
Configuring Relational Connections in Informatica PowerCenter Workflow Manager
How to Configure Relational Connections
(Teradata specific) How to Configure the Informatica Repository for Teradata External Loader Connections
Configuring the SiebelUnicodeDB Custom Property
Setting Up DAC to Receive Email Notification
Configuring Email Recipients in DAC
Configuring Email in the DAC Server
Additional Configuration Tasks
Setting DAC Source System Parameters
Creating Stored Procedures for DB2-UDB
How to Verify the Existence of Stored Procedures
How to Create DB2 Stored Procedures
Siebel-Specific Configuration Tasks
Migrating Seed Data from a Siebel Source System to the Oracle BI Repository
Updating Siebel Transactional Database Schema Definitions
Teradata-Specific Configuration Tasks
Setting Up the Code Page File Property for Unicode Environments on Teradata Databases
Setting Up the HOSTS File for Teradata Installations on Windows
Setting Up the HOSTS File for Teradata Installations on UNIX
Teradata-Specific Installation Checklist
About Running A Full Load ETL
An Example of Running a Full Load ETL
Part III Appendices
A
Supporting Tasks for DAC and Informatica PowerCenter
How to Log into DAC
How to Set DAC System Properties
How to Start and Stop the DAC Server
How to Log Into Informatica PowerCenter Administration Console
How to Start and Stop Informatica Services
How to Stop and Start the Informatica Repository Service (Optional)
About the DAC Server Scripts for Bash and C Shells
How to Configure the DAC Metadata Repository
How to Set Up DAC System Properties
How to Activate Join Indices for Teradata Databases
B
Configuring Universal Adapter for CRM Analytics
What is Universal Adapter for CRM Analytics?
Data Format Requirements
About the Sample Source Files Provided
How to Create Data Files for Universal Adapter for CRM Analytics
List of Sample Source Files for Universal Adapter for CRM Analytics
List of Source Files for Seed Data and Common Dimensions
List of Source Files for Specific Subject Areas
C
Localizing Oracle Business Intelligence Deployments
Process of Maintaining Translation Tables for Oracle BI
Upgrading Oracle Business Intelligence Seed Data for Non-English Locales
Importing Locale Seed Data Into The Translation Table (W_LOCALIZED_STRING_G)
Externalizing Customer Metadata Strings
Adding Custom Translations to the W_LOCALIZED_STRING_G Table
Adding String Translations for Analytics Metadata
About Translating Presentation Services Strings
Changing the Default Currency in Analytics Applications
D
Integrating Interactive Dashboards and Operational Applications Data
Importing Oracle's Siebel Industry Applications Seed Data
Completing the Initialization in the Siebel Operational Application
Updating the Siebel Operational Application
Reapplying Customized Style Sheets
How to Configure Oracle Business Intelligence with Oracle's Siebel Web Extension (SWE)
Creating a Virtual IP Address for the SWE and Oracle BI Presentation Services
Testing the Virtual IP Configuration for Oracle Business Intelligence and the SWE
How to Configure Oracle BI Action Links
Testing Action Links
Process of Integrating Analytics and Oracle's Siebel Operational Applications
Accessing Optional Analytics Applications
Configuring the Browser Settings for Operational Applications
Process of Customizing Oracle BI Application Home Page and Dashboards
Customizing Oracle BI Content on the Siebel Operational Application Home Page
Determining the Oracle BI Report Path Argument
Adding Views for Custom Oracle BI Interactive Dashboards
Verifying NQHOST Setup for Pharma Disconnected Analytics Client
Integrating the Pharma Application Home Page with the Pharma Disconnected Analytics Client
Importing Pharma Application Target Lists to the Pharma Disconnected Analytics Client
Viewing Information About Preconfigured Dashboards
Exposing Dashboards and Requests
Locating Dashboard and Page Names
E
Configuring Metadata for Analytics Applications
What Are Oracle's Siebel Operational Applications?
Updating Financial Analytics Logical Table Sources
Externalizing Financial Services Metadata Translation Strings
Disabling the Financial Analytics Logical Table Sources
Developing and Deploying Predictive Scores
Analytics Metadata Requirements for Oracle's Siebel Industry Applications
Oracle's Siebel Consumer Sector Dashboards and Pages
Oracle's Siebel Consumer Sector Data Requirements
Oracle's CME family of products (Oracle Communications, Media and Energy Sales Analytics
Oracle's Siebel CME Dashboards and Pages
Oracle's Siebel CME Data Requirements
Oracle Pharma Sales Analytics Dimensions
Positions Dimension
Alignments Dimension
Products Dimension
Product Costs Dimension
Dimensions Specific to Subject Areas in Oracle Pharma Sales Analytics and Oracle Pharma Marketing Analytics
Pharma Sales Effectiveness
Pharma Product Categories
Pharma Promotional Effectiveness
Pharma Medical Education Effectiveness
Pharma Objectives Achievement`
F
Oracle Business Analytics Warehouse for Life Sciences Data Considerations
What's New for Pharma Analytics in Version 7.9
Oracle Business Analytics Warehouse for Life Sciences Overview
Importing Syndicated Data into Oracle Business Analytics Warehouse
Syndicated Loading Definitions
Data Types Supported in the Oracle Business Analytics Warehouse
Loading Syndicated Data into the Oracle Business Analytics Warehouse
Loading From a Flat File Source Using Syndicated Data Staging Tables and Cross-Referencing Tables
Loading From a Flat File Source Using Syndicated Market Staging Tables
Syndicated Data Flat File Formats
Syndicated Data Flat File for Direct Sales Data
Syndicated Data Flat File for Indirect Sales Data
Syndicated Data Flat File for Prescription Data
Syndicated Data Flat File for Plan Level Rx Data
Syndicated Data Flat File for Physician Plan Level Rx Data
Syndicated Data Flat File for Weekly Early View Data
Syndicated Market Flat File for Indirect Sales Data
Syndicated Market Flat File for Prescription Data
Syndicated Market Flat File for Plan Level Rx Data
Syndicated Market Flat File for Physician Plan Level Rx Data
Syndicated Market Flat File for Weekly Early View Data
Flat File Cross-Reference Data Population Rules
Life Sciences Data Loading Issues with Oracle Business Analytics Warehouse
Known Issues with the Syndicated Data Fact Tables
Incremental Updates in the Oracle Business Analytics Warehouse LS Dimension Tables
W_ALIGNMT_DH
W_ALIGNVER_DH
G
Pharma Disconnected Analytics Administration - Supplemental Information
About Pharma Disconnected Analytics
Sourcing Reports for Oracle's Pharma Disconnected Analytics
H
Using Oracle Business Analytics Warehouse Exception Reports
Understanding Oracle Business Analytics Warehouse Exceptions
List of Values Exceptions
Cost List Exceptions
Products Without a Cost List
Exchange Rate Exceptions
Invalid Hierarchy Exceptions
Circular Hierarchy Exceptions
Executing Oracle Business Analytics Warehouse Exception Reports
Cleansing Data
Using the List of Values View
Using the Exchange Rates View
Using the Cost List View
Using the ETL History View
Additional Exceptions
I
Troubleshooting Oracle BI Applications
Oracle Business Analytics Warehouse Installation and Initial Configuration Issues
Informatica and Loading Issues
Unicode Issues with Informatica and the Oracle Business Analytics Warehouse
UNIX Installation Issues with the Oracle Business Analytics Warehouse
Oracle Business Analytics Warehouse Upgrade Issues
Oracle BI Interactive Dashboard Issues
ETL Issues
J
About the Versioned Informatica Repository
Summary of Versioning in the Informatica Repository
Customization of Repository Objects Using Check Out and Check In
Index