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

Active Catalog, 11.2.1

aggregation

average operator, 8.1

calculated measures, 4.6.2

definition, 8.1

hierarchical average operator, 8.1

hierarchical operators, 8.1

over attributes, 4.6

performance issues, 8.7

status (regular composites only), 8.6

sum operator, 8.1

weighted operators, 8.1

aggregation operators, 4.6

comparison with allocation operators, 9.5.4

defined, 8.2

aggregation strategies

compressed composites, 8.4

regular composites, 8.5

skip-level, 8.5.1

ALL_AW_OBJ view, 12.4.1

ALL_AW_PROP view, 12.4.1

ALL_AW_PS view, 12.4.1

ALL_AWS view, 12.4.1

allocation, 9

basis measures, 9.2.2

creating, 9.4

even operator, 9.1, 9.1

proportional operator, 9.1

source measures, 9.2.1

status, 9.3, 9.3.1

target measures, 9.2.3

weight measures, 9.2.4

allocation operators

comparison with aggregation operators, 9.5.4

descriptions, 9.5

ALTER SESSION commands, 12.1

analysis tools, 1.3

analytic functions, 6.2

Analytic Workspace Java API, 11.3

Analytic Workspace Manager, 3

installation, 2.4.1

opening, 2.4.2

analytic workspaces

basic steps for creating, 3.3.1

creating, 3.3.1

database storage, 12.4.3

defined, 1.2

disk space consumption, 12.6.5

enhancing functionality, 3.3.2

listing, 12.6.2.2

size, 12.6.2.3, 12.6.2.3

Application Express, 1.3, 10.3

attribute aggregation, 4.6

attributes

creating, 3.4.3.2

description, 3.4.3

logical, 1.5.5

authentication, 2.3

Automatic Database Diagnostic Monitor, 12.6

Automatic Storage Management, 12.2.4

Automatic Workload Repository, 12.6

average operator (aggregation), 8.1

AW$ tables, 12.4.2

AW$AWCREATE10G table, 12.4.2

AW$AWMD table, 12.4.2

AWXML package, 11.3

B

backup and recovery, 12.7

backup options

for analytic workspaces, 12.8

basis measures (allocation), 9.2.2

batch processing, 12.5.2

BI Beans

described, 11.1.2, 11.2

BI Publisher, 10.2

bind variables, 10.1, 10.2.4.3, 10.3.2.4, 10.3.3.2

branches (Application Express), 10.3.2.3

build log, 3.4.5

C

calculated measures

creating, 6.2

defined, 6.1

calculation plan

allocation step, 9.4

forecast, 7.4

calculation plans

creating, 6.5

forecast steps, 7.4.5

Calculation Wizard, 1.4.2

calculations

in queries, 4.5

causal analysis, 7.2.2

changes

saving, 3.3.3

character functions, 4.3.3

column links, 10.3.3.3

connect string

for Analytic Workspace Manager, 2.4.4

connections

defining, 2.4.3

copy allocation operators, 9.5.1

CREATE SESSION privilege, 2.3, 2.3

creation

analytic workspaces, 12.6.2.4

crosstab bean, 11.2.5

cubes, 1.2

creating, 3.5

description, 3.5

mapping, 3.5.2

custom measures

BI Beans support, 11.2.7

D

dashboard, 1.3

data

displaying, 3.5.5

data dictionary views, 12.4.1

data display, 3.4.6

data formatting, 11.2.3

data loads, 3.4.5, 3.5.4

Data Mining

forecasting, 7.2.2

data model

designing, 3.1

data models, 1.5

Data Pump, 12.8

data sources

mapping, 3.4.4

database connections

defining, 2.4.3

Database Control, 12.6

database integration, 1.1.1

database security, 2.3

DBA scripts download, 12.6.3

DBA_AW_OBJ view, 12.4.1

DBA_AW_PROP view, 12.4.1

DBA_AW_PS view, 12.4.1

DBA_AWS view, 12.4.1, 12.6.2.2

DBA_OBJECTS view, 12.6.2.4

DBA_REGISTRY view, 12.6.2.1

DBMS_LOB PL/SQL package, 12.6.2.3

DECIMAL data type

comparison with NUMBER, 8.7.2

dimension hierarchies

See hierarchies

dimension members

selecting (allocation), 9.3

selecting for aggregation, 8.6

dimensions

creating, 3.4

description, 3.4

logical, 1.5.3

viewing members, 3.4.6

Discoverer Plus OLAP, 1.4, 3.4.3.1

disk

spreading data, 12.2.4

disk space consumption, 12.6.5

displaying data, 3.5.5

drillable reports, 10.2

drilling, 4.3.3, 10.3.3.3, 11.2.2

drilling (Application Express), 10.3.3

dump files, 12.8

dynamic performance tables, 12.6.1

E

edits

saving, 3.3.3

Enterprise Manager Database Control, 12.6

even distribution allocation operators, 9.5.2

even operator (allocation), 9.1, 9.1

Excel add-in, 5.1

EXP_FULL_DATABASE privilege, 12.8

expert opinion in forecasting, 7.2.3

Expert System, 7.5.1

extensibility using plug-ins, 2.4.5

EXTENT MANAGEMENT LOCAL, 12.2

F

filtering queries, 4.3.1

forecast steps

creating, 7.4.5

forecasting, 7

applications, 7.3

Data Mining, 7.2.2

dimension levels, 7.4.4

Expert System, 7.5.1

time horizons, 7.2

verification window, 7.5.2, 7.5.2

forecasts

creating, 7.4

formatting

data, 11.2.3

G

