Skip Headers
Oracle® Fusion Middleware Configuration Guide for Oracle Business Intelligence Applications
11
g
Release (11.1.1)
Part Number E16814-01
Home
Book List
Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Documentation Accessibility
Audience
Related Documents
Conventions
1
What's New in This Release
1.1
What's New in Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Applications
1.2
System Requirements and Certification
2
Overview
2.1
Overview
Part I Setting Up Oracle Business Intelligence Applications
3
Pre-installation and Pre-deployment Requirements for Oracle BI Applications
3.1
Oracle-Specific Database Guidelines for Oracle Business Analytics Warehouse
3.2
Additional Suggestions for Optimizing Oracle Performance in Oracle Business Analytics Warehouse
3.3
Creating Custom Indexes in Oracle Fusion Applications Database for Incremental Load Performance
3.4
Code Page and Data Movement Requirements
4
Setting Up Oracle Business Intelligence Applications
4.1
Before You Set Up Oracle BI Applications
4.2
Overview of Setting Up Oracle BI Applications
4.2.1
About Setting Up Oracle BI Applications
4.2.2
About the Components in an Oracle BI Applications Environment
4.2.3
Summary of Home Directories
4.2.4
Overview of Tasks for Setting Up Oracle Business Intelligence Applications
4.3
Setting Up Oracle BI Applications
4.3.1
Step 1: Create the Required Database
4.3.2
Step 2: Create Schemas and Data Warehouse Objects for Oracle BI Applications
4.3.2.1
Creating Oracle BI Applications Schemas Using Oracle BI Applications RCU
4.3.2.2
Creating Data Warehouse Objects with the Oracle Sales Prediction Engine RCU
4.3.3
Step 3: Apply Patches
4.3.4
Step 4: Install and Set Up Informatica PowerCenter
4.3.4.1
Before Installing Informatica PowerCenter for Oracle BI Applications Environments
4.3.4.2
Locations of Installation Files for Informatica PowerCenter and Hotfix 11
4.3.4.3
Prerequisites for Installing Informatica PowerCenter for Oracle BI Applications Environments
4.3.4.4
Installing Informatica PowerCenter Client Tools (Windows)
4.3.4.5
Installing Informatica PowerCenter Services and Hotfix 11
4.3.4.6
Install and Configure Database Connectivity Software
4.3.4.7
Creating the Informatica Repository Service
4.3.4.8
Creating the Informatica Integration Service
4.3.4.9
Restoring the Prebuilt Informatica Repository
4.3.4.10
Copying Source Files to the Informatica PowerCenter Services Computer
4.3.4.11
Setting PowerCenter Integration Services Relaxed Code Page Validation
4.3.4.12
Setting PowerCenter Integration Services Custom Properties
4.3.4.13
Creating the Repository Administrator User in the Native Security Domain
4.3.4.14
Accessing Informatica Domain and Repository from Informatica Client Tools
4.3.5
Step 5: Install Oracle BI Administration Tool
4.3.6
Step 6: Extend the BI Domain
4.3.7
Step 7: Configure the Oracle BI Repository File (RPD)
4.3.8
Step 8: Grant User Access to Oracle BI Applications Components
4.3.9
Step 9: Create a User for ETL
4.3.10
Step 10: Configure Oracle HTTP Server
4.3.11
Step 11: Configure SSO for Configuration Manager and Functional Setup Manager
4.3.12
Step 12: Install the DAC Client
4.3.13
Step 13: Configure the DAC Server URL
4.3.14
Step 14: Configure DAC Integration Settings
4.3.14.1
Setting DAC System Properties
4.3.14.2
Registering Informatica Services in DAC
4.3.15
Step 15: Configure Physical Data Source Connections in DAC
4.3.16
Step 16: Configure Relational Connections in Informatica
4.3.16.1
Create an ODBC DSN to the Oracle BI Server
4.3.16.2
Create Informatica Relational Connections
4.3.17
Step 17: Set SiebelUnicodeDB Property in Informatica Integration Services
4.3.18
Step 18: Enable User Currency Preference Settings
4.3.18.1
Enabling the Currency User Preference File for Oracle BI Applications
4.3.18.2
Editing Currency Display Names
4.3.18.3
Enable Document Currency
4.3.19
Step 19: Optimize the Repository File (RPD) for Oracle BI Applications
4.3.20
Step 20: Register Source Systems and Enable Offerings
4.3.20.1
Registering Source Systems
4.3.20.2
Enable Offerings for Standardization
4.3.21
Step 21: Set Languages for Data Load
4.3.22
Step 22: Run Domains ETL
4.4
Next Steps
Part II Functional Configuration for Oracle Business Intelligence Applications
5
Overview of Functional Configuration in Oracle BI Applications
5.1
Terminology
5.2
Overview of BI Applications Configuration Manager and Functional Setup Manager
5.2.1
What is Oracle BI Applications Configuration Manager?
5.2.2
What is Functional Setup Manager?
5.3
Getting Started With Oracle BI Applications Configuration Manager
5.3.1
About Starting Oracle BI Applications Configuration Manager
5.3.2
About Getting Help
5.3.3
About Setup Data Migration in Oracle BI Applications Configuration Manager
5.4
About Users and Roles in Oracle BI Applications Configuration Manager
5.5
About Setup Objects in Configuration Manager
5.6
About Functional Setup Tasks in FSM
5.7
About the Main Task Areas in Oracle BI Applications Configuration Manager
5.8
About the Oracle BI Applications Configuration Manager Work Area
5.8.1
About the Work Area
5.8.2
About the Menu Options
5.8.3
About the Icons
5.8.4
How to use Query By Example
6
Performing Functional Configuration
6.1
What is Functional Configuration?
6.1.1
About Task Lists and Tasks for Oracle Business Intelligence Applications Offerings
6.1.2
About Administrator Passwords
6.2
Roadmap for Functional Configuration
6.3
Performing Functional Configuration
6.3.1
How to Enable Offerings and Select Feature Choices
6.3.2
How to Create an Implementation Project and Select Offerings
6.3.3
Additional Steps for Managing Projects in FSM
6.3.3.1
About Performing Functional Tasks
6.3.3.2
How to Assign Tasks to Functional Developers
6.3.3.3
How to Perform Functional Tasks using the Administrator role
6.3.3.4
How to Perform Functional Tasks using the Functional Developer role
6.3.3.5
How to Monitor Implementation Projects
6.3.3.6
How to Monitor Functional Setup Tasks
6.3.3.7
About Completing Tasks in the Common Areas and Dimensions Configurations area
7
Administering and Maintaining Functional Configuration Data
7.1
About Maintaining and Administering Functional Configuration Data
7.2
Roadmap for Setup Data Maintenance and Administration
7.3
About Functional Configuration Data
7.4
About Working With Domains and Domain Mappings
7.4.1
About Domain Mappings and Domain Member Mappings
7.4.2
About Source Domains
7.4.3
About Warehouse Domains
7.4.4
About Warehouse Domain Hierarchies
7.4.5
About Setting Up Domain Member Mappings
7.4.5.1
How to edit a Domain Member Mapping
7.4.5.2
How to add a Range Member Mapping
7.4.5.3
How to add a Target Domain Member
7.4.6
How to modify a Warehouse Domain Hierarchy
7.4.7
Why are some domains non-extensible?
7.5
About Working With Data Load Parameters
7.5.1
About Global Data Load Parameters
7.5.1.1
About Editing Global Data Load Parameters
7.5.2
About Application-Specific Data Load Parameters
7.5.2.1
About Overridable and Non-Overridable Application-Specific Parameter Values
7.5.2.2
About Editing Application-Specific Parameter Values
7.5.2.3
How to Edit a Data Load Parameter value
7.6
About Working With Reporting Parameters
7.7
How to Monitor Setup Data
7.8
How to Change Configuration Values Using Oracle BI Applications Configuration Manager
7.9
How to Locate Unmapped Domain Values in Oracle BI Applications Configuration Manager
7.10
About Adding Target Domain Members
7.10.1
How to add a Target Domain Member
7.11
Viewing Domain Hierarchies
7.12
About Exporting and Importing Setup Data for Oracle BI Applications Configuration Manager
7.12.1
What Data is Exported?
7.12.2
What Data is Imported?
7.12.3
About Migrating Setup Data
7.12.4
About Backing-up Setup Data
7.12.5
How to Export Setup Data
7.12.6
How to Import Setup Data
Part III Appendices
A
Supporting Tasks
A.1
Enabling DAC Client Communication with Informatica PowerCenter
A.1.1
How to Define the Informatica Domains File Path in the DAC Client Environment Variables
A.1.2
How to Verify the DAC Client Is Able to Use pmrep and pmcmd
A.2
Enabling DAC Server Communication with Informatica PowerCenter
A.2.1
How to Set Environment Variables for DAC Server Communication on Windows
A.2.2
How to Set Environment Variables for DAC Server Communication on UNIX
A.2.3
How to Verify Java JDK Availability and Version
A.3
How to Log Into Informatica PowerCenter Administration Console
A.4
How to Start Oracle BI Applications Configuration Manager
A.5
Optimizing a Repository File (RPD) for Oracle BI Applications
A.5.1
Overview of Optimizing the Repository File (RPD) for Oracle BI Applications
A.5.2
Extracting Oracle BI Applications Projects
A.5.3
Merging Repositories for Oracle BI Applications Projects
B
Functional Configuration Task Reference
B.1
Lists of Functional Configuration Tasks For Each Offering
B.1.1
List of Functional Configuration Tasks for Common Areas and Dimensions
B.1.2
List of Functional Configuration Tasks for Oracle Customer Data Management Analytics
B.1.3
List of Functional Configuration Tasks for Oracle Financial Analytics
B.1.4
List of Functional Configuration Tasks for Human Resources Analytics
B.1.5
List of Functional Configuration Tasks for Oracle Marketing Analytics
B.1.6
List of Functional Configuration Tasks for Oracle Partner Analytics
B.1.7
List of Functional Configuration Tasks for Oracle Procurement and Spend Analytics
B.1.8
List of Functional Configuration Tasks for Oracle Product Information Management Analytics
B.1.9
List of Functional Configuration Tasks for Oracle Project Analytics
B.1.10
List of Functional Configuration Tasks for Oracle Sales Analytics
B.1.11
List of Functional Configuration Tasks for Oracle Supply Chain and Order Management Analytics
B.2
Informational Task Reference
B.3
ETL Notes and Additional Information for Oracle Product Information Management Analytics
B.4
ETL Notes and Additional Information for Oracle Supply Chain and Order Management Analytics
B.5
ETL Notes and Additional Information for Oracle Procurement and Spend Analytics
B.6
ETL Notes and Additional Information for Oracle Customer Data Management Analytics
B.7
ETL Notes and Additional Information for Oracle Project Analytics
B.8
ETL Notes and Additional Information for Oracle Partner Analytics
B.9
ETL Notes and Additional Information for Oracle Financial Analytics
B.10
ETL Notes and Additional Information for Oracle HR Analytics
B.11
ETL Notes and Additional Information for Oracle Marketing Analytics
B.12
ETL Notes and Additional Information for Oracle Sales Analytics
B.13
How to Integrate Project Analytics with Procurement and Spend Analytics
B.14
How To Integrate Procurement and Spend Analytics with Spend Classification
B.14.1
Overview to Oracle Spend Classification Integration
B.14.2
About the Oracle Spend Classification Metadata
B.14.3
How to deploy UNSPSC, Oracle Purchasing Categories, and Custom Category1
B.14.4
How to deploy the additional Custom Category2 and Custom Category3
B.15
How to remove or hide Oracle Spend Classification Integration Metadata
B.16
How to Configure the Inventory Transaction Aggregate Table for ETL Runs
B.17
How to Add Dates to the Order Cycle Time Table for Post-Load Processing
B.18
How to Add Closed Orders to Backlog Calculations
B.19
How to Track Multiple Attribute Changes in Bookings
B.20
How to Integrate Project Analytics with Financial Analytics
B.21
How to Include Uncompleted Invoice Lines
B.22
How to Configure Backlog Period Date
B.23
How To incrementally Refresh the Inventory Monthly Balance Table
B.24
How to Enable Project Analytics Integration with Supply Chain and Order Management Analytics
B.25
How to Integrate Project Analytics with Procurement and Spend Analytics
B.26
How to Set Up Drill Down in Oracle BI EE from General Ledger to Subledger
B.27
How to Implement GL Segment and GL Account Dimensions
B.27.1
Configuring the BI Extender
B.27.2
Configuring GL Segment and GL Account Dimensions
B.27.2.1
Configuring GL Segment Dimensions
B.27.2.2
Configuring GL Account Dimension
B.28
How to Set Up GL Balance Segment Aggregates
B.29
How to Integrate Financial Analytics with Project Analytics
B.30
How to Perform RPD Modifications for Cost and Revenue Time Grain Changes
B.31
How to Assign Group Account Numbers to Natural Accounts for Human Resources Analytics
B.32
How to Configure Group Account Numbers
B.33
How To Customize Extended Cross Functional Security for Accounts Payables
B.34
How To Customize Extended Cross Functional Security for Employee Expenses
B.35
How To Customize Security for Procurement Executive / Spend Analyst
B.36
How to Grant Cross Functional Access to Order Management Users
B.37
How To Grant GL Data Role to HR VP Users
B.38
How to Implement Asset Category and Asset Location Dimension
B.39
How to Perform System Setups and Post Install Tasks for Oracle BI Applications
B.40
How to Reload the Time Dimension Tables After the Data Warehouse Is Loaded
B.41
How To Configure Scorecard Target Before Running ETL
B.42
How to Configure Order Item and Service Request Flat Files For ETL
B.42.1
Flat file file_orderitem_fs.csv
B.42.2
Flat file file_srvreq_fs.csv
B.42.3
Flat file file_srvreq_ds.csv
B.43
How to Add Balances to BI Balance Group
B.44
Getting Started With Functional Configuration
B.45
Overview of Oracle Sales Analytics
B.46
Overview of Oracle Marketing Analytics
B.47
Overview of Oracle Partner Analytics
B.48
Overview of Oracle Human Resources Analytics
B.49
Overview of Oracle Customer Data Management Analytics
B.50
Overview of Oracle Financial Analytics
B.51
Overview of Oracle Product Information Management Analytics
B.52
Overview of Oracle Project Analytics
B.53
Overview of Oracle Procurement and Spend Analytics
B.54
Overview of Oracle Supply Chain and Order Management Analytics
B.55
About Configuring Initial Extract Date
B.56
About Configuring Global Currencies
B.57
About Configuring Calendars
B.57.1
About Specifying a Gregorian Calendar Date Range
B.57.2
About Defining an Enterprise Calendar
B.57.3
About Configuring Data Load Parameters for File Based Calendars (also known as Generated Calendars)
B.58
About Configuring Slowly Changing Dimensions
B.59
About Configuring Reporting Parameters for Year Prompting
C
Dialog Reference for Oracle BI Applications Configuration Manager
C.1
Add Warehouse Domain Member/Add Target Domain Member button
C.2
Add Warehouse Domain Member/Add Target Domain Member dialog
C.3
Define Business Intelligence Applications Instance: Source System tab
C.4
Define Business Intelligence Applications Instance: Target Warehouse tab
C.5
Edit Business Analytics Warehouse dialog
C.6
Edit Domain Member Mappings dialog
C.7
Edit Parameter Value dialog (for Data Load Parameters)
C.8
Edit Parameter Value dialog (for Reporting Parameters)
C.9
Edit Preferred Currency Name dialog
C.10
Export Data dialog
C.11
Export Setup Data dialog
C.12
Edit Source dialog
C.13
Import Data dialog
C.14
Import Setup Data dialog
C.15
Manage BI Applications: BI Applications Offerings tab
C.16
Manage BI Applications: Warehouse Languages tab
C.17
Manage Data Load Parameters dialog
C.17.1
Icons on the Data Load Parameters dialog
C.18
Manage Domains and Mappings: Domain Mappings tab
C.19
Manage Domains and Mappings: Source Domains tab
C.20
Manage Domains and Mappings: Warehouse Domains tab
C.21
Manage Domains and Mappings: Warehouse Domain Hierarchies tab
C.22
Manage Preferred Currencies dialog
C.23
Manage Reporting Parameters: Global/Application Specific tab
C.24
Overview Page for Oracle BI Applications Configuration Manager
C.25
Register Source dialog
C.26
Search Area
C.27
Getting Started With System Setup
Index
Scripting on this page enhances content navigation, but does not change the content in any way.