Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

New Features for Oracle Business Intelligence System Administrators

• New Features for Oracle BI EE 11g Release 1 (11.1.1.5)
• New Features for Oracle BI EE 11g Release 1 (11.1.1.3)

Part I Administering Oracle Business Intelligence

1 Introduction to Oracle Business Intelligence System Administration

• 1.1 What Are the Oracle Business Intelligence System Administration Tasks?
• 1.2 Getting Started with Managing Oracle Business Intelligence
• 1.3 What Is the Oracle Business Intelligence System Logical Architecture?
  • 1.3.1 Oracle Business Intelligence on a Single Host
    • 1.3.1.1 A Single Host and Enterprise Install
    • 1.3.1.2 A Single Host and Simple Install
  • 1.3.2 Oracle Business Intelligence on Multiple Hosts
  • 1.3.3 About Java Components and System Components for Oracle Business Intelligence
    • 1.3.3.1 About Java Components
    • 1.3.3.2 About System Components
  • 1.3.4 What Is the Administration Server?
• 1.4 What System Administration Tools Manage Oracle Business Intelligence?
  • 1.4.1 Fusion Middleware Control
  • 1.4.2 Oracle WebLogic Server Administration Console
  • 1.4.3 Oracle Process Manager and Notification Server (OPMN) Tool
  • 1.4.4 Oracle Weblogic Scripting Tool (WLST)
  • 1.4.5 Oracle BI Administration Tool
  • 1.4.6 Job Manager
• 1.5 Working with the Sample Application
• 1.6 Oracle BI Publisher Integration
• 1.7 Topics of Interest in Other Guides
• 1.8 System Requirements and Certification

2 Managing Oracle Business Intelligence

• 2.1 Why Use Fusion Middleware Control and WebLogic Server Administration Console?
• 2.2 Centrally Managing Oracle Business Intelligence Components Using Fusion Middleware Control
  • 2.2.1 Logging into Fusion Middleware Control to Manage Oracle Business Intelligence
  • 2.2.2 Using Fusion Middleware Control to Manage Oracle Business Intelligence System Components
  • 2.2.3 Using Fusion Middleware Control to Monitor Status and Start and Stop Oracle Business Intelligence Java Components
  • 2.2.4 About the Navigation Tree in Fusion Middleware Control
• 2.3 Centrally Managing Oracle Business Intelligence Java Components Using the Oracle WebLogic Server Administration Console
• 2.4 Managing Oracle Business Intelligence JMX MBeans Using the Fusion Middleware Control MBean Browser
  • 2.4.1 What Is the Fusion Middleware Control MBean Browser?
  • 2.4.2 Displaying the Fusion Middleware Control MBean Browser

3 Configuring the Oracle Business Intelligence System

• 3.1 Configuring Oracle Business Intelligence
• 3.2 Using Fusion Middleware Control to Update Oracle Business Intelligence Configuration Settings
• 3.3 Using the Oracle BI Systems Management API to Update Configuration Settings
• 3.4 Using a Text Editor to Update Configuration Settings
• 3.5 Using the Fusion Middleware Control MBean Browser to Update Configuration Settings
• 3.6 Where Are Configuration Files Located?

Part II Managing Processes and Components

4 Starting and Stopping Oracle Business Intelligence

• 4.1 About Starting and Stopping Oracle Business Intelligence
• 4.2 Starting the Oracle Business Intelligence System
  • 4.2.1 Starting Oracle Business Intelligence on Windows Platforms
  • 4.2.2 Starting Oracle Business Intelligence on UNIX Platforms
• 4.3 Using Fusion Middleware Control to Start and Stop Oracle Business Intelligence System Components and Java Components
• 4.4 Using Oracle WebLogic Server Administration Console to Start and Stop Java Components
• 4.5 Alternative Methods for Starting and Stopping System Components
  • 4.5.1 Using the OPMN Command Line to Start, Stop, Restart, and View the Status of System Components
  • 4.5.2 Using a Windows Service to Start and Stop System Components
  • 4.5.3 Using the Oracle BI Systems Management API to Programmatically Start and Stop Oracle Business Intelligence
• 4.6 Confirming Whether the Administration Server Is Running
• 4.7 Starting and Stopping the Administration Server and All Oracle Business Intelligence Java Components on Windows and UNIX
• 4.8 Starting and Stopping Managed Servers on Windows and UNIX
  • 4.8.1 Confirming If the Managed Server Is Running and Starting It
• 4.9 Troubleshooting System Startup
  • 4.9.1 Administration Server Fails to Start When the Database Is Not Running
  • 4.9.2 Managed Server Is Down
  • 4.9.3 Oracle BI Server Fails to Start
  • 4.9.4 Oracle BI Presentation Services Fails to Start
  • 4.9.5 Cannot Log In

Part III Scaling and Deploying for High Availability and Performance

5 Scaling Your Deployment

