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

add-in for Microsoft Office, C.2.3.3.2

Admin MBeans, 1.5

Administration pages, C.2.1

Administration Server

confirming whether running, 4.6

defined, 1.5

starting and stopping, 4.2, 4.7

Administration Tool

using to manage clustered system components, 6.5

using to purge cache, 7.7.4.2

agents

administering with SA System subject area, D

antivirus software, 20.2.1

configuring e-mail settings for, 11.1.1

definition of, 20.1, 24.1

delivery options for, 20.3.4

e-mail Scheduler configuration settings, 20.3.3.2

failover considerations, 6.3.3.1

general Scheduler configuration settings, 20.3.3.1

jobs, adding and modifying, 26.4

KeepErrorLogFiles configuration element, 20.3.3.3

log directory, viewing entries, 8.4.5, 8.4.5

log file location, 20.3.3.3

Log_Dir configuration element, 20.3.3.3

LogPurgeDays configuration element, 20.3.3.3

managing device types, 20.4

manually configuring settings, 20.3.1

MaxDeliverySleepSecs configuration element, 20.3.3.3

MaxGlobalSleepSecs configuration element, 20.3.3.3

MaxRequestSleepSecs configuration element, 20.3.3.3

MaxRowsTimesColumns configuration element, 20.3.3.3

MinDeliverySleepSecs configuration element, 20.3.3.3

MinGlobalSleepSecs configuration element, 20.3.3.3

MinRequestSleepSecs configuration element, 20.3.3.3

modifying in Job Manager, 26.5

number connection attempts, 20.3.3.3

number delivery attempts, 20.3.3.3

NumDeliveryRetries configuration element, 20.3.3.3

NumGlobalReTries configuration element, 20.3.3.3

NumRequestRetries configuration element, 20.3.3.3

permission settings, 20.2.2

property fields, 26.5

rerunning, 26.6

running in parallel, 24.3

Scheduler, 24.1

Scheduler configuration settings, 20.3.3.3, 20.3.3.3

seeding server cache, 7.7.3

sleep time, 20.3.3.3, 20.3.3.3

support in Scheduler, 24.3

using to seed cache, 7.7.3

viewing information about active sessions, 20.5

aggregate tables, using, 7.2

AllowRememberPassword configuration element, E.1

alternating bars, changing color, 19.3.3

alternative methods for starting and stopping system components, 4.5

AlwaysKeepSessionAffiliation configuration parameter, 6.4.3

ampersand in time zone values, 15.4.1

analyses

blocking, 19.6

default currency, 17.1

default header and footer, 19.7.2.1

links on dashboards, 19.7.2.6

navigation and drill down, 19.2.2

unattended time, E.1

view defaults, 19.7

annotations, enabling for Oracle Scorecard and Strategy Management, 14.1

API, Oracle BI Systems Management, 30.3.3

application roles

inheritance, C.3

permissions and privileges, C.1.3

archiving

catalog folders, 18.10

objects, 18.3.3

Presentation Catalog, 18.10

attributes file, 18.1

B

backup and recovery, 34

bars, changing color for alternating bars, 19.3.3

BI domain, definition of, 1.3

BI Publisher

configuring toolbar, 19.4.3

biee_domain.xml, disabling Fusion Middleware Control from managing configuration settings, H.1

blocking analyses, 19.6

briefing books, table of contents, 19.4.4

BulkFetchBufferSize (bytes) configuration element, 20.3.3.1

bypassing static files, for better performance, 7.10.2

C

CACertificateDir configuration element, 20.3.3.1

CACertificateFile configuration element, 20.3.3.1

cache

about hits, 7.7.1

administering, 7.9

attributes for physical tables, 7.6.1.2

clearing, C.2.4

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

purging using Administration Tool, 7.7.4.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.5.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

cache persistence time setting, 7.6.1.2

canceling instances, 29.2.4

capacity, managing, 5

captions, localizing for Presentation Catalog, 18.9

cascading style sheets

location, 22.3

new dashboard style, 22.3.1

case of logon names, D.4.1

case sensitivity, E.1

CaseInsensitiveMode configuration element, E.1

catalog folders

archiving, 18.10

unarchiving, 18.10

Catalog groups, C.2.2, C.2.2

adding to an existing group, C.2.2.3

creating, C.2.2.1

inheritance, C.3

Catalog Manager

about, 18.2

archiving a Presentation Catalog, 18.10

components of, 18.5.2

copying and pasting items between Presentation Catalogs, 18.6.2

creating reports to display Presentation Catalog data, 18.9

localizing Presentation Catalog captions, 18.9

localizing Presentation Catalog text strings, 16.2.2

opening a Presentation Catalog, 18.4.4

previewing objects, 18.6.6

recommendations for working with, 18.2.2

renaming items, 18.6.3

searching for and replacing Presentation Catalog text, 18.8

searching for Presentation Catalog items, 18.6.1

setting permissions of items, 18.6.5

starting, 18.4

unarchiving a Presentation Catalog, 18.10

viewing and editing objects in XML, 18.7

working with item properties, 18.6.4

