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

ADVISOR privilege, 2.3, 2.3

aggregation

average operator, 9.1

calculated measures, 4.5.2

definition, 9.1

hierarchical average operator, 9.1

over attributes, 4.5

sum operator, 9.1

weighted operators, 9.1

aggregation operators, 3.5, 4.5, 9.2

aggregation order, 9.3

aggregation percentages, 9.4.2

Aggregation step (cube scripts), 3.6.1

ALL_AW_OBJ view, 7.3.1

ALL_AW_PROP view, 7.3.1

ALL_AW_PS view, 7.3.1

ALL_AWS view, 7.3.1

ALL_CUBES view, 7.4.1

analysis tools, 1.2

analytic functions, 5.2.2, 5.5

Analytic Workspace Manager

installation, 2.4.1

opening, 2.4.2

using, 3.2

analytic workspace object security, 8.2.2.1

analytic workspace security, 8.2.1.1

analytic workspaces

creating, 3.3.1

database storage, 7.3.3

disk space consumption, 7.6.5

enhancing functionality, 3.3.2

listing, 7.6.2.2

size, 7.6.2.3, 7.6.2.3

Analyze step (cube scripts), 3.6.1

Application Express, 1.2, 6.3

arithmetic operations, 5.2.1

attribute aggregation, 4.5

attributes

creating, 3.4.3.2

defined, 1.3.5

description, 3.4.3

authentication, 2.3

Automatic Database Diagnostic Monitor, 7.6

Automatic Storage Management, 7.2.4

Automatic Workload Repository, 7.6

average

cumulative, 5.4.7

moving, 5.4.8

average operator (aggregation), 9.1

average rank, 5.4.2

AVERAGE_RANK function, 5.5

AVG function, 5.5

AW$ tables, 7.3.2

AW$AWCREATE10G table, 7.3.2

AW$AWMD table, 7.3.2

B

backup and recovery, 7.7

backup options

for analytic workspaces, 7.8

batch processing, 7.4.3

BI Publisher, 6.2

BI Suite, 1.3

bind variables, 6.1, 6.2.4.3, 6.3.2.4, 6.3.3.2

branches (Application Express), 6.3.2.3

build log, 3.4.5

build logs, 7.3.4

BusinessObjects Enterprise, 1.3

C

calculated measures

creating, 5.3

defined, 5.1

calculation templates, 5.3.1, 5.4

calculations

free-form, 5.5

in queries, 4.4

nested, 5.4.10

changes

saving, 3.3.3

character functions, 4.2.3

Clear Data step (cube scripts), 3.6.1

CLEAR LEAVES command, 7.9.3.2

Cognos ReportNet, 1.3

column links, 6.3.3.3

connect string

for Analytic Workspace Manager, 2.4.4

connections

defining, 2.4.3

CREATE ANY DIMENSION privilege, 2.3

CREATE ANY MATERIALIZED VIEW privilege, 2.3

CREATE DIMENSION privilege, 2.3

CREATE MATERIALIZED VIEW privilege, 2.3

CREATE SESSION privilege, 2.3, 2.3

creation

analytic workspaces, 7.6.2.4

cube materialized views, 7.9

creating, 3.6.2

Cube Partitioning Advisor, 3.5.3

CUBE SCAN, 4.6.2

cube scripts, 3.6.1

cube security, 8.2.1.3

cube views, 3.5.6, 4.1.1

CUBE_BUILD_LOG table, 7.3.4

cubes

creating, 3.5

defined, 1.3.1

description, 3.5

mapping, 3.5.2

requirements for materialized views, 3.6.2

cumulative calculations, 5.4.7

cursors, 1.1.5

D

dashboard, 1.2

data

displaying, 3.5.5

data dictionary views, 4.7, 7.3.1

data display, 3.4.6

data loads, 3.4.5, 3.5.4

data maintenance, 3.6

data model

description of dimensional, 1.3

designing, 3.1

saving, 3.8

Data Pump, 7.8

data security, 8.1.2

data security policies, 8.3

data sources

database objects, 3.2

mapping, 3.4.4

database connections

defining, 2.4.3

Database Control, 7.6

database integration, 1.1.1

database security, 2.3

DBA scripts download, 7.6.3

DBA_AW_OBJ view, 7.3.1

DBA_AW_PROP view, 7.3.1

DBA_AW_PS view, 7.3.1

DBA_AWS view, 7.3.1, 7.6.2.2

DBA_OBJECTS view, 7.6.2.4

DBA_REGISTRY view, 7.6.2.1

DBMS_AW_STATS PL/SQL package, 7.5

DBMS_CUBE PL/SQL package, 3.6, 7.9.2.1

DBMS_LOB PL/SQL package, 7.6.2.3

DBMS_METADATA PL/SQL package, 7.9.5

DBMS_MVIEW PL/SQL package, 7.9.2.2, 7.9.5

DBMS_SCHEDULER PL/SQL package., 3.6

DBMS_XPLAN PL/SQL package, 7.9.5

dense rank, 5.4.2

DENSE_RANK function, 5.5

dimension hierarchies

See hierarchies

dimension object security, 8.2.2.2

dimension order

effect on aggregation, 9.3.1

dimension security, 8.2.1.2

dimension views, 4.1.2

dimensions

creating, 3.4

defined, 1.3.3

description, 3.4

viewing members, 3.4.6

Discoverer Plus OLAP, 1.3

disk

spreading data, 7.2.4

disk space consumption, 7.6.5

displaying data, 3.5.5

drillable reports, 6.2

drilling, 4.2.3, 6.3.3.3

drilling (Application Express), 6.3.3

dump files, 7.8

dynamic performance tables, 7.6.1

E

edits

saving, 3.3.3

end date attributes, 3.4.3.1

Enterprise Manager Database Control, 7.6

execution plans, 4.6

EXP_FULL_DATABASE privilege, 7.8

EXPLAIN PLAN command, 4.6

extensibility using plugins, 2.4.5

EXTENT MANAGEMENT LOCAL, 7.2

F

FAST SOLVE method, 7.9.3.2

filtering queries, 4.2.1

free-form calculations, 5.5

future periods, 5.4.4

G

Global Computing Company

data requirements, A.1.1

Global schema

download, 2.1

Gregorian calendar, 5.3.2

H

hidden items (Application Express), 6.3.3.1

HIER_ANCESTOR function, 5.5

HIER_CHILD_COUNT function, 5.5

HIER_DEPTH function, 5.5

HIER_LEVEL function, 5.5

HIER_PARENT function, 5.5

HIER_TOP function, 5.5

hierarchical average operator (aggregation), 9.1

hierarchical operators, 9.2.3

hierarchical queries, 4.2.3

hierarchies

creating, 3.4.2

defined, 1.3.4

description, 3.4.2

level-based, 3.4.1

supported types, 3.4.2

hierarchy views, 4.1.2

I

index, 5.4.9

initialization parameters, 7.1

init.ora file, 7.1

installation

Analytic Workspace Manager, 2.4.1

installation of OLAP option

validating, 7.6.2.1

integration in database, 1.1.1

J

JOB_QUEUE_PROCESSES parameter, 7.1, 7.4.3

L

lag, 5.4.4

LAG function, 5.5

LAG_VARIANCE function, 5.5

LAG_VARIANCE_PERCENT function, 5.5

layout template (BI Publisher), 6.2.1

lead, 5.4.4

LEAD function, 5.5

LEAD_VARIANCE function, 5.5

LEAD_VARIANCE_PERCENT function, 5.5

level-based dimensions, 3.4

level-based hierarchy, 3.4.1

levels

creating, 3.4.1

defined, 1.3.4.1

Load step (cube scripts), 3.6.1

loading data, 3.4.5, 3.5.4

LOVs (list of values), 6.2.4, 6.3.2.2

M

maintenance alternatives, 3.6

Maintenance Wizard, 3.4.5, 3.5.4

mappings

creating, 3.4.4

materialized views, 3.6.2

refresh logs, 7.9.1.2

MAX function, 5.5

maximum

cumulative, 5.4.7

moving, 5.4.8

measure folders

creating, 3.7

measures

creating, 3.5.1

defined, 1.3.2

MIN function, 5.5

minimum

cumulative, 5.4.7

moving, 5.4.8

moving calculations, 5.4.8

N

natural keys, 3.4

nested calculations, 5.4.10

normal hierarchies, 3.4.2

O

object security, 8.1.2, 8.2.1

objects

mapping, 3.4.4

OLAP DML step (cube scripts), 3.6.1

OLAP option

verifying installation, 7.6.2.1

OLAP_DBA role, 2.3

