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

aggregate functions, 3.5.2

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

Analytic Workspace Manager

configuring, 2.4.2, 2.4.5, 2.4.6, 3.5.3.1, 3.5.3.1

installing, 2.4.1

opening, 2.4.2

using, 3.2

analytic workspace security, 8.2.1.1, 8.2.2.1

analytic workspaces

backing up and recovering, 7.7

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

saving and re-creating, 3.9

size, 7.6.2.3

analyze step (cube scripts), 3.6.1

Application Express, 1.2, 6.3

arithmetic operations, 5.2.1

attachment modes

configuring, 2.4.5

selecting, 3.3

showing, 2.4.5

attribute aggregation, 4.5

attributes

creating, 3.4.5.2

defined, 1.3.5, 3.4.5

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

AVG function, 3.5.2, 5.5.4

AW$ tables, 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.8

BusinessObjects Enterprise, 1.3

C

calculated measures

and measure dimensions, 1.3.3

copying and pasting, 3.10

creating, 5.3

defined, 5.1

generator, 5.3

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

Cloud Control, 7.6

Cognos ReportNet, 1.3

column links, 6.3.3.3

configuring

partitioning options, 3.5.3.1

configuring Analytic Workspace Manager

for a proxy server, 2.4.2

for partitioning options, 3.5.3.1

for plug-ins, 2.4.6

for showing attachment modes, 2.4.5

connect string, for Analytic Workspace Manager, 2.4.4

connections, defining, 2.4.3

COUNT function, 3.5.2

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 dates of analytic workspaces, 7.6.2.4

CUBE JOIN, 4.6

cube materialized views, 3.6.3, 7.10

CUBE SCAN operation, 4.7.2

cube scripts, 3.6.1

cube security, 8.2.1.3

cube views, 3.5.6, 4.1.1

CUBE_TABLE function, 8.1.3

CUBE_TEMPLATES table, 3.9

cubes

copying and pasting, 3.10

creating, 3.5

defined, 1.3.1, 3.5

joining, 4.6

mapping, 3.5.2

partitioning, 3.5.3

requirements for materialized views, 3.6.3

saving and re-creating, 3.9

cumulative calculations, 5.4.9

cursors, 1.1.5

D

dashboard, 1.2

data dictionary views, 4.8, 7.3.1

data display, 3.4.10, 3.5.5

data loads, 3.4.8, 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

disabling and enabling, 8.3

implementation, Preface

policies, 8.3

roles, 8.4

data sources

database objects, 3.2

mapping, 3.4.7, 3.5.2

database connections, defining, 2.4.3

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

DBMS_LOB PL/SQL package, 7.6.2.3

DBMS_METADATA PL/SQL package, 7.10.5

DBMS_MVIEW PL/SQL package, 7.10.2.2, 7.10.5

DBMS_SCHEDULER PL/SQL package., 3.6

DBMS_XPLAN PL/SQL package, 7.10.5

dense rank, 5.4.6

DENSE_RANK function, 5.5.4

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

copying and pasting, 3.10

creating, 3.4.2

defined, 1.3.3, 3.4

saving and re-creating, 3.9

viewing members, 3.4.10

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

EIF files

about, 7.9.2

creating analytic workspaces from, 3.9.3

saving analytic workspaces to, 3.9.4

end date attributes, 3.4.5.1

Enterprise Manager Cloud Control, 7.6

execution plans, 4.7

EXP_FULL_DATABASE privilege, 7.8

EXPLAIN PLAN command, 4.7

extensibility using plug-ins, 2.4.6

EXTENT MANAGEMENT LOCAL, 7.2

F

FAST SOLVE method, 7.10.3.2

filtering queries, 4.2.1

free-form calculations, 5.5

future periods, 5.4.3

G

generator, calculated measures, 5.3

Global Computing Company

data requirements, A.1.1

GLOBAL QUERY REWRITE privilege, 7.10.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.4

HIER_CHILD_COUNT function, 5.5.4

HIER_DEPTH function, 5.5.4

HIER_LEVEL function, 5.5.4

HIER_PARENT function, 5.5.4

HIER_TOP function, 5.5.4

hierarchical average operator (aggregation), 9.1

hierarchical operators, 9.2.3

hierarchical queries, 4.2.3

hierarchies

creating, 3.4.4

defined, 1.3.4, 3.4.4

level-based, 3.4.3

