Skip Headers
Oracle® Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition
11g Release 1 (11.1.1)

Part Number E10541-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Z 

A

action framework, 11.2
adapters, relational data source, 1.7
Admin MBeans, 1.3.4
Administration Server
confirming whether running, 4.6
defined, 1.3.4
starting and stopping, 4.2, 4.7
Administration Tool
using to manage clustered system components, 6.4
using to purge cache, 7.7.4.2
agents
antivirus software, 19.2.1
configuring email settings for, 11.1.1
definition of, 19.1
delivery options for, 19.3.4
e-mail Scheduler configuration settings, 19.3.3.2
general Scheduler configuration settings, 19.3.3.1
KeepErrorLogFiles configuration element, 19.3.3.3
log directory, viewing entries, 8.5.6, 8.5.6
log file location, 19.3.3.3
Log_Dir configuration element, 19.3.3.3
LogPurgeDays configuration element, 19.3.3.3
managing device types, 19.4
manually configuring settings, 19.3.1
MaxDeliverySleepSecs configuration element, 19.3.3.3
MaxGlobalSleepSecs configuration element, 19.3.3.3
MaxRequestSleepSecs configuration element, 19.3.3.3
MaxRowsTimesColumns configuration element, 19.3.3.3
MinDeliverySleepSecs configuration element, 19.3.3.3
MinGlobalSleepSecs configuration element, 19.3.3.3
MinRequestSleepSecs configuration element, 19.3.3.3
number connection attempts, 19.3.3.3
number delivery attempts, 19.3.3.3
NumDeliveryRetries configuration element, 19.3.3.3
NumGlobalReTries configuration element, 19.3.3.3
NumRequestRetries configuration element, 19.3.3.3
permission settings, 19.2.2
Scheduler configuration settings, 19.3.3.3, 19.3.3.3
seeding server cache, 7.7.3
sleep time, 19.3.3.3, 19.3.3.3
using to seed cache, 7.7.3
viewing information about active sessions, 19.5
aggregate tables, using, 7.2
AllowedLanguages configuration element, 15.2.1.4
AllowedLocales configuration element, 15.2.1.4
AllowRememberPassword configuration element, B.1
alternating bars, changing color, 18.3.3
alternative methods for starting and stopping system components, 4.5
AlwaysKeepSessionAffiliation configuration parameter, 6.3.3
ampersand in time zone values, 14.4.1
analyses
blocking, 18.6, 18.6
default currency, 16.1
default header and footer, 18.7.2.1
general configuration tasks, 18.2
navigation and drill down, 18.2.2
unattended time, B.1
view defaults, 18.7, 18.7
API, Oracle BI Systems Management, 22.3.3
application, sample, 1.5
archiving
catalog folders, 17.10
objects, 17.2.3
Presentation Catalog, 17.10
attack on web pages, B.1.1
attribute files, 17.1.1.2

B

backup and recovery, 25
bars, changing color for alternating bars, 18.3.3
BI domain, definition of, 1.3.1.1
BI Publisher, configuring toolbar, 18.5.4
biee_domain.xml, disabling Fusion Middleware Control from managing configuration settings, D.1
blocking analyses, 18.6, 18.6
briefing books, table of contents, 18.5.5
BulkFetchBufferSize (bytes) configuration element, 19.3.3.1

C