OLAP_USER role, 2.3, 2.3

OLAP_XS_ADMIN privilege, 8.3

OLAP_XS_ADMIN role, 2.3

optimizer statistics, 7.5

Oracle Application Express, 1.2

Oracle Business Intelligence, 1.3

Oracle Recovery Manager, 7.7

OracleBI Discoverer Plus OLAP, 1.3

OracleBI Spreadsheet Add-In, 1.3

OracleBI Suite Enterprise Edition, 1.3

OUTER plan option, 4.6.2

owners

identifying for analytic workspaces, 7.6.2.2

P

page definition (Application Express), 6.3.2

parallel periods, 5.4.5

parallel processing, 7.4.3

parameter file, 7.1

parent-child relations

described, 1.3.4.1

PARTIAL OUTER plan option, 4.6.2

partitioning, 7.4.1

benefits, 3.5.3

description, 3.5.3.2

Partitioning Advisor for cubes, 3.5.3

partitioning strategies, 3.5.3.1

performance counters, 7.6.1

period to date, 5.4.6

pfile settings, 7.1

PLAN_TABLE table, 4.6

PL/SQL step (cube scripts), 3.6.1

plugins, 2.4.5

prior periods, 5.4.4

privileges, 8.1.3

PS$ tables, 7.3.2

Q

queries

filtering, 4.2.1

query rewrite, 7.9.4

query tools, 1.2

QUERY_REWRITE_ENABLED parameter, 7.9.4

QUERY_REWRITE_INTEGRITY parameter, 7.9.4

querying dimensions and cubes, 4

R

RAC, 1.1.5, 7.4.3

ragged hierarchies, 3.4.2

rank, 5.4.2

RANK function, 5.5

Real Application Clusters, 1.1.5

refresh logs, 7.9.1.2

refresh methods, 7.9.2, 7.9.3.1

report entry (BI Publisher), 6.2.1

report layout (BI Publisher), 6.2.3

reports, 6.2

RMAN, 7.7

ROW_NUMBER function, 5.5

S

sample schema

download, 2.1

scaled operators, 9.2.2

scheduling maintenance, 7.4.3

security policies, 8.3

server parameter file, 7.1

SESSIONS parameter, 7.1

share, 5.4.3

SHARE function, 5.5

single-row functions, 5.2.3

size

analytic workspace, 7.6.2.3, 7.6.2.3

skip-level hierarchies, 3.4.2

source data, 3.2

Spreadsheet Add-In, 1.3

static data dictionary views, 4.7, 7.3.1

step types, 3.6.1

SUM function, 5.5

sum operator (aggregation), 9.1

surrogate keys, 3.4

system tables, 7.3.2

T

tablespaces

defining for OLAP, 7.2

templates

BI Publisher, 6.2.2

calculation, 5.3.1

creating, 3.8

time

defining ranges, 5.3.2

time dimensions, 3.4

time span attributes, 3.4.3.1

total

cumulative, 5.4.7

moving, 5.4.8

transportable tablespaces, 7.8, 7.8

U

UNDO_MANAGEMENT parameter, 7.1

UNDO_TABLESPACE parameter, 7.1

Unique key attributes, 3.4.3.3

user names, 2.3

USER_AW_OBJ view, 7.3.1

USER_AW_PROP view, 7.3.1

USER_AW_PS view, 7.3.1

USER_AWS view, 7.3.1

USER_CUBE_DIM_VIEW_COLUMNS view, 4.1.2.2

USER_CUBE_DIM_VIEWS view, 4.1.2.1

USER_CUBE_HIER_LEVELS view, 4.2.1

USER_CUBE_HIER_VIEWS view, 4.1.2.1

USER_CUBE_VIEW_COLUMNS view, 4.1.1.2

USER_MVIEWS view, 7.9.1.1

V

V$AW_AGGREGATE_OP view, 7.6.1

V$AW_ALLOCATE_OP view, 7.6.1

V$AW_CALC view, 7.6.1

V$AW_LONGOPS view, 7.6.1

V$AW_OLAP view, 7.6.1

V$AW_SESSION_INFO view, 7.6.1

value-based dimensions, 3.4

value-based hierarchies, 3.4.2

W

weighted operators, 9.2.2

weighted sum (aggregation), 9.1

WHERE clause operations, 4.2.3

X

XML Templates, 7.8