Global Computing Company

data requirements, A.1.1

Global schema

download, 2.1

graph bean, 11.2.4

H

hidden items (Application Express), 10.3.3.1

hierarchical average (aggregation), 8.1

hierarchical average operator (aggregation), 8.1

hierarchical queries, 4.3.3

hierarchies

creating, 3.4.2

description, 3.4.2

logical, 1.5.4

I

IDE

defined, 11.1.3

initialization parameters, 12.1, 12.1

init.ora file, 12.1, 12.1

installation

Analytic Workspace Manager, 2.4.1

installation of OLAP option

validating, 12.6.2.1

integration in database, 1.1.1

J

Java

described, 11.1

sandbox security, 11.1.1

Java APIs for OLAP, 11

JDeveloper, 11.1.3

JOB_QUEUE_PROCESSES parameter, 12.1, 12.5.2

L

language support, 3.7

layout template (BI Publisher), 10.2.1

level-based dimensions, 3.4

levels

creating, 3.4.1

logical, 1.5.4.1

loading data, 3.4.5, 3.5.4

localization, 3.7

LOVs (list of values), 10.2.4, 10.3.2.2

M

Maintenance Wizard, 3.4.5, 3.5.4

mappings

creating, 3.4.4

MDI

defined, 11.1.3

measure folders

creating, 3.6

measures

creating, 3.5.1

custom, 11.2.7

logical, 1.5.2

model

saving, 3.8

multidimensional data, 1.2

N

natural keys, 3.4

normal hierarchies, 3.4.2

NUMBER data type

comparison with DECIMAL, 8.7.2

number formatting, 11.2.3

O

objects

mapping, 3.4.4

OLAP API

described, 11.1.2

OLAP option

verifying installation, 12.6.2.1

OLAP_DBA role, 2.3

OLAP_USER role, 2.3, 2.3

OLAPSYS.XML_LOAD_LOG file, 12.4.4

Oracle Application Express, 1.3

Oracle Business Intelligence

OracleBI Discoverer Plus OLAP, 1.4

OracleBI Spreadsheet Add-In, 1.4

Oracle Real Application Clusters, 1.1.4, 12.5.2

Oracle Recovery Manager, 12.7

OracleBI Beans, 3.4.3.1, 11.2, 11.2.6

owners

identifying for analytic workspaces, 12.6.2.2

P

page definition (Application Express), 10.3.2

paging, 11.2.2

parallel processing, 12.5.2

parameter file, 12.1

parent-child relations, 1.5.4.1

partitioning

benefits, 3.5.3.1

description, 3.5.3.3

Partitioning Advisor, 3.5.3.1

partitioning strategies, 3.5.3.2

performance checklist, 8.7.3

performance counters, 12.6.1

pfile settings, 12.1

PGA_AGGREGATE_TARGET parameter, 8.7.1, 12.1

PGA_TARGET parameter, 12.1

pivoting, 11.2.2

plug-ins, 2.4.5

Presentation Beans, 11.2

proportional allocation operators, 9.5.3

proportional operator (allocation), 9.1

PS$ tables, 12.4.2

Q

queries

filtering, 4.3.1

query builder, 11.2.7

query tools, 1.3

Query Wizard, 1.4.1

querying dimensions and cubes, 4.1

R

RAC, 1.1.4, 12.5.2

ragged hierarchies, 3.4.2

report entry (BI Publisher), 10.2.1

report layout (BI Publisher), 10.2.3

reports, 10.2

response time

improving, 8.7.3

RMAN, 12.7

S

sample schema

download, 2.1

scheduling maintenance, 12.5.2

server parameter file, 12.1

SESSIONS parameter, 12.1

SGA_TARGET parameter, 8.7.1

share, 6.4.5

size

analytic workspace, 12.6.2.3, 12.6.2.3

skip-level aggregation, 8.5.1

skip-level hierarchies, 3.4.2

source measures (allocation), 9.2.1, 9.2.1

Sparsity Advisor, 3.5.3

Spreadsheet Add-In, 1.4, 3.4.3.1

described, 5.1

static data dictionary views, 12.4.1

status

aggregation, 8.6, 8.6

allocation, 9.3, 9.3.1

stoplight formatting, 11.2.3

sum operator (aggregation), 8.1

summary data methods, 1.2.4

surrogate keys, 3.4

system tables, 12.4.2

T

tablespaces

defining for OLAP, 12.2

target measures (allocation), 9.2.3

templates

BI Publisher, 10.2.2

logical model

saving, 3.8

time dimensions, 3.4

time-series forecasting, 7.2.1

transportable tablespaces, 12.8, 12.8

U

UNDO_MANAGEMENT parameter, 12.1

UNDO_TABLESPACE parameter, 12.1

user names, 2.3

USER_AW_OBJ view, 12.4.1

USER_AW_PROP view, 12.4.1

USER_AW_PS view, 12.4.1

USER_AWS view, 12.4.1

V

V$AW_AGGREGATE_OP view, 12.6.1

V$AW_ALLOCATE_OP view, 12.6.1

V$AW_CALC view, 12.6.1

V$AW_LONGOPS view, 12.6.1

V$AW_OLAP view, 12.6.1

V$AW_SESSION_INFO view, 12.6.1

value-based dimensions, 3.4

value-based hierarchies, 3.4.2

verification window, 7.5.2, 7.5.2

W

weight measures (allocation), 9.2.4

weighted sum (aggregation), 8.1

WHERE clause operations, 4.3.3

wizards

BI Beans, 11.2.7

X

XML metadata, 11.3

XML Templates, 12.8