Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Getting Started

1 What's New in This Release

• 1.1 What's New in Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users

2 Overview of Configuring Oracle Business Intelligence Applications

• 2.1 High-Level Overview of Configuring ETL for Oracle BI Applications

Part II Configuring Common Areas and Dimensions

3 Configuring Common Areas and Dimensions

• 3.1 Source-Independent Configuration Steps
  • 3.1.1 How to Configure Initial Extract Date
  • 3.1.2 How to Configure Global Currencies
  • 3.1.3 How to Configure Exchange Rate Types
  • 3.1.4 About Configuring Calendars
    • 3.1.4.1 Overview of Calendars in Oracle BI Applications
    • 3.1.4.2 About Configuring Calendars
    • 3.1.4.3 Notes on Configuring Calendars
    • 3.1.4.4 How to Set Up the Gregorian Calendar Date Range
    • 3.1.4.5 How to Configure PeopleSoft Summary Calendars
    • 3.1.4.6 How to Set Up an Enterprise Calendar Using an Oracle EBS Source System
    • 3.1.4.7 How to Set Up an Enterprise Calendar Using a PeopleSoft Source System
    • 3.1.4.8 How to Set Up an Enterprise Calendar Using an Oracle JD Edwards EnterpriseOne Source System
    • 3.1.4.9 How to Set Up an Enterprise Calendar Using an Oracle JD Edwards World Source System
    • 3.1.4.10 How to Set Up a 13 Period Calendar
    • 3.1.4.11 How to Set Up a 4-4-5 Calendar
    • 3.1.4.12 How to Use a Fiscal Calendar Loaded Through the Universal Adapter
    • 3.1.4.13 How to Use a PeopleSoft Summary Calendar
    • 3.1.4.14 Examples of Configuring the Universal Adapter
    • 3.1.4.15 How to Reload the Time Dimension Tables After the Data Warehouse Is Loaded
    • 3.1.4.16 ETL Process Flow Diagrams
  • 3.1.5 About Mapping GL Accounts to Group Account Numbers for All Source Systems
  • 3.1.6 Configuration Steps for Controlling Your Data Set for All Source Systems
    • 3.1.6.1 How to Configure Data Source Numbers
  • 3.1.7 About Support for Back-Dated Change Scenarios
  • 3.1.8 Supported Back-Dated Change Scenarios That Affect Position Hierarchy
    • 3.1.8.1 Scenario 1
    • 3.1.8.2 Scenario 1a
    • 3.1.8.3 Scenario 2
    • 3.1.8.4 Scenario 3
    • 3.1.8.5 Scenario 3a
    • 3.1.8.6 Scenario 3b
    • 3.1.8.7 Scenario 3c
    • 3.1.8.8 Scenario 3d
• 3.2 Oracle EBS-Specific Configuration Steps
  • 3.2.1 Configuration Required Before a Full Load for Oracle EBS
    • 3.2.1.1 Configuration of Product Hierarchy (Except for GL, HR Modules)
    • 3.2.1.2 How to Assign UNSPSC Codes to Products
    • 3.2.1.3 How to Configure the Master Inventory Organization in Product Dimension Extract for Oracle Adapters (Except for GL & HR Modules)
    • 3.2.1.4 About Mapping Oracle GL Natural Accounts to Group Account Numbers
    • 3.2.1.5 How to Make Corrections to the Group Account Number Configuration
    • 3.2.1.6 About Configuring GL Account Hierarchies
  • 3.2.2 Configuration Steps for Controlling Your Data Set for Oracle EBS
    • 3.2.2.1 How to Configure the Make-Buy Indicator
• 3.3 PeopleSoft-Specific Configuration Steps
  • 3.3.1 Configuration Required Before a Full Load for PeopleSoft
    • 3.3.1.1 About the GL Account Dimension and Chartfields for PeopleSoft
    • 3.3.1.2 About Mapping PeopleSoft GL Accounts to Group Account Numbers
    • 3.3.1.3 How to Make Corrections to the Group Account Number Configuration
    • 3.3.1.4 About Configuring GL Account Hierarchies
  • 3.3.2 Configuration Steps for Controlling Your Data Set for PeopleSoft
    • 3.3.2.1 About Employee Dimension Extraction
    • 3.3.2.2 About Configuring Department Trees
    • 3.3.2.3 How to Configure Department Trees and Business Unit Trees
    • 3.3.2.4 How to Configure Country Codes for PSFT
• 3.4 Oracle Siebel-Specific Configuration Steps
• 3.5 Oracle's JD Edwards-Specific Configuration Steps
  • 3.5.1 Configuration Required Before a Full Load for Oracle's JD Edwards EnterpriseOne or JD Edwards World
    • 3.5.1.1 How to Configure Category Codes
    • 3.5.1.2 About Configuring the Code Dimension for Oracle's JD Edwards EnterpriseOne or JD Edwards World UDCs
    • 3.5.1.3 About Configuring Quarters for a Fiscal Pattern and Fiscal Year of Time Dimensions
    • 3.5.1.4 About Mapping JD Edwards EnterpriseOne or JD Edwards World GL Accounts to Group Account Numbers
    • 3.5.1.5 About Configuring GL Account Segment Hierarchies
    • 3.5.1.6 Setting Up $$JDE_RATE_TYPE

Part III Configuring Functional Areas

4 Configuring Oracle Procurement and Spend Analytics

• 4.1 Overview of Oracle Procurement and Spend Analytics
• 4.2 Configuration Required Before a Full Load for Oracle Procurement and Spend Analytics
  • 4.2.1 Configuration Steps for Oracle Procurement and Spend Analytics for All Source Systems
    • 4.2.1.1 About Integrating Oracle Procurement with Spend Analytics with Oracle Spend Classification
  • 4.2.2 Configuration Steps for Oracle Procurement and Spend Analytics for Oracle EBS
    • 4.2.2.1 How to Configure the DAC Parameter for Purchase Cycle Line
    • 4.2.2.2 Domain Values and CSV Worksheet Files for Oracle Procurement and Spend Analytics
    • 4.2.2.3 How to Configure AP Invoice Types for Spend Analysis
    • 4.2.2.4 Configuration Specific to Certain Versions of Oracle EBS
  • 4.2.3 Configuration Steps for Oracle Procurement and Spend Analytics for PeopleSoft
    • 4.2.3.1 Domain Values and CSV Worksheet Files for PeopleSoft Procurement and Spend Analytics
    • 4.2.3.2 CSV Worksheet Source Files for PeopleSoft Procurement and Spend Analytics
    • 4.2.3.3 Enabling Reporting on Product/Purchasing Categories for PeopleSoft Procurement and Spend Analytics