workspace, 18.5

centrally managing

Java components using WebLogic Server administration console, 2.3

Oracle Business Intelligence using Fusion Middleware Control, 2.2

CertificateFileName configuration element, 20.3.3.1

CertificateVerifyDepth configuration element, 20.3.3.1

certification information, 1.8

CertPrivateKeyFileName configuration element, 20.3.3.1

change/delete permission, 20.2.2

checkpoints for usage tracking, 9.1.2.4

CipherList configuration element, 20.3.3.1

class, Java SchedulerJobException, 28.7

client sessions, expiration time, 7.3.2

cluster

about components in, 6.1

Cluster Controller components, 6.3.1

Cluster Server, about, 6.3.4

configuring for, 6.4

configuring Scheduler instances, 25.3

JavaHost components, 6.3.6

managing with Fusion Middleware Control, 6.2.1

Master BI Server component, 6.3.2

Oracle BI Scheduler components, 6.3.3

Oracle BI Server components, 6.3.2

Presentation Services components, 6.3.5

shared files and directories, 5.4

shared Oracle BI Presentation Catalog, 5.4.2

shared repository publishing directory, 5.4.1

troubleshooting, 6.6

viewing and managing using Cluster Manager, 6.5.1

Web tier components, 6.3.7

Cluster Controller

about, 6.3.1

configuring for high availability configuration settings updating in NQClusterConfig.INI, 5.4.4

configuring primary and secondary, 6.1.2

failover considerations, 6.3.1.1

Cluster Manager

D

daily trigger type, 29.5.2.1

dashboards

headers and footers, 19.7.2.5

link with analyses, 19.7.2.6

links to page, 19.4.2

managing, 19.1

new dashboard style, 22.3.1

saved customizations, 19.5

section defaults, 19.7.2.4

view defaults, 19.7

data sources, setting up, 1.7

DATA_STORAGE_PATHS configuration parameter, 7.5.3

database, back-end

bulk fetch buffer size, 20.3.3.1

job script path, 20.3.3.1

maximum concurrent connections field, 20.3.3.1

purging, 20.3.3.1

Scheduler requirement, 24.4

timeout specification, 20.3.3.1

tuning and indexing, 7.2

databases supported, 1.8

DayOfWeek Enum values, 27.7.3

DB2 Cube Views

deploying cube metadata, B.4.2

guidelines for materialized query tables (MQTs), B.4.2.3

DB2 Cube Views Generator

about, B.1, B.4.1

about input file for, B.2.2

about output files for, B.2.3

conversion rules, B.2.5

exporting metadata into DB2 Cube Views, B.4

generating import file, B.2

optional parameters and defaults, B.2.1

troubleshooting, B.2.4

DDL, Dynamic Library section parameters, A.7

default RPD, viewing, 10.1

DefaultImageType configuration element, 19.3.2

DefaultName configuration element, 19.4.1

DefaultRowsDisplayed configuration element, 19.3.1.2

DefaultScriptPath configuration element, 5.4.4, 20.3.3.1

deleting

Catalog groups, C.2.2.2

device types, 20.4

delivery devices, 20.3.4

delivery profiles, 20.3.4

DeregisterCancelCommand object method, 27.8.2

descriptions for repository objects, externalizing for localization, 16.4

diagnostics, 8

introduction, 8

log configuration file format example for BI Server, 8.2.2

log configuration file format example for JavaHost Server, 8.2.2

log configuration file settings, 8.2.2

log configuration files location, 8.2.2

log files, 8.1.1

log files location, 8.2.1

dictionary, metadata, 19.2.1

disabling Fusion Middleware Control from managing configuration settings, H.1

display names for repository objects, externalizing for localization, 16.4

double column support, associating a descriptor ID column and descriptor column, 16.5.3

downloading

Oracle BI Add-in for Microsoft Office, C.2.3.3.2

Smart View, 11.4, C.2.3.3.2

drill down, adding support for, 19.2.2

DSN

configuring entry for SQL Server databases, 25.2.2

Presentation Services, E.1

Dynamic Library section (NQSConfig.INI file)

parameters, about, A.7

E

ECID, viewing log information, 8.1.1

editing device types, 20.4

e-mail addresses, populating for agents, D

embedded fonts, 19.3.2.1.1

embedded maps in pages, 21.4

EmbedFonts configuration element, 19.3.2

EnableBookmarkURL configuration element, 19.4.2

EnablePromptedURL configuration element, 19.4.2

enabling users to act for others, C.5

event polling tables

about, 7.6.1.3, 7.8

column names, 7.8.1.1

configuring, 7.6.1.3

CREATE TABLE statements, 7.8.1.2

making active, 7.8.2

populating, 7.8.3

setting up, 7.8.1

troubleshooting, 7.8.4

exchanging metadata

about, B.1

generating import file, B.2, B.2

with IBM DB2 using DB2 Cube Views, B.4

with Oracle Database using SQL Access Advisor, B.3

ExitCode instance property, 29.2.5, 29.2.5

ExitCode script object property, 27.6

