1/58
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
New Features for Oracle Business Intelligence System Administrators
New Features
Upgrade Considerations
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.4
About Oracle BI Java Components and System Components
1.5
What is the Administration Server?
1.6
What System Administration Tools are Available for Managing Oracle Business Intelligence?
1.6.1
Fusion Middleware Control - Monitor, Manage, and Configure Oracle Business Intelligence System Components
1.6.2
Oracle WebLogic Server Administration Console - Monitor and Manage Oracle Business Intelligence JEE Java Components
1.6.3
Oracle Process Manager and Notification Server (OPMN) Tool - Manage Oracle Business Intelligence System Components (for advanced users)
1.6.4
Oracle Weblogic Scripting Tool (WLST) - Programmatically Administer Oracle Business Intelligence
1.6.5
Oracle BI Administration Tool - Manage the Metadata Repository
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 Oracle Business Intelligence Configuration Settings
3.4
Using a Text Editor to Update Oracle Business Intelligence 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.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 Oracle Business Intelligence System Components
4.5.1
Using the OPMN Command Line to Start, Stop, Restart, and View the Status of Oracle Business Intelligence System Components
4.5.2
Using a Windows Service to Start and Stop Oracle Business Intelligence System Components
4.5.3
Configuring OPMN to Start and Stop Oracle Business Intelligence System Components Automatically on Linux
4.5.4
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
Confirming Whether the Managed Server is Running, and Starting it if Necessary
4.9
Starting and Stopping Managed Servers on Windows and UNIX
4.10
Troubleshooting System Startup
4.10.1
The Administration Server Fails to Start When the Database is Not Running
4.10.2
The Managed Server is Down
4.10.3
The Oracle BI Server Fails to Start
4.10.4
Oracle BI Presentation Services Fails to Start
4.10.5
Unable to Log On
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.2
Configuring Oracle Business Intelligence Components for High Availability
6.2.1
Using Fusion Middleware Control to Configure Primary and Secondary Instances
6.3
How Do Oracle Business Intelligence Components Provide Availability?
6.3.1
About the Cluster Controller
6.3.1.1
What if the Cluster Controller Fails?
6.3.2
About Clustered Oracle BI Servers and the Master BI Server
6.3.2.1
What if a Clustered Oracle BI Server Fails?
6.3.2.2
What if the Master BI Server Fails?
6.3.3
About Clustered Oracle BI Scheduler Instances
6.3.3.1
What if an Oracle BI Scheduler Instance Fails?
6.3.4
About the Oracle BI Cluster Server
6.3.4.1
About the Startup Process for the Cluster Server
6.3.4.2
Performance Considerations for the Cluster Server
6.3.5
About Clustered Presentation Services Instances
6.3.5.1
What if a Presentation Services Instance Fails?
6.3.6
About Clustered JavaHost Instances
6.3.7
About Web Tier Components
6.4
Optional Configuration for Oracle Business Intelligence High Availability
6.4.1
Setting Optional Cluster Controller Parameters
6.4.2
Setting Optional Presentation Services Parameters
6.4.3
Setting Optional Oracle BI Presentation Services Plug-in Parameters
6.5
Using the Cluster Manager
6.5.1
Viewing and Managing Cluster Information
6.5.1.1
Status Information
6.5.1.2
Cache Information
6.5.1.3
Session Information
6.5.1.4
Server Information
6.6
Troubleshooting an Oracle Business Intelligence Clustered Environment
6.6.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
Setting Up Static File Caching
7.10.1.1
Setting Up Static File Caching for Microsoft IIS Server
7.10.1.2
Setting Up Static File Caching for Oracle HTTP Server/Apache HTTP Server
7.10.2
Bypassing Static Files
Part IV Resolving Issues
8
Diagnosing and Resolving Issues in Oracle Business Intelligence
8.1
Viewing And Configuring Diagnostic Log Files
8.1.1
Using Fusion Middleware Control to View Log Information, Error Messages, and Alerts
8.1.2
Configuring Log File Rotation Policy and Specifying Log Levels
8.1.2.1
Using Fusion Middleware Control to Configure Log File Rotation Policy and Specify Log Levels
8.1.2.2
Manually Changing Additional Log File Settings
8.2
Understanding Diagnostic Log and Log Configuration Files
8.2.1
What Are Diagnostic Log Files and Where are They Located?
8.2.2
What Are Diagnostic Log Configuration Files and Where are They Located?
8.2.3
What Are Log File Message Categories and Levels?
8.2.4
What is Log File Rotation?
8.3
Managing the Query Log
8.3.1
Configuring Query Logging
8.3.1.1
Setting the Query Logging Level
8.3.1.2
Setting the Query Logging Level for a User
8.3.2
Using the Log Viewer
8.3.2.1
Interpreting the Log Records
8.4
Logging in Oracle BI Presentation Services
8.4.1
Using the Oracle BI Presentation Services Logging Facility
8.4.2
Structure for the Oracle BI Presentation Services Configuration File
8.4.2.1
Examples of the Formats of Logged Messages
8.4.3
Oracle BI Presentation Services Message Structure
8.4.4
Oracle BI Presentation Services Log Filters
8.4.5
Diagnosing Issues with the 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
Using Fusion Middleware Control to Upload a Repository and Set the Oracle BI Presentation Catalog Location
10.2
Understanding Repository Version Numbers
10.3
Using the System MBeans to Publish 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 for Connections to the Marketing Content Server
11.3.1
Using Fusion Middleware Control to Configure the Connection to the Marketing Content Server
11.3.2
Manually Editing Settings for the Marketing Content Server Connection
11.4
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.1.1
Hardware Sizing and Deployment Strategy for Maps
13.2
Administering Maps
13.2.1
Working with Maps and Layers
13.2.1.1
Associating Layers with Columns
13.2.1.2
Ordering Layers on Maps
13.2.2
Administration Page Functions
13.2.3
Administering Maps
14
Configuring Oracle Scorecard and Strategy Management
14.1
Enabling Comments and Status Overrides in Oracle Scorecard and Strategy Management
15
Configuring Time Zones
15.1
Where Time Zones Are Used
15.2
Setting Time Zones
15.3
Precedence Order for Time Zones
15.3.1
User-Preferred Time Zone
15.4
Where Time Zone Specifications Are Stored
15.4.1
Specifying Time Zone Values
15.5
Description of Time Zone Settings
15.6
Example: Configuration File Settings for Specifying the Time Zone
16
Localizing Oracle Business Intelligence
16.1
What is Localization?
16.1.1
What Components are Translated?
16.1.2
How Do I Localize Oracle Business Intelligence Components?
16.2
Localizing Oracle BI Presentation Services
16.2.1
Localizing the User Interface for Oracle BI Presentation Services
16.2.1.1
Understanding the Directory Structure for Localizing Oracle BI Presentation Services
16.2.1.2
Localizing Messages for Users' Preferred Currency
16.2.1.3
Specifying the Default Language for the Sign-in Page
16.2.1.4
Specifying the Language in the URL
16.2.2
Localizing Oracle BI Presentation Catalog Captions
16.2.3
Tip for Arabic and Hebrew in Mozilla Firefox Browsers
16.2.4
Handling the Translation of Layers in Maps
16.3
Setting the Current Locale in the Oracle BI Server
16.3.1
Setting Locale Parameters on Oracle BI Server
16.3.1.1
Setting the Locale on UNIX Systems
16.3.2
Understanding How the Error Message Language is Determined
16.3.3
Troubleshooting the Current Locale in the Oracle BI Server
16.3.3.1
Handling the NLS Locale Not Supported Error Message
16.3.3.2
Setting the Japanese Locale on AIX Systems
16.4
Localizing Metadata Names in the Repository
16.5
Supporting Multilingual Data
16.5.1
What is Multilingual Data Support?
16.5.2
What is Lookup?
16.5.3
What is Double Column Support?
16.5.4
Designing Translation Lookup Tables in a Multilingual Schema
16.5.4.1
A Lookup Table for Each Base Table
16.5.4.2
A Lookup Table for Each Translated Field
16.5.5
Creating Logical Lookup Tables and Logical Lookup Columns
16.5.5.1
Creating Logical Lookup Tables
16.5.5.2
Designating a Logical Table as a Lookup Table
16.5.5.3
About the LOOKUP Function Syntax
16.5.5.4
Creating Logical Lookup Columns
16.5.6
Creating Physical Lookup Tables and Physical Lookup Columns
16.5.7
Supporting Multilingual Data in Essbase Through Alias Tables
16.5.8
Enabling Lexicographical Sorting
17
Configuring Currency Options
17.1
Changing the Default Currency for Analyses
17.2
Defining User-Preferred Currency Options
17.2.1
Defining User-Preferred Currency Options Using a Static Mapping
17.2.2
Example: Static Mapping to Define User-Preferred Currency Options
17.2.3
Defining User-Preferred Currency Options Using a Dynamic Mapping
17.2.4
Example: Dynamic Mapping to Define User-Preferred Currency Options
18
Configuring and Managing the Oracle BI Presentation Catalog
18.1
About the Oracle BI Presentation Catalog
18.2
About Catalog Manager
18.2.1
Uses for Catalog Manager
18.2.2
Guidelines for Working with Catalog Manager
18.2.3
Tips for Working with Catalog Manager
18.3
Maintaining the Oracle BI Presentation Catalog
18.3.1
Manually Changing Additional Configuration Settings for the Catalog
18.3.2
Manually Creating a New Oracle BI Presentation Catalog
18.3.3
Deploying a Catalog Object to Production
18.4
Starting Catalog Manager and Opening Catalogs
18.4.1
Starting Catalog Manager
18.4.2
Understanding the Two Catalog Modes
18.4.3
Operations Available in Online Mode and Offline Mode
18.4.4
Opening an Oracle BI Presentation Catalog
18.5
Using the Catalog Manager Workspace
18.5.1
What Does the Catalog Manager Workspace Do?
18.5.2
What Does the Catalog Manager Workspace Look Like?
18.5.3
Managing the View of the Catalog Manager Workspace
18.6
Working with Objects in Catalog Manager
18.6.1
Searching for Catalog Objects Using Catalog Manager
18.6.2
Copying and Pasting Objects
18.6.2.1
Tips for Copying and Pasting
18.6.2.2
Online and Offline Mode for Copying and Pasting
18.6.2.3
Copying and Pasting Objects Between Catalogs
18.6.2.4
Advanced Options for Pasting Objects
18.6.2.4.1
Paste Overwrite
18.6.2.4.2
Paste ACL
18.6.3
Renaming Catalog Objects
18.6.4
Working with the Properties of Catalog Objects
18.6.5
Setting Permissions of Catalog Objects
18.6.6
Previewing Objects from Catalog Manager
18.7
Viewing and Editing Catalog Objects in XML
18.8
Searching for and Replacing Catalog Text Using Catalog Manager
18.8.1
Searching for and Replacing a Single Catalog Text String
18.8.2
About Searching for and Replacing Multiple Catalog Text Strings
18.8.2.1
XML File Format for Searching for and Replacing Text Strings
18.8.2.2
Example XML File for Searching for and Replacing Text Strings
18.8.3
Searching for and Replacing Multiple Catalog Text Strings
18.9
Creating Reports to Display Catalog Data Using Catalog Manager
18.10
Archiving and Unarchiving a Catalog Using Catalog Manager
18.11
Configuring for Full-Text Catalog Search
18.11.1
What is a Full-Text Catalog Search?
18.11.2
Deployment of Oracle Full-Text Catalog Search
18.11.3
How is Security Handled in the Full-Text Catalog Search?
18.11.4
Process for Configuring the Full-Text Catalog Search
18.11.4.1
Step 1: Assigning Privileges for Crawling and Indexing
18.11.4.2
Step 2: Ensuring that Secure Enterprise Search is Available
18.11.4.3
Step 3: Configuring Identity Management for Full-Text Catalog Search
18.11.4.4
Step 4: Creating the Data Source for Full-Text Catalog Search
18.11.4.5
Step 5: Editing the Schedule for Full-Text Catalog Search
18.11.4.6
Step 6: Specifying the Look and Feel of Search Results
18.11.4.7
Step 7: Enabling Incremental Crawls for Full-Text Catalog Search
18.11.4.8
Step 8: Configuring Properties for Full-Text Catalog Search Manually
18.11.4.9
Step 9: Allowing Users to Access the Full-Text Catalog Search
18.11.4.9.1
Providing Designers with the URL
18.11.4.9.2
Making the Shortcut Available from the Oracle BI EE Home Page
18.12
Replicating Oracle BI Presentation Catalogs
18.12.1
About Replication Log Files
18.12.1.1
Replication Log File Records
18.12.2
Configuring to Replicate an Oracle BI Presentation Catalog
18.12.2.1
Copying Oracle BI Presentation Catalog Files
18.12.3
Using the Oracle BI Presentation Services Replication Agent
18.12.3.1
mark
18.12.3.2
remotecopy
18.12.3.3
run
18.12.4
Creating the config.xml File for Replication
18.12.4.1
Structure of the Configuration File
18.12.4.2
Elements of the Configuration File
18.12.4.3
Example config.xml File
18.12.5
Editing the instanceconfig.xml File for Replication
18.12.6
Resuming Replication If Replication Log Files Are Unavailable
Part VI Advanced Configuration Settings
19
Configuring and Managing Analyses and Dashboards
19.1
Managing Dashboards
19.2
Performing General Configuration Tasks for Analyses
19.2.1
Providing Access to Metadata Dictionary Information
19.2.2
Supporting Nested Folders, Navigation, and Drill Down
19.3
Configuring for Displaying and Processing Data in Views
19.3.1
Manually Configuring for Data in Views
19.3.1.1
Manually Configuring Cube Settings for Pivot Tables and Graphs
19.3.1.2
Manually Configuring Settings for Data in Views
19.3.2
Manually Configuring for Graphs and Gauges
19.3.2.1
Configuring Fonts for Graphs
19.3.2.1.1
Setting the Embed Fonts Element
19.3.2.1.2
Delivering Font Files for Printing
19.3.3
Manually Changing Alternating Bar Color
19.4
Manually Changing Presentation Settings
19.4.1
Manually Changing Presentation Setting Defaults
19.4.2
Configuring Links to Dashboard Pages
19.4.3
Configuring an Alternate Toolbar for Oracle BI Publisher
19.4.4
Modifying the Table of Contents for PDF Versions of Briefing Books
19.5
Controlling Access to Saved Customization Options in Dashboards
19.5.1
Overview of Saved Customizations in Dashboards
19.5.2
Administering Saved Customizations
19.5.2.1
Privileges for Saved Customizations
19.5.2.2
Permissions for Saved Customizations
19.5.2.2.1
Assigning Permissions to Dashboards
19.5.2.2.2
Assigning Permissions for Customizations on a Dashboard Page
19.5.2.2.3
Catalog Folder Structure for Saved Customizations
19.5.3
Permission and Privilege Settings for Creating Saved Customizations
19.5.4
Example Usage Scenario for Saved Customization Administration
19.6
Blocking Analyses in Answers
19.6.1
Storing JavaScript Files
19.6.2
Blocking Analyses Based on Criteria
19.6.3
Blocking Analyses Based on Formula
19.6.4
Validation Helper Functions
19.7
Specifying View Defaults for Analyses and Dashboards
19.7.1
XML Message Files for View Defaults
19.7.2
Examples of Customizing Default Values for Analyses and Dashboards
19.7.2.1
Adding a Default Header or Footer to New Analyses
19.7.2.2
Preventing Auto-Previewing of Results
19.7.2.3
Setting Defaults for Analyses in the Compound Layout
19.7.2.4
Changing Dashboards Section Defaults
19.7.2.5
Specifying Dashboard Page Defaults Including Headers and Footers
19.7.2.6
Including Links with Analyses on Dashboards
19.8
Configuring for Write Back in Analyses and Dashboards
19.8.1
Write-Back Limitations
19.8.2
Configuring for Write Back
19.8.2.1
Setting the LightWriteback Element
19.8.3
About the Write-Back Template
19.8.3.1
How Write Back Works
19.8.3.2
Requirements for the Write-Back Template
19.8.3.3
Example: Write Back Template
20
Configuring and Managing Agents
20.1
How are Agents Used?
20.2
How Do Antivirus Software and Privileges Affect Agents?
20.2.1
How Does Antivirus Software Affect Agents?
20.2.2
What Privileges Affect Agents?
20.3
Configuring Settings That Affect Agents
20.3.1
Manually Configuring Presentation Services Settings That Affect Agents
20.3.2
Manually Changing Additional Scheduler Settings that Affect Agents
20.3.3
What Additional Scheduler Configuration Settings Affect Agents?
20.3.3.1
General Scheduler Configuration Settings That Affect Agents
20.3.3.2
Email Scheduler Configuration Settings That Affect Agents
20.3.3.3
Agent Scheduler Configuration Settings
20.3.4
Controlling Delivery Options for Agents
20.4
Managing Device Types for Agents
20.5
Monitoring Active Agent Sessions
21
Configuring Advanced Options for Mapping and Spatial Information
21.1
Configuring MapViewer to Support Map Views
21.2
Manually Configuring for Map Views
21.3
Inserting Text on a Map
21.4
Embedding Maps in External Pages
22
Customizing the Oracle BI Web User Interface
22.1
Tips for Customizing the Web User Interface
22.2
What are Skins and Styles?
22.2.1
Using the SKIN Variable
22.3
Modifying Oracle BI Presentation Services User Interface Styles
22.3.1
Creating a New Dashboard Style
22.3.2
Specifying Defaults for Styles and Skins
22.4
Customizing Language Selections and Other Components
22.4.1
Customizing a Language Selection
22.4.2
Customizing the Appearance of the Sign-In Page
22.4.3
Customizing Non-Dashboard Components
22.5
Customizing the User Interface Using XML Message Files
22.5.1
User Interface XML Message Files
22.5.2
Structure of XML Message Files
22.5.3
Customizing XML Messages
22.5.4
Resolution of XML Message Name Elements
22.5.5
Sample XML Template
22.5.6
Sample custommessages.xml File
23
Configuring Resource Availability and URL Generation
Part VII Configuring Oracle BI Scheduler
24
Introducing Oracle BI Scheduler
24.1
What is Oracle BI Scheduler?
24.2
About Oracle BI Scheduler Server Components
24.3
About Agent Support in Oracle BI Scheduler
24.4
About Database Support in Oracle BI Scheduler
24.5
About Oracle BI Scheduler Schemas
25
Configuration Tasks for Oracle BI Scheduler
25.1
Creating an Oracle BI Scheduler Database and Tables Using RCU
25.2
Configuring a Database for the Oracle BI Scheduler
25.2.1
Using Fusion Middleware Control to Configure a Database for the Oracle BI Scheduler
25.2.2
Configuring a System DSN entry for SQL Server Databases
25.3
Configuring Oracle BI Scheduler Instances in a Clustered Environment
25.4
Changing Oracle BI Scheduler Table Names
26
Using Oracle BI Scheduler Job Manager
26.1
Opening Job Manager
26.2
Adding Oracle BI Scheduler Jobs in Job Manager
26.3
Modifying Oracle BI Scheduler Jobs in the Job Manager
26.4
About Adding Agent Jobs
26.5
Modifying Agents in Job Manager
26.6
Re-Running a Job Instance
26.7
Managing Oracle BI Scheduler Job Instances
26.7.1
Viewing or Refreshing Oracle BI Scheduler Job Instances
26.7.2
Cancelling Oracle BI Scheduler Job Instances
26.7.3
Purging Oracle BI Scheduler Job Instances
26.7.3.1
Using the Job Manager Instances List
26.7.3.2
Using the Job Manager Purge Instances Window
27
Programming BI Scheduler VBScript and JScript Jobs
27.1
Configuring Custom Script Properties for Oracle BI Scheduler
27.2
Creating a Custom Script Example - Cache Clearance
27.3
Configuring Custom Script Properties for Oracle BI Delivers
27.4
Creating a Custom Script Example - Copy Results to the File System
27.5
Oracle BI Scheduler Read-Only Script Object Properties
27.6
Oracle BI Scheduler Read/Write Script Object Properties
27.7
Oracle BI Scheduler Script-Defined Constants
27.7.1
Severity Constants
27.7.2
DayEnum Constants
27.7.3
DayOfWeekEnum Constants
27.7.4
JobFlagsEnum Constants
27.7.5
MonthEnum Constants
27.7.6
OccurrenceEnum Constants
27.8
Oracle BI Scheduler Script Object Methods and Events
27.8.1
CreateArray Method
27.8.2
DeregisterCancelCommand Method
27.8.3
GetConfigurationValue Method
27.8.4
GetTempFileName Method
27.8.5
LaunchProcess Method
27.8.6
RegisterCancelCommand Method
27.8.7
ScheduleJobDaily Method
27.8.8
ScheduleJobMonthlyDate Method
27.8.9
ScheduleJobMonthlyDOW Method
27.8.10
ScheduleJobNow Method
27.8.11
ScheduleJobOnce Method
27.8.12
ScheduleJobWeekly Method
27.8.13
OnError Event
27.9
Troubleshooting JScript and VBScript Job Failures
28
Programming BI Scheduler Java Jobs
28.1
Using Oracle BI Scheduler Java Jobs
28.1.1
Adding and Configuring Custom Java Jobs in Job Manager
28.1.2
Example: Creating a Java Program for Agents
28.1.3
Example: Configuring a Java Program
28.2
Oracle BI Scheduler Java Jobs
28.3
Adding Java Jobs for Oracle BI Scheduler
28.4
Oracle BI Scheduler Custom Java Program Package
28.5
SchedulerJavaExtension Interface
28.6
SchedulerJobInfo Interface
28.7
SchedulerJobException Class
28.8
Oracle BI Scheduler Java Extension Example
29
Oracle BI Scheduler Job Manager Menus
29.1
About the Job Manager
29.2
Toolbar Menus in Job Manager
29.2.1
File Menu in Job Manager
29.2.2
Service Management Menu in Job Manager
29.2.3
Jobs Menu in Job Manager
29.2.4
Instances Menu in Job Manager
29.2.5
Instance Properties in Job Manager
29.3
General Oracle BI Scheduler Job Properties
29.4
Job Action Properties Available in Job Manager
29.5
Job Triggers in Job Manager
29.5.1
Single-Run Triggers
29.5.2
Recurrent Triggers
29.5.2.1
Recurrent Trigger Types
Part VIII Automating Management of Oracle Business Intelligence
30
Introducing the Oracle BI Systems Management API
30.1
What is the Oracle BI Systems Management API?
30.2
Accessing Oracle BI Systems Management API Methods
30.3
Using the Oracle BI Systems Management API to Manage and Configure Oracle Business Intelligence
30.3.1
Displaying Oracle Business Intelligence Status Using the Oracle BI Systems Management API
30.3.1.1
Example: Using WLST Commands in a Script to Display the Status of Oracle Business Intelligence
30.3.1.2
Example: Using a Java Program to Display the Status of Oracle Business Intelligence
30.3.2
Starting and Stopping Oracle Business Intelligence Using the Oracle BI Systems Management API
30.3.2.1
Example: Using WLST Commands to Stop and Start Oracle Business Intelligence
30.3.2.2
Example: Using a Java Program to Stop and Start Oracle Business Intelligence
30.3.3
Updating Configuration Settings Using the Oracle BI Systems Management API
30.3.3.1
Example: Using WLST to Edit the E-Mail Sender Display Name Configuration Setting
30.3.3.2
Example: Using a Java Program to Edit the E-Mail Sender Display Name Configuration Setting
30.3.4
Scaling Out for High Availability and Performance Using the Oracle BI Systems Management API
30.3.4.1
Example: Using WLST to Scale Out to Servers
30.3.4.2
Example: Using a Java Program to Scale Out to Servers
30.4
Descriptions of JMX Admin MBeans and Methods for Oracle BI Systems Management API
Part IX Managing the Life Cycle
31
Patching Oracle Business Intelligence Systems
31.1
What is Patched for the Oracle Business Intelligence Platform?
31.2
Patching the Platform
31.2.1
What Conditions Apply When Patching the Platform?
31.2.2
Applying a Patch to the Platform
31.2.2.1
Step 1: Download the Patch
31.2.2.2
Step 2: Stop System Component Processes for Oracle BI EE
31.2.2.3
Step 3: Apply the Patch to Each Oracle Home
31.2.2.4
Step 4: Start System Component Processes for Oracle BI EE
31.2.2.5
Step 5: Redeploy Patched J2EE Applications
31.2.3
What Happens if a Patching Conflict Occurs?
31.3
Rolling Back a Platform Patch
31.3.1
Step 1: Stop System Component Processes for Oracle BI EE
31.3.2
Step 2: Invoke OPatch with "-rollback" Option
31.3.3
Step 3: Start System Component Processes for Oracle BI EE
31.3.4
Step 4: Redeploy J2EE Applications
31.4
Determining Current Patch Levels
32
Moving to a New Environment
33
Moving From a Test to a Production Environment
34
Backup and Recovery of Oracle Business Intelligence Systems
Part X 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
AUTOMATIC_RESTART
A.6.21
FMW_SECURITY_SERVICE_URL
A.6.22
FMW_SECURITY_SERVICE_MAX_NUMBER_OF_CONNECTIONS
A.6.23
FMW_SECURITY_SERVICE_MAX_NUMBER_OF_RETRIES
A.6.24
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
B
Exchanging Metadata with Databases to Enhance Query Performance
B.1
About Exchanging Metadata with Databases
B.2
Generating the Import File
B.2.1
Running the Generator
B.2.2
About the Metadata Input File
B.2.3
About the Output Files
B.2.4
Troubleshooting Errors from the Generator
B.2.5
Metadata Conversion Rules and Error Messages
B.2.5.1
Conversion Rules for Oracle Databases
B.2.5.2
Conversion Rules for IBM DB2 Databases
B.3
Using Materialized Views in the Oracle Database with Oracle Business Intelligence
B.3.1
About Using the SQL Access Advisor with Materialized Views
B.3.2
Deploying Metadata for Oracle Database
B.3.2.1
Executing the SQL File for Oracle Database
B.3.2.2
Defining Constraints for the Existence of Joins
B.3.2.3
Creating the Query Workload
B.3.2.4
Creating Materialized Views
B.4
Using IBM DB2 Cube Views with Oracle Business Intelligence
B.4.1
About Using IBM DB2 Cube Views with Oracle Business Intelligence
B.4.2
Deploying Cube Metadata
B.4.2.1
Executing the Alias-SQL File for IBM Cube Views
B.4.2.2
Importing the XML File
B.4.2.2.1
Guidelines for Importing the XML File Using the IBM OLAP Center
B.4.2.2.2
Guidelines for Changing Cube Metadata After Importing the XML File
B.4.2.3
Guidelines for Creating Materialized Query Tables (MQTs)
C
Managing Security for Dashboards and Analyses
C.1
Managing Security for Users of Oracle BI Presentation Services
C.1.1
Where Are Oracle BI Presentation Services Security Settings Made?
C.1.2
What are the Security Goals in Oracle BI Presentation Services?
C.1.3
How Are Permissions and Privileges Assigned to Users?
C.2
Managing Users Using Administration Pages
C.2.1
Understanding the Administration Pages
C.2.2
Working with Catalog Groups
C.2.2.1
Creating Catalog Groups
C.2.2.2
Deleting Catalog Groups
C.2.2.3
Editing Catalog Groups
C.2.3
Managing Presentation Services Privileges
C.2.3.1
What are Privileges?
C.2.3.2
Setting Privileges in Oracle BI Presentation Services Administration
C.2.3.3
Default Oracle BI Presentation Services Privilege Assignments
C.2.3.3.1
Access to Oracle BI Enterprise Edition Actions
C.2.3.3.2
Access to Oracle BI for Microsoft Office Privilege
C.2.4
Managing Sessions in Oracle BI Presentation Services
C.3
Inheritance of Permissions and Privileges for Oracle BI Presentation Services
C.3.1
Rules for Inheritance for Permissions and Privileges
C.3.2
Example of Inherited Privileges for Application Roles
C.3.3
Example of Inherited Privileges for Catalog Groups
C.4
Providing Shared Dashboards for Users
C.4.1
Understanding the Catalog Structure for Shared Dashboards
C.4.2
Creating Shared Dashboards
C.4.3
Testing the Dashboards
C.4.4
Releasing Dashboards to the User Community
C.5
Enabling Users to Act for Others
C.5.1
Why Enable Users to Act for Others?
C.5.2
What are the Proxy Levels?
C.5.3
Process of Enabling Users to Act for Others
C.5.3.1
Defining the Association Between Proxy Users and Target Users
C.5.3.2
Creating Session Variables for Proxy Functionality
C.5.3.3
Modifying the Configuration File Settings for Proxy Functionality
C.5.3.4
Creating a Custom Message Template for Proxy Functionality
C.5.3.5
Assigning the Proxy Privilege
D
Setting Up the SA System Subject Area
D.1
About the SA System Subject Area
D.1.1
About Group and Application Role Resolution
D.2
Setting Up the Data Source for the SA System Subject Area
D.3
Importing SA System Data Into the Repository
D.4
Setting Configuration Options for the SA System Subject Area
D.4.1
Managing the Case of Login Names for the SA System Subject Area
E
Advanced Configuration Reference
E.1
Making Advanced Configuration Changes for Oracle BI Presentation Services
E.1.1
HardenXSS Element
E.2
Using the JavaHost Service for Oracle BI Presentation Services
F
Propagating Labels and Tooltips from Oracle ADF Data Sources
F.1
What are Labels and Tooltips?
F.2
Session Variable Naming Scheme for UI Hints from an Oracle ADF Data Source
F.3
Mapping of Presentation Columns to Physical Columns
F.4
Initializing Session Variables Automatically for Propagating UI Hints
F.5
Example: Using UI Hints From an Oracle ADF Data Source When Creating Analyses
F.6
Using XML Code in Initialization Blocks to Query UI Hints from an Oracle ADF Data Source
G
Mapping User Interface Labels with Configuration File Elements
H
Manually Updating Fusion Middleware Control Settings
H.1
Disabling Fusion Middleware Control from Managing Oracle Business Intelligence Configuration Settings
H.2
Manually Updating Oracle Business Intelligence Configuration Settings Normally Managed by Fusion Middleware Control
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.