• 4.3 Configuration Steps for Controlling Your Data Set
  • 4.3.1 Configuration Steps for Oracle Procurement and Spend Analytics for All Source Systems
    • 4.3.1.1 About Configuring the Purchase Receipts Aggregate Table
    • 4.3.1.2 How to Configure the Purchase Receipts Aggregate Table
    • 4.3.1.3 About Configuring the Purchase Cycle Lines Aggregate Table
    • 4.3.1.4 How to Configure the Purchase Cycle Lines Aggregate Table
  • 4.3.2 Configuration Steps for Oracle Procurement and Spend Analytics for Oracle EBS
    • 4.3.2.1 How to Extract Particular Purchase Order Records
    • 4.3.2.2 How to Enable Project Analytics Integration with Procurement and Spend Subject Areas
  • 4.3.3 Configuration Steps for Oracle Procurement and Spend Analytics for PeopleSoft
    • 4.3.3.1 How to Enable Project Analytics Integration with Procurement and Spend Subject Areas
  • 4.3.4 Configuration Steps for Oracle Procurement and Spend Analytics for Universal
    • 4.3.4.1 About Configuring Oracle Procurement and Spend Analytics for Universal Source
    • 4.3.4.2 How to Configure the Preferred Merchant Flag
    • 4.3.4.3 How to Configure the Customer Billable Indicator
    • 4.3.4.4 How to Configure the Receipts Indicator
    • 4.3.4.5 How to Configure the Default Expense Distribution Percentage
    • 4.3.4.6 How to Configure Lookup Dates for Currency Conversion

5 Configuring Oracle Financial Analytics

• 5.1 Overview of Oracle Financial Analytics
• 5.2 Configuration Required Before a Full Load for Financial Analytics
  • 5.2.1 Configuration Steps for Financial Analytics for All Source Systems
  • 5.2.2 Configuration Steps for Financial Analytics for Oracle EBS
    • 5.2.2.1 About Configuring Domain Values and CSV Worksheet Files for Oracle Financial Analytics
    • 5.2.2.2 How to Configure Transaction Types for Oracle General Ledger and Profitability Analytics (for Oracle EBS R12)
    • 5.2.2.3 How to Configure Transaction Types for Oracle General Ledger and Profitability Analytics (for Oracle EBS R11i)
    • 5.2.2.4 How to Specify the Ledger or Set of Books for which GL Data is Extracted
    • 5.2.2.5 Oracle EBS Currency Balance Types
  • 5.2.3 Configuration Steps for Financial Analytics for PeopleSoft
    • 5.2.3.1 About Configuring Domain Values and CSV Worksheet Files for Oracle Financial Analytics
    • 5.2.3.2 How to Configure Domain Values for Oracle Receivables Analytics
    • 5.2.3.3 How to insert beginning GL Balances into Oracle BI Applications
    • 5.2.3.4 Oracle GL Budget Analytics for PeopleSoft Configuration
    • 5.2.3.5 PeopleSoft Currency Balance Types
  • 5.2.4 Configuration Steps for Financial Analytics for Oracle's JD Edwards EnterpriseOne and JD Edwards World
    • 5.2.4.1 About Configuring Domain Values and CSV Worksheet Files for Oracle Financial Analytics for Oracle's JD Edwards EnterpriseOne and JD Edwards World
    • 5.2.4.2 How to Configure domainvalues_payment_method_jde.csv
    • 5.2.4.3 How to Configure domainvalues_src_transaction_type_codes_jde.csv and domainvalues_lkp_transaction_type_codes_jde.csv
    • 5.2.4.4 How to Configure domainvalues_make_buy_indicator_product_jde.csv
    • 5.2.4.5 About the file_fin_stmt_item_names_jde.csv and file_fin_sub_names_jde.csv Files
    • 5.2.4.6 How to Configure the file_group_acct_codes_jde.csv
    • 5.2.4.7 How to Configure the file_glacct_catcodes_segment_config_jde.csv
    • 5.2.4.8 How to Configure the file_glacct_segment_config_jde.csv
    • 5.2.4.9 How to Configure the file_lkp_fiscal_period_Qtr_Config_jde.csv
    • 5.2.4.10 Configuring the Exchange Date for JD Edwards EnterpriseOne Accounts Payable
    • 5.2.4.11 About the Exchange Date for JD Edwards EnterpriseOne Account Receivables
• 5.3 Configuration Steps for Controlling Your Data Set
  • 5.3.1 Configuration Steps for Financial Analytics for All Source Systems
    • 5.3.1.1 How to Include Unapplied Payments in AR Aging Calculations
    • 5.3.1.2 How to Configure the AP/AR Aging Tables
    • 5.3.1.3 How to Set Up Drill Down in Oracle BI Answers from General Ledger to Subledger
    • 5.3.1.4 About the Customer Costs Lines and Product Costs Lines Tables for Oracle Profitability Analytics
    • 5.3.1.5 How to Configure the Customer Costs Lines and Product Costs Lines Tables for Oracle's Profitability Analytics
    • 5.3.1.6 How to Configure Budgets for Oracle General Ledger Analytics
  • 5.3.2 Configuration Steps for Financial Analytics for Oracle EBS
    • 5.3.2.1 How GL Balances Are Populated in Oracle EBS
    • 5.3.2.2 How to Configure Oracle Profitability Analytics Transaction Extracts
    • 5.3.2.3 How to Configure Cost Of Goods Extract (for Oracle EBS 11i)
    • 5.3.2.4 How to Configure AP Balance ID for Oracle Payables Analytics
    • 5.3.2.5 How to Configure AR Balance ID for Oracle Receivables Analytics and Oracle General Ledger and Profitability Analytics
    • 5.3.2.6 How to Configure the AR Adjustments Extract for Oracle Receivables Analytics
    • 5.3.2.7 How to Configure the AR Schedules Extract
    • 5.3.2.8 How to Configure the AR Cash Receipt Application Extract for Oracle Receivables Analytics
    • 5.3.2.9 How to Configure the AR Credit-Memo Application Extract for Oracle Receivables Analytics
    • 5.3.2.10 How to Enable Project Analytics Integration with Financial Subject Areas
  • 5.3.3 Configuration Steps for Financial Analytics for PeopleSoft
    • 5.3.3.1 Overview of PeopleSoft Tree Data Structures
    • 5.3.3.2 About PeopleSoft Trees in Oracle Financial Analytics
    • 5.3.3.3 General Ledger Chartfield and Chartfield Hierarchy Extraction Customization
    • 5.3.3.4 How to Set Up Default Fiscal Calendars For PeopleSoft
    • 5.3.3.5 How to Enable Project Analytics Integration with Financial Subject Areas
    • 5.3.3.6 Configuring Number of Days based Metrics for PeopleSoft
    • 5.3.3.7 How to Update Dashboard Pages with PeopleSoft Prompts
  • 5.3.4 Configuration Steps for Financial Analytics for Oracle's JD Edwards EnterpriseOne and JD Edwards World
    • 5.3.4.1 Configuring GL Balances in Oracle's JD Edwards EnterpriseOne and JD Edwards World
    • 5.3.4.2 Configuring Ledger Type
    • 5.3.4.3 Configuring the DAC Parameter for Receivables
    • 5.3.4.4 Configuring the DAC Parameter when Multicurrency Processing is Disabled in JD Edwards
    • 5.3.4.5 Configuring Number of Days based Metrics
    • 5.3.4.6 How to Update Dashboard Pages with Oracle's JD Edwards EnterpriseOne and JD Edwards World Prompts

6 Configuring Oracle Supply Chain and Order Management Analytics

