Oracle9
i
OLAP Services Concepts and Administration Guide
Release 1 (9.0.1)
Part Number A88755-01
Home
Book List
Contents
Master Index
Feedback
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
W
X
A
access rights, 3-27
administration privileges, 4-11
Instance Manager, 3-9
agent.
See
OLAP Services Agent
aggregate data
storage options, 2-12
analytic workspace character set, 5-5
applications support, A-3
attributes
creating, 4-14
defined, 4-7
editing, 4-22
authentication, 3-14
B
batch processing, 3-23
Beans
described, 2-5
BLOB, 4-10
C
caching, 2-9
certificates, 1-7
character set
defined, 5-2
character set encoding, 5-3
character sets, 5-7
Asian, 5-12
European, 5-13
Middle Eastern, 5-16
CHARSET option, A-6
charts
performance statistics, 6-6
client character set, 5-6
CLOB, 4-10
collection cartridge, 6-6
Common Object Request Broker Architecture (CORBA), 2-10
configuration parameters
changing, 3-12
default settings, 3-12
configuration settings
defined, 3-11
CONNECT role, 3-27
CONNECT THROUGH system privilege, 3-27
connection problems, 3-14
constraints, 4-6
counters, 6-6
performance statistics, 6-6
crosstab bean, 2-7
cube viewer, 4-18
cubes
defined, 4-16
editing, 4-22
viewing, 4-18
cursors, 2-9
custom measures, 2-8
D
data formatting, 2-6
Data Gatherer Cartridge Support module, 6-6
data storage, 2-11
data structure comparison, 4-5
data types, 4-10
data warehouse
defined, 4-2,
4-8
database requirements, 4-8
DBA user, 3-14
derived data, 4-3
Diagnostic Pack, 6-6
dimension hierarches.
See
hierarchies
dimension tables, 4-3
dimensions
creating, 4-14
defined, 4-6
defining, 4-13
editing, 4-22
time, 4-8,
4-14
disk assignments, 3-12
drilling
described, 2-6
E
eim.properties file, 3-28
end-date attributes, 4-8
environment variables, 3-7
ETT tool
defined, 4-2
EventLogPath setting, 3-18
Express Common Metadata (ECM), A-1
Express databases
upgrading, A-2
Express Relational Access Administrator, A-3
Express Relational Access Manager, A-3
Express services
creating, 3-21
Express Web Agent support, A-3
F
fact tables, 4-3,
4-6
failure to start, 3-7
files
disk assignments, 3-12
formatting
data, 2-6
FreePageHighCount, FreePageLowCount settings, 6-2
G
global counters, 6-6
globalization, 5-2
Globalization Technology .
See
NLS, A-5
graph bean, 2-7
graphs
performance statistics, 6-6
H
hardware recommendations, 6-2
hierarchies, 4-3
creating, 4-14
defined, 4-7
historical data, 4-2
HOLAP
defined, 2-12
I
IDE
defined, 2-2
indexing, 6-4
Instance Administration Privilege, 3-9
Instance character set, 5-8
instance character set, 5-5,
5-6
choosing, 5-7
Instance Manager
basic usage, 3-3 to ??
configuration, 3-27
described, 3-3
navigation, 3-4
opening, 3-3
startup properties, 3-27
instances.
See
Express services
Intelligent Agent, 6-6
internationalization, 5-2
J
Java
described, 1-4,
2-1
JavaBeans
defined, 1-5
JDeveloper
described, 2-2
K
keys
affect of data type on performance, 6-4
L
language
defined, 5-2
languages, 5-10
LDAP
defined, 1-7
levels
creating, 4-14
defined, 4-7
locale
defined, 5-8
localization
defined, 5-2
log files, 3-18,
3-29
LONG RAW, 4-10
lookup tables.
See
dimension tables
M
materialized views, 4-3,
4-23,
6-5
creating, 4-26
MDI
defined, 2-2
measure folders
defined, 4-19
measures
custom, 2-8
defined, 4-6
editing, 4-22
metadata
defined, 4-3
module list, 6-6
MOLAP
defined, 2-11
multibyte character sets
Express equivalents, A-6
multiple services, 3-21
N
NCHAR character handling, 5-6
NCLOB, 4-10
NLS_LANG configuration parameter, 5-8,
A-5
n-pass functions, 2-10
number formatting, 2-6
NVARCHAR character handling, 5-6
O
object-oriented programming, 2-9
ODBC support, A-3
OES_EA_STARTUP system variable, 3-29
oescmd command, A-5
oesmgr command, A-5
OLAP
defined, 1-2
OLAP Agent, 3-19
OLAP API
described, 2-9
OLAP beans, 2-6,
2-8
OLAP management tool, 4-10
OLAP Service Manager
description, 3-23
running interactively, 3-24
OLAP Services
defined, 1-6
starting, 3-5
stopping, 3-8
OLAP services
multiple instances, 3-12
starting, 3-5
stopping, 3-8
OLAP Services Administration Privilege, 3-9
OLAP Services Agent, 3-28
OLAP Services Instance Manager.
See
Instance Manager
OLAP Worksheet, A-3
OLAP_DBA role, 3-9,
4-11
OLAPDBA user, 3-14
OLAPEvent.log file, 3-18
olap.prm file, 3-7
OlapProxyPwd/OlapProxyUID, 3-14
olap.sh script, 3-2,
3-29
OLAPSVR user, 3-14
OLTP
defined, 1-1
Oracle Enterprise Manager
Capacity Planner, 6-6
OLAP Services Instance Manager, 3-3
Performance Manager, 6-6
Oracle Enterprise Manager Diagnostic Pack, 6-6
Oracle Globalization Technology.
See
NLS, 5-2
Oracle Internet Directory, 1-7
OverWriteEventLog setting, 3-18
P
paging
described, 2-6
parameters.
See
configuration parameters
partitioning, 6-3,
6-5
passwords, 3-14
performance, 6-1
check list, 6-2
data type of keys, 6-4
performance counters, 6-6
performance statistics, 6-6
pivoting
described, 2-6
port numbers, 3-29
Presentation Beans, 2-6
proxy user, 3-14
Public Key Infrastructure, 1-7
Q
query builder, 2-8
query rewrite, 4-24,
6-5
QUERY REWRITE system privilege, 3-27
R
rank formatting, 2-7
RAW, 4-10
Relational Access Administrator, A-3
Relational Access Manager, A-3
repository
application runtime, 2-3
database's user, 1-7
Instance Manager, 3-9
requirements
data warehouse, 4-8
result sets, 2-9
ROLAP
defined, 2-11
roles, 3-27
root.sh script, 3-2
S
schemas
star, snowflake defined, 4-4
scripts
starting, 3-23
security
user authorization, 1-7
SELECT privilege, 3-27
ServerDBPath setting, 3-7
service directory, 3-7
service environment, 3-2
initializing, 3-2
log files, 3-18
service identifiers, 3-12
services
See also
Express services
sessions
terminating, 3-17
SNAPI support, A-3
socket communications, 3-28
SQL-99 extensions, 1-4
SSL
defined, 1-7
startup failure, 3-7
status messages, 3-18,
3-18 to
3-20
stoplight formatting, 2-7
striping, 6-3,
6-5
Summary Advisor, 4-24
summary tables.
See
materialized views
T
table bean, 2-7
termination
procedure, 3-8
territories, 5-10
territory
defined, 5-2
thick-client applications
defined, 2-2
diagram, 2-4
illustrated, 2-3
thin-client applications
defined, 2-2
diagram, 2-4
illustrated, 2-4
tiers, 2-3,
2-4
time dimensions, 4-8,
4-14
time periods
regular, irregular defined, 4-8
timeout delay, 3-28
time-span attributes, 4-9
translation tables, A-6
troubleshooting
connections from OLAP API, 3-14
log files, 3-18
startup, 3-7
tuning
checklist, 6-2
data warehouse, 6-3
U
Unicode
defined, 5-4
UPDATECHARSET argument, A-2
user access rights, 3-27
user counters, 6-7
user sessions
terminating, 3-17
UTF-8 encoding, 5-4
W
wizards
Beans, 2-8
workspace character set, 5-5,
A-2
X
X.509 certificates, 1-7
XCA support, A-3
xscosvc command, A-5
xscosvc program
running OLAP Service Manager, 3-24
Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.
Home
Book List
Contents
Master Index
Feedback