exporting Presentation Catalog text strings, 16.2.2

exposing Presentation Catalog text strings, 16.2.2

extensions, Java

example, 28.8

overview, 28.2

Externalize Strings utility, using, 16.4

F

failover

configuring for, 6.4

for Cluster Controller, 6.3.1.1

for Master BI Server, 6.3.2.2

for Oracle BI Scheduler, 6.3.3.1

for Oracle BI Server, 6.3.2.1

for Presentation Services, 6.3.5.1

FlashCLSID configuration element, 19.3.2

FlashCodeBase configuration element, 19.3.2

folders

archiving, 18.10

unarchiving, 18.10

fonts, embedded, 19.3.2.1.1

footer for analyses, 19.7.2.1

framework, actions, 11.2

Fusion Middleware Control

MBean Browser, 2.4.2

navigation tree, 2.2.4

starting and stoppiong system and Java components, 4.3

starting to centrally manage Oracle Business Intelligence, 2.2.1

tool to monitor and configure system components, 1.6.1

user interface labels mapped to configuration file elements, G

using to centrally manage Oracle Business Intelligence, 2.2

using to configure the connection to the marketing content server, 11.3.1

using to update configuration settings, 3.2

WebLogic Server, 2.1

G

gauge views, configuring, 19.3.2

General section parameters (NQSConfig.INI file)

about, A.4

AGGREGATE_PREFIX, A.11.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

GetConfigurationValue object method, 27.8.3

GetTempFileName object method, 27.8.4

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, 19.3.1.2

configuring, 19.3.2

cube settings, 19.3.1.1

fonts, 19.3.2.1.1

green bar styling, 19.3.3

groups

adding to existing, C.2.2.3

Catalog groups, C.2.2

in SA System subject area, D.1.1

guidelines for Catalog Manager, 18.2.2

H

header for analyses, 19.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

HTML insertions, E.1.1

I

IBM DB2 Cube Views

about, B.1

using to create DB2 materialized query tables, B.4

IgnoreWebcatDeliveryProfiles configuration element, D.4

installing and upgrading, 1.7

instanceconfig.xml file

for Oracle BI Scheduler, 5.4.4

for Presentation Services, E.1

InstanceID instance property, 29.2.5

InstanceID script object property, 27.5

instances

canceling, 29.2.4

ExitCode property, 29.2.5, 29.2.5

InstanceID property, 29.2.5

job instances, managing, 26.7

JobID property, 29.2.5

Message property, 29.2.5

purging, 29.2.4

Scheduler job, 26.7

Status property, 29.2.5, 29.2.5, 29.2.5

viewing, 29.2.4

interface, Java

SchedulerJavaExtension, 28.5

SchedulerJobInfo, 28.6

J

Java components

definition of, 1.3, 1.4

in a clustered environment, 6.1

listed, 1.4

managing using WebLogic server administration console, 1.6.2

monitoring and starting and stopping using Fusion Middleware Control, 2.2.3

Java jobs

configuring config.xml to enable use by Scheduler, 28.1.3

example, 28.8

overview, 28.2

using, 28.1

Java program

configuring to use with agents, 28.1.3

example of creating, 28.1.2

using with Oracle BI Systems Management API to update configuration settings, 30.3.3.2

JavaHost

configuration file, 28.1.3

configuring service, E.2

diagnostic log configuration file format example, 8.2.2

in a clustered environment, 6.3.6

service, E.2

JavaHostProxy configuration parameter, 6.4.2

JavaHostReadLimitInKB configuration element, 19.3.1.2

JavaScript files

location, 19.6.1

using to customize the user interface, 22

JMX MBeans

container, 1.5

using the MBean Browser to manage, 2.4

job action

definition of, 29.4

Load Script from File field, 29.4

Parameters (script) field, 29.4

Script field, 29.4

Script Type field, 29.4

job failures, troubleshooting, 27.9

job instances, managing, 26.7

Job Manager

about, 29.1

agent jobs, adding and modifying, 26.4

File menu options, table of, 29.2.1

Instances menu options, table of, 29.2.4

job instances, managing, 26.7

Jobs menu options, table of, 29.2.3

menus, 29.2

overview, 26.1

Service Management menu options, table of, 29.2.2

shutting down, 29.2.1

Job Manager Configuration dialog box

accessing, 20.3.2

agents tab fields, 20.3.3.3

role of, 20.3.2

Scheduler Tab fields, 20.3.3.1

job scripts

day-of-month flags, 27.7.2

day-of-week flags, 27.7.3

definition of, 27

Delete Script When Job is Removed, 29.3

deleting at end of job, 29.3

Disabled field, 29.3

disabling, 29.3

locating, 24.5

month-of-year constants, 27.7.5

occurrence constants, 27.7.6

path, 20.3.3.1

Script object, 27

Script object read-only properties, 27.5

Script object read/write properties, 27.6

Script-defined constants, 27.7

job triggers

definition of, 29.5

recurrent trigger fields, 29.5.2

recurrent trigger types, 29.5.2.1

setting, 29.5

single-run triggers, 29.5.1