• 6.1 Overview of Oracle Supply Chain and Order Management Analytics
• 6.2 Configuration Required Before A Full Load for Oracle Supply Chain and Order Management Analytics
  • 6.2.1 Configuration Steps for Oracle Supply Chain and Order Management Analytics for All Source Systems
    • 6.2.1.1 How to Disable Project Dimensions
    • 6.2.1.2 Enabling Delete and Primary Extract Sessions for Oracle Supply Chain and Order Management Analytics
  • 6.2.2 Configuration Steps for Oracle Supply Chain and Order Management Analytics for Oracle EBS
    • 6.2.2.1 About Configuring Domain Values and CSV Worksheet Files for Oracle Supply Chain and Order Management Analytics
    • 6.2.2.2 How to Configure Invoice Type Domain Values
    • 6.2.2.3 How to Configure Pick Types Domain Values
    • 6.2.2.4 How to Configure Order Types Domain Values
    • 6.2.2.5 How to Configure Pick Status Domain Values
    • 6.2.2.6 How to Configure Pay Method Domain Values
    • 6.2.2.7 How to Configure Invoice Status Domain Values
    • 6.2.2.8 How to Configure Order Overall Status Domain Values
    • 6.2.2.9 How to Configure Movement Types Domain Values
    • 6.2.2.10 How to Configure Invoice Source Type Domain Values
    • 6.2.2.11 How to Configure Quantity Types for Product Transactions
    • 6.2.2.12 How to Deploy Objects in Oracle EBS for Exploding the BOM
  • 6.2.3 Configuration Steps for Oracle Supply Chain and Order Management Analytics for Oracle's JD Edwards EnterpriseOne
    • 6.2.3.1 About Configuring Domain Values and CSV Worksheet Files for JD Edwards EnterpriseOne Supply Chain and Order Management Analytics
    • 6.2.3.2 How to Configure User Defined Code Categories
    • 6.2.3.3 How to Configure Movement Type Domain Values
    • 6.2.3.4 How to Configure Transaction Types Domain Values for Sales Invoice Lines
    • 6.2.3.5 How to Configure Transaction Types Domain Values for Sales Order Lines
    • 6.2.3.6 How to Configure Sales Order Statuses
    • 6.2.3.7 How to Configure Channel Type Groups
    • 6.2.3.8 How to Configure Inventory Consignments
    • 6.2.3.9 How to Configure Inventory Return Locations
    • 6.2.3.10 How to Process Bill of Material Explosion
    • 6.2.3.11 How to Deploy the Stored Procedure for the Left Bound and Right Bound Calculation Option
• 6.3 Configuration Steps for Controlling Your Data Set
  • 6.3.1 Configuration Steps for Oracle Supply Chain and Order Management Analytics for All Source Systems
    • 6.3.1.1 Tracking Multiple Attribute Changes in Bookings
    • 6.3.1.2 Process of Aggregating Oracle Supply Chain and Order Management Analytics Tables
    • 6.3.1.3 About Tracking Multiple Products for Oracle Supply Chain and Order Management Analytics
    • 6.3.1.4 Adding Dates to the Order Cycle Time Table for Post-Load Processing
    • 6.3.1.5 About Configuring the Backlog Period Date for Oracle Supply Chain and Order Management Analytics
    • 6.3.1.6 Example of How Backlog Data Is Stored in the Backlog History Table
    • 6.3.1.7 About Configuring the Customer Status History Fact for Post-Load Processing In Oracle Supply Chain and Order Management Analytics
    • 6.3.1.8 Configuring the Customer Status History Fact table
    • 6.3.1.9 How to Configure the Customer Status History Fact Table
    • 6.3.1.10 About Configuring the Inventory Monthly Balance Table
    • 6.3.1.11 How to Configure the Inventory Monthly Balance
    • 6.3.1.12 About Configuring the Product Transaction Aggregate Table
    • 6.3.1.13 How to Configure the Product Transaction Aggregate Table
  • 6.3.2 Configuration Steps for Oracle Supply Chain and Order Management Analytics for Oracle EBS
    • 6.3.2.1 About Configuring Sales Order Lines Data Storage
    • 6.3.2.2 How to Include Non-Booked Orders in the Sales Order Lines and Sales Schedule Lines Tables
    • 6.3.2.3 How to Configure Sales Schedule Lines Data Storage
    • 6.3.2.4 About Loading Bookings at the Schedule Line Level
    • 6.3.2.5 How to Configure Early and Late Tolerances for Shipments
    • 6.3.2.6 How to Configure Sales Invoice Lines Data Storage
    • 6.3.2.7 How to Configure the Sales Invoice Extract
    • 6.3.2.8 How to Configure the Order Lines
    • 6.3.2.9 How to Configure Oracle Financial Analytics for Oracle Supply Chain and Order Management Analytics
    • 6.3.2.10 About Tracking Attribute Changes in Bookings
    • 6.3.2.11 About Viewing the Data Warehouse Changes by Salesperson ID
    • 6.3.2.12 How to Configure Different Types of Backlog Calculations
    • 6.3.2.13 Adding Closed Orders to Backlog Calculations
    • 6.3.2.14 How to Configure the Bill of Materials Explosion Options
    • 6.3.2.15 How to Configure the Left Bound and Right Bound Calculation Option

7 Configuring Oracle Human Resources Analytics

