Index

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

A

access rights, 6.3.3

active catalogs, 5.2.1

ALL_ATTRIBUTES dimension, A.7.1.6

ALL_ATTRTYPES dimension, A.7.2.2

ALL_CUBES dimension, A.7.1.1

ALL_DESCRIPTIONS variable, A.8.1

ALL_DESCTYPES dimension, A.7.2.1

ALL_DIMENSIONS dimension, A.7.1.3

ALL_HIERARCHIES dimension, A.7.1.4

ALL_LANGUAGES dimension, A.7.2.3

ALL_LEVELS dimension, A.7.1.5

ALL_MEASURES dimension, A.7.1.2

ALL_OBJECTS dimension, A.7.1.7

allocation, B.3

ALTER SESSION commands, 6.5

analysis tools

described, 1.4

analytic capabilities

compared, 1.7.4

Analytic Workspace Java API, 5.5, 7.1.3

Analytic Workspace Manager, 3

analytic workspaces

basic process overview, 1.9

basic steps for creating, 3.4.2

best practices, 1.7.1, 1.7.1

database storage, 6.7.1

defined, 1.6, 1.6, 1.8.2

standard form, 3.4

applications

differences from Express, B.2.1

ATTRDEF object, A.6.3.7

attributes

B

BFILE security, 6.6

BI Beans

described, 5.1.2, 5.2

relational data source, 5.4

relational data sources, 5.4

C

caches

use in iterative queries, 5.3.3

calculation engine

defined, 1.8.1

catalogs class

database standard form, A.7

character sets, B.1.4

CHARSET option, B.1.4

classes

database standard form, A.3.2

COMMIT command, B.3.3

configuration procedures, 6.1

conjoints, B.3.2

CONNECT role, 6.3.3

connect string

for Analytic Workspace Manager, 3.2.4

CREATE_DB_STDFORM program, B.4.1

crosstab bean, 5.2.5

CUBE_MEASURES valueset, A.7.3.1

CUBEDEF dimension, A.6.1.1

cubes, 1.6

defined, 7.3.3

cursors, 5.3.3

custom measures

BI Beans support, 5.2.7

CWM2

write APIs, 7.5.1

CWM2_OLAP_CATALOG package, 7.5.5

CWM2_OLAP_CUBE package, 7.5.2

CWM2_OLAP_DIMENSION package, 7.5.1

CWM2_OLAP_HIERARCHY package, 7.5.1

CWM2_OLAP_LEVEL package, 7.5.1

CWM2_OLAP_LEVEL_ATTRIBUTE package, 7.5.1

CWM2_OLAP_MEASURE package, 7.5.2

CWM2_OLAP_PC_TRANSFORM package, 7.5.4

CWM2_OLAP_VALIDATE package, 7.5.5

D

data formatting, 5.2.3

data models, 1.5

data stores

described, 1.7

data striping, 6.2

database configuration, 6.1

database security, 6.3

database standard form

described, A.1

specification, A

DEFAULT_HIER relation, A.8.2

demand planning systems, 1.3

DIM_ATTRIBUTES relation, A.7.3.4

DIM_HIERARCHIES relation, A.7.3.2

DIM_LEVELS relation, A.7.3.3

DIM_LEVELS valueset, A.7.3.4

DIMDEF dimension, A.6.3.1

dimension hierarchies

See hierarchies

dimension order

basic rules, 3.7.2

dimension tables

defining metadata, 7.3.2.1

dimensions

creating logical, 7.3.2.3

logical, 1.5.3, 7.3.2.1

time, 7.3.2.2

directories

database, 6.6

directory object, 8.5.1

drilling, 5.2.2

dynamic performance tables, 6.8

E

EDDE.HIERMNT program (obsolete), B.4.4

EDDE.MSG program (obsolete), B.4.4

EIF files, B.4

Excel add-in, 1.4

Express Connection Utility (obsolete), B.2.1

Express databases

converting to standard form, B.4

Express Relational Access Administrator (obsolete), B.1.3

Express Relational Access Manager (obsolete), B.1.3

EXTCALL (obsolete), B.3.2

extensions class

database standard form, A.9

F

fact tables

defining metadata, 7.3.3

features class

database standard form, A.8

files

allowing access, 6.6

financial applications, 1.3

forecasting commands

OLAP DML, 4.1

formatting

data, 5.2.3

G

Global Computing Company

data requirements, 2.1.1

Global star schema, 2.4

GLOBAL_AW user

defining, 3.13.1