JobID instance property, 29.2.5

JobID script object property, 27.5

jobs

about setting up, 29.1

adding or modifying, 26.2

automatic deletion after execution, 29.3

Delete Job When Done field, 29.3

Execute When Missed field, 29.3

job property configuration fields, 29.3

last run time and next run time fields, 29.3

Last Run Time field, 29.3

Maximum Run Time MS field, 29.3

number of instances running, 29.3

re-running, 26.6

Running Instance Count field, 29.3

scheduling and canceling, 29.2.3

time out setting, 29.3

JScript and VBScript job failures, troubleshooting, 27.9

K

KeepErrorLogFiles configuration element, 20.3.3.3

L

labels, for ADF data sources, F.1

languages

default language, specifying for login screen, 16.2.1.3

multiple languages and messages, 22.5.3

selection, 22.4.1

user interface, 22.4

LaunchProcess object method, 27.8.5

links to dashboard pages, 19.4.2

Linux, configuring OPMN for starting and stopping system components, 4.5.3

listen address, setting, 5.5

localization

of repository metadata, 16.4

setting the Japanese locale on AIX systems, 16.3.3.2

SORT_ORDER_LOCALE settings on UNIX systems, 16.3

location

BI configuration files, 3.6

Presentation Catalog, 18.1

locking mechanism for multiple concurrent administrators, 2.1

log files

M

Managed Server, 1.5

confirming whether running, 4.8

definition of, 1.3

guidelines for scaling, 5.1.2

in a clustered environment, 6.1

scaling horizontally, 5.3

starting and stopping on Windows and UNIX, 4.9

managing job instances, 26.7

manually starting the Oracle Business Intelligence system, 4.2

map views

configuring, 21

configuring manually, 21.2

configuring MapViewer, 21.1

embedded in pages, 21.4

hardware requirements, 13.1.1

inserting text, 21.3

system requirements, 13.1

translating layers, 16.2.4

mapping configuration file elements with corresponding Fusion Middleware Control user interface labels, G

MapViewer configuration, 21.1

marketing content server

configuring the connection to, 11.3, 11.3.2

using Fusion Middleware Control to configure the connection to, 11.3.1

Master BI Server

about, 6.3.2

failover considerations, 6.3.2.2

viewing in Cluster Manager, 6.5.1.1

materialized query tables (MQTs), about, B.4.1

materialized views

creating, B.3.2.4

using, B.3

MAX_ROWS_PER_CACHE_ENTRY configuration parameter, 7.5.3

MaxAgeMinutes configuration element, 19.4.2

MaxDeliverySleepSecs configuration element, 20.3.3.3

MaxDropDownValues configuration element, 19.4.1

MaxEntries configuration element, 7.9

MaxExecThreads configuration element, 20.3.3.1

MaxExpireMinutes configuration element, 7.9

MaxFollowLinks configuration element, 19.4.1

MaxGlobalSleepSecs configuration element, 20.3.3.3

MaxRecords configuration element, 21.2

MaxRequestSleepSecs configuration element, 20.3.3.3

MaxRowsTimesColumns configuration element, 20.3.3.3

MaxVisibleColumns configuration element, 19.3.1.2

MaxVisiblePages configuration element, 19.3.1.2

MaxVisibleRows configuration element, 19.3.1.2

MaxVisibleSections configuration element, 19.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.10.2

ENABLE, A.10.1

MAX_MEMBER_PER_LEVEL, A.10.4

MAX_SIZE_PER_USER, A.10.3

memory requirements, 1.8

Message instance property, 29.2.5

Message script object property, 27.6

messages in log files, 8.4.3

metadata dictionary, 19.2.1

methods, running and canceling Java, 28.5

metrics, viewing, 7.1.1

migrating to a new environment, 32

MinDeliverySleepSecs configuration element, 20.3.3.3

MinExecThreads configuration element, 20.3.3.1

MinExpireMinutes configuration element, 7.9

MinGlobalSleepSecs configuration element, 20.3.3.3

minimum disk space, 1.8

MinRequestSleepSecs configuration element, 20.3.3.3

MinUserExpireMinutes configuration element, 7.9

modes for opening catalogs, 18.4.2

monitoring system metrics, 7.1

Monthly by Date trigger type, 29.5.2.1

Monthly by DOW trigger type, 29.5.2.1

month-of-year constants, 27.7.5

multilingual data support, 16.5.1

multilingual support, lookup, 16.5.2

multiple host logical architecture, 1.3

N

names, case of logon, D.4.1

navigation tree in Fusion Middleware Control

about, 2.2.4

navigation, adding support for in analyses, 19.2.2

node manager

daemon process, 1.3

starting on Windows and UNIX, 4.2

NQClusterConfig.INI file

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

nqJobDeleteScriptWhenDone script-defined constant, 27.7.4

nqJobDeleteWhenDone script-defined constant, 27.7.4

nqJobDisabled script-defined constant, 27.7.4

nqJobExecuteWhenMissed script-defined constant, 27.7.4

nqJobHasEndDate script-defined constant, 27.7.4