CACertificateDir configuration element, 19.3.3.1
CACertificateFile configuration element, 19.3.3.1
cache
about hits, 7.7.1
administering, 7.9
attributes for physical tables, 7.6.1.2
configuring event polling tables, 7.6.1.3
displaying global cache information, 7.7.4.1
effects of repository changes on, 7.6.3
enabling and disabling, 7.5.1
in a clustered environment, 7.4.6
managing settings, 7.9
monitoring and managing, 7.6
persistence time setting, 7.6.1.2
purging using Administration Tool, 7.7.4.2
purging using ODBC procedures, 7.6.2
purging when switching between repositories, 7.6.3.3
reasons for disabling, 7.6.1.1
seeding with a suite of queries, 7.7.2
seeding with agents, 7.7.3
setting max entry size, 7.5.2
setting max number of entries, 7.5.2
strategies, 7.7
using event polling tables, 7.8
using the Cache Manager, 7.7.4
using with row-level database security, 7.7.1.1
viewing information in Cluster Manager, 6.4.1.2
Cache Manager
about and opening, 7.7.4
displaying global cache information, 7.7.4.1
purging cache, 7.7.4.2
using, 7.7.4
capacity, managing, 5
captions, localizing for Presentation Catalog, 17.9
catalog folders
archiving, 17.10
unarchiving, 17.10
Catalog Manager
about, 17.3
archiving a Presentation Catalog, 17.10
components of, 17.5.2
copying and pasting items between Presentation Catalogs, 17.6.2
creating reports to display Presentation Catalog data, 17.9
localizing Presentation Catalog captions, 17.9
localizing Presentation Catalog text strings, 15.2.2
opening a Presentation Catalog, 17.4.6
previewing objects, 17.6.6
recommendations for working with, 17.3.2
renaming items, 17.6.3
searching for and replacing Presentation Catalog text, 17.8
searching for Presentation Catalog items, 17.6.1
setting permissions of items, 17.6.5
starting, 17.4
unarchiving a Presentation Catalog, 17.10
viewing and editing objects in XML, 17.7
working with item properties, 17.6.4
workspace, 17.5
catalogs
file system guidelines, 17.1.3
validating, 17.2.5
centrally managing
Java components using WebLogic Server administration console, 2.3
Oracle Business Intelligence using Fusion Middleware Control, 2.2
CertificateFileName configuration element, 19.3.3.1
CertificateVerifyDepth configuration element, 19.3.3.1
certification information, 1.8
CertPrivateKeyFileName configuration element, 19.3.3.1
change/delete permission, 19.2.2
checkpoints for usage tracking, 9.3.4
CipherList configuration element, 19.3.3.1
clickjacking, B.1.1
client sessions, expiration time, 7.3.2
cluster
about components in, 6.1
configuring for, 6.3
managing with Fusion Middleware Control, 6.2.1
shared files and directories, 5.4
shared Oracle BI Presentation Catalog, 5.4.2
shared repository publishing directory, 5.4.1
troubleshooting, 6.5
viewing and managing using Cluster Manager, 6.4.1
Cluster Controller, configuring primary and secondary, 6.1.2
Cluster Manager
See also Cluster Server
about, 6.4
accessing when components are stopped, 6.4
activating Oracle BI Scheduler instances, 6.4
managing clustered servers, 6.4.1.3
viewing and managing cluster information, 6.4.1
viewing cache information, 6.4.1.2
viewing session information, 6.4.1.3
Cluster Server
See also Cluster Manager
viewing cache information, 6.4.1.2
ColocatedOracleMapViewerContextPath configuration element, 20.2
colors, changing alternating bar color, 18.3.3
comments and status overrides, configuring, 1.7
components
Catalog Manager, 17.5.2
Java and system, 1.3.3
Compound Layout default views, 18.7.2.3
concurrent connections, maximum number, 19.3.3.1
configuration
alternate BI Publisher toolbar, 18.5.4
cache, accessing, 7.9
changes for Presentation Services, B.1
default language, specifying for login screen, 15.2.1.3
file location, 3.6
general tasks for analyses, 18.2
graphs and gauges, 18.3.2
instanceconfig.xml file, B.1
JavaHost service, B.2
map views, 20
marketing content server, 11.4, 11.4.2
tables and pivot tables, 7.3.3, 12.1
time zones, 14.5
URL generation and resource file location, 21
configuration settings
disabling Fusion Middleware Control from managing, D.1
methods for updating, 3.1
updating using a text editor, 3.4
updating using Fusion Middleware Control, 3.2
updating using Java program with Oracle BI Systems Management API, 22.3.3.2
updating using MBean Browser, 3.5
updating using Oracle BI Systems Management API, 3.3, 22.3.3
updating using WLST with Oracle BI Systems Management API, 22.3.3.1
ControllerPollSeconds configuration parameter, 6.3.1
CookieDomain configuration element, B.1
CookiePath configuration element, B.1
cookies, B.1
copying and pasting content between catalogs, 17.6.2
copyright text on maps, 20.3
creating
device types, 19.4
reports to display Presentation Catalog data, 17.9
CubeMaxPopulatedCells configuration element, 18.3.1.1
CubeMaxRecords configuration element, 18.3.1.1
currency
customized subject areas, 16.1
default for analyses, 16.1
user-preferred options, 16.2

D

dashboards
headers and footers, 18.7.2.5
links to page, 18.5.3
managing, 18.1
page defaults, 18.7.2.5
section defaults, 18.7.2.4, 18.7.2.4
view defaults, 18.7, 18.7
data sources, setting up, 1.7
DATA_STORAGE_PATHS configuration parameter, 7.5.3
database, back-end
bulk fetch buffer size, 19.3.3.1
job script path, 19.3.3.1
maximum concurrent connections field, 19.3.3.1
purging, 19.3.3.1
timeout specification, 19.3.3.1
tuning and indexing, 7.2
databases supported, 1.8
DDL, Dynamic Library section parameters, A.8
default RPD, viewing, 10.2
DefaultName configuration element, 18.5.1
DefaultRowsDisplayed configuration element, 18.3.1.2
DefaultScriptPath configuration element, 5.4.4, 19.3.3.1
deleting device types, 19.4
delivery devices, 19.3.4
delivery profiles, 19.3.4
descriptions for repository objects, externalizing for localization, 15.5
diagnostics
introduction, 8
log configuration file format example for BI Server, 8.3.2
log configuration file format example for JavaHost Server, 8.3.2
log configuration file settings, 8.3.2
log configuration files location, 8.3.2
log files, 8.2.1
log files location, 8.3.1
dictionary, metadata, 18.2.1, 18.2.1
disabling Fusion Middleware Control from managing configuration settings, D.1
display names for repository objects, externalizing for localization, 15.5
double column support, associating a descriptor ID column and descriptor column, 15.6.3
drill down, adding support for, 18.2.2
DSN, Presentation Services, B.1
Dynamic Library section (NQSConfig.INI file)
parameters, about, A.8