• 5.1 About Scaling Oracle Business Intelligence
  • 5.1.1 How Do I Know When to Scale Out Processes?
  • 5.1.2 What Processes Should I Scale?
• 5.2 Vertically Scaling Oracle Business Intelligence
• 5.3 Horizontally Scaling Oracle Business Intelligence
• 5.4 Setting Up Shared Files and Directories
  • 5.4.1 Uploading and Sharing the Oracle BI Repository
  • 5.4.2 Sharing the Oracle BI Presentation Catalog
  • 5.4.3 Setting Up the Global Cache
  • 5.4.4 Setting the Scheduler Script Path and Default Script Path
• 5.5 Using Fusion Middleware Control to Scale System Components
• 5.6 Validating That Your System Has Been Scaled Correctly
  • 5.6.1 Using Fusion Middleware Control to View System Component Availability
  • 5.6.2 Using the Administration Console to View Managed Server Availability

6 Deploying Oracle Business Intelligence for High Availability

• 6.1 About Oracle Business Intelligence Components in a Clustered Environment
  • 6.1.1 Recommendations for Availability
  • 6.1.2 Using Fusion Middleware Control to Identify Single Points of Failure
  • 6.1.3 Achieving High Availability Using an Active-Passive Model
• 6.2 Configuring Oracle Business Intelligence Components for High Availability
  • 6.2.1 Using Fusion Middleware Control to Configure Primary and Secondary Instances
• 6.3 Optional Configuration for Oracle Business Intelligence High Availability
  • 6.3.1 Setting Optional Cluster Controller Parameters
  • 6.3.2 Setting Optional Presentation Services Parameters
  • 6.3.3 Setting Optional Oracle BI Presentation Services Plug-in Parameters
• 6.4 Using the Cluster Manager
  • 6.4.1 Viewing and Managing Cluster Information
    • 6.4.1.1 Status Information
    • 6.4.1.2 Cache Information
    • 6.4.1.3 Session Information
    • 6.4.1.4 Server Information
• 6.5 Troubleshooting an Oracle Business Intelligence Clustered Environment
  • 6.5.1 Avoiding Errors with Network Appliance Devices When the Oracle BI Server Is Running on Linux or UNIX

7 Managing Performance Tuning and Query Caching

• 7.1 Monitoring Service Levels
  • 7.1.1 Using Fusion Middleware Control to View Common Performance Metrics
  • 7.1.2 Using Fusion Middleware Control to View All Oracle Business Intelligence Metrics
  • 7.1.3 Using the Administration Console to View Metrics for Java Components
• 7.2 About Query Performance Tuning
• 7.3 Setting Performance Parameters in Fusion Middleware Control
  • 7.3.1 Using Fusion Middleware Control to Disallow RPD Updates
  • 7.3.2 Using Fusion Middleware Control to Set the User Session Log-Off Period
  • 7.3.3 Using Fusion Middleware Control to Set Configuration Options for Data in Tables and Pivot Tables
  • 7.3.4 Using Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table
• 7.4 About the Oracle BI Server Query Cache
  • 7.4.1 Query Cache Architecture
  • 7.4.2 Advantages of Caching
  • 7.4.3 Costs of Caching
    • 7.4.3.1 Disk Space
    • 7.4.3.2 Administrative Tasks
    • 7.4.3.3 Keeping the Cache Up To Date
    • 7.4.3.4 CPU Usage and Disk I/O
  • 7.4.4 Cache Sharing Across Users
  • 7.4.5 About the Refresh Interval for XML Data Sources
  • 7.4.6 About the Global Cache
• 7.5 Configuring Query Caching
  • 7.5.1 Using Fusion Middleware Control to Enable and Disable Query Caching
  • 7.5.2 Using Fusion Middleware Control to Set Query Cache Parameters
  • 7.5.3 Manually Editing Additional Query Cache Parameters
  • 7.5.4 Using Fusion Middleware Control to Set Global Cache Parameters
  • 7.5.5 Manually Editing Additional Global Cache Parameters
• 7.6 Monitoring and Managing the Cache
  • 7.6.1 Choosing a Cache Management Strategy
    • 7.6.1.1 Disable Caching for the System
    • 7.6.1.2 Caching and Cache Persistence Timing for Specified Physical Tables
    • 7.6.1.3 Configure Oracle BI Server Event Polling Tables
  • 7.6.2 Purging and Maintaining Cache Using ODBC Procedures
    • 7.6.2.1 About ODBC Procedure Syntax
    • 7.6.2.2 About Sharing the Presentation Services Query Cache
    • 7.6.2.3 About Result Records
    • 7.6.2.4 Storing and Purging Cache for SAP/BW Data Sources
  • 7.6.3 How Repository Changes Affect the Query Cache
    • 7.6.3.1 Online Mode
    • 7.6.3.2 Offline Mode
    • 7.6.3.3 Switching Between Repositories
    • 7.6.3.4 Changes to Dynamic Repository Variables