nqJobNoFlags, 27.7.4

nqJobScriptContainsPath script-defined constant, 27.7.4

nqJobStartNow script-defined constant, 27.7.4

nQLogViewer utility

interpreting log records, 8.3.2.1

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.7

General section, about, A.4

Optimization Flags section parameters, A.9

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.8

NumDBConnections configuration element, 20.3.3.1

NumDeliveryRetries configuration element, 20.3.3.3

NumGlobalReTries configuration element, 20.3.3.3

NumRequestRetries configuration element, 20.3.3.3

O

objects

committing to production, 18.3.3

previewing in Catalog Manager, 18.6.6

searching for, 18.6.1

viewing and editing in XML, 18.7

working with properties, 18.6.4

occurrence constants, table of values, 27.7.6

offline mode for opening catalogs, 18.4.2

OnError object event, 27.8.13

online mode for opening catalogs, 18.4.2

opening catalogs, 18.4.2

operating systems, supported, 1.8

OPMN

about, 1.6.3

definition of, 1.3

using opmnctl command line to start and stop System components, 4.5.1

Optimization Flags section parameters (NQSConfig.INI file)

parameters, about, A.9

STRONG_DATETIME_TYPE_CHECKING, A.9.1

options, delivery for agents, 20.3.4

Oracle ADF data sources, propagating lables and tooltips for, F

Oracle BI Catalog Manager

See Catalog Manager

Oracle BI Dashboards

See dashboards and dashboards, administering

Oracle BI Presentation Services Plug-in, configuring for high availability, 6.4.3

Oracle BI repository

disallowing updates, 7.3.1

localizing repository metadata, 16.4

mapping SA System subject area in, D.3

metadata dictionary, 19.2.1

publishing using Fusion Middleware Control, 10.1

publishing using System MBeans, 10.3

repository publishing directory, 5.4.1

restarting Oracle BI processes, 4.1

sharing, 10.1

specifying password for, 10.1

understanding version numbers, 10.2

Oracle BI Server

P

ParameterCount script object property, 27.5

PassphraseFileName configuration element, 20.3.3.1

password

remembering, E.1

specifying for repository upon upload, 10.1

pasting items between Presentation Catalogs, 18.6.2

patching

about, 31

components, 31.1

determining current patch levels, 31.4

platform patches, 31.2

rolling back a patch, 31.3

PauseOnStartup configuration element, 20.3.3.1

pausing and continuing the Scheduler, 29.2.2

PERF_PREFER_IN_LISTS database feature, 7.8.1.1

performance

about managing, 7.2

accelerating by exchanging metadata with databases, B.1

disallowing repository updates, 7.3.1

for Web client, 7.10

setting up static file caching, 7.10.1

static file bypass, 7.10.2

tuning and indexing data sources, 7.2

using aggregate tables, 7.2

viewing metrics, 7.1.1

permissions

inheritance, C.3

inheritance rules, C.3.1

saved customizations, 19.5.2.2

setting for items, 18.6.5

setting in Catalog Manager, 18.6.5

settings for agents, 20.2.2

users, C.1.3

pivot table views

common settings, 19.3.1.2

configuration, 7.3.3, 12.1

cross-site scripting, E.1.1

cube settings, 19.3.1.1

platforms, supported, 1.8

PoolTimeout (minutes) configuration element, 20.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, 15.3

Presentation Catalog

about, 18.1

administering, 18.2, 18.6.4

archiving, 18.10

Catalog Manager workspace, about, 18.5

Catalog Manager, setting permissions through, 18.6.5

Catalog Manager, starting, 18.4

committing an object to production, 18.3.3

configuring for a full text search, 18.11

copying and pasting objects between, 18.6.2

creating new, 18.3.2

creating reports to display data, 18.9

exporting text strings for, 16.2.2

exposing text strings for, 16.2.2

localizing captions for, 18.9

location of, 18.1

maintaining manually, 18.3

maintaining using Fusion Middleware Control, 18.3

manually changing additional configuration settings for, 18.3.1

manually creating a new one, 18.3.2

modes for opening in Catalog Manager, 18.4.2

opening, 18.4.2

recommendations for working with, 18.2.2

rename items, about using Catalog Manager to, 18.6.3

replicating, 18.12

searching for and replacing text, 18.8

setting object permissions, 18.6.5

setting permissions of objects, 18.6.5

setting up a network share for, 5.4.2

specifying shared location for, 10.1

unarchiving, 18.10

viewing and editing objects in XML, 18.7

Presentation Services

Administration pages, C.2.1

cache, 7.9

Catalog groups, C.2.2

configuring for high availability, 6.4.2

failover considerations, 6.3.5.1

in a clustered environment, 6.3.5

log message structure, 8.4.3

logging in, 8.4

managing sessions, C.2.4

query cache, 7.6.2.2

Replication Agent, 18.12.3

security, C.1

specifying default language, for login screen, 16.2.1.3

previewing objects from Catalog Manager, 18.6.6

privileges

changing, C.2.3.2

default assignments, C.2.3.3

defined, C.2.3.1

inheritance, C.3

inheritance rules, C.3.1

managing, C.2.3

saved customizations, 19.5.2.1

setting, C.2.3.2

users, C.1.3

production, committing objects to, 18.3.3

programmatically starting and stopping Oracle Business Intelligence using the Oracle BI Systems Management API, 4.5.4

properties of catalog objects, 18.6.4

proxy levels for users, C.5.2

publish agents for Subscription privilege, 20.2.2

PurgeInstDays configuration element, 20.3.3.1

PurgeIntervalMinutes configuration element, 20.3.3.1

purging cache

using Administration Tool, 7.7.4.2

when switching between repositories, 7.6.3.3

purging instances, 29.2.4

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 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.3

usage tracking, administering, 9.1

query logs

administering, 8.3

configuring, 8.3.1

disabling user logging levels, 8.3.1.2

interpreting the log records, 8.3.2.1

log viewer utility, 8.3.2

logging levels, 8.3.1.1

setting logging levels, 8.3.1.1

setting user logging levels, 8.3.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

query workload, creating, B.3.2.3

R

RCU, using to create Scheduler database schemas, 25.1

recovery and backup, 34

recurrent trigger

Begin Date, 29.5.2

End Date, 29.5.2

End Time, 29.5.2

fields related to, 29.5.2

Has End Date, 29.5.2

Interval in Minutes, 29.5.2

Maximum Concurrent Instances, 29.5.2

Set Start Time To Now, 29.5.2

Start Time, 29.5.2

trigger types, 29.5.2.1

refresh interval, setting for XML data sources, 7.4.5

RegisterCancelCommand object method, 27.8.6

relational data source adapters, 1.7

RemoteOracleMapViewerAbsoluteURL configuration element, 21.2

renaming items

about, 18.6.3

with reference updates, 18.6.3

without reference updates, 18.6.3

replacing Presentation Catalog text, 18.8

replication

catalogs, 18.12

Oracle BI Presentation Services Replication Agent, 18.12.3

resuming, 18.12.6

sawrepaj utility, 18.12.3

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)

about, A.2

repository variables, cache purging considerations, 7.6.3.4

requirements, system, 1.8

resource files, location, 23

resuming replication, 18.12.6

rollover, described, 9.1.2.4

row-level database security, ensuring correct cache results with, 7.7.1.1

running job, definition of, 29.2.5

S

S_NQ_ERR_MSG, 24.5, 24.5

S_NQ_INSTANCE, 24.5, 24.5

S_NQ_JOB, 24.5

S_NQ_JOB_PARAM, 24.5, 24.5

SA System subject area, D.4.1

about, D.1

about group resolution, D.1.1

columns for, D.2

delivery options, 20.3.4

importing data from, D.3

managing the case of login names, D.4.1

setting configuration options for, D.4

setting up, D.2

sametaexport utility

about, B.1

parameters, B.2.1

running, B.2.1

saved customizations, 19.5

administration, 19.5.2

folder structure, 19.5.2.2.3

permissions, 19.5.2.2

privileges, 19.5.2.1

sawrepaj utility, 18.12.3

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, 30.3.4

ScheduleJobDaily object method, 27.8.7

ScheduleJobMonthlyDate object method, 27.8.8

ScheduleJobMonthlyDOW object method, 27.8.9

ScheduleJobNow object method, 27.8.10

ScheduleJobOnce object method, 27.8.11

ScheduleJobWeekly object method, 27.8.12

Scheduler

activating inactive instances of, 6.5

adding jobs in Job Manager, 26.2

computer running, 20.3.1

configuration options, 20.3.2

configuring database, 25.2

configuring for high availability, 5.4.4

configuring primary and secondary, 6.1.2

configuring Scheduler Tab options, 20.3.3.1

connection, opening and closing, 29.2.1

database schemas, 24.5

database schemas created in RCU, 25.1

databases supported, 24.4

DefaultScriptPath configuration element, 5.4.4

execution threads, 20.3.3.1, 20.3.3.1

failover considerations, 6.3.3.1

in a clustered environment, 6.3.3

Java Job properties, 28.3

Job Manager, role of, 26.1

modifying jobs in Job Manager, 26.3

overview, 24.1

pausing and continuing, 29.2.2

role of, 24.1

SchedulerScriptPath configuration element, 5.4.4

scheduling and removing jobs, 29.2.3

schema tables, 20.3.3.1, 24.5

scripted jobs, 24.1

scripts, setting up a network share for, 5.4.4

stopping, 29.2.2

table names, 25.4

tables, 24.5

tables and database support, 24.4

SchedulerScriptPath configuration element, 5.4.4, 20.3.3.1

Script object

overview, 27, 28.2

read-only properties, 27.5

read/write properties, 27.6

script-defined constants

about, 27.7

day-of-month, 27.7.2

day-of-month flags, 27.7.2

day-of-week, 27.7.3

day-of-week constants, 27.7.3

job status flags, 27.7.4

JobFlagsEnum, 27.7.4

month-of-year, 27.7.5

occurrence flags, 27.7.6

severity, 27.7.1

