Oracle9i OLAP Services Concepts and Administration Guide
Release 1 (9.0.1)

Part Number A88755-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

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

Go to previous page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback