Skip Headers
Oracle® Business Intelligence Discoverer Configuration Guide
10g Release 2 (10.1.2.1) for Microsoft Windows and Solaris Operating System (SPARC)
B13918-03
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents

Previous
Previous
 

Index

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

Numerics

500 Internal Server Error - troubleshooting, D.1.18

A

Apache
timeout, A.1
Apple Mac
choosing the correct JVM, 5.9
prerequisites, 3.6, 3.6
required JVM, 5.9
running Discoverer Plus, 3.6
Application Server Control, 5.1
about, 5.1
how to display the Discoverer home page, 5.1.2
how to start, 5.1.2
using to manage Discoverer components, 5.1.2
why use with Discoverer, 5.1.1
applypreferences.bat, A.1, A.1, A.1
architecture
of Discoverer, 1.6
of Discoverer Catalog, 6.1.4
ASO encryption certification, 14.2
Available Items pane
hide and display, 9.1

B

BI Beans Catalog, 6.1.5
administer, 5.1.1
block size
Discoverer Catalog, 6.2.2.1
browser
requirements, 3.2
supported by Discoverer, 3.2

C

caching
creating a rule for Discoverer, 8.5.1
in Discoverer Portlet Provider, A.2
caching Discoverer Viewer pages
enabling, 8.5.2
Catalog
Discoverer, 6.1
OLAP, 6.1.2
CellPadding preference, 10.6
certdb.txt, A.1
certification
Oracle Applications, D.1.2
character limits
browser limits, 13.2
checkconfiguration utility, 6.6
checkdiscoverer utility, A.1, A.1, D.2.1, D.2.2
collectlogs.bat, A.1, D.2.1, D.2.9
collectlogs.sh, D.2.1, D.2.9
column spacing in reports, 10.6
communication protocols, 5.1.1, 5.1.1, 5.1.1
about HTTP, 14.6.3, 14.6.3.2
about HTTPS, 14.6.3.2, 14.9.3
about JRMP, 14.6.3, 14.6.3.2
configuration diagnostic utility
Discoverer Plus OLAP, 6.6
configuration files
applypreferences.bat, A.1, A.1, A.1
certdb.txt, A.1
checkdiscoverer.bat, A.1, A.1
collectlogs.bat, A.1
configuration.xml, A.1, A.2
convertreg.pl, A.1, A.1, A.1
defaults.txt, A.1, A.1, A.1
dis51pr, A.1
discwb.sh, A.1, A.1
error.txt, A.1, A.1, A.1, A.1, A.1, A.1
migratediscoconnection.bat, A.1
migrateprefs.bat, A.1
migrateprefs.sh, A.1
mod_osso.conf, A.1
opmnctl, A.1
opmn.xml, A.1, A.1, A.1, A.3
pref.txt, A.1, A.1, A.1, A.1, A.1, A.1
reg_key.dc, A.1, A.1, A.1
tnsnames.ora, A.1, A.1, A.1, A.1, A.1, A.1, A.1
upgradeMR script, A.1
web.xml, A.1
configuration.xml
settings, A.2
summary, A.1
connection ID
how to find out, 13.4.3
connections, 3.7, 3.11
about, 4.1, 4.3
about private connections, 4.2.1
about public connections, 4.2.2
connections page, 4.4
creating a public connection, 4.6, 4.7
enabling private, 4.8
how to find out a connection ID, 13.4.3
managing with Oracle Application Server Control, 4.3
migrating, 4.3
private, 3.7, 3.11
private for OLAP data, 6.3.8
public, 5.1.1
troubleshooting, D.1.21
types, 4.2
convertreg.pl script, 10.7
CORBA components
Preferences, 1.8.2
Session, 1.8.2
currency
Euro countries, 10.6
customizing
hide and display Available Items pane, 9.1
customizing Discoverer Plus
about, 9.1
customizing Discoverer Viewer
about, 9.2, 9.2.1
layout, 9.2.3
look and feel, 9.2.2
troubleshooting, D.1.23

