Home
/
Middleware
/
Oracle Business Intelligence Enterprise Edition
1/41
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documentation and Other Resources
Conventions
New Features for Oracle Business Intelligence System Administrators
New Features and Changes for Oracle BI EE 12
c
(12.2.1)
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 System Architecture
1.3.2
Oracle Business Intelligence Components
1.3.3
About the Administration Server, Managed Servers, and System Components
1.3.3.1
About the Administration Server and Managed Servers
1.3.3.2
About System Components
1.4
Key Directories in Oracle Business Intelligence
1.5
What System Administration Tools Manage Oracle Business Intelligence?
1.5.1
Fusion Middleware Control
1.5.2
Oracle WebLogic Server Administration Console
1.5.3
Process Control Commands
1.5.4
Oracle WebLogic Scripting Tool (WLST)
1.5.5
Oracle BI Administration Tool
1.5.6
Catalog Manager
1.5.7
Job Manager
1.6
Working with the Sample Application
1.7
Oracle BI Publisher Integration
1.8
Topics of Interest in Other Guides
1.9
System Requirements and Certification
Part II Managing Processes and Components
2
Managing Oracle Business Intelligence Processes
2.1
About Managing Oracle Business Intelligence Processes
2.2
Conditions for Starting the Oracle Business Intelligence System
2.3
Using Commands to Stop, Start, and View Status of Oracle Business Intelligence Processes
2.3.1
Stopping Oracle Business Intelligence Component Processes in a Domain
2.3.2
Starting Oracle Business Intelligence Component Processes in a Domain
2.3.3
Viewing the Status of Oracle Business Intelligence Components in a Domain
2.4
Using Fusion Middleware Control to Start and Stop BI System Component Processes
2.5
Using Fusion Middleware Control to Start and Stop Java Components
2.6
Using Oracle WebLogic Server Administration Console to Start and Stop Java Components
Part III Scaling and Deploying for High Availability and Performance
3
Scaling Your Deployment
3.1
About Scaling Oracle Business Intelligence
3.1.1
How Do I Know When to Scale Out Processes?
3.1.2
What Processes Should I Scale?
3.2
Setting Up Shared Files and Directories
3.2.1
Changing the Singleton Data Directory (SDD)
3.2.2
Setting Up the Global Cache
3.3
Managing Capacity in Oracle Business Intelligence (Vertically Scaling)
3.3.1
Adding System Components
3.3.2
Removing System Components
3.4
Managing Availability in Oracle Business Intelligence (Horizontally Scaling)
3.4.1
Adding New Computers
3.4.2
Removing Existing Computers
3.5
Validating That Your System Has Been Scaled Correctly
3.5.1
Using Fusion Middleware Control to View System Component Availability
3.5.2
Using the Administration Console to View Managed Server Availability
4
Deploying Oracle Business Intelligence for High Availability
4.1
About Oracle Business Intelligence Components in a Clustered Environment
4.1.1
Recommendations for Availability
4.1.2
Using Fusion Middleware Control to Identify Single Points of Failure
4.1.3
Achieving High Availability Using an Active-Passive Model
4.2
Configuring Oracle Business Intelligence Components for High Availability
4.3
Optional Configuration for Oracle Business Intelligence High Availability
4.3.1
Setting Optional Cluster Controller Parameters
4.3.2
Setting Optional Presentation Services Parameters
4.3.3
Setting Optional Oracle BI Presentation Services Plug-in Parameters
4.4
Using the Cluster Manager
4.4.1
Viewing and Managing Cluster Information
4.4.1.1
Status Information
4.4.1.2
Cache Information
4.4.1.3
Session Information
4.4.1.4
Server Information
4.5
Troubleshooting an Oracle Business Intelligence Clustered Environment
4.5.1
Avoiding Errors with Network Appliance Devices When the Oracle BI Server Is Running on Linux or UNIX
5
Managing Performance Tuning and Query Caching
5.1
Monitoring Service Levels
5.1.1
Using Fusion Middleware Control to View All Oracle Business Intelligence Metrics
5.1.2
Using the Administration Console to View Metrics for Java Components
5.2
About Query Performance Tuning
5.3
Setting Performance Parameters in Fusion Middleware Control
5.3.1
Using Fusion Middleware Control to Disallow RPD Updates
5.3.2
Using Fusion Middleware Control to Set the User Session Log-Off Period
5.3.3
Using Fusion Middleware Control to Set Configuration Options for Data in Tables and Pivot Tables
5.3.4
Using Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table
5.4
About the Oracle BI Server Query Cache
5.4.1
Query Cache Architecture
5.4.2
Advantages of Caching
5.4.3
Costs of Caching
5.4.3.1
Disk Space
5.4.3.2
Administrative Tasks
5.4.3.3
Keeping the Cache Up To Date
5.4.3.4
CPU Usage and Disk I/O
5.4.4
Cache Sharing Across Users
5.4.5
About the Refresh Interval for XML Data Sources
5.4.6
About the Global Cache
5.5
Configuring Query Caching
5.5.1
Using Fusion Middleware Control to Enable and Disable Query Caching
5.5.2
Using Fusion Middleware Control to Set Query Cache Parameters
5.5.3
Manually Editing Additional Query Cache Parameters
5.5.4
Using Fusion Middleware Control to Set Global Cache Parameters
5.5.5
Manually Editing Additional Global Cache Parameters
5.6
Monitoring and Managing the Cache
5.6.1
Choosing a Cache Management Strategy
5.6.1.1
Disable Caching for the System
5.6.1.2
Caching and Cache Persistence Timing for Specified Physical Tables
5.6.1.3
Configure Oracle BI Server Event Polling Tables
5.6.2
Purging and Maintaining Cache Using ODBC Procedures
5.6.2.1
About ODBC Procedure Syntax
5.6.2.2
About Sharing the Presentation Services Query Cache
5.6.2.3
About Result Records
5.6.2.4
Storing and Purging Cache for SAP/BW Data Sources
5.6.3
How Repository Changes Affect the Query Cache
5.6.3.1
Online Mode
5.6.3.2
Offline Mode
5.6.3.3
Switching Between Repositories
5.6.3.4
Changes to Dynamic Repository Variables
5.7
Strategies for Using the Cache
5.7.1
About Cache Hits
5.7.1.1
Ensuring Correct Cache Results When Using Row-Level Database Security
5.7.2
Running a Suite of Queries to Populate the Cache
5.7.3
Using Agents to Seed the Oracle BI Server Cache
5.7.4
Using the Cache Manager
5.7.4.1
Displaying Global Cache Information in the Cache Manager
5.7.4.2
Purging Cache in the Administration Tool
5.8
Cache Event Processing with an Event Polling Table
5.8.1
Setting Up Event Polling Tables on the Physical Databases
5.8.2
Making the Event Polling Table Active
5.8.3
Populating the Oracle BI Server Event Polling Table
5.8.4
Troubleshooting Problems with Event Polling Tables
5.9
Managing the Oracle BI Presentation Services Cache Settings
5.10
Improving Oracle BI Web Client Performance
5.10.1
Configuring Apache HTTP Server for Static File Caching
5.10.2
Configuring Oracle HTTP Server for Static File Caching
5.11
Setting the JVM Heap Size for Oracle Business Intelligence
5.12
Capturing Metrics Using the Dynamic Monitoring Service
5.12.1
Using the Dynamic Monitoring Service for Metrics
5.12.2
Using WLST Commands for Metrics
Part IV Resolving Issues
6
Diagnosing and Resolving Issues in Oracle Business Intelligence
6.1
What Diagnostic Tools Are Available?
6.2
Collecting Diagnostic Bundles
6.3
Viewing and Configuring Diagnostic Log Files
6.3.1
Using Fusion Middleware Control to View Log Information, Error Messages, and Alerts
6.3.2
Configuring Log File Rotation Policy and Specifying Log Levels
6.3.2.1
Using Fusion Middleware Control to Configure Log File Rotation Policy and Specify Log Levels
6.3.2.2
Manually Changing Additional Log File Settings
6.3.3
Diagnosing Issues Using the Log Viewer
6.4
Understanding Diagnostic Log and Log Configuration Files
6.4.1
What Are Diagnostic Log Files and Where Are They Located?
6.4.2
What Are Diagnostic Log Configuration Files and Where Are They Located?
6.4.3
What Are Log File Message Categories and Levels?
6.4.4
What is Log File Rotation?
6.4.5
What Messages Are Included in the System Log?
6.5
Managing the Query Log
6.5.1
Configuring Query Logging
6.5.1.1
Setting the Query Logging Level
6.5.1.2
Setting the Query Logging Level for a User
6.5.2
Using the Log Viewer
6.5.2.1
Running the Log Viewer Utility
6.5.2.2
Interpreting the Log Records
6.6
Logging in Oracle BI Presentation Services
6.6.1
Using the Oracle BI Presentation Services Logging Facility
6.6.2
Setting the Logging Levels for Oracle BI Presentation Services
6.6.3
Structure for the Oracle BI Presentation Services Configuration File
6.6.4
Examples of the Formats of Logged Messages
6.6.5
Oracle BI Presentation Services Message Structure
6.6.6
Oracle BI Presentation Services Log Filters
6.6.7
Diagnosing Issues with Agents
6.6.7.1
Debugging Agents Using Fusion Middleware Control
6.6.7.2
Manually Debugging Agents Using instanceconfig.xml
6.7
Using ODBC/JDBC Procedures to Obtain Oracle BI Server Diagnostics
6.7.1
About the Oracle BI Server ODBC/JDBC Procedures
6.7.2
Obtaining a List of Available Diagnostic Categories
6.7.3
Running Specific Diagnostics
6.7.4
About Parameters for ODBC/JDBC Procedures
6.8
Troubleshooting System Startup
6.8.1
Administration Server Fails to Start When the Database Is Not Running
6.8.2
Managed Server Is Down
6.8.3
Oracle BI Server Fails to Start
6.8.4
Cannot Log In
7
Managing Usage Tracking
7.1
About Usage Tracking
7.2
Setting Up Direct Insertion to Collect Information for Usage Tracking
7.2.1
Setting Up the Usage Tracking Statistics Database
7.2.2
Setting Direct Insertion Parameters
7.2.3
Setting Optional Direct Insert Parameters
7.3
Description of the Usage Tracking Data
Part V Configuring Oracle Business Intelligence
8
Using Tools for Managing and Configuring Oracle Business Intelligence
8.1
Why Use Fusion Middleware Control and WebLogic Server Administration Console?
8.2
Managing Oracle Business Intelligence System Components Using Fusion Middleware Control
8.2.1
Logging into Fusion Middleware Control
8.2.2
Displaying Oracle Business Intelligence Pages in Fusion Middleware Control
8.2.3
Using the Navigation Tree in Fusion Middleware Control
8.2.4
Tips for Using Fusion Middleware Control with Oracle Business Intelligence
8.3
Configuring Oracle Business Intelligence System Settings
8.3.1
Using Fusion Middleware Control
8.3.2
Using a Text Editor
8.3.3
Using the WebLogic Scripting Tool (WLST)
8.3.3.1
Making Offline Configuration Changes
8.3.3.2
Making Online Configuration Changes
8.3.4
Updating the Java Development Kit (JDK)
8.4
Managing Oracle Business Intelligence Java Components Using the Oracle WebLogic Server Administration Console
9
Managing Metadata and Working with Service Instances
9.1
About Oracle Business Intelligence Application Archive (BAR) Files
9.1.1
What Are Oracle Business Intelligence Application Archive (BAR) Files?
9.1.2
What Predefined BAR Files are Available?
9.1.3
About Importing BAR Files
9.2
Managing Service Instances
9.2.1
listBIServiceInstances
9.2.2
getBIServiceInstance
9.2.3
scaleOutBIServiceInstance
9.2.4
exportServiceInstance
9.2.5
importServiceInstance
9.2.6
refreshServiceInstance
9.2.7
refreshDomainServiceInstances
9.2.8
resetServiceInstance
10
Configuring Connections to External Systems
10.1
Configuring Email and Agents
10.1.1
Using Fusion Middleware Control to Configure Oracle BI Scheduler Email Settings that Affect Agents
10.2
Configuring for Actions with the Action Framework
10.3
Configuring Connections to the Marketing Content Server
10.4
Configuring Connections to Data Sources
11
Configuring Presentation Setting Defaults
11.1
Using Fusion Middleware Control to Change Presentation Setting Defaults
12
Configuring Mapping and Spatial Information
12.1
What Are the System Requirements for Map Views?
12.2
Hardware Sizing and Deployment Strategy for Maps
12.3
Administering Maps
12.3.1
Working with Maps and Layers
12.3.1.1
Associating Layers with Columns
12.3.1.2
Ordering Layers on Maps
12.3.1.3
Changes to Spatial Metadata Require Restart
12.3.2
Administration Page Functions
12.3.3
Administering Maps Using Administration Pages
12.3.4
Handling the Translation of Layers in Maps
13
Configuring Time Zones
13.1
Why and Where Are Time Zones Used?
13.2
Setting Time Zones
13.3
What is the Precedence Order for Time Zones
13.3.1
User-Preferred Time Zone
13.4
Where Are Time Zone Specifications Stored?
13.4.1
Specifying Time Zone Values
13.5
Description of Time Zone Settings
13.6
Example: Configuration File Settings for Specifying the Time Zone
14
Localizing Oracle Business Intelligence
14.1
What Is Localization?
14.1.1
What Components Are Translated?
14.1.2
Tasks for Localizing Oracle Business Intelligence Components
14.2
Localizing Oracle BI Presentation Services
14.2.1
Localizing the User Interface for Oracle BI Presentation Services
14.2.1.1
Understanding the Directory Structure for Localizing Presentation Services
14.2.1.2
Localizing Messages for Users' Preferred Currency
14.2.1.3
Specifying the Default Language for the Sign-In Page
14.2.1.4
Configuring the Languages and Locales for the Sign-In Page
14.2.1.5
Specifying the Scaling of Numbers in Performance Tiles
14.2.1.6
Specifying the Language in the URL
14.2.2
Localizing Oracle BI Presentation Catalog Captions
14.2.2.1
Step 1: Understanding the Export Process
14.2.2.2
Step 2: Exporting Text Strings in the Catalog
14.2.2.3
Step 3: Editing Exported Strings in XML Files
14.2.2.4
Step 4: Handling Duplicate Exported Text Strings
14.2.2.5
Step 5: Exposing Text Strings in the Catalog
14.2.3
Tip for Arabic and Hebrew in Mozilla Firefox Browsers
14.3
Setting the Current Locale in Catalog Manager
14.4
Setting the Current Locale in the Oracle BI Server
14.4.1
Setting Locale Parameters on the Oracle BI Server
14.4.1.1
Setting the Locale on UNIX Systems
14.4.2
Understanding How the Error Message Language Is Determined
14.4.3
Setting the Language for Components of the Oracle BI Server
14.4.4
Modifying the Language of the User Interface for the Administration Tool
14.4.5
Troubleshooting the Current Locale in the Oracle BI Server
14.4.5.1
Handling the NLS Locale Not Supported Error Message
14.4.5.2
Setting the Japanese Locale on AIX Systems
14.4.6
Ensuring That Text for Oracle BI Server Utilities is Displayed in the Correct Language
14.4.7
Modifying the Metadata Repository When the Underlying Oracle Database NLS_CHARACTERSET Is Not Unicode
14.5
Localizing Metadata Names in the Repository
14.6
Supporting Multilingual Data
14.6.1
What is Multilingual Data Support?
14.6.2
What is Lookup?
14.6.3
What is Double Column Support?
14.6.4
Designing Translation Lookup Tables in a Multilingual Schema
14.6.4.1
A Lookup Table for Each Base Table
14.6.4.2
A Lookup Table for Each Translated Field
14.6.5
Creating Logical Lookup Tables and Logical Lookup Columns
14.6.5.1
Creating Logical Lookup Tables
14.6.5.2
Designating a Logical Table as a Lookup Table
14.6.5.3
About the LOOKUP Function Syntax
14.6.5.4
Creating Logical Lookup Columns
14.6.6
Creating Physical Lookup Tables and Physical Lookup Columns
14.6.7
Supporting Multilingual Data in Essbase Through Alias Tables
14.6.8
Enabling Lexicographical Sorting
15
Configuring Currency Options
15.1
Changing the Default Currency for Analyses
15.2
Defining User-Preferred Currency Options
15.2.1
Defining User-Preferred Currency Options Using a Static Mapping
15.2.2
Example: Static Mapping to Define User-Preferred Currency Options
15.2.3
Defining User-Preferred Currency Options Using a Dynamic Mapping
15.2.4
Example: Dynamic Mapping to Define User-Preferred Currency Options
16
Configuring and Managing the Oracle BI Presentation Catalog
16.1
About the Oracle BI Presentation Catalog
16.1.1
Objects in the Catalog
16.1.1.1
Guidelines for Object Names
16.1.1.2
Attribute Files for Objects
16.1.1.3
Lock Files for Objects
16.1.2
File System Guidelines for Catalogs
16.1.2.1
Handling Users of the Catalog
16.1.2.2
Handling Heterogeneous Nodes
16.1.2.3
Handling Catalog Files on Various Platforms
16.1.2.4
Known Issues with Catalog Files
16.2
Maintaining the Oracle BI Presentation Catalog
16.2.1
Manually Changing Configuration Settings for the Catalog
16.2.2
Deploying Catalogs and Objects to Production
16.2.2.1
Deploying Catalogs to Production
16.2.2.2
Deploying Objects to Production
16.2.3
Updating Catalog Objects
16.2.4
Validating the Catalog
16.2.4.1
Process: Validating the Catalog
16.2.4.2
Tasks in the Validation Process
16.2.4.3
Important Guidelines for Validating the Catalog
16.2.4.4
Performing a Basic Validation of the Catalog
16.2.4.5
Specifying the Elements for Validating the Catalog
16.3
About Catalog Manager
16.3.1
Uses for Catalog Manager
16.3.2
Guidelines for Working with Catalog Manager
16.3.3
Tips for Working with Catalog Manager
16.4
Starting Catalog Manager and Opening Catalogs
16.4.1
Requirements for Running Catalog Manager
16.4.2
Starting the Catalog Manager User Interface
16.4.3
Resolving Startup Issues on Linux Systems
16.4.4
Understanding the Two Catalog Modes
16.4.4.1
Online Mode
16.4.4.2
Offline Mode
16.4.5
Operations Available in Online Mode and Offline Mode
16.4.6
Opening an Oracle BI Presentation Catalog
16.5
Using the Catalog Manager Workspace
16.5.1
What Does the Catalog Manager Workspace Do?
16.5.2
What Does the Catalog Manager Workspace Look Like?
16.5.3
Managing the View of the Catalog Manager Workspace
16.6
Working with Objects in Catalog Manager
16.6.1
Searching for Catalog Objects Using Catalog Manager
16.6.2
Copying and Pasting Objects
16.6.2.1
Tips for Copying and Pasting
16.6.2.2
Advanced Options for Pasting Objects
16.6.3
Renaming Catalog Objects
16.6.4
Working with the Properties of Catalog Objects
16.6.5
Setting Permissions of Catalog Objects
16.6.6
Previewing Objects from Catalog Manager
16.7
Viewing and Editing Catalog Objects in XML
16.8
Searching for and Replacing Catalog Text Using Catalog Manager
16.8.1
Searching for and Replacing a Simple Catalog Text String
16.8.2
About Searching for and Replacing Multiple Catalog Text Strings
16.8.2.1
XML File Format for Searching for and Replacing Text Strings
16.8.2.2
Example XML File for Searching for and Replacing Text Strings
16.8.3
Searching for and Replacing Multiple Catalog Text Strings
16.9
Creating Reports to Display Catalog Data Using Catalog Manager
16.9.1
Sample Uses for Reports
16.10
Archiving and Unarchiving Using Catalog Manager
16.10.1
Archiving a Folder Using Catalog Manager
16.10.2
Unarchiving a Folder Using Catalog Manager
Part VI Advanced Configuration Settings
17
Configuring and Managing Analyses and Dashboards
17.1
Managing Dashboards
17.2
Performing General Configuration Tasks for Analyses
17.2.1
Increasing Heap Size to Assist in Exports to Excel
17.2.2
Manually Configuring for Export
17.2.3
Supporting Nested Folders, Navigation, and Drill-Down
17.3
Configuring for Displaying and Processing Data in Views
17.3.1
Manually Configuring for Data in Views
17.3.1.1
Manually Configuring Cube Settings for Pivot Tables and Graphs
17.3.1.2
Manually Configuring Settings for Data in Views
17.3.1.3
Manually Configuring Settings for Fetching Data for Table Views, Pivot Table Views, and Trellis Views
17.3.2
Manually Configuring for Graphs and Gauges
17.3.2.1
Configuring Fonts for Graphs
17.3.2.2
Configuring Graph and Gauge Rendering
17.3.3
Manually Changing Alternating Bar Color
17.3.4
Manually Configuring for Interactions in Views
17.4
Configuring for Prompts
17.5
Manually Changing Presentation Settings
17.5.1
Manually Changing Presentation Setting Defaults
17.5.2
Providing Custom Links in Presentation Services
17.5.2.1
Updating the customlinks.xml File
17.5.2.2
Adding the CustomLinks Element
17.5.2.3
Setting the Custom Links Privilege
17.5.3
Enabling the Ability to Create Links to Dashboard Pages
17.5.4
Configuring an Alternate Toolbar for Oracle BI Publisher
17.5.5
Enabling the Ability to Export Dashboard Pages to Oracle BI Publisher
17.5.6
Modifying the Table of Contents for PDF Versions of Briefing Books
17.5.7
Configuring a Custom Download Link for the Smart View Installer
17.6
Blocking Analyses in Answers
17.6.1
Storing JavaScript Files
17.6.2
Blocking Analyses Based on Criteria
17.6.3
Blocking Analyses Based on Formula
17.6.4
Validation Helper Functions
17.7
Specifying View Defaults for Analyses and Dashboards
17.7.1
XML Message Files for View Defaults
17.7.2
Examples of Customizing Default Values for Analyses and Dashboards
17.7.2.1
Adding a Default Header or Footer to New Analyses
17.7.2.2
Preventing Auto-Previewing of Results
17.7.2.3
Setting Defaults for Analyses in the Compound Layout
17.7.2.4
Changing Dashboards Section Defaults
17.7.2.5
Specifying Dashboard Page Defaults Including Headers and Footers
17.8
Configuring for Write Back in Analyses and Dashboards
17.8.1
How Write Back Works
17.8.2
Process for Configuring Write Back
17.8.3
Example: Process for Configuring Write Back
17.8.4
Write-Back Limitations
17.8.5
Creating Write-Back Template Files
17.8.5.1
Requirements for a Write-Back Template
17.8.5.2
Examples: Write-Back Template Files
17.8.6
Setting the LightWriteback Element
17.9
Customizing the Oracle BI Web User Interface
17.9.1
What Are Skins and Styles?
17.9.2
General Tips for Customizing the Web User Interface
17.9.3
About Style Customizations
17.9.4
Modifying the User Interface Styles for Presentation Services
17.9.4.1
Approach 1: Deploying the "bicustom.ear" File for the First Time?
17.9.4.2
Approach 1: Redeploying the "bicustom.ear" File
17.9.4.3
Approach 2: Deploying Using Shared Folders
17.9.4.4
Approach 2: Viewing Your Modifications to a Shared Folder
17.9.5
Customizing Your Style
17.9.6
Example of Modifying the Skyros Master Branding Class
17.10
Embedding External Content in Dashboards
17.11
Installing R and Oracle R Enterprise for External Logical SQL Functions
17.11.1
Installing R and R Packages
17.11.1.1
Before You Begin the Installation
17.11.1.2
Installing R and R Packages on UNIX Platforms
17.11.1.3
Installing R and R Packages on Windows
17.11.2
Installing Oracle R Enterprise and Required R Packages on the Oracle Database
17.11.2.1
Before You Begin the Installation
17.11.2.2
Installing Oracle R Enterprise and R Packages
17.11.2.3
Configuring Oracle R Enterprise to Work with Oracle BI EE
18
Configuring and Managing Agents
18.1
How Are Agents Used?
18.2
How Do Antivirus Software and Privileges Affect Agents?
18.2.1
How Does Antivirus Software Affect Agents?
18.2.2
What Privileges Affect Agents?
18.3
Configuring Settings that Affect Agents
18.3.1
Manually Configuring Presentation Services Settings that Affect Agents
18.3.2
Manually Changing Additional Scheduler Settings that Affect Agents
18.3.3
What Additional Scheduler Configuration Settings Affect Agents?
18.3.3.1
General Scheduler Configuration Settings that Affect Agents
18.3.3.2
Email Scheduler Configuration Settings that Affect Agents
18.3.3.3
Agent Scheduler Configuration Settings
18.3.4
Controlling Delivery Options for Agents
18.4
Managing Device Types for Agents
18.5
Monitoring Active Agent Sessions
19
Configuring Advanced Options for Mapping and Spatial Information
19.1
Configuring MapViewer to Support Map Views
19.2
Manually Configuring for Map Views
19.3
Inserting Text on a Map
19.4
Configuring Maps for External Consumption
20
Configuring Resource Availability and URL Generation
Part VII Managing the Life Cycle
21
Patching Oracle Business Intelligence Systems
21.1
About Patching Oracle Business Intelligence Systems
21.1.1
Where Do I Find Complete Information on Patching?
21.1.2
Updating an Existing 12
c
BI Server Installation
21.1.3
What Happens If a Patching Conflict Occurs?
21.2
What Is Patched for the Oracle Business Intelligence Platform?
21.3
Rolling Back a Platform Patch
21.4
Determining Current Patch Levels
22
Moving Oracle Business Intelligence Between Environments
22.1
Moving Between Environments
22.2
Moving to a New Environment
22.3
Upgrading from 11
g
to 12
c
22.4
Migrating the Whole Server
23
Backup and Recovery of Oracle Business Intelligence Systems
Part VIII Using Oracle Essbase With Oracle Business Intelligence
24
Introduction to Using Oracle Essbase and Associated Components in Oracle Business Intelligence
24.1
Overview
24.2
High-Level Roadmap for Working with Essbase and Associated Tools in Oracle Business Intelligence
24.3
Performing Tasks on Essbase and Associated Tools in Oracle Business Intelligence Compared to Performing the Same Tasks in EPM and Information on Which Guides to Consult
24.4
Installing Essbase and Associated Components with Oracle Business Intelligence
24.4.1
Installing Essbase
24.4.2
Selecting the Essbase Suite Option During Install
24.4.3
Limitations for Using Client Tools when Essbase Is Installed with Oracle Business Intelligence
24.4.4
Essbase Features Not Supported when Essbase Is Installed with Oracle Business Intelligence
24.5
Changing Essbase Ports in Oracle Business Intelligence
24.6
Managing Essbase System Administration in Oracle Business Intelligence
24.6.1
Starting and Stopping Essbase Components
24.6.2
Maintaining High Availability of Essbase Components in Oracle Business Intelligence
24.6.2.1
Scaling Out Essbase to Support High Availability
24.6.2.2
About the Essbase Active-Passive Topology?
24.6.2.3
Managing Essbase Capacity
24.6.3
Configuring Logging for Essbase Components
24.6.4
Configuring Logging for EPM Components
24.6.5
Migrating Essbase Configuration Between Domains
24.6.6
Monitoring Essbase Metrics
24.6.7
Backup and Recovery of Essbase Data
24.7
Working with Essbase Data in Oracle Business Intelligence
24.7.1
Enabling Single Sign-On for Essbase Data Sources
24.7.2
Creating, Scheduling, and Running Analyses and Reports Where Essbase Is the Data Source
24.7.3
Enabling Oracle BI EE to Connect to Essbase Over SSL
24.8
Where Can I Learn More Information About Essbase?
Part IX Reference Information
A
Configuration File Settings
A.1
Configuration Files
A.2
NQSConfig.INI File Configuration Settings
A.2.1
About Parameters in the NQSConfig.INI File
A.2.1.1
How to Update Parameters in NQSConfig.INI
A.2.2
Repository Section Parameters
A.2.3
Multitenancy Section Parameters
A.2.3.1
MT_ROOT_DIRECTORY
A.2.3.2
MT_ENTRIES
A.2.4
Query Result Cache Section Parameters
A.2.4.1
ENABLE
A.2.4.2
DATA_STORAGE_PATHS
A.2.4.3
MAX_ROWS_PER_CACHE_ENTRY
A.2.4.4
MAX_CACHE_ENTRY_SIZE
A.2.4.5
MAX_CACHE_ENTRIES
A.2.4.6
POPULATE_AGGREGATE_ROLLUP_HITS
A.2.4.7
USE_ADVANCED_HIT_DETECTION
A.2.4.8
MAX_SUBEXPR_SEARCH_DEPTH
A.2.4.9
DISABLE_SUBREQUEST_CACHING
A.2.4.10
CACHE_FILE_BUFFER_SIZE
A.2.4.11
GLOBAL_CACHE_STORAGE_PATH
A.2.4.12
MAX_GLOBAL_CACHE_ENTRIES
A.2.4.13
CACHE_POLL_SECONDS
A.2.4.14
CLUSTER_AWARE_CACHE_LOGGING
A.2.5
General Section Parameters
A.2.5.1
LOCALE
A.2.5.2
SORT_ORDER_LOCALE
A.2.5.3
SORT_TYPE
A.2.5.4
CASE_SENSITIVE_CHARACTER_COMPARISON
A.2.5.5
NULL_VALUES_SORT_FIRST
A.2.5.6
DATE_TIME_DISPLAY_FORMAT
A.2.5.7
DATE_DISPLAY_FORMAT
A.2.5.8
TIME_DISPLAY_FORMAT
A.2.5.9
WORK_DIRECTORY_PATHS
A.2.5.10
WORK_FILE_COMPRESSION_LEVEL
A.2.5.11
ENABLE_COLUMNAR_STORAGE_FOR_WORK_FILE
A.2.5.12
WORK_DIRECTORY_SIZE_GLOBAL_LIMIT
A.2.5.13
MAX_WORK_FILE_SIZE_PERCENT
A.2.5.14
VIRTUAL_TABLE_PAGE_SIZE
A.2.5.15
USE_LONG_MONTH_NAMES
A.2.5.16
MEMORY_COMPACT_PERIOD_IN_SECONDS
A.2.5.17
USE_LONG_DAY_NAMES
A.2.5.18
USE_UPPERCASE_MONTH_NAMES
A.2.5.19
USE_UPPERCASE_DAY_NAMES
A.2.5.20
UPPERCASE_USERNAME_FOR_INITBLOCK
A.2.6
Security Section Parameters
A.2.6.1
DEFAULT_PRIVILEGES
A.2.6.2
PROJECT_INACCESSIBLE_COLUMN_AS_NULL
A.2.6.3
IGNORE_LDAP_PWD_EXPIRY_WARNING
A.2.6.4
MAX_AUTHENTICATION_TIME
A.2.6.5
INIT_BLOCK_LOG_TIME_THRESHOLD
A.2.6.6
NUM_INIT_BLOCK_THREADS_PER_USER
A.2.6.7
SSL
A.2.6.8
SSL_CERTIFICATE_FILE
A.2.6.9
SSL_PRIVATE_KEY_FILE
A.2.6.10
SSL_PK_PASSPHRASE_FILE
A.2.6.11
SSL_PK_PASSPHRASE_PROGRAM
A.2.6.12
SSL_VERIFY_PEER
A.2.6.13
SSL_VERIFY_SERVERS
A.2.6.14
SSL_VERIFY_CLIENTS
A.2.6.15
SSL_CA_CERTIFICATE_DIR
A.2.6.16
SSL_CA_CERTIFICATE_FILE
A.2.6.17
SSL_TRUSTED_PEER_DNS
A.2.6.18
SSL_INTERNAL_CA_CERTIFICATE_FILE
A.2.6.19
SSL_INTERNAL_TRUSTED_PEER_DNS
A.2.6.20
SSL_WEBSERVER_CA_CERTIFICATE_FILE
A.2.6.21
SSL_WEBSERVER_TRUSTED_PEER_DNS
A.2.6.22
SSL_CERT_VERIFICATION_DEPTH
A.2.6.23
SSL_CIPHER_LIST
A.2.7
Server Section Parameters
A.2.7.1
READ_ONLY_MODE
A.2.7.2
MAX_SESSION_LIMIT
A.2.7.3
MAX_REQUEST_PER_SESSION_LIMIT
A.2.7.4
SERVER_THREAD_RANGE
A.2.7.5
SERVER_THREAD_STACK_SIZE
A.2.7.6
DB_GATEWAY_THREAD_RANGE
A.2.7.7
DB_GATEWAY_THREAD_STACK_SIZE
A.2.7.8
HTTP_CLIENT_THREAD_RANGE
A.2.7.9
HTTP_CLIENT_THREAD_STACK_SIZE
A.2.7.10
MAX_EXPANDED_SUBQUERY_PREDICATES
A.2.7.11
MAX_QUERY_PLAN_CACHE_ENTRIES
A.2.7.12
MAX_QUERY_PLAN_CACHE_ENTRY_SIZE
A.2.7.13
MAX_DRILLDOWN_INFO_CACHE_ENTRIES
A.2.7.14
MAX_DRILLDOWN_QUERY_CACHE_ENTRIES
A.2.7.15
INIT_BLOCK_CACHE_ENTRIES
A.2.7.16
CLIENT_MGMT_THREADS_MAX
A.2.7.17
DEFAULT_JOBQUEUE_SIZE_PER_THREAD
A.2.7.18
MAX_COLUMNS_IN_SELECT
A.2.7.19
MAX_LOGICAL_DIMENSION_TABLES
A.2.7.20
MAX_LOGICAL_FACT_TABLES
A.2.7.21
MAX_LOGICAL_MEASURES
A.2.7.22
MAX_SET_OPERATION_BLOCKS
A.2.7.23
QUERY_LIMIT_WARNING_INSTEAD_OF_ERROR
A.2.7.24
RPC_SERVICE_OR_PORT
A.2.7.25
LISTEN_ADDRESS
A.2.7.26
LISTEN_PORT
A.2.7.27
ENABLE_DB_HINTS
A.2.7.28
PREVENT_DIVIDE_BY_ZERO
A.2.7.29
CLUSTER_PARTICIPANT
A.2.7.30
REPOSITORY_PUBLISHING_DIRECTORY
A.2.7.31
REQUIRE_PUBLISHING_DIRECTORY
A.2.7.32
DISCONNECTED
A.2.7.33
AUTOMATIC_RESTART
A.2.7.34
VARIABLE_VALUE_LIMIT
A.2.7.35
EVALUATE_SUPPORT_LEVEL
A.2.7.36
FMW_SECURITY_SERVICE_URL
A.2.7.37
FMW_SECURITY_SERVICE_MAX_NUMBER_OF_CONNECTIONS
A.2.7.38
FMW_SECURITY_SERVICE_MAX_NUMBER_OF_RETRIES
A.2.7.39
ENABLE_NUMERIC_DATA_TYPE
A.2.7.40
ENDECA_SERVLET_URL
A.2.8
High Availability Parameters
A.2.8.1
HA_DB_PING_PERIOD_MILLISECS
A.2.9
Dynamic Library Section Parameters
A.2.10
Usage Tracking Section Parameters
A.2.10.1
ENABLE
A.2.10.2
DIRECT_INSERT
A.2.10.3
STORAGE_DIRECTORY
A.2.10.4
CHECKPOINT_INTERVAL_MINUTES
A.2.10.5
FILE_ROLLOVER_INTERVAL_MINUTES
A.2.10.6
CODE_PAGE
A.2.10.7
PHYSICAL_TABLE_NAME
A.2.10.8
CONNECTION_POOL
A.2.10.9
INIT_BLOCK_TABLE_NAME
A.2.10.10
INIT_BLOCK_CONNECTION_POOL
A.2.10.11
BUFFER_SIZE
A.2.10.12
BUFFER_TIME_LIMIT_SECONDS
A.2.10.13
NUM_INSERT_THREADS
A.2.10.14
MAX_INSERTS_PER_TRANSACTION
A.2.10.15
JOBQUEUE_SIZE_PER_INSERT_THREADPOOL_THREAD
A.2.10.16
THROW_INSERT_WHEN_JOBQUEUE_FULL
A.2.10.17
SUMMARY_STATISTICS_LOGGING
A.2.10.18
SUMMARY_ADVISOR_TABLE_NAME
A.2.11
Query Optimization Flags Section Parameters
A.2.11.1
STRONG_DATETIME_TYPE_CHECKING
A.2.12
MDX Member Name Cache Section Parameters
A.2.12.1
ENABLE
A.2.12.2
DATA_STORAGE_PATH
A.2.12.3
MAX_SIZE_PER_USER
A.2.12.4
MAX_MEMBER_PER_LEVEL
A.2.12.5
MAX_CACHE_SIZE
A.2.13
Aggregate Persistence Section Parameters
A.2.13.1
AGGREGATE_PREFIX
A.2.13.2
AGGREGATE_THREAD_POOL_SIZE
A.2.13.3
AGGREGATE_AW_NAME
A.2.13.4
PREAGGREGATE_AW_CUBE
A.2.13.5
SUPPORT_ANALYTICAL_WORKSPACE_TARGETS
A.2.14
JavaHost Section Parameters
A.2.14.1
JAVAHOST_HOSTNAME_OR_IP_ADDRESSES
A.2.14.2
JAVAHOST_HOSTNAME_OR_IP_ADDRESSES_OVERRIDE
A.2.15
Datamart Automation Section Parameters
A.2.15.1
ESSBASE_SERVER
A.2.15.2
DMA_DATABASE
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
BI-Specific WLST Command Reference
Scripting on this page enhances content navigation, but does not change the content in any way.