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

installing, 2.4.1

opening, 2.4.2

using, 3.2

analytic workspace security, 8.2.1.1, 8.2.2.1

analytic workspaces

creating, 3.3

database storage, 7.3.3

disk space consumption, 7.6.5

enhancing functionality, 3.3.1

identifying owners, 7.6.2.2

listing, 7.6.2.2

size, 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, 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.9

moving, 5.4.8

average operator (aggregation), 9.1

average rank, 5.4.6

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, 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 logs, 3.4.5

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

time ranges, 5.3.2

changes, saving, 3.3.2

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

creating analytic workspaces, 7.6.2.4

cube materialized views, 3.6.2, 7.9

Cube Partitioning Advisor, 3.5.3

CUBE SCAN operation, 4.6.2

cube scripts, 3.6.1

cube security, 8.2.1.3

cube views, 3.5.6, 4.1.1

cubes

creating, 3.5

defined, 1.3.1, 3.5

mapping, 3.5.2

requirements for materialized views, 3.6.2

cumulative calculations, 5.4.9

cursors, 1.1.5

D

dashboard, 1.2

data dictionary views, 4.7, 7.3.1

data display, 3.4.7, 3.5.5

data loads, 3.4.5, 3.5.4

data maintenance, 3.6

data model

description of dimensional, 1.3

designing, 3.1

saving, 3.9

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.6

DENSE_RANK function, 5.5

dimension hierarchies

See hierarchies

dimension object security, 8.2.2.2

dimension order, affecting aggregation, 9.3.1

dimension security, 8.2.1.2

dimension views, 4.1.2

dimensions

creating, 3.4

defined, 1.3.3, 3.4

viewing members, 3.4.7

Discoverer Plus OLAP, 1.3

disk space consumption, 7.6.5

disks, spreading data across, 7.2.4

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.2

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.3

G

Global Computing Company

data requirements, A.1.1

GLOBAL QUERY REWRITE privilege, 7.9.4

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

level-based, 3.4.1

supported types, 3.4.2

hierarchy views, 4.1.2

I

index, 5.4.2

initialization parameters, 7.1

init.ora file, 7.1

installing Analytic Workspace Manager, 2.4.1

installing OLAP option, validation, 7.6.2.1

integration in database, 1.1.1

J

JOB_QUEUE_PROCESSES parameter, 7.1, 7.4.3

L

LAG function, 5.4.3, 5.5

LAG_VARIANCE function, 5.5

LAG_VARIANCE_PERCENT function, 5.5

language support, 3.7

layout template (BI Publisher), 6.2.1

LEAD function, 5.4.3, 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

localization, 3.7

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

access privileges, 7.9.4

creating cube, 3.6.2

refresh logs, 7.9.1.2

MAX function, 5.5

maximum

cumulative, 5.4.9

moving, 5.4.8

measure folders, creating, 3.8

measures

creating, 3.5.1

defined, 1.3.2

MIN function, 5.5

minimum

cumulative, 5.4.9

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, 8.2.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 role, 2.3, 8.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 of analytic workspaces, identifying, 7.6.2.2

P

page definition (Application Express), 6.3.2

parallel periods, 5.4.7

parallel processing, 7.4.3

parameter file, 7.1

parent-child relations, 1.3.4.1

PARTIAL OUTER plan option, 4.6.2

partitioning

benefits, 3.5.3

description, 3.5.3.2

discussed, 7.4.1

Partitioning Advisor for cubes, 3.5.3

partitioning strategies, 3.5.3.1

performance counters, 7.6.1

period to date, 5.4.4

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.3

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.6

RANK function, 5.5

Real Application Clusters, 1.1.5, 7.4.3

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

materialized views, 7.9.4

security policies, 8.3

server parameter file, 7.1

SESSIONS parameter, 7.1

share, 5.4.5

SHARE function, 5.5

single-row functions, 5.2.3

size of analytic workspace, 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, 7.2

templates

BI Publisher, 6.2.2

calculation, 5.3.1

creating, 3.9

time dimensions, 3.4

time ranges in calculations, 5.3.2

time span attributes, 3.4.3.1

total

cumulative, 5.4.9

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