• 7.7 Strategies for Using the Cache
  • 7.7.1 About Cache Hits
    • 7.7.1.1 Ensuring Correct Cache Results When Using Row-Level Database Security
  • 7.7.2 Running a Suite of Queries to Populate the Cache
  • 7.7.3 Using Agents to Seed the Oracle BI Server Cache
  • 7.7.4 Using the Cache Manager
    • 7.7.4.1 Displaying Global Cache Information in the Cache Manager
    • 7.7.4.2 Purging Cache in the Administration Tool
• 7.8 Cache Event Processing with an Event Polling Table
  • 7.8.1 Setting Up Event Polling Tables on the Physical Databases
    • 7.8.1.1 Polling Table Structure
    • 7.8.1.2 Sample Event Polling Table CREATE TABLE Statements
  • 7.8.2 Making the Event Polling Table Active
  • 7.8.3 Populating the Oracle BI Server Event Polling Table
  • 7.8.4 Troubleshooting Problems with Event Polling Tables
• 7.9 Managing the Oracle BI Presentation Services Cache Settings
• 7.10 Improving Oracle BI Web Client Performance
  • 7.10.1 Configuring Apache HTTP Server for Static File Caching
  • 7.10.2 Configuring Oracle HTTP Server for Static File Caching

Part IV Resolving Issues

8 Diagnosing and Resolving Issues in Oracle Business Intelligence

• 8.1 How Are Issues Resolved?
• 8.2 Viewing And Configuring Diagnostic Log Files
  • 8.2.1 Using Fusion Middleware Control to View Log Information, Error Messages, and Alerts
  • 8.2.2 Configuring Log File Rotation Policy and Specifying Log Levels
    • 8.2.2.1 Using Fusion Middleware Control to Configure Log File Rotation Policy and Specify Log Levels
    • 8.2.2.2 Manually Changing Additional Log File Settings
• 8.3 Understanding Diagnostic Log and Log Configuration Files
  • 8.3.1 What Are Diagnostic Log Files and Where Are They Located?
  • 8.3.2 What Are Diagnostic Log Configuration Files and Where Are They Located?
  • 8.3.3 What Are Log File Message Categories and Levels?
  • 8.3.4 What is Log File Rotation?
  • 8.3.5 What Messages Are Included in the System Log?
• 8.4 Managing the Query Log
  • 8.4.1 Configuring Query Logging
    • 8.4.1.1 Setting the Query Logging Level
    • 8.4.1.2 Setting the Query Logging Level for a User
  • 8.4.2 Using the Log Viewer
    • 8.4.2.1 Running the Log Viewer Utility
    • 8.4.2.2 Interpreting the Log Records
• 8.5 Logging in Oracle BI Presentation Services
  • 8.5.1 Using the Oracle BI Presentation Services Logging Facility
  • 8.5.2 Structure for the Oracle BI Presentation Services Configuration File
  • 8.5.3 Examples of the Formats of Logged Messages
  • 8.5.4 Oracle BI Presentation Services Message Structure
  • 8.5.5 Oracle BI Presentation Services Log Filters
  • 8.5.6 Diagnosing Issues with Agents

9 Managing Usage Tracking

• 9.1 Setting Up Usage Tracking
  • 9.1.1 Setting Up Direct Insertion to Collect Information for Usage Tracking
  • 9.1.2 Setting Up a Log File to Collect Information for Usage Tracking
    • 9.1.2.1 Selecting an Output Location
    • 9.1.2.2 File Naming Conventions
    • 9.1.2.3 Output File Format
    • 9.1.2.4 Performance Considerations
• 9.2 Description of the Usage Tracking Data

Part V Configuring Oracle Business Intelligence

10 Configuring Repositories

• 10.1 Why Upload a Repository and Set the Catalog Location?
  • 10.1.1 Understanding Modes
  • 10.1.2 Understanding Repository Version Numbers
• 10.2 Using Fusion Middleware Control to Upload a Repository and Set the Oracle BI Presentation Catalog Location
• 10.3 Using the System MBeans to Upload the Metadata Repository

11 Configuring Connections to External Systems

• 11.1 Configuring E-Mail and Agents
  • 11.1.1 Using Fusion Middleware Control to Configure Oracle BI Scheduler E-Mail Settings that Affect Agents
• 11.2 Configuring for Actions with the Action Framework
• 11.3 Configuring Connections to Data Sources
• 11.4 Configuring for Connections to the Marketing Content Server
  • 11.4.1 Using Fusion Middleware Control to Configure the Connection to the Marketing Content Server
  • 11.4.2 Manually Editing Settings for the Marketing Content Server Connection
• 11.5 Configuring to Download Oracle Hyperion Smart View for Office

12 Configuring Presentation Setting Defaults

• 12.1 Using Fusion Middleware Control to Change Presentation Setting Defaults

13 Configuring Mapping and Spatial Information