• 7.1 Overview of Oracle Human Resources Analytics
• 7.2 Configuration Required Before A Full Load for Oracle HR Analytics
  • 7.2.1 Configuration Steps for Oracle HR Analytics for All Source Systems
    • 7.2.1.1 Configuring Band Dimensions
    • 7.2.1.2 About Domain Values and CSV Worksheet Files for Oracle HR Analytics
  • 7.2.2 Configuration Steps for Oracle HR Analytics for Oracle EBS
    • 7.2.2.1 Domain Values and CSV Worksheet Files for Oracle EBS
    • 7.2.2.2 How to Configure the domainValues_AbsenceEvent_Status_oraVersion.csv
    • 7.2.2.3 How to Configure the domainValues_Employment_Cat_oraVersion.csv
    • 7.2.2.4 How to Configure the domainValues_Employee_Ethnic_Group_Code_oraVersion.csv
    • 7.2.2.5 How to Configure the domainValues_Employment_Full_Time_Flg_oraVersion.csv
    • 7.2.2.6 How to Configure the domainValues_Employee_Sex_MF_oraVersion.csv
    • 7.2.2.7 How to Configure the domainValues_Employment_Status_oraVersion.csv
    • 7.2.2.8 How to Configure the domainValues_Employee_Veteran_Status_Code_oraVersion.csv
    • 7.2.2.9 How to Configure the domainValues_Flsa_oraVersion.csv
    • 7.2.2.10 How to Configure the domainValues_HRPosition_Active_Pos_Flg_oraVersion.csv
    • 7.2.2.11 How to Configure the domainValues_Pay_Type_Flg_oraVersion.csv
    • 7.2.2.12 How to Configure the domainValues_Pay_Type_Grp_Code_oraVersion.csv
    • 7.2.2.13 How to Configure the domainValues_perf_nrml_rating_oraVersion.csv
    • 7.2.2.14 How to Configure the domainValues_Recruitment_Event_Reason_oraVersion.csv
    • 7.2.2.15 How to Configure the domainValues_Recruitment_Source_Type_oraVersion.csv
    • 7.2.2.16 How to Configure the domainValues_Requisition_Category_oraVersion.csv
    • 7.2.2.17 How to Configure the domainValues_Status_Recruitment_oraVersion.csv
    • 7.2.2.18 How to Configure the domainValues_Status_Vacancy_oraVersion.csv
    • 7.2.2.19 How to Configure the domainValues_Wrkfc_EventType_oraVersion.csv
    • 7.2.2.20 How to Configure the domainValues_LearningEnrollment_Status_oraVersion.csv
    • 7.2.2.21 How to Configure the domainValues_Wrkfc_Appraisals_oraVersion.csv
    • 7.2.2.22 How to Configure the file_Normal_Hours_Conversion_Factor_oraVersion.csv
    • 7.2.2.23 How to Configure Address Types for the Employee Dimension
    • 7.2.2.24 How to Configure Phone Types for HR Profile
    • 7.2.2.25 How to Configure Education Degree Codes for Employee Dimension
    • 7.2.2.26 How to Configure Flags for the Pay Type Dimension
    • 7.2.2.27 How to Configure Classification Names for Payroll
    • 7.2.2.28 How to configure the daily working hours value for Employee Assignments
  • 7.2.3 Configuration Steps for Flexflelds
    • 7.2.3.1 How to Generate a Flexfield Configuration File for HCM hr_file_flex_kff_dff_user_config_map.csv
    • 7.2.3.2 How to Configure the Key Flexfields for the Job Dimension
    • 7.2.3.3 How to Configure the Key Flexfields for the HR Position Dimension
    • 7.2.3.4 How to Configure the Key Flexfields for the Pay Grade Dimension
    • 7.2.3.5 How to Configure Collect FTE, Collect Performance Ratings, and Load User Flex Data
  • 7.2.4 Configuration Steps for Oracle HR Analytics for PeopleSoft
    • 7.2.4.1 Domain Values and CSV Worksheet Files for HR Analytics for PeopleSoft HCM
    • 7.2.4.2 How to Configure the domainValues_Employee_Ethnic_Group_Code_psft.csv
    • 7.2.4.3 How to Configure the domainValues_Employee_Sex_MF_psft.csv
    • 7.2.4.4 How to Configure the domainValues_Employee_Veteran_Status_Code_psft.csv
    • 7.2.4.5 How to Configure the domainValues_Employment_Category_psft.csv
    • 7.2.4.6 How to Configure the domainValues_Flsa_psft.csv
    • 7.2.4.7 How to Configure the domainValues_Employment_Full_Time_Flg_psft.csv
    • 7.2.4.8 How to Configure the domainValues_Employment_Status_psft.csv
    • 7.2.4.9 How to Configure the domainValues_Wrkfc_EventType_psft.csv
    • 7.2.4.10 How to Configure the domainValues_HRPosition_Active_Pos_Flg_psft.csv
    • 7.2.4.11 How to Configure the domainValues_Pay_Type_Grp_Code_psft.csv
    • 7.2.4.12 How to Configure the domainValues_Emp_EventType_EventReason_Code_psft.csv
    • 7.2.4.13 How to Configure the domainValues_Recruitment_Source_Type_psftVersion.csv
    • 7.2.4.14 How to Configure the domainValues_Requisition_Category_psftVersion.csv (WIP)
    • 7.2.4.15 How to Configure the domainValues_Status_Vacancy_Recruitment_psftVersion.csv
    • 7.2.4.16 How to Configure the domainValues_Recruitment_Event_Reason_psftVersion.csv
    • 7.2.4.17 How to Configure the file_pension_comp_flg.csv
    • 7.2.4.18 How to Configure Compensation Flag and Pension Compensation Flag for Pay Type Dimension
    • 7.2.4.19 How to Configure the domainValues_perf_nrml_rating_psft.csv
    • 7.2.4.20 How to Configure the domainValues_Wrkfc_IntlAssign_psft.csv
    • 7.2.4.21 How to Configure the domainValues_AbsenceEvent_Status_psft.csv
    • 7.2.4.22 How to Configure the domainValues_Learning_Enrollment_Status_psftVersion.csv
    • 7.2.4.23 How to Build an Execution Plan for Running HR and GL Subject Areas Together
  • 7.2.5 Configuration Steps for Oracle HR Analytics for Universal
• 7.3 Configuration Steps for Controlling Your Data Set
  • 7.3.1 Configuration Steps for Oracle HR Analytics for All Source Systems
    • 7.3.1.1 How to Aggregate the Payroll Table for Oracle HR Analytics
    • 7.3.1.2 Resolving Dimensions for Every Snapshot Date
    • 7.3.1.3 About Oracle HR Analytics DAC Parameters
    • 7.3.1.4 About Future-Dated Security for Oracle HR Analytics
  • 7.3.2 Configuration Steps for Oracle HR Analytics for Oracle EBS
    • 7.3.2.1 About Incremental Processing for Oracle EBS
    • 7.3.2.2 Configuring Original Job Requisition Status
    • 7.3.2.3 About Job Requisition Metrics in Oracle EBS
    • 7.3.2.4 Configuring Employee Assignment and Applicant Assignment Correlation
    • 7.3.2.5 About Oracle HR Analytics DAC Parameters and Configuration Tags for Oracle EBS
    • 7.3.2.6 About Duration Unit Conversion to Hours
  • 7.3.3 Configuration Steps for Oracle HR Analytics for PeopleSoft
    • 7.3.3.1 About Incremental Processing for PeopleSoft
    • 7.3.3.2 How to Tune Performance for the Payroll Table for PeopleSoft HCM HR Analytics
    • 7.3.3.3 About Oracle HR Analytics DAC Parameters for PeopleSoft

8 Configuring Oracle Sales Analytics

• 8.1 Overview of Oracle Sales Analytics
• 8.2 Configuration Required Before A Full Load
  • 8.2.1 How to Deploy Stored Procedures
• 8.3 Configuration Steps for Controlling Your Data Set
  • 8.3.1 How to Configure the Snapshot Frequency in the Pipeline Fact
• 8.4 Configuring Usage Accelerator
  • 8.4.1 What is Usage Accelerator?
  • 8.4.2 Configuring Usage Accelerator
    • 8.4.2.1 Tracking of Targeted Users
    • 8.4.2.2 Other Siebel Required Responsibilities
    • 8.4.2.3 About Metric Definitions and Variables
    • 8.4.2.4 Configuring Variables
  • 8.4.3 About the Usage Accelerator Execution Plan

9 Configuring Oracle Contact Center Telephony Analytics

• 9.1 Overview of Oracle Contact Center Telephony Analytics
• 9.2 Configuration Required Before A Full Load for Contact Center Telephony Analytics
  • 9.2.1 About the Dimension Key Resolution Process for Universal Source
  • 9.2.2 How to Load the Dimension Table
  • 9.2.3 How to Load the Fact Table
  • 9.2.4 Setting Up The DATASOURCE_NUM_ID Parameter for the Universal Adapter
  • 9.2.5 About Configuring the Event Type Columns
    • 9.2.5.1 The Activity Type Column
    • 9.2.5.2 Call Type (or Contact Type) Column
    • 9.2.5.3 Call Event Type Column
    • 9.2.5.4 After-Call Work Activity (ACW) Type Column
  • 9.2.6 About Configuring The Contact Reason Column
  • 9.2.7 About Configuring Contact Status Type Column
  • 9.2.8 Setting Up the Representative Activities Table
  • 9.2.9 Setting Up the Contact Center Performance Table
  • 9.2.10 Setting Up the Benchmarks and Targets Table
  • 9.2.11 Logical Delete of Records From Fact Tables
  • 9.2.12 How to Configure Dates and Times
  • 9.2.13 Configuring Flags for Oracle Contact Center Telephony Analytics
  • 9.2.14 How to Exclude Representative Data for Post-Load Processing
  • 9.2.15 How to Configure Alternate Load Plan to Enable Direct Load to the Entry-Level Rep Activity Aggregates
  • 9.2.16 How to Configure Alternate Load Plan to Enable Direct Load to the Entry-Level Contact Performance Aggregates
  • 9.2.17 How to Set Up the Integration_Id of the Contact Center Telephony Facts in the Warehouse
  • 9.2.18 Setting Up the IVR Menu and IVR Navigation Profile Tables
    • 9.2.18.1 Determining Navigation Profile and Transfer Flag for a Call
    • 9.2.18.2 Slowly Changing Dimension Behavior of IVR Menu and IVR Navigation Profile Dimensions
  • 9.2.19 How to View Duration Metrics in hh:mm:ss Format in Oracle BI Answers