E

ECID, viewing log information, 8.2.1
editing device types, 19.4
embedded fonts, 18.3.2.1.1
embedded maps in pages, 20.4
EmbedFonts configuration element, 18.3.2
EnableBookmarkURL configuration element, 18.5.3
EnablePromptedURL configuration element, 18.5.3
event polling tables
about, 7.6.1.3, 7.8
column names, 7.8.1
configuring, 7.6.1.3
making active, 7.8.2
populating, 7.8.3
setting up, 7.8.1
troubleshooting, 7.8.4
exchanging metadata, 1.7
exporting Presentation Catalog text strings, 15.2.2.2
exposing Presentation Catalog text strings, 15.2.2.5
Externalize Strings utility, using, 15.5

F

failover, configuring for, 6.3
FlashCLSID configuration element, 18.3.2
FlashCodeBase configuration element, 18.3.2
folders, archiving and unarchiving, 17.10
fonts, embedded, 18.3.2.1.1
footer for analyses, 18.7.2.1
frame busting, B.1.1
framework, actions, 11.2
Fusion Middleware Control
MBean Browser, 2.4.2
navigation tree, 2.2.5
starting and stopping system and Java components, 4.3
starting to centrally manage Oracle Business Intelligence, 2.2.2
tool to monitor and configure system components, 1.4.1
user interface labels mapped to configuration file elements, C
using to centrally manage Oracle Business Intelligence, 2.2
using to configure the connection to the marketing content server, 11.4.1
using to update configuration settings, 3.2
WebLogic Server, 2.1

G

gauge views, configuring, 18.3.2
General section parameters (NQSConfig.INI file)
about, A.4
AGGREGATE_PREFIX, A.12.1
CASE_SENSITIVE_CHARACTER_COMPARISON, A.4.4
DATE_DISPLAY_FORMAT, A.4.7
DATE_TIME_DISPLAY_FORMAT, A.4.6
LOCALE, A.4.1
NULL_VALUES_SORT_FIRST, A.4.5
SORT_ORDER_LOCALE, A.4.2
SORT_ORDER_LOCALE on UNIX, A.4.2.1
SORT_TYPE, A.4.3
TIME_DISPLAY_FORMAT, A.4.8
UPPERCASE_USERNAME_FOR_INITBLOCK, A.4.13
VIRTUAL_TABLE_PAGE_SIZE, A.4.10
WORK_DIRECTORY_PATHS, A.4.9
global cache
about, 7.4.6
configuring, 7.5.4, 7.5.5
displaying information in Cache Manager, 7.7.4.1
setting up a network share for, 5.4.3
graph views
common settings, 18.3.1.2
configuring, 18.3.2
cube settings, 18.3.1.1
fonts, 18.3.2.1.1
green bar styling, 18.3.3
guidelines
for Catalog Manager, 17.3.2
for catalogs, 17.1.3
for object names, 17.1.1.1

H

header for analyses, 18.7.2.1
high availability
deploying Oracle Business Intelligence for, 6
deployment diagram, 6.1
eliminating single points of failure, 6.1.2
managing using Fusion Middleware Control, 6.2.1
horizontal scaling
about, 5.1
performing steps for, 5.3

I

i1012980
Sect1
Understanding the User Log, 8.4
i1013009
Sect3
Choosing a Logging Level, 8.4.1.1
InIFrameRenderingMode configuration element, B.1.1
inline frames, B.1.1
installing and upgrading, 1.7
instanceconfig.xml file
for Oracle BI Scheduler, 5.4.4
for Presentation Services, B.1

J

Java components
definition of, 1.3.1.1, 1.3.3.1
in a clustered environment, 6.1
listed, 1.3.3
managing using WebLogic server administration console, 1.4.2
monitoring and starting and stopping using Fusion Middleware Control, 2.2.4
Java program, using with Oracle BI Systems Management API to update configuration settings, 22.3.3.2
JavaHost
diagnostic log configuration file format example, 8.3.2
service, B.2
JavaHostProxy configuration parameter, 6.3.2
JavaHostReadLimitInKB configuration element, 18.3.1.2
JavaScript files, 18.6.1
JMX MBeans
container, 1.3.4
using the MBean Browser to manage, 2.4
Job Manager Configuration dialog box
accessing, 19.3.2
agents tab fields, 19.3.3.3
role of, 19.3.2
Scheduler Tab fields, 19.3.3.1
job scripts path, 19.3.3.1

K

KeepErrorLogFiles configuration element, 19.3.3.3

L

