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

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

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