• 13.1 What Are the System Requirements for Map Views?
• 13.2 Hardware Sizing and Deployment Strategy for Maps
• 13.3 Administering Maps
  • 13.3.1 Working with Maps and Layers
    • 13.3.1.1 Associating Layers with Columns
    • 13.3.1.2 Ordering Layers on Maps
    • 13.3.1.3 Changes to Spatial Metadata Require Restart
  • 13.3.2 Administration Page Functions
  • 13.3.3 Administering Maps Using Administration Pages
  • 13.3.4 Handling the Translation of Layers in Maps

14 Configuring Time Zones

• 14.1 Why and Where are Time Zones Used?
• 14.2 Setting Time Zones
• 14.3 What is the Precedence Order for Time Zones
  • 14.3.1 User-Preferred Time Zone
• 14.4 Where are Time Zone Specifications Stored?
  • 14.4.1 Specifying Time Zone Values
• 14.5 Description of Time Zone Settings
• 14.6 Example: Configuration File Settings for Specifying the Time Zone

15 Localizing Oracle Business Intelligence

• 15.1 What Is Localization?
  • 15.1.1 What Components Are Translated?
  • 15.1.2 Tasks for Localizing Oracle Business Intelligence Components
• 15.2 Localizing Oracle BI Presentation Services
  • 15.2.1 Localizing the User Interface for Oracle BI Presentation Services
    • 15.2.1.1 Understanding the Directory Structure for Localizing Presentation Services
    • 15.2.1.2 Localizing Messages for Users' Preferred Currency
    • 15.2.1.3 Specifying the Default Language for the Sign-In Page
    • 15.2.1.4 Configuring the Languages and Locales for the Sign-In Page
    • 15.2.1.5 Specifying the Language in the URL
  • 15.2.2 Localizing Oracle BI Presentation Catalog Captions
    • 15.2.2.1 Step 1: Understanding the Export Process
    • 15.2.2.2 Step 2: Exporting Text Strings in the Catalog
    • 15.2.2.3 Step 3: Editing Exported Strings in XML Files
    • 15.2.2.4 Step 4: Handling Duplicate Exported Text Strings
    • 15.2.2.5 Step 5: Exposing Text Strings in the Catalog
  • 15.2.3 Tip for Arabic and Hebrew in Mozilla Firefox Browsers
• 15.3 Setting the Current Locale in Catalog Manager
• 15.4 Setting the Current Locale in the Oracle BI Server
  • 15.4.1 Setting Locale Parameters on the Oracle BI Server
    • 15.4.1.1 Setting the Locale on UNIX Systems
  • 15.4.2 Understanding How the Error Message Language Is Determined
  • 15.4.3 Troubleshooting the Current Locale in the Oracle BI Server
    • 15.4.3.1 Handling the NLS Locale Not Supported Error Message
    • 15.4.3.2 Setting the Japanese Locale on AIX Systems
• 15.5 Localizing Metadata Names in the Repository
• 15.6 Supporting Multilingual Data
  • 15.6.1 What is Multilingual Data Support?
  • 15.6.2 What is Lookup?
  • 15.6.3 What is Double Column Support?
  • 15.6.4 Designing Translation Lookup Tables in a Multilingual Schema
    • 15.6.4.1 A Lookup Table for Each Base Table
    • 15.6.4.2 A Lookup Table for Each Translated Field
  • 15.6.5 Creating Logical Lookup Tables and Logical Lookup Columns
    • 15.6.5.1 Creating Logical Lookup Tables
    • 15.6.5.2 Designating a Logical Table as a Lookup Table
    • 15.6.5.3 About the LOOKUP Function Syntax
    • 15.6.5.4 Creating Logical Lookup Columns
  • 15.6.6 Creating Physical Lookup Tables and Physical Lookup Columns
  • 15.6.7 Supporting Multilingual Data in Essbase Through Alias Tables
  • 15.6.8 Enabling Lexicographical Sorting

16 Configuring Currency Options

• 16.1 Changing the Default Currency for Analyses
• 16.2 Defining User-Preferred Currency Options
  • 16.2.1 Defining User-Preferred Currency Options Using a Static Mapping
  • 16.2.2 Example: Static Mapping to Define User-Preferred Currency Options
  • 16.2.3 Defining User-Preferred Currency Options Using a Dynamic Mapping
  • 16.2.4 Example: Dynamic Mapping to Define User-Preferred Currency Options

17 Configuring and Managing the Oracle BI Presentation Catalog

• 17.1 About the Oracle BI Presentation Catalog
  • 17.1.1 Objects in the Catalog
    • 17.1.1.1 Guidelines for Object Names
    • 17.1.1.2 Attribute Files for Objects
    • 17.1.1.3 Lock Files for Objects
  • 17.1.2 Locations for the Catalog
  • 17.1.3 File System Guidelines for Catalogs
    • 17.1.3.1 Handling Users of the Catalog
    • 17.1.3.2 Handling Heterogeneous Nodes
    • 17.1.3.3 Handling Catalog Files on Various Platforms
    • 17.1.3.4 Known Issues with Catalog Files