scripted jobs

definition of, 24.1

Scheduler, 24.1

ScriptRPCPort configuration element, 20.3.3.1

scripts, object methods, 27.8

searching for

and replacing catalog text, 18.8

catalog objects, 18.6.1

SectionSliderDefault configuration element, 19.3.2

SectionSliderLimit configuration element, 19.3.2

security

Catalog groups, C.2.2

goals, C.1.2

Presentation Services, C.1

settings location, C.1.1

Security section parameters (NQSConfig.INI file)

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 section parameters (NQSConfig.INI file)

DEFAULT_PRIVILEGES, A.5.1

parameters, about, A.5

PROJECT_INACCESSIBLE_COLUMN_AS_NULL, A.5.2

Security Sensitive option, for session variables, 7.7.1.1

Server section parameters (NQSConfig.INI file)

AUTOMATIC_RESTART, A.6.20

CLIENT_MGMT_THREADS_MAX, A.6.13

CLUSTER_PARTICIPANT, A.6.17

DB_GATEWAY_THREAD_RANGE, A.6.6

DB_GATEWAY_THREAD_STACK_SIZE, A.6.7

ENABLE_DB_HINTS, A.6.15

INIT_BLOCK_CACHE_ENTRIES, A.6.12

MAX_DRILLDOWN_INFO_CACHE_ENTRIES, A.6.10

MAX_DRILLDOWN_QUERY_CACHE_ENTRIES, A.6.11

MAX_EXPANDED_SUBQUERY_PREDICATES, A.6.8

MAX_QUERY_PLAN_CACHE_ENTRIES, A.6.9

MAX_REQUEST_PER_SESSION_LIMIT, A.6.3

MAX_SESSION_LIMIT, A.6.2

parameters, about, A.6

PREVENT_DIVIDE_BY_ZERO, A.6.16

REPOSITORY_PUBLISHING_DIRECTORY, A.6.18

REQUIRE_PUBLISHING_DIRECTORY, A.6.19

RPC_SERVICE_OR_PORT, A.6.14

SERVER_THREAD_RANGE, A.6.4

SERVER_THREAD_STACK_SIZE, A.6.5

SERVER_POLL_SECONDS configuration parameter, 6.4.1

ServerPortNumber configuration element, 20.3.3.1

service levels, monitoring, 7.1

session variables

for proxy functionality, C.5.3.2

for time zones, 15.5

naming scheme for ADF data source UI hints, F.2

Security Sensitive option, 7.7.1.1

using to translate strings, 16.4

sessions

expiration time, 7.3.2

managing, C.2.4

viewing information about active agent, 20.5

settings for time zones, 15.5

Severity script object property, 27.6

shared files and directories, clustering requirements, 5.4

Shared Location option

for catalogs, 10.1

for Oracle BI repository, 10.1

sign-in page, customizing, 22.4.2

single points of failure, eliminating, 6.1.2

Single-Run Triggers, 29.5.1

SIZE parameters (NQSConfig.INI file)

USE_LONG_DAY_NAMES, A.4.12

USE_LONG_MONTH_NAMES, A.4.11

skins

defaults, 22.3.2

user interface, 22.2

Smart View download, 11.4, C.2.3.3.2

specifications for time zones, 15.4

SQL Access Advisor

about, B.1

using to create materialized views, B.3

SSL information, 1.7

SSL Trusted Peer DNs configuration field, 20.3.3.1

standalone script jobs, 27

starting and stopping

Administration Server, 4.7

Catalog Manager, 18.4

Fusion Middleware Control, 2.2.1

Java components, 4.4

Managed Server, 4.9

Oracle BI components, 4.1

Oracle Business Intelligence system manually, 4.2

Oracle Business Intelligence using the Oracle BI Systems Management API, 30.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.1

status

displaying using the Oracle BI Systems Administration API, 30.3.1

enabling overrides for Oracle Scorecard and Strategy Management, 14.1

viewing for components, in Fusion Middleware Control, 2.2.2

Status instance property, 29.2.5, 29.2.5, 29.2.5

stopping the Scheduler, 29.2.2

STORAGE_DIRECTORY parameter

user tracking log files, selecting an output location for, 9.1.2.1

strings

externalizing for localization, 16.4

translating using session variables, 16.4

style sheets

location, 22.3

new dashboard style, 22.3.1

styles

skins, 22.3.2

user interface, 22.2

subject area, SA System, 20.3.4, D.4.1

supported installation types, 1.8

SyndicatedOracleMapViewerContextPath configuration element, 21.2

system administration

introduction and overview, 1

links to typical tasks, 1.2

tasks, 1.1

tools for managing Oracle Business Intelligence, 1.6

system components

definition of, 1.3, 1.4

displaying names, 4.5.1

in a clustered environment, 6.1

listed, 1.4

managing using Fusion Middleware Control, 2.2.2

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.10

SystemSubjectArea configuration element, D.4

T

table of contents for briefing books, 19.4.4

table views

common settings, 19.3.1.2

configuration, 7.3.3, 12.1