10 Configuring Oracle Price Analytics

• 10.1 Overview of Oracle Price Analytics
• 10.2 Configuration Required Before a Full Load for Oracle Price Analytics
  • 10.2.1 Configuration Steps for Oracle Price Analytics for All Source Systems
  • 10.2.2 About Configuring Domain Value and CSV Worksheet Files for Oracle Price Analytics
  • 10.2.3 How to Configure the domainValues_PriceWaterfallElement_Name.csv
  • 10.2.4 Configuration Steps for Universal Sources
• 10.3 Price Waterfall Element Sample Data
  • 10.3.1 Example of an Order for a Simple Product
  • 10.3.2 Example of an Order for a Configured Product

11 Configuring Oracle Service Analytics

• 11.1 Overview of Oracle Service Analytics
• 11.2 Configuration Required Before A Full Load With An Oracle EBS Source System
  • 11.2.1 Configuring DAC Parameters for Oracle Service Analytics With An Oracle EBS Source System
  • 11.2.2 Configuring Domain Values for Oracle Service Analytics With An Oracle EBS Source System
    • 11.2.2.1 About Domain Values and CSV Worksheet Files for Oracle Service Analytics
    • 11.2.2.2 How to Configure Activity Status
    • 11.2.2.3 How to Configure Asset Status
    • 11.2.2.4 How to Configure Agreement Status
    • 11.2.2.5 How to Configure Service Request Status
    • 11.2.2.6 How to Configure Activity Priority
    • 11.2.2.7 How to Configure Activity Category
    • 11.2.2.8 How to Configure Activity Type
    • 11.2.2.9 How to Configure Activity Resolution
    • 11.2.2.10 How to Configure Asset Cost Category
    • 11.2.2.11 How to Configure Request Severity Code
    • 11.2.2.12 How to Configure Service Request Area Code
  • 11.2.3 Configuring Your RPD Repository for Oracle Service Analytics With An Oracle EBS Source System
• 11.3 Configuration Required Before A Full Load With Siebel CRM Source Systems
  • 11.3.1 Configuring Domain Values for Oracle Service Analytics With A Siebel CRM Source System
    • 11.3.1.1 About Domain Values and CSV Worksheet Files for Oracle Service Analytics
    • 11.3.1.2 How to Configure Activity Status
    • 11.3.1.3 How to Configure Asset Status
    • 11.3.1.4 How to Configure Agreement Status
    • 11.3.1.5 How to Configure Service Request Status
    • 11.3.1.6 How to Configure Activity Priority
    • 11.3.1.7 How to Configure Activity Category
    • 11.3.1.8 How to Configure Activity Type
    • 11.3.1.9 How to Configure Activity Resolution
    • 11.3.1.10 How to Configure Request Severity Code
    • 11.3.1.11 How to Configure Service Request Area Code

12 Configuring Oracle Marketing Analytics

• 12.1 Overview of Oracle Marketing Analytics
• 12.2 Configuration Required Before A Full Load
  • 12.2.1 Configuring Oracle Marketing Analytics For Siebel Version 8.1.1
    • 12.2.1.1 About Domain Values and CSV Worksheet Files for Oracle Marketing Analytics
    • 12.2.1.2 How to Configure the Lead Quality Codes
    • 12.2.1.3 How to Configure Lead Status Codes

13 Configuring Oracle Loyalty Analytics

• 13.1 Overview of Oracle Loyalty Analytics
  • 13.1.1 Oracle Loyalty Analytics Roles
• 13.2 Configuration Required Before a Full Load
  • 13.2.1 About Configuring Domain Values and CSV Worksheet Files for Oracle Loyalty Analytics
  • 13.2.2 How to Configure the domainValues_Loyalty_Statement_Type.csv
  • 13.2.3 How to Configure the domainValues_Member_Status.csv
  • 13.2.4 How to Configure the domainValues_Transaction_Status_Types.csv
  • 13.2.5 How to Configure the domainValues_Loyalty_Tier_movement_Type.csv
  • 13.2.6 How to Configure the file_Redeemed_Unit_Cost.csv
• 13.3 Configuration Steps for Controlling Your Data Set
  • 13.3.1 How to Configure the LoyaltyTotalRevenueInput.xls
• 13.4 Configuring SQL Transformations in Informatica for Database Dependencies

14 Configuring Oracle Pharma Analytics

• 14.1 Overview of Oracle Business Analytics Warehouse for Life Sciences
• 14.2 Importing Syndicated Data into Oracle Business Analytics Warehouse
  • 14.2.1 Syndicated Loading Definitions
  • 14.2.2 Data Types Supported in the Oracle Business Analytics Warehouse
  • 14.2.3 Loading Syndicated Data into the Oracle Business Analytics Warehouse
    • 14.2.3.1 Loading From a Flat File Source Using Syndicated Data Staging Tables and Cross-Referencing Tables
    • 14.2.3.2 Loading From a Flat File Source Using Syndicated Market Staging Tables
• 14.3 Syndicated Data Flat File Formats
  • 14.3.1 Syndicated Data Flat File for Direct Sales Data
  • 14.3.2 Syndicated Data Flat File for Indirect Sales Data
  • 14.3.3 Syndicated Data Flat File for Prescription Data
  • 14.3.4 Syndicated Data Flat File for Plan Level Rx Data
  • 14.3.5 Syndicated Data Flat File for Physician Plan Level Rx Data
  • 14.3.6 Syndicated Data Flat File for Weekly Early View Data
  • 14.3.7 Syndicated Market Flat File for Indirect Sales Data
  • 14.3.8 Syndicated Market Flat File for Prescription Data
  • 14.3.9 Syndicated Market Flat File for Plan Level Rx Data
  • 14.3.10 Syndicated Market Flat File for Physician Plan Level Rx Data
  • 14.3.11 Syndicated Market Flat File for Weekly Early View Data
  • 14.3.12 Flat File Cross-Reference Data Population Rules
• 14.4 Supporting Database Partitioning in Syndicated Data and Market Load
  • 14.4.1 Overview
  • 14.4.2 Definitions for Database Partition Components
  • 14.4.3 Identify Partition Name and Value
  • 14.4.4 How to Create Partition Table
  • 14.4.5 How to Prepare Flat Files for Database Partition
    • 14.4.5.1 Syndicated Data and Market Flat File Format
    • 14.4.5.2 Define the Relation Between Top Level Position and Partition Value in Flat File
  • 14.4.6 How to Enable Database Partition Feature for Syndicated Data and Market Fact
  • 14.4.7 How to Disable Database Partition Feature for Syndicated Data and Market Fact
  • 14.4.8 Only the Oracle Platform is Supported for the Database Partition Feature in Default
    • 14.4.8.1 The W_SYND_PARTITION_TMP Table
    • 14.4.8.2 Dynamically Generate SQL for Active Partition to Truncate Partitioned Table
    • 14.4.8.3 Method to Truncate Partitioned Table for Syndicated Data and Market Base Fact Tables
    • 14.4.8.4 Method to Truncate Partitioned Table for Syndicated Data and Market Territory or District Level and Aggregate Fact Tables
    • 14.4.8.5 Method to Create Index for Partitioned Syndicated Data and Market Fact Tables