D

D4OSYS user
database privileges, 6.2.1
privileges, 6.3.4
dashboard application, 11.1
Database Connection file, 15.1
database privileges
D4OSYS, 6.2.1
database security
about, 14.2
ASO encryption certification, 14.2
database users and performance, 12.3.13
DBC files, 15.1
dc* file, A.3
defaults.txt, A.1, A.1, A.1
demilitarized zones (DMZs)
about, 14.9.2
diagnosing problems, D.2.1
checkdiscoverer utility, D.2.2
dis51pr, A.1
Discoverer
about, 1.1
and Oracle Application Server, 2.1
and Oracle Applications, 15
and OracleAS Portal, 11.1
architecture, 1.6
CORBA components, 1.8.2
J2EE components, 1.8.1
over SSL/HTTPS, 3.5, 14.6
Plus servlet, 1.8.1.2
port numbers, 5.8
Portlet Provider servlet, 1.8.1.3
process, 1.10
security, 3.3, 4.8
servlet, 1.8.1.1
URL arguments for Discoverer Plus, 13.8
URL parameters for Discoverer Viewer, 13.9
Viewer, 1.1
Discoverer Catalog, 6.1
about, 6.1.1
administer, 6.1
architecture, 6.1.4
authorize access, 6.3.6
authorized users and roles, 6.3
block size, 6.2.2.1
D4OSYS user, 6.2.1
defined, 6.1.1
deinstallation, 6.2.3
export, 6.2.4
folder structure, 6.3.1, 6.3.1
import, 6.2.5
installation, 6.2.2
maintain users and roles, 6.3
object properties, 6.1.3
privileges, 6.3.3
privileges for objects and folders, 6.3.3
revoke access, 6.3.7
Discoverer connections
about, 4.1
and Oracle Applications, 15.1
migrating, 4.3
Oracle e-Business Suite, 14.4, 15.1
Discoverer Java applet, 1.7.1
Discoverer logins
managing with Oracle Application Server Control, 4.3
Discoverer memory and performance, 12.3.13
Discoverer Plus, 3.6
about, 1.1
accessing over dial-up, 3.6
client machine requirements, 1.7.1
configuration, 5.1.1
hide and display UI panes, 9.1
look and feel, 9.1, 9.1.1
on Apple Mac, 3.6, 5.9
operating system rights, 3.4
process, 1.10.1, 1.10.2
removing applet, 3
running, 3.6
running on Apple Mac, 3.6
running on Internet Explorer, 3.6, 3.8
running on Netscape Navigator, 3.6, 3.9
running over HTTPS, 14.6.3.2
security settings, 3.6
session timeout, 3.6
upgrading the applet, 1.7.1
URL arguments, 13.8
Discoverer Plus OLAP
about, 1.1
about the configuration diagnostic utility, 6.6
customizing, 6.4
ensuring access, 6.3.5
information for end users, 6.5
starting with URL parameters, 13.5.6
URL parameters, 6.7
Discoverer Portlet Provider, 12.3.12, A.2
editing, 11.4
how to register, 11.3
over HTTPS, 11.3
security example, 14.7.2.3
test URL, 11.2
testing, 11.2
troubleshooting, D.1.18
using, 11.2
Discoverer preferences
about, 10.1
migrating, 10.8
Discoverer Preferences component
specifying the machine that is going to run it, 7.6
Discoverer security
communication protocols, 14.6.3.2
configuring with HTTPS, 14.6.3.6
connections, 14.5.1
database, 14.2
default, 14.6.3.2
Discoverer Services Configuration page, 14.6.3.3
JRMP,HTTP,HTTPS, 14.6
non-Single Sign-On, 14.7.3
OracleAS Portal, 14.7.2.3
secure tunneling, 14.6.3.2
Single Sign-On, 14.7.1
tunneling, 14.6.3.2
Discoverer Services components
about, 1.8
Discoverer Session component, 1.8.2.1
Preferences component, 1.8.2.2
Session component, 1.8.2.1
Discoverer Services Configuration page
starting OEM, 14.6.3.3
Discoverer Viewer
about, 1.1
client machine requirements, 1.7.2
customization, 5.1.1
customization troubleshooting, D.1.23
email option, D.1.10
graph display problem, D.1.19
JavaScript, 1.7.2
look and feel, 9.2
over HTTPS within OracleAS Portal, 11.3
process, 1.10.3
running, 3.11
saving worksheet behavior, A.2
security, 14.6.2
troubleshooting, D.1.1
URL parameter for OLAP worksheet, 6.8
URL parameters, 13.9
discwb.sh, A.1, A.1
DMZs, 14.9.2