languages, default language, specifying for login screen, 15.2.1.3
links to dashboard pages, 18.5.3
listen address, setting, 5.5
localization
of repository metadata, 15.5
setting the Japanese locale on AIX systems, 15.4.5.2
SORT_ORDER_LOCALE settings on UNIX systems, 15.4
location
BI configuration files, 3.6
Presentation Catalog, 17.1
lock files, 17.1.1.3
locking mechanism for multiple concurrent administrators, 2.1
log files
See also query log, administering
agent log directory, viewing entries, 8.5.6
configuration file location, 8.3.2
levels, 8.3.3
manually configuring rotation policy, 8.2.2.2
message categories, 8.3.3
messages in, 8.5.4
Presentation Services, 8.5
rotation, 8.2.2.1, 8.3.4
viewing in Fusion Middleware Control, 8.2.1
log viewer utility
about, 8.4.2
interpreting log records, 8.4.2.2
running, 8.4.2.1
Log_Dir configuration element, 19.3.3.3
LogAllSqlStmts configuration element, 19.3.3.1
logging levels
configuring using Fusion Middleware Control, 8.2.2.1
described, 8.4.1.1
enabling for individual users, 8.4.1.1
log viewer utility, 8.4.2, 8.4.2.2
manually configuring, 8.2.2.2
overriding with session variable, 8.4.1.1
user logging levels, 8.4.1.2, 8.4.1.2
logical architecture for Oracle Business Intelligence, 1.3
login screen, specifying default language, 15.2.1.3
LogPurgeDays configuration element, 19.3.3.3
lookup
creating logical lookup columns, 15.6.5.4
creating logical lookup tables, 15.6.5.1
designating a logical table as a lookup table, 15.6.5.2
designing translation lookup tables in a mls schema, 15.6.4
function syntax, 15.6.5.3

M

Managed Server, 1.3.4
confirming whether running, 4.8.1
definition of, 1.3.1.1
guidelines for scaling, 5.1.2
in a clustered environment, 6.1
scaling horizontally, 5.3
starting and stopping on Windows and UNIX, 4.8
manually starting the Oracle Business Intelligence system, 4.2
map views
configuring, 20
configuring manually, 20.2
configuring MapViewer, 20.1
embedded in pages, 20.4
hardware requirements, 13.2
inserting text, 20.3
system requirements, 13.1
translating layers, 13.3.4
mapping configuration file elements with corresponding Fusion Middleware Control user interface labels, C
MapViewer configuration, 20.1
marketing content server
configuring the connection to, 11.4, 11.4.2
using Fusion Middleware Control to configure the connection to, 11.4.1
Master BI Server, viewing in Cluster Manager, 6.4.1.1
MAX_ROWS_PER_CACHE_ENTRY configuration parameter, 7.5.3
MaxAgeMinutes configuration element, 18.5.3
MaxCells configuration element, 18.3.1.2
MaxDeliverySleepSecs configuration element, 19.3.3.3
MaxDropDownValues configuration element, 18.5.1
MaxEntries configuration element, 7.9
MaxExecThreads configuration element, 19.3.3.1
MaxExpireMinutes configuration element, 7.9
MaxFollowLinks configuration element, 18.5.1
MaxGlobalSleepSecs configuration element, 19.3.3.3
MaxRecords configuration element, 20.2
MaxRequestSleepSecs configuration element, 19.3.3.3
MaxRowsTimesColumns configuration element, 19.3.3.3
MaxVisibleColumns configuration element, 18.3.1.2
MaxVisiblePages configuration element, 18.3.1.2
MaxVisibleRows configuration element, 18.3.1.2
MaxVisibleSections configuration element, 18.3.1.2
MBean Browser
updating configuration settings, 3.5
using to manage Oracle Business Intelligence, 2.4
MDX Member Name Cache section parameters (NQSConfig.INI file)
DATA_STORAGE_PATH, A.11.2
ENABLE, A.11.1
MAX_MEMBER_PER_LEVEL, A.11.4
MAX_SIZE_PER_USER, A.11.3
memory requirements, 1.8
messages in log files, 8.5.4
metadata
exchanging, 1.7
importing into IBM DB2 or Oracle Database, 1.7
metadata dictionary, 18.2.1, 18.2.1
metrics, viewing, 7.1.1
migrating to a new environment, 24
migration, whole server, 24
MinDeliverySleepSecs configuration element, 19.3.3.3
MinExecThreads configuration element, 19.3.3.1
MinExpireMinutes configuration element, 7.9
MinGlobalSleepSecs configuration element, 19.3.3.3
minimum disk space, 1.8
MinRequestSleepSecs configuration element, 19.3.3.3
MinUserExpireMinutes configuration element, 7.9
modes for opening catalogs, 17.4.4
monitoring system metrics, 7.1
multilingual data support, 15.6.1
multilingual support, lookup, 15.6.2
multiple host logical architecture, 1.3.2

N