• 17.2 Maintaining the Oracle BI Presentation Catalog
  • 17.2.1 Manually Changing Additional Configuration Settings for the Catalog
  • 17.2.2 Manually Creating a New Oracle BI Presentation Catalog
  • 17.2.3 Deploying Catalogs and Objects to Production
    • 17.2.3.1 Deploying Catalogs to Production
    • 17.2.3.2 Deploying Objects to Production
  • 17.2.4 Validating the Catalog
    • 17.2.4.1 Performing a Basic Validation of the Catalog
    • 17.2.4.2 Specifying the Elements for Validating the Catalog
• 17.3 About Catalog Manager
  • 17.3.1 Uses for Catalog Manager
  • 17.3.2 Guidelines for Working with Catalog Manager
  • 17.3.3 Tips for Working with Catalog Manager
• 17.4 Starting Catalog Manager and Opening Catalogs
  • 17.4.1 Starting Catalog Manager
  • 17.4.2 Understanding the Two Catalog Modes
    • 17.4.2.1 Online Mode
    • 17.4.2.2 Offline Mode
  • 17.4.3 Operations Available in Online Mode and Offline Mode
  • 17.4.4 Opening an Oracle BI Presentation Catalog
• 17.5 Using the Catalog Manager Workspace
  • 17.5.1 What Does the Catalog Manager Workspace Do?
  • 17.5.2 What Does the Catalog Manager Workspace Look Like?
  • 17.5.3 Managing the View of the Catalog Manager Workspace
• 17.6 Working with Objects in Catalog Manager
  • 17.6.1 Searching for Catalog Objects Using Catalog Manager
  • 17.6.2 Copying and Pasting Objects
    • 17.6.2.1 Tips for Copying and Pasting
    • 17.6.2.2 Advanced Options for Pasting Objects
  • 17.6.3 Renaming Catalog Objects
  • 17.6.4 Working with the Properties of Catalog Objects
  • 17.6.5 Setting Permissions of Catalog Objects
  • 17.6.6 Previewing Objects from Catalog Manager
  • 17.6.7 Working with Tenants
    • 17.6.7.1 What Happens When Tenants are Provisioned?
    • 17.6.7.2 What Options are Available for Provisioning?
    • 17.6.7.3 How is Multi-Tenancy Enabled?
• 17.7 Viewing and Editing Catalog Objects in XML
• 17.8 Searching for and Replacing Catalog Text Using Catalog Manager
  • 17.8.1 Searching for and Replacing a Simple Catalog Text String
  • 17.8.2 About Searching for and Replacing Multiple Catalog Text Strings
    • 17.8.2.1 XML File Format for Searching for and Replacing Text Strings
    • 17.8.2.2 Example XML File for Searching for and Replacing Text Strings
  • 17.8.3 Searching for and Replacing Multiple Catalog Text Strings
• 17.9 Creating Reports to Display Catalog Data Using Catalog Manager
• 17.10 Archiving and Unarchiving Using Catalog Manager
  • 17.10.1 Archiving a Folder Using Catalog Manager
  • 17.10.2 Unarchiving a Folder Using Catalog Manager
• 17.11 Configuring for Full-Text Catalog Search
  • 17.11.1 What is a Full-Text Catalog Search?
  • 17.11.2 Deployment of Oracle Full-Text Catalog Search
  • 17.11.3 How is Security Handled in the Full-Text Catalog Search?
  • 17.11.4 Process for Configuring the Full-Text Catalog Search
    • 17.11.4.1 Step 1: Assigning Privileges for Crawling and Indexing
    • 17.11.4.2 Step 2: Ensuring that Secure Enterprise Search is Available
    • 17.11.4.3 Step 3: Configuring Identity Management for Full-Text Catalog Search
    • 17.11.4.4 Step 4: Creating the Data Source for Full-Text Catalog Search
    • 17.11.4.5 Step 5: Editing the Schedule for Full-Text Catalog Search
    • 17.11.4.6 Step 6: Specifying the Look and Feel of Search Results
    • 17.11.4.7 Step 7: Enabling Incremental Crawls for Full-Text Catalog Search
    • 17.11.4.8 Step 8: Configuring Properties for Full-Text Catalog Search Manually
    • 17.11.4.9 Step 9: Allowing Users to Access the Full-Text Catalog Search
• 17.12 Replicating Oracle BI Presentation Catalogs
  • 17.12.1 About Replication Log Files
    • 17.12.1.1 Replication Log File Records
  • 17.12.2 Configuring to Replicate an Oracle BI Presentation Catalog
  • 17.12.3 Copying Oracle BI Presentation Catalog Files
  • 17.12.4 Using the Oracle BI Presentation Services Replication Agent
    • 17.12.4.1 mark
    • 17.12.4.2 remotecopy
    • 17.12.4.3 run
  • 17.12.5 Creating the config.xml File for Replication
    • 17.12.5.1 Structure of the Configuration File
    • 17.12.5.2 Elements of the Configuration File
    • 17.12.5.3 Example config.xml File
  • 17.12.6 Editing the instanceconfig.xml File for Replication
  • 17.12.7 Resuming Replication if Replication Log Files Are Unavailable

