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

aggregation, 7

average operator, 7.1

definition, 7.1

hierarchical average operator, 7.1

hierarchical operators, 7.1

objects, 7.5

performance issues, 7.3.3

status (regular composites only), 7.4

sum operator, 7.1

weighted operators, 7.1

aggregation methods

dimensional, 7.2.2

relational, 7.2.1

aggregation operators

comparison with allocation operators, 8.5.4

defined, 7.6

aggregation strategies

basics, 7.3

compressed composites, 7.3.2

regular composites, 7.3.1

skip-level, 7.3.1.1

ALL_AW_OBJ view, 6.8.3

ALL_AW_PROP view, 6.8.3

ALL_AW_PS view, 6.8.3

ALL_AWS view, 6.8.3

allocation, 8

basis measures, 8.2.2

creating, 8.4

even operator, 8.1, 8.1

proportional operator, 8.1

source measures, 8.2.1

status, 8.3, 8.3.1

target measures, 8.2.3

weight measures, 8.2.4

allocation operators

comparison with aggregation operators, 8.5.4

descriptions, 8.5

ALTER SESSION commands, 6.5

analysis tools

described, 1.4

analytic capabilities

compared, 1.5.3

Analytic Workspace Java API, 4.3

Analytic Workspace Manager, 5

opening, 5.2.2

analytic workspaces

basic process overview, 1.7

basic steps for creating, 5.4.2

creating, 5.4.2

database storage, 6.8.1

defined, 1.5, 1.5, 1.6.2

enhancing functionality, 5.4.3

standard form, 5.4

analytic workspaces, listing, 6.7.2

analytic workspaces, size, 6.7.3, 6.7.3

attributes

creating, 5.5.3.2

description, 5.5.3

logical, 2.6

authentication, 6.3

average operator (aggregation), 7.1

AW$ tables, 6.8.2

AW$AWCREATE10G table, 6.8.2

AW$AWMD table, 6.8.2

AW$AWXML table, 6.8.2

AW$EXPRESS table, 6.8.2

AWXML package, 4.3

B

backup options, for analytic workspaces, 6.10

basis measures (allocation), 8.2.2

batch processing, 5.9.1

BFILE security, 6.6

BI Beans

described, 4.1.2, 4.2

build tools, 5.3.2

C

calculated measures

creating, 5.6.3

calculation engine

defined, 1.6.1

calculation plan

allocation step, 8.4

forecast, 9.4

calculation plans

creating, 5.12

forecast steps, 9.4.5

causal analysis, 9.2.2

changes

saving, 5.4.1

composites

description, 5.8.4

compressed cubes

data characteristics, 5.8.1

configuration procedures, 6.1

CONNECT role, 6.3.3

connect string

for Analytic Workspace Manager, 5.2.4

connections

defining, 5.2.3

copy allocation operators, 8.5.1

creation, analytic workspaces, 6.7.5

crosstab bean, 4.2.5

cubes, 1.5

creating, 5.6.1

description, 5.6

mapping, 5.7.2

custom measures

BI Beans support, 4.2.7

D

data dictionary views, 6.8.3

data formatting, 4.2.3

data maintenance, 5.9

data mapping requirements, 5.3.1

Data Mining

forecasting, 9.2.2

data models, 2.1

data sources

mapping, 5.7

data striping, 6.2

data transformations, 5.3.1.4

data types, 5.8.3

database configuration, 6.1

database connections

defining, 5.2.3

database security, 6.3

DBA scripts download, 6.9

DBA_AW_OBJ view, 6.8.3

DBA_AW_PROP view, 6.8.3

DBA_AW_PS view, 6.8.3

DBA_AWS view, 6.7.2, 6.8.3

DBA_OBJECTS view, 6.7.5

DBA_REGISTRY view, 6.7.1

DBMS_LOB package, 6.7.3

DBMS_METADATA package, 6.7.4

DECIMAL data type, 5.8.3

comparison with NUMBER, 7.3.3.2

demand planning systems, 1.3

dimension hierarchies

See hierarchies

dimension members

selecting (allocation), 8.3

selecting for aggregation, 7.4

dimension order

basic rules, 5.8.2

dimensions

creating, 5.5

description, 5.5

logical, 2.4

directories

database, 6.6

Discoverer Plus OLAP, 5.5.3.1

drilling, 4.2.2

dump files, 6.10

dynamic performance tables, 6.9

E

edits

saving, 5.4.1

EIF files, 6.10

even distribution allocation operators, 8.5.2

even operator (allocation), 8.1, 8.1

Excel add-in, 1.4

expert opinion in forecasting, 9.2.3

Expert System, 9.5.1

extensibility using plug-ins, 5.14

F

files

allowing access, 6.6

financial applications, 1.3

forecast

creating, 9.4

forecast steps

creating, 9.4.5

forecasting, 9

applications, 9.3

Data Mining, 9.2.2

dimension levels, 9.4.4

Expert System, 9.5.1

time horizons, 9.2

verification window, 9.5.2, 9.5.2

formatting

data, 4.2.3

G

Global Computing Company

data requirements, 3.1.1

Global schema

downloading, 5.15

Global star schema, 3.4

GLOBAL_AW user

defining, 5.15.1

graph bean, 4.2.4

H

hierarchical average (aggregation), 7.1