E

e-Business Suite login, 14.4, 15.1
email option in Discoverer Viewer, D.1.10
encryption
how to configure Discoverer to use encryption in an intranet, 14.9.7
how to configure Discoverer to use encryption through firewalls, 14.9.8
how to verify that Discoverer is encrypting communications, 14.9.9
Endian format in preferences file, 10.7
Enterprise Manager
query progress delay, 5.1.1
error diagnosis, D.1
error message - Could not resolve service name?, D.1.4
error message ORA-12154, D.1.4
Euro currency, 10.6
EuroCountries preference, 10.6
export
temporary file, A.3
export Discoverer Catalog, 6.2.4
export errors
troubleshooting, D.1.1
export types
Web Query, 10.6
exporting data
displaying repeating values, 10.6
minimum required Excel version, D.1.1
NULL values, 10.6

F

firewalls
about, 14.9.1
how to configure Discoverer for both intranet users and users accessing Discoverer through a firewall, 14.9.10
how to configure Discoverer to use encryption through firewalls, 14.9.8
how to configure Discoverer to work through a firewall, 14.9.5, 14.9.6
policies, 14.9.2
FND_SECURE, A.3
FND_TOP, A.3
folder structure of Discoverer Catalog, 6.3.1
frequently asked questions
about security, 14.9

G

graphing
troubleshooting, D.1.19

H

HTTP, 14.6
about, 14.6.3, 14.6.3.2
HTTPS, 14.6
about, 14.6.3.2, 14.9.3
enabling, 3.5, 14.6
running Discoverer, 3.5
running Discoverer Plus, 14.6.3.2
running Discoverer Portlet Provider, 11.3
troubleshooting, D.1.7

I

import Discoverer Catalog, 6.2.5
index values
troubleshooting, D.1.15
Internet Explorer
running Discoverer, 3.8
intranet
configure Discoverer for both intranet users and users accessing Discoverer through a firewall, 14.9.10
how to configure Discoverer to work in an intranet, 14.9.4
IQY format, 5.10

J

J2EE components
about, 1.8.1
Java Plug-in
pop-up, 3
Java runtime environment, 3
Oracle JInitiator, 3
Sun Java Plug-in, 3
Java Virtual Machine, 5.9
overriding, 5.9
Javascript
Discoverer Viewer requirements, 1.7.2
JInitiator
version 1.3, 5.9
JRMP, 14.6
about, 14.6.3, 14.6.3.2

L

LAFs
browser, 9.1.1
oracle, 9.1.1
Plastic, 9.1.1
plastic, 9.1.1
system, 9.1.1
layout
customizing, 9.2.3
load balancing
session binding, 7.5.2.3
log files, D.2.1, D.2.9
collecting, D.2.1, D.2.9
enabling Discoverer Service logs, D.2.5
enabling Discoverer Servlet logs, D.2.6
OPMN, A.3
ORB debug file, A.3
server diagnostics available, D.2.1
using OracleAS View Logs, D.2.3
viewing Discoverer Services logs, D.2.7
viewing Discoverer Servlet logs, D.2.8
logging and performance, 12.3.13
look and feel, 9.1.3, 9.1.4
changing, 9.1.3
creating a custom LAF, 9.1.4
customizing, 9.1, 9.2, 9.2.2
types, 9.1.1

