List of Tables

• 2-1 Oracle BI Applications Components (with Informatica/DAC)
• 3-1 OS, Driver and Connectivity Requirements for Oracle Business Analytics Warehouse
• 3-2 Recommended Tablespace Configuration
• 3-3 Recommended DB2 Parameter Settings
• 3-4 Variable Settings for IBM DB2 UDB zOS and OS/390 Databases
• 3-5 Recommended Variable Settings for SQL Server Databases
• 3-6 Preconfigured Mappings for the User Table in the SA System Subject Area
• 3-7 Initialization Blocks and Their Purposes
• 3-8 SQL files for Siebel transactional databases
• 3-9 Indexes Created on the S_CONTACT Table in Siebel transactional database
• 3-10 Recommended Partitioning Keys for Large Fact Tables
• 3-11 Source System Parameters for Partitioned Tables
• 3-12 Field Values on Tasks Tab
• 4-1 Changes in Informatica Terminology
• 4-2 Custom Properties for Informatica PowerCenter Integration Services
• 4-3 Hibernate Library Files You Need to Copy
• 4-4 Teradata-Specific Installation Checklist for Windows
• A-1 Oracle Business Analytics Warehouse Scripts for Bash and C Shells
• B-1 Seed Data and Common Dimension Source Files
• B-2 Subject Areas and Associated Source Files
• C-1 Example of W_LOCALIZED_STRING_G Translation Table
• D-1 Oracle Business Intelligence Applications Options
• E-1 Consumer Sector Dashboards and Page Tabs
• E-2 Data Requirements for Consumer Sector Schema
• E-3 Communications, Media and Energy Dashboards and Page Tabs
• E-4 Data Requirements for Communications, Media and Energy Dashboards
• E-5 Sales Territory Alignment
• E-6 Customer Products Predefined Product Types
• E-7 Product Costs For Customer Products
• E-8 Hierarchy Categories to be Populated in Pharma Analytics
• F-1 Syndicated Loading Definitions
• F-2 Data Types Supported in Oracle Business Analytics Warehouse
• F-3 AlignmentType.csv Mapping File
• F-4 Syndicated Data Flat File - Direct Sales Data
• F-5 Syndicated Data Flat File - Indirect Sales Data
• F-6 Syndicated Data Flat File - Prescription Data
• F-7 Syndicated Data Flat File - Plan Level Rx Data
• F-8 Syndicated Data Flat File - Physician Plan Level Rx Data
• F-9 Syndicated Data Flat File - Weekly Early View Data
• F-10 Syndicated Market Flat File - Indirect Sales Data
• F-11 Syndicated Market Flat File - Prescription Data
• F-12 Syndicated Market Flat File - Plan Level Rx Data
• F-13 Syndicated Market Flat File - Physician Plan Level Rx Data
• F-14 Syndicated Market Flat File - Weekly Early View Data
• F-15 Flat File Cross-Reference Data Population Rules for Area (Brick) Data
• F-16 Flat File Cross-Reference Data Population Rules for Account and Plan Data
• F-17 Flat File Cross-Reference Data Population Rules for Payer Type Data
• F-18 Flat File Cross-Reference Data Population Rules for Contact Data
• F-19 Flat File Cross-Reference Data Population Rules for Product and Market Data
• G-1 Sourcing Reports for Pharma Disconnected Analytics
• H-1 List of Values Exceptions (Example)
• H-2 Cost List Exceptions (Example)
• H-3 Circular Hierarchy Example 1
• H-4 Circular Hierarchy Example 2
• I-1 Oracle Business Analytics Warehouse Installation and Configuration Issues
• I-2 Informatica and Loading Issues
• I-3 Unicode Issues with Informatica and Oracle Business Analytics Warehouse
• I-4 UNIX Installation Issues with Oracle Business Analytics Warehouse
• I-5 Upgrade Issues
• I-6 Oracle BI Dashboard Issues
• I-7 ETL Issues