hierarchical average operator (aggregation), 7.1

hierarchies

creating, 5.5.2

description, 5.5.2

logical, 2.5

I

IDE

defined, 4.1.3

initialization parameters, 6.4, 6.5

init.ora file, 6.4, 6.4

installation of OLAP option, validating, 6.7.1

J

Java

described, 4.1

sandbox security, 4.1.1

Java APIs for OLAP, 4

JDeveloper, 4.1.3

job queue, 5.9.1

JOB_QUEUE_PROCESSES parameter, 5.9.1, 6.4

JVM access, 6.3.4

L

language support, 5.11

level-based dimensions, 5.5

levels

creating, 5.5.1

logical, 2.5.1

loading data, 5.9

localization, 5.11

logical objects

mapping, 5.7

M

maintenance, 5.9

Maintenance Wizard, 5.9

mapping requirements, 5.3.1

mappings

creating, 5.7, 5.7.1

MDI

defined, 4.1.3

measure folders

creating, 5.10

measures

creating, 5.6.2

custom, 4.2.7

logical, 2.3

model

saving, 5.13

MOLAP

analytic operations, 1.5.3

multidimensional data, 1.5

N

natural keys, 5.5

normal hierarchies, 5.5.2

NUMBER data type, 5.8.3

comparison with DECIMAL, 7.3.3.2

number formatting, 4.2.3

O

objects

mapping, 5.7

OLAP

defined, 1.2

OLAP API

described, 1.6.8, 4.1.2

OLAP Beans, 4.2, 4.2.6

OLAP DML

described, 1.6.5

OLAPSYS.XML_LOAD_LOG file, 5.9.2

OLTP

defined, 1.2

OPEN_CURSORS parameter, 6.4

optimization techniques, 6.2

Oracle Java Virtual Machine access permissions, 6.3.4

Oracle Warehouse Builder, 5.3.2

OracleBI Beans, 5.5.3.1

owners, identifying for analytic workspaces, 6.7.2

P

paging, 4.2.2

parameter file, 6.4

parent-child relations

described, 2.5.1

partitioning, 6.8.1

benefits, 5.8.5

description, 5.8.5.3

performance checklist, 7.3.3.3

performance counters, 6.9

permissions

JVM, 6.3.4

pfile settings, 6.4

PGA_AGGREGATE_TARGET parameter, 6.4, 7.3.3.1

PGA_TARGET parameter, 6.4

pivoting, 4.2.2

plug-ins, 5.14

predictive analysis applications, 1.3

Presentation Beans, 4.2

proportional allocation operators, 8.5.3

proportional operator (allocation), 8.1

PS$ tables, 6.8.2

Q

query builder, 4.2.7

QUERY REWRITE system privilege, 6.3.3

query tools

described, 1.4

R

ragged hierarchies, 5.5.2

refreshing data, 5.9

response time

improving, 7.3.3.3

ROLAP

analytic operations, 1.5.3

roles, 6.3.3

S

scheduling maintenance, 5.9.1

schema requirements, 5.3.1

SELECT privilege, 6.3.3

server parameter file, 6.4

SESSIONS parameter, 6.4

SGA_TARGET parameter, 7.3.3.1

size, analytic workspace, 6.7.3, 6.7.3

skip-level aggregation, 7.3.1.1

skip-level hierarchies, 5.5.2

snowflake schema

description, 5.3.1.2

source data, 5.3

source measures (allocation), 8.2.1, 8.2.1

sparsity

description, 5.8.1

Sparsity Advisor, 5.6, 5.8

Spreadsheet Add-In, 5.5.3.1

described, 1.4

SQL analytic operations, 1.5.3

SQL interface, 1.6.6

star schema

description, 5.3.1.1

startup parameters

database, 5.16.2

static data dictionary views, 6.8.3

status

aggregation, 7.4, 7.4

allocation, 8.3, 8.3.1

stoplight formatting, 4.2.3

storage, analytic workspace, 6.7.4

striping, 6.2

sum operator (aggregation), 7.1

summary data methods

compared, 1.5.4

surrogate keys, 5.5

T

tablespaces

defining, 5.16.3

for analytic workspaces, 6.2

target measures (allocation), 8.2.3

templates

logical model

saving, 5.13

time dimensions, 5.5

time-series forecasting, 9.2.1

transformations

data, 5.3.1.4

transportable tablespaces, 6.10

U

UNDO_MANAGEMENT parameter, 6.4

UNDO_TABLESPACE parameter, 6.4

user access rights, 6.3.3

user names, 6.3

USER_AW_OBJ view, 6.8.3

USER_AW_PROP view, 6.8.3

USER_AW_PS view, 6.8.3

USER_AWS view, 6.8.3

users, creating (example), 5.15.1

V

V$AW_AGGREGATE_OP view, 6.9

V$AW_ALLOCATE_OP view, 6.9

V$AW_CALC view, 6.9

V$AW_LONGOPS view, 6.9

V$AW_OLAP view, 6.9

V$AW_SESSION_INFO view, 6.9

value-based dimensions, 5.5

value-based hierarchies, 5.5.2

verification window, 9.5.2, 9.5.2

W

Warehouse Builder, 5.3.2

weight measures (allocation), 8.2.4

weighted sum (aggregation), 7.1

wizards

BI Beans, 4.2.7

X

XML metadata, 4.3