navigation tree in Fusion Middleware Control, 2.2.5
navigation, adding support for in analyses, 18.2.2
node manager
daemon process, 1.3.1.1
starting on Windows and UNIX, 4.2.2
nQLogViewer utility, interpreting log records, 8.4.2.2
NQSConfig.INI file
comments, adding, A.1
configuration file parameter entries, rules for, A.1
configuring parameters for clustering, load balancing, and failover, 7.5.5
Dynamic Library section parameters, A.8
General section, about, A.4
Optimization Flags section parameters, A.10
parameters and syntax, about, A
parsing rules, A.1
Query Result Cache section, parameters, A.3
Repository section parameters, A.2
security section parameters, A.5
Server section parameters, A.6
Usage Tracking section parameters, A.9
NumDBConnections configuration element, 19.3.3.1
NumDeliveryRetries configuration element, 19.3.3.3
NumGlobalReTries configuration element, 19.3.3.3
NumRequestRetries configuration element, 19.3.3.3

O

object names, guidelines for, 17.1.1.1
objects
attribute files for, 17.1.1.2
committing to production, 17.2.3
guidelines for names, 17.1.1.1
lockfiles for, 17.1.1.3
previewing in Catalog Manager, 17.6.6
searching for, 17.6.1
viewing and editing in XML, 17.7
working with properties, 17.6.4
ODBC procedures
about syntax for, 7.6.2.1
for Presentation Services shared request key, 7.6.2.2
for purging cache, 7.6.2
for purging SAP/BW data sources, 7.6.2.4
offline mode for opening catalogs, 17.4.4
online mode for opening catalogs, 17.4.4
opening catalogs, 17.4.4
operating systems, supported, 1.8
OPMN
about, 1.4.3
definition of, 1.3.1.1
using opmnctl command line to start and stop System components, 4.5.1
Optimization Flags section parameters (NQSConfig.INI file)
parameters, about, A.10
STRONG_DATETIME_TYPE_CHECKING, A.10.1
options, delivery for agents, 19.3.4
Oracle BI Catalog Manager
See Catalog Manager
Oracle BI Dashboards
See dashboards
Oracle BI Presentation Services Plug-in, configuring for high availability, 6.3.3
Oracle BI repository
disallowing updates, 7.3.1
localizing repository metadata, 15.5
metadata dictionary, 18.2.1
repository publishing directory, 5.4.1
restarting Oracle BI processes, 4.1
sharing, 10.2
specifying password for, 10.2
understanding version numbers, 10.1.2
uploading using Fusion Middleware Control, 10.2
uploading using System MBeans, 10.3
Oracle BI Server
diagnostic log configuration file format example, 8.3.2
loading repository, 10.2
viewing sessions in Cluster Manager, 6.4.1.3
Windows, starting or restarting, 4.5.2
Oracle BI Systems Management API
accessing API methods, 22.2
JMX Admin MBeans and Methods, 22.4
purpose of, 22.1
using to manage and configure Oracle Business Intelligence, 22.3
using to programmatically start and stop Oracle Business Intelligence, 4.5.3
using to scale out for high availability and performance, 22.3.4
using to start and stop Oracle Business Intelligence, 22.3.2
using to update configuration settings, 3.3, 22.3.3, 22.3.3
Oracle Business Intelligence
deploying for high availability, 6
logical architecture explained, 1.3
scaling, 5
Oracle Scorecard and Strategy Management, configuring comments and status overrides for, 1.7
Oracle WebLogic Server Admin Console, starting and stopping Java components, 4.4

P