supported types, 3.4.4

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

joining cubes, 4.6

L

LAG function, 5.4.3, 5.5.4

LAG_VARIANCE function, 5.5.4

LAG_VARIANCE_PERCENT function, 5.5.4

language support, 3.7

layout template (BI Publisher), 6.2.1

LEAD function, 5.4.3, 5.5.4

LEAD_VARIANCE function, 5.5.4

LEAD_VARIANCE_PERCENT function, 5.5.4

level-based dimensions, 3.4

level-based hierarchy, 3.4.3

levels

creating, 3.4.3

defined, 1.3.4.1

load step (cube scripts), 3.6.1

loading data, 3.4.8, 3.5.4

localization, 3.7

LOVs (list of values), 6.2.4, 6.3.2.2

M

maintenance alternatives, 3.6

maintenance scripts, 3.6.2

Maintenance Wizard, 3.4.8, 3.5.4

mappings

cube, 3.5.2

dimension, 3.4.7

materialized views

access privileges, 7.10.4

creating cube, 3.6.3

refresh logs, 7.10.1.2

MAX function, 3.5.2, 5.5.4

maximum

cumulative, 5.4.9

moving, 5.4.8

measure dimension table

mapping dimension to, 3.4.7.1

measure dimensions

aggregation method of cube, 3.5

and calculated measures, 1.3.3

mapping, 3.4.7.1

measure folders

creating, 3.8

saving and re-creating, 3.9

measures

copying and pasting, 3.10

creating, 3.5.1

defined, 1.3.2

MIN function, 3.5.2, 5.5.4

minimum

cumulative, 5.4.9

moving, 5.4.8

moving calculations, 5.4.8

N

natural keys, 3.4.1.1

nested calculations, 5.4.10

NO_USE_CUBE hint, 4.6

normal hierarchies, 3.4.4

O

object security, 8.1.2, 8.2.1, 8.2.2.1

objects

copying and pasting, 3.10

mapping, 3.4.7, 3.5.2

saving and re-creating, 3.9

OLAP data security roles, 8.4

OLAP DML

calculated measures, 5.6

expressions for data security policies, 8.3

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 Real Application Clusters, 1.1.5, 7.4.3

Oracle Real Application Security, Preface, 8.1.2

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

partitioning

analyzing partition members, 3.5.3.2

benefits, 3.5.3

cubes, 3.5.3

discussed, 7.4.1

selecting partitions, 3.5.3

performance counters, 7.6.1

period to date, 5.4.4

pfile settings, 7.1

PLAN_TABLE table, 4.7

PL/SQL step (cube scripts), 3.6.1

plug-ins

configuring, 2.4.6

installing, 2.4.6

prior periods, 5.4.3

privileges, 8.1.3

proxy server

configuring, 2.4.2

PS$ tables, 7.3.2

Q

queries, filtering, 4.2.1

query rewrite, 7.10.4

query tools, 1.2

QUERY_REWRITE_ENABLED parameter, 7.10.4

QUERY_REWRITE_INTEGRITY parameter, 7.10.4

querying dimensions and cubes, 4

R

RAC

See Oracle Real Application Clusters

ragged hierarchies, 3.4.4

rank, 5.4.6

RANK function, 5.5.4

Real Application Clusters

See Oracle Real Application Clusters

refresh logs, 7.10.1.2

refresh methods, 7.10.2, 7.10.3.1

Relational Schema Advisor, 3.6.3, 7.10.1.2

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

S

sample schema download, 2.1

saving

analytic workspaces to EIF files, 3.9.4

objects

to XML Templates, 3.9.2

scaled operators, 9.2.2

scheduling maintenance, 7.4.3

security

about, 8

data, 8.1.2

materialized views, 7.10.4

object, 8.2.2.1

T

tablespaces, 7.2

templates

BI Publisher, 6.2.2

calculation, 5.3.1

creating XML, 3.9

saving object definitions to, 3.9.2

time dimensions, 3.4.1.2

time ranges in calculations, 5.3.2

time span attributes, 3.4.5.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.5.3

upgrading metadata, 2.5

USE_CUBE hint, 4.6

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.10.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.4

W

weighted operators, 9.2.2

weighted sum (aggregation), 9.1

WHERE clause operations, 4.2.3

X

XML templates

about, 7.9.1

creating objects from, 3.9.1

saving object definitions to, 3.9.2