• 14.5 Supporting Restartability in Syndicated Data and Market Load
  • 14.5.1 Overview
  • 14.5.2 How to Enable Restartability Feature in DAC for Syndicated Data and Market Base Fact Tables
    • 14.5.2.1 How to Enable Restartability Feature in DAC for Syndicated Data Base Fact
    • 14.5.2.2 How to Enable Restartability Feature in DAC for Syndicated Market Base Fact
    • 14.5.2.3 How to Reassemble Subject Areas and Rebuild Execution Plans
  • 14.5.3 How to Disable Restartability in DAC for Syndicated Data and Market Base Fact Tables
    • 14.5.3.1 How to Disable Restartability in DAC for Syndicated Data Base Fact
    • 14.5.3.2 How to Disable Restartability in DAC for Syndicated Market Base Fact
    • 14.5.3.3 How to Reassemble Subject Areas and Rebuild Execution Plans
• 14.6 Life Sciences Data Loading Issues with Oracle Business Analytics Warehouse
  • 14.6.1 Known Issues with the Syndicated Data Fact Tables
• 14.7 Incremental Updates in the Oracle Business Analytics Warehouse LS Dimension Tables
  • 14.7.1 W_ALIGNMT_DH
  • 14.7.2 W_ALIGNVER_DH

15 Configuring Oracle Project Analytics

• 15.1 Overview of Oracle Project Analytics
  • 15.1.1 Linear Spread Metrics for Project Budget Fact
• 15.2 Configuration Required Before a Full Load of Project Analytics
  • 15.2.1 Configuration Steps for Project Analytics for All Source Systems
    • 15.2.1.1 Configuring Dimension Hierarchies for Project Analytics
    • 15.2.1.2 Configuring DAC Parameters for Project Analytics
    • 15.2.1.3 Configuring the Project Cost Aggregate Table
  • 15.2.2 Configuration Steps for Project Analytics for Oracle EBS
    • 15.2.2.1 About Configuring Domain Values and CSV Worksheet Files for Oracle Project Analytics
    • 15.2.2.2 How to Configure the DomainValues_Project_Type_Class_code_oraVersion.csv
    • 15.2.2.3 How to Configure the domainValues_Project_Status_oraVersion.csv
    • 15.2.2.4 How to Configure the domainValues_Project_ServiceType_oraVersion.csv
    • 15.2.2.5 How to Configure the domainValues_Project_ResourceClass_oraVersion.csv
    • 15.2.2.6 How to Configure the domainValues_Project_InvoiceRevenue_Status_oraVersion.csv
    • 15.2.2.7 How to Configure the domainValues_Project_Invoice_Line_Type_oraVersion.csv
    • 15.2.2.8 How to Configure the domainValues_Project_Funding_Level_code_oraVersion.csv
    • 15.2.2.9 How to Configure the domainValues_Project_Funding_Category_oraVersion.csv
    • 15.2.2.10 How to Configure the domainValues_Project_Cost_Transfer_Status_oraVersion.csv
    • 15.2.2.11 How to Configure the domainValues_Project_Budget_Time_Phased_Code_oraVersion.csv
    • 15.2.2.12 About the Project Commitments Subject Area for Oracle EBS
    • 15.2.2.13 How to Configure the domainValues_Project_CommitmentType_oraVersion.csv
    • 15.2.2.14 About Configuring the Project Dimension for Oracle EBS
    • 15.2.2.15 About Configuring the Task Dimension for Oracle EBS
    • 15.2.2.16 About Configuring the Financial Resource Dimension
    • 15.2.2.17 About Configuring the Project Classification Dimension
    • 15.2.2.18 About Configuring the Work Type Dimension
    • 15.2.2.19 About Configuring the Job Dimension
    • 15.2.2.20 About Operating Unit Based Security with Oracle EBS
    • 15.2.2.21 Configuring a Custom Relationship Value for Project Customer
    • 15.2.2.22 About Configuring Budget Fact for Oracle EBS
    • 15.2.2.23 About Configuring Forecast Fact for Oracle EBS
    • 15.2.2.24 About Configuring Funding Fact for Oracle EBS
    • 15.2.2.25 About Configuring Cost Fact for Oracle EBS
    • 15.2.2.26 Configuring Revenue Fact for Oracle EBS
    • 15.2.2.27 Configuring Invoice Fact for Oracle EBS
    • 15.2.2.28 How to Tune Performance for Project Analytics for Oracle EBS
  • 15.2.3 Configuration Steps for Project Analytics for PeopleSoft
    • 15.2.3.1 About Persisted Stage for Oracle Project Analytics for PeopleSoft
    • 15.2.3.2 About Configuring Domain Values and CSV Worksheet Files for Oracle Project Analytics
    • 15.2.3.3 How to Configure Resource Class Domain Values for the Transaction Type Dimension
    • 15.2.3.4 How to Configure Invoice Line Domain Values for the Transaction Type Dimension
    • 15.2.3.5 How to Configure Project Type Class Code Domain Values for the Project Dimension
    • 15.2.3.6 How to Configure Project Status Domain Values for the Status Dimension
    • 15.2.3.7 How to Configure Transfer Status Domain Values for the Status Dimension
    • 15.2.3.8 How to Configure Revenue Status Domain Values for the Status Dimension
    • 15.2.3.9 How to Configure Invoice Status Domain Values for the Status Dimension
    • 15.2.3.10 How to Configure Project Budget
    • 15.2.3.11 How to Configure Project Cost
    • 15.2.3.12 Deleting Certain Physical Joins from the RPD (PeopleSoft Only)
    • 15.2.3.13 Operating Unit Based Security with PeopleSoft
    • 15.2.3.14 About Configuring Project Funding Fact
    • 15.2.3.15 About Configuring Project Retention Fact
  • 15.2.4 Configuration Steps for Project Analytics for Universal
    • 15.2.4.1 What is Universal Adapter for Project Analytics?
    • 15.2.4.2 Data Format Requirements
    • 15.2.4.3 Sample Source Files for Universal Adapter for Project Analytics
    • 15.2.4.4 Configuring CSV Files for the Code Dimension
    • 15.2.4.5 How to Create Data Files for Universal Adapter for Project Analytics
• 15.3 Configuration Steps for Controlling Your Data Set
  • 15.3.1 Configuration Steps for Oracle Project Analytics for All Source Systems
    • 15.3.1.1 About Configuring Multi Calendar Support in Oracle Project Analytics
    • 15.3.1.2 Configuring Multi Currency Support in Oracle Project Analytics
  • 15.3.2 Configuration Steps for Oracle Project Analytics for PeopleSoft
    • 15.3.2.1 About Configuring Budget Fact for PeopleSoft