PassphraseFileName configuration element, 19.3.3.1
password
remembering, B.1
specifying for repository upon upload, 10.2
pasting items between Presentation Catalogs, 17.6.2
patching
about, 23
components, 23.1
determining current patch levels, 23.4
platform patches, 23.2
rolling back a patch, 23.3
PauseOnStartup configuration element, 19.3.3.1
PERF_PREFER_IN_LISTS database feature, 7.8.1
performance
about managing, 7.2
disallowing repository updates, 7.3.1
for web client, 7.10
setting up static file caching, 7.10
tuning and indexing data sources, 7.2
using aggregate tables, 7.2
viewing metrics, 7.1.1
permissions
setting for items, 17.6.5
setting in Catalog Manager, 17.6.5
settings for agents, 19.2.2
pivot table views
common settings, 18.3.1.2
configuration, 7.3.3, 12.1
cube settings, 18.3.1.1
platforms, supported, 1.8
PoolTimeout (minutes) configuration element, 19.3.3.1
POPULATE_AGGREGATE_ROLLUP_HITS configuration parameter, 7.5.3
ports
specifying, 5.5
viewing, 5.6.1
precedence order for time zones, 14.3
Presentation Catalog
about, 17.1
administering, 17.3, 17.6.4
archiving, 17.10
Catalog Manager workspace, about, 17.5
Catalog Manager, setting permissions through, 17.6.5
Catalog Manager, starting, 17.4
committing an object to production, 17.2.3
configuring for a full text search, 17.11
copying and pasting objects between, 17.6.2
creating new, 17.2.2
creating reports to display data, 17.9
exporting text strings for, 15.2.2.2
exposing text strings for, 15.2.2.5
localizing captions for, 17.9
location of, 17.1
maintaining manually, 17.2
maintaining using Fusion Middleware Control, 17.2
manually changing additional configuration settings for, 17.2.1
manually creating a new one, 17.2.2
modes for opening in Catalog Manager, 17.4.4
opening, 17.4.4
recommendations for working with, 17.3.2
rename items, about using Catalog Manager to, 17.6.3
replicating, 17.12
searching for and replacing text, 17.8
setting object permissions, 17.6.5
setting permissions of objects, 17.6.5
setting up a network share for, 5.4.2
specifying shared location for, 10.2
unarchiving, 17.10
viewing and editing objects in XML, 17.7
Presentation Services
cache, 7.9
configuring for high availability, 6.3.2
log message structure, 8.5.4
logging in, 8.5
query cache, 7.6.2.2
Replication Agent, 17.12.4
specifying default language, for login screen, 15.2.1.3
previewing objects from Catalog Manager, 17.6.6
production, committing objects to, 17.2.3
programmatically starting and stopping Oracle Business Intelligence using the Oracle BI Systems Management API, 4.5.3
properties of catalog objects, 17.6.4
publish agents for Subscription privilege, 19.2.2
PurgeInstDays configuration element, 19.3.3.1
PurgeIntervalMinutes configuration element, 19.3.3.1
purging cache
for SAP/BW data sources, 7.6.2.4
result records, 7.6.2.3
using Administration Tool, 7.7.4.2
using ODBC procedures, 7.6.2
when switching between repositories, 7.6.3.3

Q

query caching
about hits, 7.7.1
advantages of, 7.4.2
attributes for physical tables, 7.6.1.2
cache strategies, 7.7
configuring event polling tables, 7.6.1.3
cost of caching, about, 7.4.3
displaying global cache information, 7.7.4.1
effects of repository changes on, 7.6.3
enabling and disabling, 7.5.1
monitoring and managing, 7.6
Presentation Services query cache, 7.6.2.2
purging using Administration Tool, 7.7.4.2
purging using ODBC procedures, 7.6.2
purging when switching between repositories, 7.6.3.3
reasons for disabling, 7.6.1.1
refresh interval, setting for XML data sources, 7.4.5
seeding with a suite of queries, 7.7.2
seeding with agents, 7.7.3
setting max entry size, 7.5.2
setting max number of entries, 7.5.2
using event polling tables, 7.8
using the Cache Manager, 7.7.4
using with row-level database security, 7.7.1.1
query environment, administering
query logs, administering, 8.4
usage tracking, administering, 9.1
query logs
administering, 8.4
configuring, 8.4.1
disabling user logging levels, 8.4.1.2
interpreting the log records, 8.4.2.2
log viewer utility, 8.4.2
logging levels, 8.4.1.1
setting logging levels, 8.4.1.1
setting user logging levels, 8.4.1.2
Query Result Cache section parameters (NQSConfig.INI file), A.3
CACHE_POLL_SECONDS, A.3.12
CLUSTER_AWARE_CACHE_LOGGING, A.3.13
DATA_STORAGE_PATHS, A.3.2
ENABLE, A.3.1
GLOBAL_CACHE_STORAGE_PATH, A.3.10
MAX_CACHE_ENTRIES, A.3.5
MAX_CACHE_ENTRY_SIZE, A.3.4
MAX_GLOBAL_CACHE_ENTRIES, A.3.11
MAX_ROWS_PER_CACHE_ENTRY, A.3.3
MAX_SUBEXPR_SEARCH_DEPTH, A.3.8
POPULATE_AGGREGATE_ROLLUP_HITS, A.3.6
USE_ADVANCED_HIT_DETECTION, A.3.7

R

recovery and backup, 25
refresh interval, setting for XML data sources, 7.4.5
relational data source adapters, 1.7
RemoteOracleMapViewerAbsoluteURL configuration element, 20.2
renaming items
about, 17.6.3
with reference updates, 17.6.3
without reference updates, 17.6.3
replacing Presentation Catalog text, 17.8
replication
catalogs, 17.12
Oracle BI Presentation Services Replication Agent, 17.12.4
resuming, 17.12.7
sawrepaj utility, 17.12.4
repository file, disallowing updates, 7.3.1
repository publishing directory, setting up a network share for, 5.4.1
Repository section parameters (NQSConfig.INI file), A.2
repository variables, cache purging considerations, 7.6.3.4
requirements, system, 1.8
resource files, location, 21
result records, for purging cache, 7.6.2.3
resuming replication, 17.12.7
rollover, described, 9.3.4
row-level database security, ensuring correct cache results with, 7.7.1.1

S