Part VI Advanced Configuration Settings

18 Configuring and Managing Analyses and Dashboards

• 18.1 Managing Dashboards
• 18.2 Performing General Configuration Tasks for Analyses
  • 18.2.1 Providing Access to Metadata Dictionary Information
  • 18.2.2 Supporting Nested Folders, Navigation, and Drill-Down
• 18.3 Configuring for Displaying and Processing Data in Views
  • 18.3.1 Manually Configuring for Data in Views
    • 18.3.1.1 Manually Configuring Cube Settings for Pivot Tables and Graphs
    • 18.3.1.2 Manually Configuring Settings for Data in Views
  • 18.3.2 Manually Configuring for Graphs and Gauges
    • 18.3.2.1 Configuring Fonts for Graphs
  • 18.3.3 Manually Changing Alternating Bar Color
• 18.4 Manually Changing Presentation Settings
  • 18.4.1 Manually Changing Presentation Setting Defaults
  • 18.4.2 Configuring Links to Dashboard Pages
  • 18.4.3 Configuring an Alternate Toolbar for Oracle BI Publisher
  • 18.4.4 Modifying the Table of Contents for PDF Versions of Briefing Books
• 18.5 Blocking Analyses in Answers
  • 18.5.1 Storing JavaScript Files
  • 18.5.2 Blocking Analyses Based on Criteria
  • 18.5.3 Blocking Analyses Based on Formula
  • 18.5.4 Validation Helper Functions
• 18.6 Specifying View Defaults for Analyses and Dashboards
  • 18.6.1 XML Message Files for View Defaults
  • 18.6.2 Examples of Customizing Default Values for Analyses and Dashboards
    • 18.6.2.1 Adding a Default Header or Footer to New Analyses
    • 18.6.2.2 Preventing Auto-Previewing of Results
    • 18.6.2.3 Setting Defaults for Analyses in the Compound Layout
    • 18.6.2.4 Changing Dashboards Section Defaults
    • 18.6.2.5 Specifying Dashboard Page Defaults Including Headers and Footers
• 18.7 Configuring for Write Back in Analyses and Dashboards
  • 18.7.1 Write-Back Limitations
  • 18.7.2 Configuring for Write Back
    • 18.7.2.1 Setting the LightWriteback Element
  • 18.7.3 About the Write-Back Template
    • 18.7.3.1 How Write Back Works
    • 18.7.3.2 Requirements for the Write-Back Template
    • 18.7.3.3 Example: Write-Back Template

19 Configuring and Managing Agents

• 19.1 How Are Agents Used?
• 19.2 How Do Antivirus Software and Privileges Affect Agents?
  • 19.2.1 How Does Antivirus Software Affect Agents?
  • 19.2.2 What Privileges Affect Agents?
• 19.3 Configuring Settings That Affect Agents
  • 19.3.1 Manually Configuring Presentation Services Settings That Affect Agents
  • 19.3.2 Manually Changing Additional Scheduler Settings That Affect Agents
  • 19.3.3 What Additional Scheduler Configuration Settings Affect Agents?
    • 19.3.3.1 General Scheduler Configuration Settings That Affect Agents
    • 19.3.3.2 E-Mail Scheduler Configuration Settings That Affect Agents
    • 19.3.3.3 Agent Scheduler Configuration Settings
  • 19.3.4 Controlling Delivery Options for Agents
• 19.4 Managing Device Types for Agents
• 19.5 Monitoring Active Agent Sessions

20 Configuring Advanced Options for Mapping and Spatial Information

• 20.1 Configuring MapViewer to Support Map Views
• 20.2 Manually Configuring for Map Views
• 20.3 Inserting Text on a Map
• 20.4 Configuring Maps for External Consumption

21 Configuring Resource Availability and URL Generation

Part VII Automating Management of Oracle Business Intelligence

22 Introducing the Oracle BI Systems Management API

