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.4
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.4
AVG function, 5.5.4
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
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.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.3, 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.3
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.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
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

generator, calculated measures, 5.3
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.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.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.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.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
login names, 2.3
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.5, 3.5.4
mappings, creating, 3.4.4
materialized views
access privileges, 7.9.4
creating cube, 3.6.3
refresh logs, 7.9.1.2
MAX function, 5.5.4
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.4
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
calculated measures, 5.6
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 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
See Oracle Real Application Clusters
ragged hierarchies, 3.4.2
rank, 5.4.6
RANK function, 5.5.4
Real Application Clusters
See Oracle Real Application Clusters
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.4

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