• 15.4 Oracle Project Analytics Integrations
  • 15.4.1 Integrations with Project Analytics for Oracle EBS
    • 15.4.1.1 About the Integration with Procurement and Spend Analytics for Oracle EBS
    • 15.4.1.2 About the Integration with Financial Analytics for Oracle EBS
  • 15.4.2 Integrations with Project Analytics for PeopleSoft
    • 15.4.2.1 About the Integration with Procurement and Spend for PeopleSoft
    • 15.4.2.2 About the Integration with Financial Analytics for PeopleSoft

16 Configuring Oracle Enterprise Asset Management Analytics

• 16.1 Overview of Oracle Enterprise Asset Management Analytics
• 16.2 Configuration Required Before a Full Load for Oracle Enterprise Asset Management Analytics
  • 16.2.1 Configuration Steps for Oracle Enterprise Management Analytics with Oracle EBS
    • 16.2.1.1 How to Disable Project Dimensions
    • 16.2.1.2 How to Disable Multiple Calendar Support
    • 16.2.1.3 How to Configure the DAC Parameter for Process Items for Supply chain – Inventory
    • 16.2.1.4 How to Disable Project Dimensions for Supply chain – inventory
    • 16.2.1.5 How to Disable Process Manufacturing Dimensions for EAM Subject Areas
  • 16.2.2 Domain Values and CSV Worksheet Files for Oracle Enterprise Asset Management Analytics with Oracle EBS
    • 16.2.2.1 List of Domain Values and CSV Worksheet Files for Oracle Asset Management Analytics
    • 16.2.2.2 How to configure domainValues_Xact_Types_EAM_WO_Type_ora11i.csv
    • 16.2.2.3 How to configure domainValues_Xact_Types_EAM_FailureCause_oraR12.csv
    • 16.2.2.4 How to configure domainValues_Xact_Types_FailureCode_ora12.csv
    • 16.2.2.5 How to configure domainValues_Xact_Types_EAM_FailureResolution_oraR12.csv
    • 16.2.2.6 How to configure domainValues_Xact_Types_EAMCostElement_ora11i.csv
    • 16.2.2.7 How to configure domainValues_Status_EAMAsset_ora11i.csv
    • 16.2.2.8 How to configure domainValues_Status_MfgJob_ora11i.csv
    • 16.2.2.9 How to configure file_ bucket_range_master_ebs11i.csv
  • 16.2.3 Configuration Steps for Oracle Enterprise Management Analytics for MAXIMO
    • 16.2.3.1 How to Configure the DAC Parameter for Maximo calendar
    • 16.2.3.2 How to Configure the DAC Parameter for Direct Items
  • 16.2.4 Domain Values and CSV Worksheet Files for Oracle Enterprise Asset Management Analytics
    • 16.2.4.1 List of Domain Values and CSV Worksheet Files for Oracle Asset Management Analytics
    • 16.2.4.2 How to configure domainValues_Xact_Types_EAM_WO_Type_maximo.csv
    • 16.2.4.3 How to configure domainValues_Xact_Types_EAM_FailureCause_maximo.csv
    • 16.2.4.4 How to configure domainValues_Xact_Types_EAM_FailureCodes_maximo.csv
    • 16.2.4.5 How to configure domainValues_Xact_Types_EAM_FailureResolution_maximo.csv
    • 16.2.4.6 How to configure domainValues_Xact_Types_EAMCostElement_MAXIMO.csv
    • 16.2.4.7 How to configure domainValues_Status_Asset_MAXIMO.csv
    • 16.2.4.8 How to configure domainValues_Status_MfgJob_MAXIMO.csv
    • 16.2.4.9 How to configure file_ bucket_range_master_ebs11i.csv

17 Configuring Oracle Manufacturing Analytics

• 17.1 Overview of Oracle Manufacturing Analytics
• 17.2 Configuration Required Before a Full Load for Oracle Manufacturing Analytics
  • 17.2.1 Configuration Steps for Oracle Manufacturing Analytics for Oracle EBS
    • 17.2.1.1 How to Configure the DAC Parameter for Process Items
    • 17.2.1.2 How to Configure the DAC Parameter for ASCP plan for Planning
    • 17.2.1.3 How to Configure the DAC Parameter for MRP plan for Planning
    • 17.2.1.4 How to Configure the DAC Parameter for ASCP plan for Discrete Manufacturing Analytics
    • 17.2.1.5 How to Configure the DAC Parameter for MRP plan for Discrete Manufacturing Analytics
    • 17.2.1.6 How to Disable Project Dimensions
    • 17.2.1.7 How to Disable Discrete Manufacturing Analytics
    • 17.2.1.8 How to Disable Process Manufacturing Analytics
    • 17.2.1.9 How to Disable Discrete Manufacturing Quality
    • 17.2.1.10 How to Disable Process Manufacturing Quality
    • 17.2.1.11 How to Disable Project Dimensions for Inventory subject areas
  • 17.2.2 Domain Values and CSV Worksheet Files for Oracle Manufacturing Analytics
    • 17.2.2.1 List of Domain Values and CSV Worksheet Files for Oracle Manufacturing Analytics
    • 17.2.2.2 How to configure domainValues_TransactionTypeDimension_KanbanErrorCode11i.csv file for Kanban
    • 17.2.2.3 How to configure domainValues_Xact_Types_MFG_CostElement_oraR12.csv file for Oracle Process Manufacturing
    • 17.2.2.4 How to configure domainValues_Xact_Types_CostElementTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics
    • 17.2.2.5 How to configure domainValues_SDE_ORA_StatusDimension_KanbanCardStatus11i.csv file for Kanban
    • 17.2.2.6 How to configure domainValues_Status_MfgJob_ora11i.csv file for Oracle Discrete Manufacturing Analytics
    • 17.2.2.7 How to configure domainValues_Status_Batch_oraR12.csv file for Oracle Process Manufacturing Analytics
    • 17.2.2.8 How to configure domainValues_Xact_Types_PlannedOrderTypes_ora11i.csv file for Discrete Manufacturing Analytics
    • 17.2.2.9 How to configure domainValues_SDE_ORA_StatusDimension_KanbanSupplyStatus11i.csv file for Kanban
    • 17.2.2.10 How to configure domainValues_TransactionTypeDimension_KanbanDocumentType11i.csv file for Kanban
    • 17.2.2.11 How to configure domainValues_TransactionTypeDimension_KanbanSourceType11i.csv file for Kanban
    • 17.2.2.12 How to configure domainValues_SDE_ORA_TransactionTypeDimension_PlannedOrderType_Pegging11i.csv file for Planning
    • 17.2.2.13 How to configure domainValues_Status_Disposition_Nonconformance_ora11i.csv file for Discrete Manufacturing Quality
    • 17.2.2.14 How to configure domainValues_Xact_Types_QA_Char_Values_ora11i.csv file for Discrete Manufacturing Quality
    • 17.2.2.15 How to configure domainValues_Xact_Types_QA_Test_Evaluation_ora12.csv file for Process Manufacturing Quality
    • 17.2.2.16 How to configure domainValues_Xact_Types_Quality_Grade_ora12.csv file for Process Manufacturing Quality
    • 17.2.2.17 How to configure domainValues_Xact_Types_Resource_Types_ora11i.csv for Oracle Discrete Manufacturing Analytics
    • 17.2.2.18 How to configure domainValues_Xact_Types_DemandClassTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics
    • 17.2.2.19 How to configure domainValues_Xact_Types_MfgTypes_ora11i.csv file for Oracle Discrete Manufacturing Analytics
    • 17.2.2.20 How to configure file_lkp_mfg_baseline_plans_ascp_ebs.csv file for Oracle Discrete Manufacturing Analytics and Planning
    • 17.2.2.21 How to configure file_lkp_mfg_baseline_plans_mrp_ebs.csv file for Oracle Discrete Manufacturing Analytics and Planning
    • 17.2.2.22 How to configure file_ bucket_range_master_ebs11i.csv

