Contents

New Features for Oracle BI Applications Installation

1 Oracle BI Applications Architecture and Installation Overview

• Oracle BI Applications Architecture
• Oracle BI Applications Installation Roadmap

2 Preinstallation and Deployment Requirements for Oracle BI Applications

• General Guidelines for Setting Up Databases for Oracle BI Applications
  • Guidelines for Setting Up Oracle Business Analytics Warehouse Databases
  • Why Use a Separate Database for the Oracle Business Analytics Warehouse ?
  • General Guidelines for Oracle Databases
  • Guidelines for Using Oracle Template Files

  3 Installing and Setting Up Oracle BI Applications

  • Hardware Requirements
  • Installation Prerequisites for Oracle BI Applications
    • Installing JDK
    • Installing Oracle WebLogic Server
    • Running Oracle Fusion Middleware Repository Creation Utility
    • Oracle BI Enterprise Edition 11 g Installation
    • Installing Oracle Data Integrator
    • Database Instances for Schemas and Repositories
    • Creating Schemas Using Business Analytics Applications Suite RCU
    • Installing Oracle BI Applications Using the Business Analytics Applications Suite Installer
    • Applying the Oracle Fusion Middleware Platform Patch
    • Updating ATGLite
    • Updating FSM
    • Updating BIACM
    • Oracle Business Intelligence Configuration
    • Configuring Oracle BI Applications
    • How to Start the BI and ODI Managed Servers
    • Installing ODI Studio
      • Installing ODI Studio
      • Configuring User Access for ODI Studio

      4 Performing Post-Installation System Setup Tasks

      • Setting the Business Analytics Warehouse Connection in Oracle Data Integrator
      • Creating SDS Schema Post Installation
      • Performing Setup Steps for On-Premises Oracle Fusion Applications Sources
        • Creating a User for ETL
        • Configuring the Oracle BI Repository for ETL
        • Extracting Projects From Full Repository
        • Merging Repositories

        5 Setting Up Fusion Applications Cloud Data Sources

        • Overview of Oracle Fusion Applications Cloud Source System Support
        • Fusion Applications Cloud Source System Deployment Options
        • Fusion Application Cloud Source System Deployment Roadmap
        • Creating Service Requests for Oracle Business Intelligence Cloud Connector Console
        • Provisioning a User for Export and Import of BI Data from Fusion UCM
        • Provisioning a User for Oracle BI Cloud Connector Console Access
        • Register the Fusion Applications Source
        • Configuring Oracle Universal Content Management URL for Federated SSO
        • Creating a Load Plan and Specifying Offerings and Fact Groups to Load
        • Extracting Data into Universal Content Management using Oracle BI Cloud Connector Console
        • Synchronizing Deletes for a Cloud Extract
        • Configure Proxy Settings for WebLogic Server
        • Managing Fusion Flex Extensions in Release 11.1.1.10.2
        • Setting Up Key Flex Fields for Financials Fusion Applications Source Data
          • Using Oracle BI Cloud Connector Console to Configure Cloud Extract
          • Using ODI to Set Up Key Flex Fields
          • Additional Steps for Fusion Financials Implementations

          6 Setting Up Oracle Service Cloud Data Source

          • Configuring Oracle Service Cloud Source System
          • Creating an Account on the Oracle Service Cloud Site
          • Reviewing SEC_PAPI_INTEG_HOSTS_SOAP Configuration
          • Registering Oracle Service Cloud Source System
          • Enabling Offerings for Oracle Service Cloud Source System
          • Specifying Offerings to Load for Oracle Service Cloud Source System
          • Mapping Domain Member Values for Oracle Service Cloud Source System
          • Managing Data Load Parameters for Oracle Service Cloud Source System

          7 Setting Up Oracle Taleo Cloud Data Source

          8 Deploying the ODI Repository for Non-Oracle Source Databases

          • Exporting Security Settings from Original ODI Repository
          • Exporting Topology Settings from Original ODI Repository
          • Creating a New Master Repository
          • Connecting to the New Master Repository
          • Creating a New Work Repository
          • Importing Source Adaptor Metadata Content into the New ODI Repository
            • Preparing to Import Source Adaptor Metadata Content
            • Running the Command Line Utility to Import Source Adaptor Metadata Content

            A Repository Creation Utility Screens

            • Welcome Page for RCU
            • Create Repository
            • Database Connection Details
              • Specifying Connection Credentials for Oracle Databases and Oracle Databases Enabled for Edition-Based Redefinition
              • Specifying Connection Credentials for Oracle MySQL Databases
              • Specifying Connection Credentials for Microsoft SQL Server Databases
              • Specifying Connection Credentials for IBM DB2 Databases
              • Database Users for IBM DB2 Databases
              • Creating Prefixes
              • Selecting Components and Dependencies
              • Custom Schema Names
              • Checking Schema Prerequisites
              • Dropping Schemas
              • Custom Variables for Oracle Business Intelligence Applications
              • Custom Variables for Master and Work Repository (ODI)
              • Custom Variables for Oracle WebCenter Portal 's Activity Graph and Analytics
              • Default Tablespace Mappings
              • Changing Default and Temporary Tablespaces
              • Viewing and Changing Additional Tablespaces
              • Managing Tablespaces and Datafiles
                • Managing Tablespaces
                • Managing Datafiles
                  • Add Datafile Dialog
                  • Modifying a Datafile
                  • Deleting a Datafile

                  B Installer Screens Common to All Oracle Fusion Middleware Suites

                  • Specify Inventory Location
                  • Inventory Location Confirmation
                  • Welcome Page for the Oracle Fusion Middleware Installer
                  • Prerequisite Checks
                  • Security Updates
                  • Software Updates
                  • Installation Location
                  • Application Server Screen
                  • Summary of Installation and Configuration Options
                  • Installation Progress
                  • Configuration Progress
                  • Complete

                  C Oracle BI Applications Installation and Configuration Screens

                  • Welcome Page for Business Analytics Applications Suite Installer
                  • Specify Installation Location for Business Analytics Applications Suite Installer
                  • Welcome Page for the configApps File
                  • Extend BI Domain
                  • Specify Installation Location for configApps
                  • Configure Components
                  • Repository Encryption Password
                  • Oracle BI Applications Administrator User
                  • MDS Schema
                  • Oracle BI Applications Components Repository Schema
                  • Business Analytics Warehouse Schema
                  • Oracle BI Applications ODI Repository Schema
                  • Configure Ports

                  D Generating DDL and Assigning Tablespaces to Tables and Indexes

                  • Overview of Oracle Business Analytics Warehouse Tables
                  • Generating the Oracle Business Analytics Warehouse DDL
                  • Oracle BI Applications Patches
                  • Assigning Tablespaces

                  E Integrating Interactive Dashboards and Siebel Operational Applications Data

                  • Updating the Siebel Operational Application
                  • Reapplying Customized Style Sheets
                  • How to Configure Oracle Business Intelligence with Oracle's Siebel Web Server Extension (SWSE)
                  • Creating a Virtual IP Address for the SWSE and Oracle BI Presentation Services
                  • Testing the Virtual IP Configuration for Oracle Business Intelligence and the SWSE
                  • About Configuring Oracle BI Action Links
                  • Accessing Optional Analytics Applications
                  • Customizing Oracle BI Applications Home Page and Dashboards
                    • Configuring a New Home Page to Use a Symbolic URL
                    • Determining the Oracle BI Report Path Argument
                    • Adding Views for Custom Oracle BI Interactive Dashboards
                    • Exposing Dashboards and Requests
                    • Locating Dashboards, Page Names, and Reports

                    F Preconfigured Mappings for Siebel System Subject Area