globalization, B.1.4

Globalization Technology See NLS

graph bean, 5.2.4

H

HIER_LEVELS valueset, A.6.3.6

hierarchies

creating logical, 7.3.2.3

logical, 1.5.4

HIERLIST dimension, A.6.3.2

I

IDE

defined, 5.1.3

implementation class

database standard form, A.6

initialization parameters, 6.5

init.ora file, 6.4, 6.4

J

Java

described, 5.1

sandbox security, 5.1.1

Java APIs for OLAP, 5

JDeveloper, 5.1.3

JOB_QUEUE_PROCESSES parameter, 6.4

L

language support, B.1.4

LEVELLIST dimension, A.6.3.3

LEVELREL relation, A.6.3.4

levels

creating logical, 7.3.2.3

logical, 1.5.4

localization, B.1.4

M

materialized views

CWM2, 8.5, 8.5.1, 8.5.2

grouping sets, 8.5

MDI

defined, 5.1.3

MEASUREDEF object, A.6.2.1

measures

custom, 5.2.7

logical, 1.5.2

MEMBER_CREATEDBY variable, A.8.5

MEMBER_FAMILYREL relation, A.8.6

MEMBER_INHIER variable, A.8.4

modeling support, B.3

MOLAP

analytic operations, 1.7.4

defined, 1.7

multibyte character sets

Express equivalents, B.1.4

multidimensional data, 1.6

N

naming conventions

database standard form, A.4

NLS_LANG configuration parameter, B.1.4

n-pass functions, 5.3.2

number formatting, 5.2.3

O

object-oriented programming, 5.3

ODBC (obsolete), B.3.2

ODBC support (obsolete), B.1.3

oescmd program (obsolete), B.1.1

oesmgr program (obsolete), B.1.1

OLAP

defined, 1.2

OLAP API

described, 1.8.8, 5.1.2, 5.3

relational data source, 5.4

P

paging, 5.2.2

parameter file, 6.4

parent-child relations

described, 1.5.4

PARENTREL relation, A.6.3.5

partitioning, 6.7.1

performance counters, 6.8

Personal Express (obsolete), B.2.1

pfile settings, 6.4

PGA_AGGREGATE_TARGET parameter, 6.4

PGA_TARGET parameter, 6.4

pivoting, 5.2.2

predictive analysis applications, 1.3

Presentation Beans, 5.2

PS$ tables, 6.7.2

Q

query builder, 5.2.7

QUERY REWRITE system privilege, 6.3.3

query tools

described, 1.4

R

random sparsity, definition, 3.7.1.1

regressions

OLAP DML, 4.1

Relational Access Administrator (obsolete), B.1.3

Relational Access Manager (obsolete), B.1.3

relational data sources, 5.4, 5.4, 8

relational schema

best practices, 1.7.2

result sets, 5.3.3

ROLAP

analytic operations, 1.7.4

defined, 1.7

roles, 6.3.3

ROLLUP command, B.3.2, B.4.1.1

S

schemas

star, snowflake, 7.3, 8.2

SELECT privilege, 6.3.3

server parameter file, 6.4

session sharing, B.2.2

SESSIONS parameter, 6.4

SNAPI (obsolete), B.3.2

SNAPI communications (obsolete), B.2.2

sparsity characteristics, 3.13.2

sparsity pattern, definition, 3.7.1.1

Spreadsheet Add-In

described, 1.4

SQL analytic operations, 1.7.4

SQL command (OLAP DML), B.1.3

SQL interface, 1.8.5

standard form

see database standard form

startup parameters

database, 3.14.2

stoplight formatting, 5.2.3

striping, 6.2

summary data

creating, 1.6.2

summary data methods

compared, 1.7.5

system properties

database standard form, A.5.1

T

tablespaces

defining, 3.14.3

for analytic workspaces, 6.2

Time attributes

creating for converted Express databases, B.4.3

time dimensions, 7.3.2.2

translation tables, B.1.4

U

UNDO_MANAGEMENT parameter, 6.4

UNDO_TABLESPACE parameter, 6.4

Unicode, B.1.4

UPDATE command, B.3.3

user access rights, 6.3.3

user names, 6.3

UTL_FILE_DIR parameter, 6.4, 8.5.1

V

VISIBLE variable, A.8.3

W

wizards

BI Beans, 5.2.7

X

XCA (obsolete), B.3.2

XML metadata, 5.5, 7.1.3

XPDDDATA database (obsolete), B.4.4