M

maxDataRows
Discoverer Portlet Provider caching, A.2
maxprocs
and portlet/Sessionpool/maxSessions, A.3
maxSessions
setting, A.2, A.3
memory requirements of Discoverer, 3.4
Metadata Repository
upgrading Discoverer part of, 2.3.1, A.1
Microsoft Excel
minimum supported version for export, D.1.1
minimum supported version for Web Query format, 5.10
migratediscoconnection.bat, A.1
migrateprefs.bat, A.1
migrateprefs.sh, A.1
migrating Discoverer connections, 4.3
migrating preferences, B.5.1
minimum security settings, 3.6
minRequestThreadPoolSize
setting, A.2
mod_osso.conf, 11.1, 14.7.2.1, A.1
OssoIPCheck, 11.1
multiple machine installation
about configuring Discoverer, 7.3

N

NAT (Network Address Translation), deploy Discoverer using a standard NAT, 14.9.11
Netscape Navigator, 3.6
running Discoverer, 3.9
Netscape V4.x
troubleshooting, D.1.6
network exception
troubleshooting, D.1.3
NULL values in exported data, 10.6

O

OLAP
starting Discoverer Plus OLAP, 13.5.6
OLAP Catalog, 6.1.2
about, 6.1.2
OPMN
list of configuration settings in opmn.xml, A.3
opmnctl script, A.1
ORBDebug, A.3
ORBDebugLevel, A.3
ORBLogFile, A.3
settings, A.3
opmn.xml, A.1, A.1, A.1, A.3
ORA-12154 error message, D.1.4
Oracle Application Server
and OracleBI Discoverer, 2.1
Oracle Application Server Control
changing database passwords, 5.1.1, 5.1.1, 5.1.1
creating public connections, 5.1.1
query progress delay, 5.1.1, 5.1.1
stylesheet pooling, 5.1.1, 5.1.1
Oracle Applications, 15.1
and OracleBI Discoverer, 15
AppsFNDNAM, 15.3
AppsGWYUID, 15.3
certification, D.1.2
configuration settings, 15.3
DBC files, 15.1
FND_SECURE, A.3
FND_TOP, A.3
using Discoverer with, 15.1
Oracle e-Business Suite login, 14.4, 15.1
Oracle Enterprise Manager
enabling private connections, 4.8
Oracle Jar Cache, 3.4
OracleAS Framework Security
and Discoverer, 14.6
OracleAS Portal
about, 11.1
integration with Discoverer, 11.2
running Viewer over HTTPS, 11.3
security example, 14.7.2.3
test URL for Discoverer Portlet Provider, 11.2
OracleAS Web Cache
about, 8.1
benefits, 8.2, 8.2
creating a caching rule, 8.5.1
enabling, 8.5.2
how does it work?, 8.3
how it works, 8.3
session binding, 7.5.2.3
using Viewer with, 8.4, 8.5
OracleBI Discoverer
about Discoverer Plus, 1.1
about Discoverer Viewer, 1.1
about Portlet Provider, 11.1
OracleBI standalone CD, 2.1
OssoIPCheck, 11.1
out of memory issues
troubleshooting, D.1.8

P