SA System subject area, delivery options, 19.3.4
sample application, 1.5
sawrepaj utility, 17.12.4
scaling your system
about, 5.1
performing steps for, 5.3
recommendations, 5.1.2
using Fusion Middleware Control, 5.5
using the Oracle BI Systems Management API, 22.3.4
Scheduler
activating inactive instances of, 6.4
computer running, 19.3.1
configuration options, 19.3.2
configuration tasks for, 1.7
configuring for high availability, 5.4.4
configuring primary and secondary, 6.1.2
configuring Scheduler Tab options, 19.3.3.1
DefaultScriptPath configuration element, 5.4.4
execution threads, 19.3.3.1, 19.3.3.1
SchedulerScriptPath configuration element, 5.4.4
schema tables, 19.3.3.1
scripts, setting up a network share for, 5.4.4
SchedulerScriptPath configuration element, 5.4.4, 19.3.3.1
ScriptRPCPort configuration element, 19.3.3.1
searching for
and replacing catalog text, 17.8
catalog objects, 17.6.1
SectionSliderDefault configuration element, 18.3.2
SectionSliderLimit configuration element, 18.3.2
Security section parameters (NQSConfig.INI file)
DEFAULT_PRIVILEGES, A.5.1
parameters, about, A.5
PROJECT_INACCESSIBLE_COLUMN_AS_NULL, A.5.2
SSL, A.5.4, A.5.4
SSL_CA_CERTIFICATE_FILE, A.5.8
SSL_CERT_VERIFICATION_DEPTH, A.5.10
SSL_CERTIFICATE_FILE, A.5.5
SSL_CIPHER_LIST, A.5.11
SSL_PK_VERIFY_PEER, A.5.7
SSL_PRIVATE_KEY_FILE, A.5.6
SSL_TRUSTED_PEER_DNS, A.5.9
Security Sensitive option, for session variables, 7.7.1.1
Server section parameters (NQSConfig.INI file)
AUTOMATIC_RESTART, A.6.26
CLIENT_MGMT_THREADS_MAX, A.6.16
CLUSTER_PARTICIPANT, A.6.22
DB_GATEWAY_THREAD_RANGE, A.6.6
DB_GATEWAY_THREAD_STACK_SIZE, A.6.7
ENABLE_DB_HINTS, A.6.20
HTTP_CLIENT_THREAD_RANGE, A.6.8
HTTP_CLIENT_THREAD_STACK_SIZE, A.6.9
INIT_BLOCK_CACHE_ENTRIES, A.6.15
LISTEN_ADDRESS, A.6.18
LISTEN_PORT, A.6.19
MAX_DRILLDOWN_INFO_CACHE_ENTRIES, A.6.13
MAX_DRILLDOWN_QUERY_CACHE_ENTRIES, A.6.14
MAX_EXPANDED_SUBQUERY_PREDICATES, A.6.10
MAX_QUERY_PLAN_CACHE_ENTRIES, A.6.11
MAX_QUERY_PLAN_CACHE_ENTRY_SIZE, A.6.12
MAX_REQUEST_PER_SESSION_LIMIT, A.6.3
MAX_SESSION_LIMIT, A.6.2
parameters, about, A.6
PREVENT_DIVIDE_BY_ZERO, A.6.21
REPOSITORY_PUBLISHING_DIRECTORY, A.6.23
REQUIRE_PUBLISHING_DIRECTORY, A.6.24
RPC_SERVICE_OR_PORT, A.6.17
SERVER_THREAD_RANGE, A.6.4
SERVER_THREAD_STACK_SIZE, A.6.5
ServerPollSeconds configuration parameter, 6.3.1
ServerPortNumber configuration element, 19.3.3.1
service levels, monitoring, 7.1
session variables
for time zones, 14.5
Security Sensitive option, 7.7.1.1
using to translate strings, 15.5
sessions
expiration time, 7.3.2
viewing information about active agent, 19.5
settings for time zones, 14.5
shared files and directories, clustering requirements, 5.4
Shared Location option
for catalogs, 10.2
for Oracle BI repository, 10.2
single points of failure, eliminating, 6.1.2
SIZE parameters (NQSConfig.INI file)
USE_LONG_DAY_NAMES, A.4.12
USE_LONG_MONTH_NAMES, A.4.11
specifications for time zones, 14.4
SSL information, 1.7
SSL Trusted Peer DNs configuration field, 19.3.3.1
starting and stopping
Administration Server, 4.7
Catalog Manager, 17.4
Fusion Middleware Control, 2.2.2
Java components, 4.4
Managed Server, 4.8
Oracle BI components, 4.1
Oracle Business Intelligence system manually, 4.2
Oracle Business Intelligence using the Oracle BI Systems Management API, 22.3.2
system and Java components, 4.3
system components, 4.5
system components with a Windows service, 4.5.2
system components with opmnctl command line, 4.5.1
static file caching, setting up, 7.10
status
displaying using the Oracle BI Systems Administration API, 22.3.1
viewing for components, in Fusion Middleware Control, 2.2.3
STORAGE_DIRECTORY parameter
user tracking log files, selecting an output location for, 9.3.1
strings
externalizing for localization, 15.5
translating using session variables, 15.5
subject area, SA System, 19.3.4
supported installation types, 1.8
SyndicatedOracleMapViewerContextPath configuration element, 20.2
system administration
introduction and overview, 1
links to typical tasks, 1.2
tasks, 1.1
tools for managing Oracle Business Intelligence, 1.4
system components
definition of, 1.3.1.1, 1.3.3.2
displaying names, 4.5.1
in a clustered environment, 6.1
listed, 1.3.3
managing using Fusion Middleware Control, 2.2.3
scaling, 5.1.2
scaling vertically and horizontally, 5.5
specifying ports for, 5.5
starting and stopping, 5.6.1
viewing host, instance, and port information for, 5.6.1
viewing status for, 5.6.1
system metrics, viewing, 7.1.1
system requirements, 1.8
system startup, troubleshooting, 4.9