configuring maximum number of rows, 7.3.4

cross-site scripting, E.1.1

templates

write back, 19.8.2, 19.8.3

write back example, 19.8.3.3

XML template sample, 22.5.5

temporary files, location of, 20.3.3.1

TemporaryFilePath configuration element, 20.3.3.1

text editor to manually update configuration settings, 3.4

text strings

exporting for Presentation Catalog, 16.2.2

exposing for Presentation Catalog, 16.2.2

localizing for Presentation Catalog, 16.2.2, 18.9

third-party tools, 1.7

time zones

precedence order, 15.3

session variables, 15.5

setting, 15.2

setting for users, 15

settings, 15.5

specifications, 15.4

specifying values, 15.4.1

usage, 15.1

user-preferred, 15.3.1

toolbar for BI Publisher, 19.4.3

tooltips, for ADF data sources, F.1

topics of interest in other guides, 1.7

troubleshooting

clustered environments, 6.6

DB2 Cube Views Generator, B.2.4

event polling tables, 7.8.4

JScript and VBScript job failures, 27.9

Oracle Database Metadata Generator, B.2.4

system startup, 4.10

U

UI hints, for ADF data sources, F

UnaccessedRunningTimeoutMinutes configuration element, E.1

unarchiving

catalog folders, 18.10

catalogs, 18.10

objects, 18.3.3

UNIX

Japanese locale on AIX, 16.3.3.2

SORT_ORDER_LOCALE parameter, 16.3.1, A.4.2.1

updating configuration settings using Oracle BI Systems Management API, 30.3.3

UpperCaseRecipientNames configuration element, D.4

URLs, generation and resource file location, 23

usage tracking

administering, 9.1

error accessing usage tracking output file, 9.1.2.1

file naming conventions, about and example, 9.1.2.2

output file, 9.1.2.3

output file column behavior, 9.1.2.3

output file format, 9.1.2.3

output location, selecting, 9.1.2.1

performance considerations, 9.1.2.4

usage tracking log files

usage tracking data (table), 9.2

Usage Tracking section parameters (NQSConfig.INI file)

BUFFER_SIZE, A.8.9

BUFFER_TIME_LIMIT_SECONDS, A.8.10

CHECKPOINT_INTERVAL_MINUTES, A.8.4

CODE_PAGE, A.8.6

CONNECTION_POOL, A.8.8

DIRECT_INSERT, A.8.2

ENABLE, A.8.1

FILE_ROLLOVER_INTERVAL_MINUTES, A.8.5

MAX_INSERTS_PER_TRANSACTION, A.8.12

NUM_INSERT_THREADS, A.8.11

parameters, about, A.8

PHYSICAL_TABLE_NAME, A.8.7

STORAGE_DIRECTORY, A.8.3

user interface

customization tips, 22.1

customizing using XML message files, 22.5

custommessages.xml file, 22.5.6

default images and style sheets, 22.3

hints for ADF data sources, F

language selection, 22.4

new dashboard style, 22.3.1

resolution of name elements, 22.5.4

sample XML template, 22.5.5

setting language, 16.2.1.3

sign-in pages, 22.4.2

skins, 22.2

styles, 22.2

styles and skins, 22.3.2

support of multiple languages, 22.5.3

XML message files, 22.5.2, 22.5.3

user profile options, populating with SA System subject area, D

UserID script object property, 27.5

users

enabling to act for others, C.5

preferred time zone, 15.3.1

proxy levels, C.5.2

session log-off period, 7.3.2

time zones, 15

utilities

log viewer utility, 8.3.2, 8.3.2.1

sawrepaj, 18.12.3

V

validation helper functions, 19.6.4

version numbers, for Oracle BI repository, 10.2

vertical scaling

about, 5.1

using Fusion Middleware Control, 5.5

view defaults, 19.7

viewing device types, 20.4

viewing instances, 29.2.4

views, default in Compound Layout, 19.7.2.3

W

Web client, improving performance for, 7.10

Web tier, in a clustered environment, 6.3.7

WebLogic scripting tool for managing domains, 1.6.4

WebLogic server administration console

centrally managing Java components, 2.3

tool to manage Java components, 1.6.2

WebMessage name tags, 22.5.4

weekly trigger type, 29.5.2.1

Windows

Scheduler tables, 24.5

Schedulerand database support, 24.4

service for starting and stopping system components, 4.5.2

WLST

tool to manage WebLogic server domains, 1.6.4

using with Oracle BI Systems Management API to update configuration settings, 30.3.3.1

workspace, Catalog Manager, 18.2.2, 18.5, 18.5.3

write back

limitations, 19.8.1

table, 19.8.2

template, 19.8.2, 19.8.3

template example, 19.8.3.3

X

XML data sources, setting refresh interval, 7.4.5

XML message files

customizing, 22.5.1, 22.5.3

custommessages.xml file, 22.5.6

multiple languages, 22.5.3

resolution of name elements, 22.5.4

sample template, 22.5.5

structure of, 22.5.2

view defaults, 19.7.1

XSS, securing against, E.1.1

Z

zones, time, 15