parameter values
troubleshooting, D.1.15
password
prompting for with URL parameters, 13.5.5
peekSleepIntervalSec
setting, A.2
performance, 12.3.12
about Discoverer and performance, 12.1
Discoverer Portlet Provider, 12.3.12
enabling Web Cache, 8.5.2
how to improve Discoverer's performance, 12.3
by basing lists of values on tables containing distinct values, 12.3.8
by changing cache settings, 12.3.9
by increasing the size of the array used to fetch rows from the database, 12.3.7
by reducing the time taken to display business areas and folders, 12.3.2
by scheduling worksheets to run overnight, 12.3.10
by setting the Case Storage item property appropriately, 12.3.6
by using Discoverer Administrator hints, 12.3.5
by using OracleAS Web Cache, 12.3.11
by using summary folders, 12.3.3
reducing the size of reports, 10.6, 10.6
swap space., 12.3.13
troubleshooting, 12.3.13
Plastic look and feel, 9.1.1
pop-up stoppers
troubleshooting, D.1.5
port numbers for Discoverer, 5.8
portals, 11.1
ports, 5.8
Preference server
configuring, A.3
preferences
about Discoverer preferences?, 10.1
about Discoverer system preferences, 10.2
about Discoverer user preferences, 10.3
converting file format, 10.7
convertreg.pl script, 10.7
EnableWebQueryRun, 10.6
Endian format, 10.7
ExportToWebQuery, 10.6
how to set for specific users, 10.5
how to set user preferences for all users, 10.4
list of Discoverer user preferences, 10.6
migrateprefs script, B.5.1
migrating, 10.8, B.5.1
upgrading Discoverer, 10.8
WebQueryBaseURL, 10.6
Preferences component of Discoverer Services, 1.8.2.2
pref.txt, A.1, A.1, A.1, A.1, A.1, A.1
PrintHeadersOnce preference, 10.6
printing
reducing the size of reports, 10.6, 10.6
printing large worksheet titles, 10.6
private connections
about, 4.2.1
for OLAP data, 6.3.8
not allowed, 13.3.1, 13.7
URL parameters for, 13.3.1, 13.7
privileges
granted to PUBLIC, C.1
granted to the Discoverer manager, C.2
required for Discoverer, 3.4
public connections
about, 4.2.2
not allowed, 13.3.1, 13.7
URL parameters for, 13.3.1, 13.7

Q

query prediction and performance, 12.3.13

R

redirect onflicts, D.1.16
reg_key.dc, A.1, A.1, A.1
reports
reducing the size of reports, 10.6, 10.6
RMI error
troubleshooting, D.1.7
running Discoverer Plus in IE, 3.8
running Discoverer Plus in Netscape, 3.9
running Discoverer Viewer, 3.11

S

Safari browser, 3.6
required JVM, 5.9
running Discoverer Plus, 3.6
scalability
troubleshooting, 12.3.13
scalable architecture of Discoverer
how to take advantage of
specifying OC4J memory usage parameters, 12.4.1
specifying the number of OC4J processes, 12.4.2
using the scalability features of OracleAS, 12.4
Secure Sockets Layer (SSL), 3.5
security
about, 14
database level, 14.2
disabling Discoverer Plus, 3.3, 4.8
disabling private connections, 3.3, 4.8
Discoverer Plus, 14.6.3
Discoverer Viewer, 14.6.2
encryption, 14.9.7
FND_SECURE, A.3
FND_TOP, A.3
installing certificates, 3.5
network level, 14.6
non-standard signing authority, 14.6.3.1
private connections not allowed, 13.3.1, 13.7
protocols, 14.6.3, 14.6.3.2
running Discoverer, 3.3, 4.8
security settings for Discoverer Plus, 3.6
session binding
in OracleAS Web Cache, 7.5.2.3
Session component, 1.8.2.2
Session component of Discoverer Services, 1.8.2.1
session ID
in logs, D.2.1
session pooling, 5.1.1, 5.1.1, 5.1.1
session timeout, A.3
session timeout in Discoverer Plus, 10.6.2
session timeout in Discoverer Viewer, 10.6.3
session-timeout value, 10.6.2
signing authority, 14.6.3.1
Single Sign-On
about, 14.7.2
OracleAS Portal example, 14.7.2.3
Single Sign-On (SSO)
about, 14.7.2
and Discoverer, 14.7.2.1
details propagation, 14.8
enabling for Oracle Applications users, 15.2
how to enable and disable, 14.7.2.1
mod_osso.conf, 14.7.2.1
troubleshooting, D.1.16
why enable or disable, 8.5
SMTP Server for Discoverer Viewer, D.1.10
SSL
enabling, 3.5, 14.6
ssl_enabled setting in OPMN.XML, A.3
troubleshooting, D.1.16
starting Discoverer with URL parameters, 13.1
summaries and performance, 12.3.13
Sun Java Plug-in alerts, 3
swap space and performance, 12.3.13
switchWorksheetBehavior flag, A.2