T

table of contents for briefing books, 18.5.5
table views
common settings, 18.3.1.2
configuration, 7.3.3, 12.1
configuring maximum number of rows, 7.3.4
templates
write back, 18.8.2, 18.8.3
write back example, 18.8.3.3
temporary files, location of, 19.3.3.1
TemporaryFilePath configuration element, 19.3.3.1
text editor to manually update configuration settings, 3.4
text strings
exporting for Presentation Catalog, 15.2.2.2
exposing for Presentation Catalog, 15.2.2.5
localizing for Presentation Catalog, 15.2.2, 17.9
third-party tools, 1.7
time zones
precedence order, 14.3
session variables, 14.5
setting, 14.2
setting for users, 14.1
settings, 14.5
specifications, 14.4
specifying values, 14.4.1
usage, 14.1
user-preferred, 14.3.1
toolbar for BI Publisher, 18.5.4
topics of interest in other guides, 1.7
troubleshooting
clustered environments, 6.5
event polling tables, 7.8.4
system startup, 4.9

U

UI hints, propagating for ADF data sources, 1.7
UnaccessedRunningTimeoutMinutes configuration element, B.1
unarchiving
catalog folders, 17.10
catalogs, 17.10
objects, 17.2.3
UNIX
Japanese locale on AIX, 15.4.5.2
SORT_ORDER_LOCALE parameter, 15.4.1, A.4.2.1
updating configuration settings using Oracle BI Systems Management API, 22.3.3
URLs, generation and resource file location, 21
usage tracking
administering, 9.1
error accessing usage tracking output file, 9.3.1
file naming conventions, about and example, 9.3.2
output file, 9.3.3
output file column behavior, 9.3.3
output file format, 9.3.3
output location, selecting, 9.3.1
performance considerations, 9.3.4
usage tracking log files, usage tracking data (table), 9.4
Usage Tracking section parameters (NQSConfig.INI file)
BUFFER_SIZE, A.9.9
BUFFER_TIME_LIMIT_SECONDS, A.9.10
CHECKPOINT_INTERVAL_MINUTES, A.9.4
CODE_PAGE, A.9.6
CONNECTION_POOL, A.9.8
DIRECT_INSERT, A.9.2
ENABLE, A.9.1
FILE_ROLLOVER_INTERVAL_MINUTES, A.9.5
MAX_INSERTS_PER_TRANSACTION, A.9.12
NUM_INSERT_THREADS, A.9.11
parameters, about, A.9
PHYSICAL_TABLE_NAME, A.9.7
STORAGE_DIRECTORY, A.9.3
user interface, setting the default language, 15.2.1.3
users
preferred time zone, 14.3.1
session log-off period, 7.3.2
time zones, 14.1
utilities
log viewer utility, 8.4.2, 8.4.2.2
sawrepaj, 17.12.4

V

validating catalogs, 17.2.5
validation helper functions, 18.6.4, 18.6.4
version numbers, for Oracle BI repository, 10.1.2
vertical scaling
about, 5.1
using Fusion Middleware Control, 5.5
view defaults, 18.7
viewing device types, 19.4
views, default in Compound Layout, 18.7.2.3

W

web client, improving performance for, 7.10
WebLogic scripting tool for managing domains, 1.4.4
WebLogic server administration console
centrally managing Java components, 2.3
tool to manage Java components, 1.4.2
whole server migration, 24
Windows, service for starting and stopping system components, 4.5.2
WLST
tool to manage WebLogic server domains, 1.4.4
using with Oracle BI Systems Management API to update configuration settings, 22.3.3.1
workspace, Catalog Manager, 17.3.2, 17.5, 17.5.3
write back
limitations, 18.8.1
table, 18.8.2
template, 18.8.2, 18.8.3
template example, 18.8.3.3

X

XML data sources, setting refresh interval, 7.4.5
XML message files, 18.7.1
XML message files, view defaults, 18.7.1

Z

zones, time, 14.1