• 22.1 What Is the Oracle BI Systems Management API?
• 22.2 Accessing Oracle BI Systems Management API Methods
• 22.3 Using the Oracle BI Systems Management API to Manage and Configure Oracle Business Intelligence
  • 22.3.1 Displaying Oracle Business Intelligence Status Using the Oracle BI Systems Management API
    • 22.3.1.1 Example: Using WLST Commands in a Script to Display the Status of Oracle Business Intelligence
    • 22.3.1.2 Example: Using a Java Program to Display the Status of Oracle Business Intelligence
  • 22.3.2 Starting and Stopping Oracle Business Intelligence Using the Oracle BI Systems Management API
    • 22.3.2.1 Example: Using WLST Commands to Stop and Start Oracle Business Intelligence
    • 22.3.2.2 Example: Using a Java Program to Stop and Start Oracle Business Intelligence
  • 22.3.3 Updating Configuration Settings Using the Oracle BI Systems Management API
    • 22.3.3.1 Example: Using WLST to Edit the E-Mail Sender Display Name Configuration Setting
    • 22.3.3.2 Example: Using a Java Program to Edit the E-Mail Sender Display Name Configuration Setting
  • 22.3.4 Scaling Out for High Availability and Performance Using the Oracle BI Systems Management API
    • 22.3.4.1 Example: Using WLST to Scale Out to Servers
    • 22.3.4.2 Example: Using a Java Program to Scale Out to Servers
  • 22.3.5 Capturing Metrics Using the Oracle BI Systems Management API
    • 22.3.5.1 Using the Dynamic Monitoring Service for Metrics
    • 22.3.5.2 Using WLTS Commands for Metrics
• 22.4 Descriptions of JMX Admin MBeans and Methods for the Oracle BI Systems Management API

Part VIII Managing the Life Cycle

23 Patching Oracle Business Intelligence Systems

• 23.1 What Is Patched for the Oracle Business Intelligence Platform?
• 23.2 Patching the Platform
  • 23.2.1 What Conditions Apply when Patching the Platform?
  • 23.2.2 Applying a Patch to the Platform
    • 23.2.2.1 Step 1: Download the Patch
    • 23.2.2.2 Step 2: Stop System Component Processes for Oracle BI EE
    • 23.2.2.3 Step 3: Apply the Patch to Each Oracle Home
    • 23.2.2.4 Step 4: Start System Component Processes for Oracle BI EE
    • 23.2.2.5 Step 5: Redeploy Patched J2EE Applications
  • 23.2.3 What Happens If a Patching Conflict Occurs?
• 23.3 Rolling Back a Platform Patch
  • 23.3.1 Step 1: Stop System Component Processes for Oracle BI EE
  • 23.3.2 Step 2: Invoke OPatch with "-rollback" Option
  • 23.3.3 Step 3: Start System Component Processes for Oracle BI EE
  • 23.3.4 Step 4: Redeploy J2EE Applications
• 23.4 Determining Current Patch Levels

24 Moving Between Environments

25 Backup and Recovery of Oracle Business Intelligence Systems

Part IX Reference Information

A NQSConfig.INI File Configuration Settings

• A.1 About Parameters in the NQSConfig.INI File
  • A.1.1 How to Update Parameters in NQSConfig.INI
• A.2 Repository Section Parameters
• A.3 Query Result Cache Section Parameters
  • A.3.1 ENABLE
  • A.3.2 DATA_STORAGE_PATHS
  • A.3.3 MAX_ROWS_PER_CACHE_ENTRY
  • A.3.4 MAX_CACHE_ENTRY_SIZE
  • A.3.5 MAX_CACHE_ENTRIES
  • A.3.6 POPULATE_AGGREGATE_ROLLUP_HITS
  • A.3.7 USE_ADVANCED_HIT_DETECTION
    • A.3.7.1 Reasons Why a Query Is Not Added to the Cache
  • A.3.8 MAX_SUBEXPR_SEARCH_DEPTH
  • A.3.9 DISABLE_SUBREQUEST_CACHING
  • A.3.10 GLOBAL_CACHE_STORAGE_PATH
  • A.3.11 MAX_GLOBAL_CACHE_ENTRIES
  • A.3.12 CACHE_POLL_SECONDS
  • A.3.13 CLUSTER_AWARE_CACHE_LOGGING
• A.4 General Section Parameters
  • A.4.1 LOCALE
  • A.4.2 SORT_ORDER_LOCALE
    • A.4.2.1 SORT_ORDER_LOCALE on UNIX Operating Systems
  • A.4.3 SORT_TYPE
  • A.4.4 CASE_SENSITIVE_CHARACTER_COMPARISON
  • A.4.5 NULL_VALUES_SORT_FIRST
  • A.4.6 DATE_TIME_DISPLAY_FORMAT
  • A.4.7 DATE_DISPLAY_FORMAT
  • A.4.8 TIME_DISPLAY_FORMAT
  • A.4.9 WORK_DIRECTORY_PATHS
  • A.4.10 VIRTUAL_TABLE_PAGE_SIZE
  • A.4.11 USE_LONG_MONTH_NAMES
  • A.4.12 USE_LONG_DAY_NAMES
  • A.4.13 UPPERCASE_USERNAME_FOR_INITBLOCK
• A.5 Security Section Parameters
  • A.5.1 DEFAULT_PRIVILEGES
  • A.5.2 PROJECT_INACCESSIBLE_COLUMN_AS_NULL
  • A.5.3 IGNORE_LDAP_PWD_EXPIRY_WARNING
  • A.5.4 SSL
  • A.5.5 SSL_CERTIFICATE_FILE
  • A.5.6 SSL_PRIVATE_KEY_FILE
  • A.5.7 SSL_VERIFY_PEER
  • A.5.8 SSL_CA_CERTIFICATE_FILE
  • A.5.9 SSL_TRUSTED_PEER_DNS
  • A.5.10 SSL_CERT_VERIFICATION_DEPTH
  • A.5.11 SSL_CIPHER_LIST