T

TAO ORB
defaults, A.3
settings, A.3
temporary file
for exports, A.3
testing
Discoverer portlet provider, 11.2
tiered architecture of Discoverer
Client tier (Plus and Viewer), 1.7
Database tier (Plus and Viewer), 1.9
Discoverer Services tier (Plus and Viewer), 1.8
Timeout
about setting in Discoverer Viewer, 10.6.3
in Discoverer Plus, 10.6.2
in Discoverer Viewer, 10.6.2
preferences, 10.6.2, 10.6.2
session timeout, 3.6, 10.6
setting timeout values, 10.6.2
timeout
Apache, A.1
Web server, A.1
titles
printing large worksheet titles, 10.6
tnsnames.ora, A.1, A.1, A.1, A.1, A.1, A.1, A.1, A.1, A.1, A.1
about, 7.7
editing, 7.7, A.1, A.1, A.1
troubleshooting, D.1
connections not available, D.1.21
customizing Discoverer Viewer, D.1.23
database users, 12.3.13
Discoverer memory, 12.3.13
Discoverer Plus Relational help, D.1.9
Discoverer Viewer Send as email option, D.1.10
graph display in Discoverer Viewer, D.1.19
HTTPS, D.1.7
index value for parameters, D.1.15
logging, 12.3.13
MS Internet Explorer v6.0, D.1.1
Netscape V4.x, D.1.6
network errors, D.1.3
OC4J_BI_forms JVM, D.1.18
ORA-12154 error, D.1.4
Oracle Applications certification, D.1.2
out of memory error, D.1.8
parameter values, D.1.15
performance and scalability, 12.3.13
Plastic look and feel, 9.1.1
pop-up stoppers, D.1.5
query prediction, 12.3.13
redirect conflicts, D.1.16
RMI error, D.1.7
summaries, 12.3.13
swap space, 12.3.13
workbooks, 12.3.13
XSL files, D.1.23

U

upgradeMR script, A.1
location, A.1
using, 2.3.1
upgrading
Discoverer preferences, 10.8
upgrading Sun Java Plug-in, 3
URL parameters
character limits, 13.2
example of starting Plus OLAP, 13.5.6
for Discoverer Plus OLAP, 6.7
opening OLAP worksheets in Discoverer Viewer, 6.8
prompting for a password, 13.5.5
specifying workbooks and worksheets, 13.4
syntax, 13.2
URL parameters common to Plus and Viewer, 13.7
why use URL parameters?, 13.1
Users Personal Profile Space, 3.4

V

Virtual Private Database (VPD), 14.8
VPD, 14.8
with a multidimensional data source, 14.8
with a relational data source, 14.8

W

Web Cache
see OracleAS Web Cache
Web Query
about, 5.10
configuring Discoverer, 5.10
enabling export to, 10.6
file association, 5.10
format limitations, 5.10
minimum required Excel version, 5.10
response messages, 10.6
Web server
timeout, A.1
web.xml, 10.6.3, A.1
workbook ID
how to find out, 13.4.1, 13.4.1
workbooks and performance, 12.3.13
worksheet
URL parameter for OLAP worksheet, 6.8
worksheet ID
how to find out, 13.4.2
worksheet layout
padding cells, 10.6
printing large title, 10.6