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.3.23 Step 23: Verifying Duty Roles required for Oracle BI Applications
• 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 Oracle 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 About sorting items
  • 5.8.5 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.1.1 About Regular Domains and Band Domains
  • 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
• A.6 Verifying Duty Roles required for Oracle BI Applications

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