• A.6 Server Section Parameters
  • A.6.1 READ_ONLY_MODE
  • A.6.2 MAX_SESSION_LIMIT
    • A.6.2.1 About the MAX_SESSION_LIMIT and SERVER_THREAD_RANGE Parameters
  • A.6.3 MAX_REQUEST_PER_SESSION_LIMIT
  • A.6.4 SERVER_THREAD_RANGE
  • A.6.5 SERVER_THREAD_STACK_SIZE
  • A.6.6 DB_GATEWAY_THREAD_RANGE
  • A.6.7 DB_GATEWAY_THREAD_STACK_SIZE
  • A.6.8 MAX_EXPANDED_SUBQUERY_PREDICATES
  • A.6.9 MAX_QUERY_PLAN_CACHE_ENTRIES
  • A.6.10 MAX_DRILLDOWN_INFO_CACHE_ENTRIES
  • A.6.11 MAX_DRILLDOWN_QUERY_CACHE_ENTRIES
  • A.6.12 INIT_BLOCK_CACHE_ENTRIES
  • A.6.13 CLIENT_MGMT_THREADS_MAX
  • A.6.14 RPC_SERVICE_OR_PORT
  • A.6.15 ENABLE_DB_HINTS
  • A.6.16 PREVENT_DIVIDE_BY_ZERO
  • A.6.17 CLUSTER_PARTICIPANT
  • A.6.18 REPOSITORY_PUBLISHING_DIRECTORY
  • A.6.19 REQUIRE_PUBLISHING_DIRECTORY
  • A.6.20 DISCONNECTED
  • A.6.21 AUTOMATIC_RESTART
  • A.6.22 VARIABLE_VALUE_LIMIT
  • A.6.23 FMW_SECURITY_SERVICE_URL
  • A.6.24 FMW_SECURITY_SERVICE_MAX_NUMBER_OF_CONNECTIONS
  • A.6.25 FMW_SECURITY_SERVICE_MAX_NUMBER_OF_RETRIES
  • A.6.26 FMW_UPDATE_ROLE_AND_USER_REF_GUIDS
• A.7 Dynamic Library Section Parameters
• A.8 Usage Tracking Section Parameters
  • A.8.1 ENABLE
  • A.8.2 DIRECT_INSERT
  • A.8.3 STORAGE_DIRECTORY
  • A.8.4 CHECKPOINT_INTERVAL_MINUTES
  • A.8.5 FILE_ROLLOVER_INTERVAL_MINUTES
  • A.8.6 CODE_PAGE
  • A.8.7 PHYSICAL_TABLE_NAME
  • A.8.8 CONNECTION_POOL
  • A.8.9 BUFFER_SIZE
  • A.8.10 BUFFER_TIME_LIMIT_SECONDS
  • A.8.11 NUM_INSERT_THREADS
  • A.8.12 MAX_INSERTS_PER_TRANSACTION
  • A.8.13 SUMMARY_STATISTICS_LOGGING
  • A.8.14 SUMMARY_ADVISOR_TABLE_NAME
• A.9 Query Optimization Flags Section Parameters
  • A.9.1 STRONG_DATETIME_TYPE_CHECKING
• A.10 MDX Member Name Cache Section Parameters
  • A.10.1 ENABLE
  • A.10.2 DATA_STORAGE_PATH
  • A.10.3 MAX_SIZE_PER_USER
  • A.10.4 MAX_MEMBER_PER_LEVEL
  • A.10.5 MAX_CACHE_SIZE
• A.11 Aggregate Persistence Section Parameters
  • A.11.1 AGGREGATE_PREFIX
  • A.11.2 AGGREGATE_THREAD_POOL_SIZE
  • A.11.3 AGGREGATE_AW_NAME
  • A.11.4 PREAGGREGATE_AW_CUBE
• A.12 JavaHost Section Parameters
  • A.12.1 JAVAHOST_HOSTNAME_OR_IP_ADDRESSES
• A.13 Datamart Automation Section Parameters
  • A.13.1 ESSBASE_STUDIO_URL

B Advanced Configuration Reference

• B.1 Making Advanced Configuration Changes for Presentation Services
  • B.1.1 Protecting Pages in Oracle BI EE from Attack
• B.2 Using the JavaHost Service for Oracle BI Presentation Services

C Mapping User Interface Labels with Configuration File Elements

D Manually Updating Fusion Middleware Control Settings

• D.1 Disabling Fusion Middleware Control from Managing Oracle Business Intelligence Configuration Settings
• D.2 Manually Updating Oracle Business Intelligence Configuration Settings Normally Managed by Fusion Middleware Control

Glossary

Index