Part IV Configuring the Oracle BI Repository

18 Configuring the Oracle BI Repository

• 18.1 How to Set Up Date-Specific Metrics
• 18.2 How to Set Up Additional Time Series Metrics for Oracle Business Analytics Warehouse
• 18.3 How to Set Up Additional Dimension Tables for Oracle Business Analytics Warehouse
• 18.4 How to Set Up Product Category Hierarchies
• 18.5 About the Ago Keys for Oracle Business Analytics Warehouse
• 18.6 About Oracle BI Time Repository Variables
• 18.7 About User Authentication
• 18.8 About the Security or Visibility Configuration
• 18.9 About the Group Variable
• 18.10 About Configuring Usage Tracking for Oracle Business Analytics Warehouse
• 18.11 About the Incremental Deployment of the Oracle BI Applications Repository

Part V Customizing the Oracle Business Analytics Warehouse

19 Customizing ETL Mappings for Oracle BI Applications

• 19.1 Overview of ETL Customization for Oracle BI Applications
• 19.2 Before You Begin ETL Customization for Oracle BI Applications
  • 19.2.1 Upgrade Considerations
    • 19.2.1.1 How Upgrade Impacts Mappings
  • 19.2.2 Using Custom Folders in the Oracle Business Analytics Warehouse
  • 19.2.3 Creating Custom Informatica Workflows
  • 19.2.4 Additional Points to Consider When Customizing Oracle BI Applications
• 19.3 Oracle BI Applications Customization Scenarios
• 19.4 Category 1 Customizations: Adding Columns to Existing Fact or Dimension Tables
  • 19.4.1 About Extending Oracle Business Analytics Warehouse
  • 19.4.2 High-Level Steps to Extend Oracle Business Analytics Warehouse
  • 19.4.3 Example of Extending Oracle Business Analytics Warehouse
    • 19.4.3.1 Tips for Modifying the SQL Override in a Source Qualifier
    • 19.4.3.2 Example of Extracting Data from a Siebel Source
    • 19.4.3.3 Including a Source Table for the Change Capture Process
    • 19.4.3.4 Example of Extracting Data from a Non-Siebel Packaged Source
    • 19.4.3.5 Example of Extracting Data from a Universal Source
    • 19.4.3.6 Example of Loading Data into an Existing Target Table
    • 19.4.3.7 Updating DAC
• 19.5 Other Types of Customizations Requiring Special Handling
  • 19.5.1 Modifying Category 2 SCD Triggers
  • 19.5.2 Adding Dimensions to Existing Facts
  • 19.5.3 Adding Date Dimensions to Existing Facts
  • 19.5.4 Adding Currencies to an Existing Table
• 19.6 Category 2 Customizations: Adding Additional Tables
  • 19.6.1 About Creating New Dimension or Fact Tables
    • 19.6.1.1 Required Columns
    • 19.6.1.2 About the Oracle Business Analytics Warehouse DATASOURCE_NUM_ID Column
  • 19.6.2 Including a Source Table for Change Capture Process
  • 19.6.3 Adding a New Dimension in the Oracle Business Analytics Warehouse
  • 19.6.4 Adding a New Fact Table in the Oracle Business Analytics Warehouse
  • 19.6.5 Adding a New Dimension Table for a New Fact Table in the Oracle Business Analytics Warehouse
• 19.7 Category 3 Customizations: Adding New Data as a Whole Row into a Standard Dimension Table
• 19.8 Configuring Extracts
  • 19.8.1 Extracting Additional Data
    • 19.8.1.1 Extracting New Data Using an Existing Source Table
    • 19.8.1.2 Extracting Data from a New Source Table
  • 19.8.2 Setting Up the Delimiter for Source Files
  • 19.8.3 Configuring a Source Adapter Mapplet
• 19.9 Marking Records as "Deleted" in Oracle Business Analytics Warehouse
  • 19.9.1 About Primary Extract and Delete Mappings Process
  • 19.9.2 About Working with Primary Extract and Delete Mappings
    • 19.9.2.1 Deleting the Configuration for Source-Archived Records
    • 19.9.2.2 Enabling Delete and Primary Extract Sessions
• 19.10 Configuring Slowly Changing Dimensions
  • 19.10.1 About Identifying Historically Significant Attributes
    • 19.10.1.1 About the Extract View
  • 19.10.2 Type 1 and Type 2 Slowly Changing Dimensions
    • 19.10.2.1 Type 1 Slowly Changing Dimension
    • 19.10.2.2 Type 2 Slowly Changing Dimension
    • 19.10.2.3 Effective Dates
• 19.11 About Stored Lookups
  • 19.11.1 Code Lookups
    • 19.11.1.1 W_CODES Table
    • 19.11.1.2 Codes Mappings
    • 19.11.1.3 Codes Mapplets
    • 19.11.1.4 Configuring Extension Column Code Description Lookups
  • 19.11.2 About Resolving Dimension Keys
    • 19.11.2.1 Resolving the Dimension Key Using Lookup
• 19.12 About Domain Values
  • 19.12.1 About the Domain Value Conversion Process
    • 19.12.1.1 Preparing to Define the Rules
  • 19.12.2 About the Importance of Domain Values
    • 19.12.2.1 Hire Count
    • 19.12.2.2 Re-hires Ratio
    • 19.12.2.3 New Hire Count
    • 19.12.2.4 Newly Separated Veterans - New Hires
    • 19.12.2.5 Other Protected Veterans - New Hires
    • 19.12.2.6 Special Disabled Veteran Head count - New Hires
    • 19.12.2.7 Vietnam Era Veteran Head count - New Hires
  • 19.12.3 About Extending the Domain Value Set
• 19.13 Configuring the Domain Value Set with CSV Worksheet Files
• 19.14 Configuring the Domain Value Set Using Informatica PowerCenter Designer
• 19.15 Configuring Conformed Dimensions
  • 19.15.1 Configuring Conformed Dimensions for Universal Adapter
    • 19.15.1.1 Product Effective Dates in the Products Dimension

Part VI Appendixes

A Configuring Universal Adapter

• A.1 What is Universal Adapter for CRM Analytics?
• A.2 Data Format Requirements
• A.3 About the Sample Source Files Provided
• A.4 Configuring Universal Adapter for Oracle Price Analytics
  • A.4.1 Populating Flat File Data For Siebel Sources
  • A.4.2 Populating Flat File Data for Non-Siebel Sources
  • A.4.3 Data Standards for Flat Files
• A.5 How to Create Data Files for Universal Adapter
• A.6 List of Sample Source Files for Universal Adapter
  • A.6.1 List of Source Files for Seed Data and Common Dimensions
  • A.6.2 List of Source Files for Specific Subject Areas
• A.7 List of Source Files for Oracle Enterprise Asset Management Analytics and Oracle Manufacturing Analytics

Index