Go to main content
1/42
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.3.0)
New Features and Changes for
Oracle BI EE
12
c
(12.2.1.2.0)
New Features and Changes for
Oracle BI EE
12
c
(12.2.1.1.0)
New Features and Changes for
Oracle BI EE
12
c
(12.2.1.0)
Part I Administering Oracle Business Intelligence
1
Introduction to Oracle Business Intelligence System Administration
What Are the Oracle Business Intelligence System Administration Tasks?
Getting Started with Managing Oracle Business Intelligence
What Is the Oracle Business Intelligence System Logical Architecture?
Oracle Business Intelligence System Architecture
Oracle Business Intelligence Components
About the Administration Server, Managed Servers, and System Components
Key Directories in Oracle Business Intelligence
What System Administration Tools Manage Oracle Business Intelligence?
Fusion Middleware Control
Oracle WebLogic Server Administration Console
Process Control Commands
Oracle WebLogic Scripting Tool (WLST)
Oracle BI AdministrationTool
Catalog Manager
Job Manager
Working with the Sample Application
Oracle BI Publisher Integration
Topics of Interest in Other Guides
System Requirements and Certification
Part II Managing Processes and Components
2
Managing Oracle Business Intelligence Processes
About Managing Oracle Business Intelligence Processes
Conditions for Starting the Oracle Business Intelligence System
Using Commands to Start, Stop, and View Status of Oracle BI EE Processes
Starting Oracle Business Intelligence Component Processes in a Domain
Stopping Oracle Business Intelligence Component Processes in a Domain
Viewing the Status of Oracle Business Intelligence Components in a Domain
Using Fusion Middleware Control to Start and Stop BI System Component Processes
Using Fusion Middleware Control to Start and Stop Java Components
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
About Scaling Oracle Business Intelligence
Setting Up Shared Files and Directories
Changing the Singleton Data Directory (SDD)
Setting Up the Global Cache
Managing Capacity in Oracle Business Intelligence (Vertically Scaling)
Adding System Components
Removing System Components
Managing Availability in Oracle Business Intelligence (Horizontally Scaling)
Adding New Computers
Removing Existing Computers
Validating That Your System Has Been Scaled Correctly
Using Fusion Middleware Control to View System Component Availability
Using the Administration Console to View Managed Server Availability
4
Deploying Oracle Business Intelligence for High Availability
About
Oracle Business Intelligence
Components in a Clustered Environment
Recommendations for Availability
Using Fusion Middleware Control to Identify Single Points of Failure
Achieving High Availability Using an Active-Passive Model
Configuring Oracle Business Intelligence Components for High Availability
Optional Configuration for Oracle Business Intelligence High Availability
Setting Optional Cluster Controller Parameters
Setting Optional Presentation Services Parameters
Setting Optional Oracle BI Presentation Services Plug-in Parameters
Using the Cluster Manager
Viewing and Managing Cluster Information
Status Information
Cache Information
Session Information
Server Information
Troubleshooting a Fusion Middleware Control Clustered Environment
Avoiding Errors with Network Appliance Devices When the Oracle BI Server Is Running on Linux or UNIX
5
Managing Performance Tuning and Query Caching
Monitoring Service Levels
Using Fusion Middleware Control to View All Oracle Business Intelligence Metrics
Using the Administration Console to View Metrics for Java Components
About Query Performance Tuning
Setting Performance Parameters in Fusion Middleware Control
Using Fusion Middleware Control to Disallow RPD Updates
Using Fusion Middleware Control to Set the User Session Log-Off Period
Using Fusion Middleware Control to Set Configuration Options for Data in Tables and Pivot Tables
Using Fusion Middleware Control to Set the Maximum Number of Rows Processed to Render a Table View
About the Oracle BI Server Query Cache
Query Cache Architecture
Advantages of Caching
Costs of Caching
Disk Space
Administrative Tasks
Keeping the Cache Up To Date
CPU Usage and Disk I/O
Cache Sharing Across Users
About the Refresh Interval for XML Data Sources
About the Global Cache
Configuring Query Caching
Using Fusion Middleware Control to Enable and Disable Query Caching
Using Fusion Middleware Control to Set Query Cache Parameters
Manually Editing Additional Query Cache Parameters
Using Fusion Middleware Control to Set Global Cache Parameters
Manually Editing Additional Global Cache Parameters
Monitoring and Managing the Cache
Choosing a Cache Management Strategy
Disabling Caching for the System
Caching and Cache Persistence Timing for Specified Physical Tables
Configuring Oracle BI Server Event Polling Tables
Purging and Maintaining Cache Using ODBC Procedures
About ODBC Procedure Syntax
About Sharing the Presentation Services Query Cache
About Result Records
Storing and Purging Cache for SAP/BW Data Sources
How Repository Changes Affect the Query Cache
Strategies for Using the Cache
About Cache Hits
Ensuring Correct Cache Results When Using Row-Level Database Security
Running a Suite of Queries to Populate the Cache
Using Agents to Seed the Oracle BI Server Cache
Using the Cache Manager
Displaying Global Cache Information in the Cache Manager
Purging Cache in the Administration Tool
Cache Event Processing with an Event Polling Table
Setting Up Event Polling Tables on the Physical Databases
Making the Event Polling Table Active
Populating the Oracle BI Server Event Polling Table
Troubleshooting Problems with Event Polling Tables
Configuring the Data Source Cache
Creating a Data Source Cache on the File System
Creating a Data Source Cache on a Database
Managing the Data Source Cache
Managing the Oracle BI Presentation Services Cache Settings
Improving Oracle BI Web Client Performance
Configuring Apache HTTP Server for Static File Caching
Configuring Oracle HTTP Server for Static File Caching
Setting the JVM Heap Size for Oracle Business Intelligence
Improving Performance when Downloading Large Reports
Capturing Metrics Using the Dynamic Monitoring Service
Using the Dynamic Monitoring Service for Metrics
Using WLST Commands for Metrics
Part IV Resolving Issues
6
Diagnosing and Resolving Issues in Oracle Business Intelligence
What Diagnostic Tools Are Available?
Collecting Diagnostic Bundles
Viewing and Configuring Diagnostic Log Files
Using Fusion Middleware Control to View Log Information, Error Messages, and Alerts
Configuring Log File Rotation Policy and Specifying Log Levels
Using Fusion Middleware Control to Configure Log File Rotation Policy and Specify Log Levels
Manually Changing Additional Log File Settings
Diagnosing Issues Using the Log Viewer
Understanding Diagnostic Log Files and Log Configuration Files
What Are Diagnostic Log Files and Where Are They Located?
What Are Diagnostic Log Configuration Files and Where Are They Located?
What Are Log File Message Categories and Levels?
What is Log File Rotation?
What Messages Are Included in the System Log?
Managing the Query Log
Configuring Query Logging
Setting the Query Logging Level
Setting the Query Logging Level for a User
Using the Log Viewer
Running the Log Viewer Utility
Interpreting the Log Records
Logging in Oracle BI Server
Using the Oracle BI Presentation Services Logging Facility
Setting the Logging Levels for Oracle BI Presentation Services
Structure for the Oracle BI Presentation Services Configuration File
Examples of the Formats of Logged Messages
Oracle BI Presentation Services Message Structure
Oracle BI Presentation Services Log Filters
Diagnosing Issues with Agents
Debugging Agents Using Fusion MiddlewareControl
Manually Debugging Agents Using instanceconfig.xml
Using ODBC/JDBC Procedures to Obtain Oracle BI Server Diagnostics
About the Oracle BI Server ODBC/JDBC Procedures
Obtaining a List of Available Diagnostic Categories
Running Specific Diagnostics
About Parameters for ODBC/JDBC Procedures
Troubleshooting System Startup
Administration Server Fails to Start When the Database Is Not Running
Managed Server Is Down
Oracle BI Server Fails to Start
Cannot Log In
7
Managing Usage Tracking
About Usage Tracking
Setting Up Direct Insertion to Collect Information for Usage Tracking
Setting Up the Usage Tracking Statistics Database
Setting Direct Insertion Parameters
Setting Optional Direct Insert Parameters
Description of the Usage Tracking Data
Part V Configuring Oracle Business Intelligence
8
Using Tools for Managing and Configuring
Oracle Business Intelligence
Why Use Fusion Middleware Control and WebLogic Server Administration Console?
Managing Oracle Business Intelligence System Components Using Fusion Middleware Control
Logging into Fusion Middleware Control
Displaying Oracle Business Intelligence Pages in Fusion Middleware Control
Using the Navigation Tree in Fusion Middleware Control
Tips for Using Fusion Middleware Control with Oracle Business Intelligence
Configuring Oracle Business Intelligence System Settings
Using Fusion Middleware Control
Using a Text Editor
Using the WebLogic Scripting Tool (WLST)
Making Offline Configuration Changes
Making Online Configuration Changes
Updating the Java Development Kit (JDK)
Managing Oracle Business Intelligence Java Components Using the Oracle WebLogic Server Administration Console
9
Managing Metadata and Working with Service Instances
About Oracle Business Intelligence Application Archive (BAR) Files
What Are Oracle Business Intelligence Application Archive (BAR) Files?
What Predefined BAR Files are Available?
About Importing BAR Files
Managing Service Instances
listBIServiceInstances
getBIServiceInstance
scaleOutBIServiceInstance
export_service_instance
import_bar
refreshServiceInstance
refreshDomainServiceInstances
resetServiceInstance
10
Configuring Connections to External Systems
Configuring Email and Agents
Using Fusion Middleware Control to Configure Oracle BI Scheduler Email Settings that Affect Agents
Configuring for Actions with the Action Framework
Configuring Connections to the Marketing Content Server
Configuring Connections to Data Sources
11
Configuring Presentation Setting Defaults
Using Fusion Middleware Control to Change Presentation Setting Defaults
12
Configuring Mapping and Spatial Information
What Are the System Requirements for Map Views?
Hardware Sizing and Deployment Strategy for Maps
Sample Spatial Dataset for use with Map Views
Administering Maps
Working with Maps and Layers
Associating Layers with Columns
Ordering Layers on Maps
Changes to Spatial Metadata Require Restart
Administration Page Functions
Administering Maps Using Administration Pages
Handling the Translation of Layers in Maps
13
Configuring Time Zones
Why and Where Are Time Zones Used?
Setting Time Zones
What Is the Precedence Order for Time Zones?
User-Preferred Time Zone
Where Are Time Zone Specifications Stored?
Description of Time Zone Settings
Example: Configuration File Settings for Specifying the Time Zone
14
Localizing Oracle Business Intelligence
What Is Localization?
What Components Are Translated?
Tasks for Localizing Oracle Business Intelligence Components
Localizing Oracle BI PresentationServices
Localizing the User Interface for Oracle BI PresentationServices
Understanding the Directory Structure for Localizing Presentation Services
Localizing Messages for Users' Preferred Currency
Specifying the Default Language for the Sign-In Page
Configuring the Languages and Locales for the Sign-In Page
Specifying the Scaling of Numbers in Performance Tiles
Specifying the Language in the URL
Localizing Oracle BI Presentation Catalog Captions
Step 1: Understanding the Export Process
Step 2: Exporting Text Strings in the Catalog
Step 3: Editing Exported Strings in XML Files
Step 4: Handling Duplicate Exported Text Strings
Step 5: Exposing Text Strings in the Catalog
Tip for Arabic and Hebrew in Mozilla Firefox Browsers
Setting the Current Locale in Catalog Manager
Setting the Current Locale in the Oracle BI Server
Setting Locale Parameters on the Oracle BI Server
Setting the Locale on UNIX Systems
Understanding How the Error Message Language Is Determined
Setting the Language for Components of the Oracle BI Server
Modifying the Language of the User Interface for the
Administration Tool
Troubleshooting the Current Locale in the Oracle BI Server
Handling the NLS Locale Not Supported Error Message
Setting the Japanese Locale on AIX Systems
Ensuring That Text for Oracle BI Server Utilities is Displayed in the Correct Language
Modifying the Metadata Repository When the Underlying Oracle Database NLS_CHARACTERSET Is Not Unicode
Localizing Metadata Names in the Repository
Supporting Multilingual Data
What is Multilingual Data Support?
What is Lookup?
What is Double Column Support?
Designing Translation Lookup Tables in a Multilingual Schema
A Lookup Table for Each Base Table
A Lookup Table for Each Translated Field
Creating Logical Lookup Tables and Logical Lookup Columns
Creating Logical Lookup Tables
Designating a Logical Table as a Lookup Table
About the LOOKUP Function Syntax
Creating Logical Lookup Columns
Tips for Using Derived Logical Columns
Handling Non-ISO Type Language Codes
Creating Physical Lookup Tables and Physical Lookup Columns
Supporting Multilingual Data in Essbase Through Alias Tables
Enabling Lexicographical Sorting
15
Configuring Currency Options
Changing the Default Currency for Analyses
Defining User-Preferred Currency Options
Defining User-Preferred Currency Options Using a Static Mapping
Example: Static Mapping to Define User-Preferred Currency Options
Defining User-Preferred Currency Options Using a Dynamic Mapping
Example: Dynamic Mapping to Define User-Preferred Currency Options
16
Managing How Content is Indexed and Searched
Scheduling Regular Content Crawls of Catalog Objects
Scheduling Regular Content Crawls of Repository Content
Monitoring Search Crawl Jobs
17
Configuring and Managing the Oracle BI Presentation Catalog
About the Oracle BI Presentation Catalog
Objects in the Catalog
File System Guidelines for Catalogs
Maintaining the Oracle BI Presentation Catalog
Manually Changing Configuration Settings for the Catalog
Deploying Catalogs and Objects to Production
Deploying Catalogs to Production
Deploying Objects to Production
Updating Catalog Objects
About Catalog Manager
Starting Catalog Manager and Opening Catalogs
Requirements for Running Catalog Manager
Starting the Catalog Manager User Interface
Resolving Startup Issues on Linux Systems
Understanding the Two Catalog Modes
Operations Available in Online Mode and Offline Mode
Opening an Oracle BI Presentation Catalog
Using the Catalog Manager Workspace
What Does the Catalog Manager Workspace Do?
What Does the Catalog Manager Workspace Look Like?
Managing the View of the Catalog Manager Workspace
Working with Objects in Catalog Manager
Searching for Catalog Objects Using Catalog Manager
Copying and Pasting Objects
Tips for Copying and Pasting
Copying and Pasting Objects Between Catalogs Using Menus
Advanced Options for Pasting Objects
Paste Overwrite
Renaming Catalog Objects
Working with the Properties of Catalog Objects
Setting Permissions of Catalog Objects
Previewing Objects from Catalog Manager
Validating the Catalog Using Catalog Manager
Viewing and Editing Catalog Objects in XML
Searching for and Replacing Catalog Text Using Catalog Manager
Searching for and Replacing a Simple Catalog Text String
About Searching for and Replacing Multiple Catalog Text Strings
XML File Format for Searching for and Replacing Text Strings
Example XML File for Searching for and Replacing Text Strings
Searching for and Replacing Multiple Catalog Text Strings
Creating Reports to Display Catalog Data Using Catalog Manager
Sample Uses for Reports
Archiving and Unarchiving Using Catalog Manager
Archiving a Folder Using Catalog Manager
Unarchiving a Folder Using Catalog Manager
Part VI Advanced Configuration Settings
18
Configuring and Managing Analyses and Dashboards
Managing Dashboards
Performing General Configuration Tasks for Analyses
Increasing Heap Size to Assist in Exports to Excel
Manually Configuring for Export
Supporting Nested Folders, Navigation, and Drill-Down
Configuring for Displaying and Processing Data in Views
Manually Configuring for Data in Views
Manually Configuring Cube Settings for Pivot Tables and Graphs
Manually Configuring Settings for Data in Views
Manually Configuring Settings for Fetching Data for Table Views, Pivot Table Views, and Trellis Views
Manually Configuring for Graphs and Gauges
Configuring Fonts for Graphs
Configuring Graph and Gauge Rendering
Manually Changing Alternating Bar Color
Manually Configuring for Interactions in Views
Configuring for Prompts
Manually Changing Presentation Settings
Manually Changing Presentation Setting Defaults
Providing Custom Links in Presentation Services
Creating the customlinks.xml File
Adding the CustomLinks Element
Setting the Custom Links Privilege
Enabling the Ability to Create Links to Dashboard Pages
Configuring an Alternate Toolbar for Oracle BI Publisher
Enabling the Ability to Export Dashboard Pages to
Oracle BI Publisher
Modifying the Table of Contents for PDF Versions of Briefing Books
Configuring a Custom Download Link for the Smart View Installer
Blocking Analyses in Answers
Storing JavaScript Files
Blocking Analyses Based on Criteria
Blocking Analyses Based on Formula
Validation Helper Functions
Specifying View Defaults for Analyses and Dashboards
XML Message Files for View Defaults
Examples of Customizing Default Values for Analyses and Dashboards
Adding a Default Header or Footer to New Analyses
Preventing Auto-Previewing of Results
Setting Defaults for Analyses in the Compound Layout
Changing Dashboards Section Defaults
Specifying Dashboard Page Defaults Including Headers and Footers
Configuring for Write Back in Analyses and Dashboards
How Write Back Works
Process for Configuring Write Back
Example: Process for Configuring Write Back
Write-Back Limitations
Creating Write-Back Template Files
Setting the LightWriteback Element
Customizing the Oracle BI Web User Interface
What Are Skins and Styles?
General Tips for Customizing the Web User Interface
About Style Customizations
Modifying the User Interface Styles for Presentation Services
Approach 1: Deploying the "bicustom.ear" File for the First Time?
Approach 1: Redeploying the "bicustom.ear" File
Approach 2: Deploying Using Shared Folders
Approach 2: Viewing Your Modifications to a Shared Folder
Customizing Your Style
Example of Modifying the Skyros Master Branding Class
Embedding External Content in Dashboards
19
Configuring and Managing Agents
How Are Agents Used?
How Do Antivirus Software and Privileges Affect Agents?
Configuring Settings that Affect Agents
Manually Configuring Presentation Services Settings that Affect Agents
Manually Changing Additional Scheduler Settings that Affect Agents
What Additional Scheduler Configuration Settings Affect Agents?
General Scheduler Configuration Settings that Affect Agents
Email Scheduler Configuration Settings that Affect Agents
Agent Scheduler Configuration Settings
Controlling Delivery Options for Agents
Managing Device Types for Agents
Monitoring Active Agent Sessions
20
Configuring Advanced Options for Mapping and Spatial Information
Configuring MapViewer to Support Map Views
Manually Configuring for Map Views
Inserting Text on a Map
Configuring Maps for External Consumption
21
Configuring Resource Availability and URL Generation
Part VII Managing the Life Cycle
22
Patching Oracle Business Intelligence Systems
About Patching Oracle Business Intelligence Systems
What Is Patched for the Oracle Business Intelligence Platform?
Rolling Back a Platform Patch
Determining Current Patch Levels
23
Moving Oracle Business Intelligence Between Environments
Moving Between Environments
Moving to a New Environment
Upgrading from 11
g
to 12
c
Migrating the Whole Server
24
Backup and Recovery of Oracle Business Intelligence Systems
Part VIII Using Oracle Essbase With Oracle Business Intelligence
25
Introduction to Using Oracle Essbase in Oracle Business Intelligence
Overview
High-Level Roadmap for Working with Essbase When Installed with Oracle Business Intelligence
Performing Tasks When Essbase Is Installed with Oracle BI EE Compared to Performing the Same Tasks in EPM and Information on Which Guides to Consult
Installing Essbase with Oracle Business Intelligence
Installing Essbase
Selecting the Essbase Suite Option During Install
Limitations for Using Client Tools when Essbase Is Installed with Oracle Business Intelligence
Essbase Features Not Supported when Essbase Is Installed with Oracle Business Intelligence
Configuring Security for Essbase in Oracle Business Intelligence
Enabling Users to Perform Specific Actions in Essbase and Associated Tools
Enabling Drill-through Reports in Oracle BI EE 12.2.1.x
Configuring Data-Level Security Using Essbase Filters
What Are Essbase Filters?
Configuring Resource Permission Definitions for Essbase Filters
Securing Data Access with Essbase Filters
When Are Filter Access Permission Grant Changes Consumed?
How Do Filter Permission Grants Differ Between Oracle Business Intelligence and EPM?
Configuring Access to Essbase Calculations
What Are Essbase Calculations?
Configuring Resource Permission Definitions for Essbase Calculations
Enabling Users to Access Essbase Calculations
Changing Essbase Ports in Oracle Business Intelligence
Resource Permissions Reference for
Essbase
What Resource Types Apply to Essbase?
What Resource Names Apply to Essbase?
What Actions Apply to Essbase?
Managing Essbase System Administration in Oracle Business Intelligence
Starting and Stopping Essbase Components
Maintaining High Availability of Essbase Components in Oracle Business Intelligence
Configuring Logging for Essbase Components
Migrating Essbase Configuration Between Domains
Monitoring Essbase Metrics
Backup and Recovery of Essbase Data
Working with Essabase Data in Oracle Business Intelligence
Enabling Single Sign-On for Essbase Data Sources
Creating, Scheduling, and Running Analyses and Reports Where Essbase Is the Data Source
Enabling Oracle BI EE to Connect to Essbase Over SSL
Where Can I Learn More Information About Essbase?
Part IX Reference Information
A
Configuration File Settings
Configuration Files
NQSConfig.INI File Configuration Settings
About Parameters in the NQSConfig.INI File
How to Update Parameters in NQSConfig.INI
Repository Section Parameters
Multitenancy Section Parameters
MT_ROOT_DIRECTORY
MT_ENTRIES
Query Result Cache Section Parameters
ENABLE
DATA_STORAGE_PATHS
MAX_ROWS_PER_CACHE_ENTRY
MAX_CACHE_ENTRY_SIZE
MAX_CACHE_ENTRIES
POPULATE_AGGREGATE_ROLLUP_HITS
USE_ADVANCED_HIT_DETECTION
Reasons Why a Query Is Not Added to the Cache
MAX_SUBEXPR_SEARCH_DEPTH
DISABLE_SUBREQUEST_CACHING
CACHE_FILE_BUFFER_SIZE
GLOBAL_CACHE_STORAGE_PATH
MAX_GLOBAL_CACHE_ENTRIES
CACHE_POLL_SECONDS
CLUSTER_AWARE_CACHE_LOGGING
General Section Parameters
LOCALE
SORT_ORDER_LOCALE
SORT_ORDER_LOCALE on UNIX Operating Systems
SORT_TYPE
CASE_SENSITIVE_CHARACTER_COMPARISON
NULL_VALUES_SORT_FIRST
DATE_TIME_DISPLAY_FORMAT
How are the Date and Time Display Formats Used?
DATE_DISPLAY_FORMAT
TIME_DISPLAY_FORMAT
WORK_DIRECTORY_PATHS
WORK_FILE_COMPRESSION_LEVEL
ENABLE_COLUMNAR_STORAGE_FOR_WORK_FILE
WORK_DIRECTORY_SIZE_GLOBAL_LIMIT
MAX_WORK_FILE_SIZE_PERCENT
VIRTUAL_TABLE_PAGE_SIZE
USE_LONG_MONTH_NAMES
MEMORY_COMPACT_PERIOD_IN_SECONDS
USE_LONG_DAY_NAMES
USE_UPPERCASE_MONTH_NAMES
USE_UPPERCASE_DAY_NAMES
UPPERCASE_USERNAME_FOR_INITBLOCK
Security Section Parameters
DEFAULT_PRIVILEGES
PROJECT_INACCESSIBLE_COLUMN_AS_NULL
IGNORE_LDAP_PWD_EXPIRY_WARNING
MAX_AUTHENTICATION_TIME
INIT_BLOCK_LOG_TIME_THRESHOLD
NUM_INIT_BLOCK_THREADS_PER_USER
SSL
SSL_CERTIFICATE_FILE
SSL_PRIVATE_KEY_FILE
SSL_PK_PASSPHRASE_FILE
SSL_PK_PASSPHRASE_PROGRAM
SSL_VERIFY_PEER
SSL_VERIFY_SERVERS
SSL_VERIFY_CLIENTS
SSL_CA_CERTIFICATE_DIR
SSL_CA_CERTIFICATE_FILE
SSL_TRUSTED_PEER_DNS
SSL_INTERNAL_CA_CERTIFICATE_FILE
SSL_INTERNAL_TRUSTED_PEER_DNS
SSL_WEBSERVER_CA_CERTIFICATE_FILE
SSL_WEBSERVER_TRUSTED_PEER_DNS
SSL_CERT_VERIFICATION_DEPTH
SSL_CIPHER_LIST
Server Section Parameters
READ_ONLY_MODE
MAX_SESSION_LIMIT
About the MAX_SESSION_LIMIT and SERVER_THREAD_RANGE Parameters
MAX_REQUEST_PER_SESSION_LIMIT
SERVER_THREAD_RANGE
SERVER_THREAD_STACK_SIZE
DB_GATEWAY_THREAD_RANGE
DB_GATEWAY_THREAD_STACK_SIZE
HTTP_CLIENT_THREAD_RANGE
HTTP_CLIENT_THREAD_STACK_SIZE
MAX_EXPANDED_SUBQUERY_PREDICATES
MAX_QUERY_PLAN_CACHE_ENTRIES
MAX_QUERY_PLAN_CACHE_ENTRY_SIZE
MAX_DRILLDOWN_INFO_CACHE_ENTRIES
MAX_DRILLDOWN_QUERY_CACHE_ENTRIES
INIT_BLOCK_CACHE_ENTRIES
CLIENT_MGMT_THREADS_MAX
DEFAULT_JOBQUEUE_SIZE_PER_THREAD
MAX_COLUMNS_IN_SELECT
MAX_LOGICAL_DIMENSION_TABLES
MAX_LOGICAL_FACT_TABLES
MAX_LOGICAL_MEASURES
MAX_SET_OPERATION_BLOCKS
QUERY_LIMIT_WARNING_INSTEAD_OF_ERROR
RPC_SERVICE_OR_PORT
LISTEN_ADDRESS
LISTEN_PORT
ENABLE_DB_HINTS
PREVENT_DIVIDE_BY_ZERO
CLUSTER_PARTICIPANT
DISCONNECTED
AUTOMATIC_RESTART
VARIABLE_VALUE_LIMIT
EVALUATE_SUPPORT_LEVEL
FMW_SECURITY_SERVICE_URL
FMW_SECURITY_SERVICE_MAX_NUMBER_OF_CONNECTIONS
FMW_SECURITY_SERVICE_MAX_NUMBER_OF_RETRIES
ENABLE_NUMERIC_DATA_TYPE
ENDECA_SERVLET_URL
High Availability Parameters
HA_DB_PING_PERIOD_MILLISECS
Dynamic Library Section Parameters
Usage Tracking Section Parameters
ENABLE
DIRECT_INSERT
STORAGE_DIRECTORY
CHECKPOINT_INTERVAL_MINUTES
FILE_ROLLOVER_INTERVAL_MINUTES
CODE_PAGE
PHYSICAL_TABLE_NAME
CONNECTION_POOL
INIT_BLOCK_TABLE_NAME
INIT_BLOCK_CONNECTION_POOL
BUFFER_SIZE
BUFFER_TIME_LIMIT_SECONDS
NUM_INSERT_THREADS
MAX_INSERTS_PER_TRANSACTION
JOBQUEUE_SIZE_PER_INSERT_THREADPOOL_THREAD
THROW_INSERT_WHEN_JOBQUEUE_FULL
SUMMARY_STATISTICS_LOGGING
SUMMARY_ADVISOR_TABLE_NAME
Query Optimization Flags Section Parameters
STRONG_DATETIME_TYPE_CHECKING
MDX Member Name Cache Section Parameters
ENABLE
DATA_STORAGE_PATH
MAX_SIZE_PER_USER
MAX_MEMBER_PER_LEVEL
MAX_CACHE_SIZE
Aggregate Persistence Section Parameters
AGGREGATE_PREFIX
AGGREGATE_THREAD_POOL_SIZE
AGGREGATE_AW_NAME
PREAGGREGATE_AW_CUBE
SUPPORT_ANALYTICAL_WORKSPACE_TARGETS
JavaHost Section Parameters
JAVAHOST_HOSTNAME_OR_IP_ADDRESSES
JAVAHOST_HOSTNAME_OR_IP_ADDRESSES_OVERRIDE
Datamart Automation Section Parameters
ESSBASE_SERVER
DMA_DATABASE
B
Advanced Configuration Reference
Making Advanced Configuration Changes for Presentation Services
Protecting Pages in Oracle BI EE from Attack
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.