Index

A

ADVISOR privilege 1
aggregate functions 1
aggregation
- average operator 1
- calculated measures 1
- definition 1
- hierarchical average operator 1
- over attributes 1
- sum operator 1
- weighted operators 1
aggregation operators 1, 2, 3
aggregation order 1
aggregation percentages 1
aggregation step (cube scripts) 1
ALL_AW_OBJ view 1
ALL_AW_PROP view 1
ALL_AW_PS view 1
analysis tools 1
analytic functions 1, 2
Analytic Workspace Manager
- configuring 1, 2, 3, 4
- installing 1
- opening 1
- using 1
analytic workspaces
- backing up and recovering 1
- creating 1
- database storage 1
- disk space consumption 1
- enhancing functionality 1
- identifying owners 1
- listing 1
- saving and re-creating 1
- size 1
analytic workspace security 1, 2
analyze step (cube scripts) 1
Application Express 1, 2
arithmetic operations 1
attachment modes
- configuring 1
- selecting 1
- showing 1
attribute aggregation 1
attributes
- creating 1
- defined 1, 2
authentication 1
Automatic Database Diagnostic Monitor 1
Automatic Storage Management 1
Automatic Workload Repository 1
average
- cumulative 1
- moving 1
AVERAGE_RANK function 1
average operator (aggregation) 1
average rank 1
AVG function 1

B

backup and recovery 1
backup options 1
batch processing 1
bind variables 1, 2, 3, 4
BI Publisher 1
BI Suite 1
branches (Application Express) 1
build logs 1
BusinessObjects Enterprise 1

C

calculated measures
- and measure dimensions 1
- copying and pasting 1
- creating 1
- defined 1
- generator 1
calculations
- free-form 1
- in queries 1
- nested 1
- time ranges 1
calculation templates 1, 2
changes, saving 1
character functions 1
clear data step (cube scripts) 1
CLEAR LEAVES command 1
Cloud Control 1
Cognos ReportNet 1
column links 1
configuring
- partitioning options 1
configuring Analytic Workspace Manager
- for a proxy server 1
- for partitioning options 1
- for plug-ins 1
- for showing attachment modes 1
connections, defining 1
connect string, for Analytic Workspace Manager 1
COUNT function 1
CREATE ANY DIMENSION privilege 1
CREATE ANY MATERIALIZED VIEW privilege 1
CREATE DIMENSION privilege 1
CREATE MATERIALIZED VIEW privilege 1
CREATE SESSION privilege 1
creation dates of analytic workspaces 1
CUBE_TABLE function 1
CUBE_TEMPLATES table 1
CUBE JOIN 1
cube materialized views 1, 2
cubes
- copying and pasting 1
- creating 1
- defined 1, 2
- joining 1
- mapping 1
- partitioning 1
- requirements for materialized views 1
- saving and re-creating 1
CUBE SCAN operation 1
cube scripts 1
cube security 1
cube views 1, 2
cumulative calculations 1
cursors 1

D

dashboard 1
database connections, defining 1
database integration 1
database security 1
data dictionary views 1, 2
data display 1, 2
data loads 1, 2
data maintenance 1
data model
- description of dimensional 1
- designing 1
- saving 1
Data Pump 1
data security 1
- disabling and enabling 1
- implementation 1
- policies 1
- roles 1
data sources
- database objects 1
- mapping 1, 2
DBA_AW_OBJ view 1
DBA_AW_PROP view 1
DBA_AW_PS view 1
DBA_AWS view 1
DBA_OBJECTS view 1
DBA_REGISTRY view 1
DBA scripts download 1
DBMS_AW_STATS PL/SQL package 1
DBMS_CUBE PL/SQL package 1
DBMS_LOB PL/SQL package 1
DBMS_METADATA PL/SQL package 1
DBMS_MVIEW PL/SQL package 1
DBMS_SCHEDULER PL/SQL package. 1
DBMS_XPLAN PL/SQL package 1
dense rank 1
dimension hierarchies
- See hierarchies 1
dimension object security 1
dimension order, affecting aggregation 1
dimensions
- copying and pasting 1
- creating 1
- defined 1, 2
- saving and re-creating 1
- viewing members 1
dimension security 1
dimension views 1
Discoverer Plus OLAP 1
disks, spreading data across 1
disk space consumption 1
displaying data 1
drillable reports 1
drilling 1, 2
drilling (Application Express) 1
dump files 1
dynamic performance tables 1

E

edits, saving 1
EIF files
- about 1
- creating analytic workspaces from 1
- saving analytic workspaces to 1
end date attributes 1
Enterprise Manager Cloud Control 1
execution plans 1
EXP_FULL_DATABASE privilege 1
EXPLAIN PLAN command 1
extensibility using plug-ins 1
EXTENT MANAGEMENT LOCAL 1

F

FAST SOLVE method 1
filtering queries 1
free-form calculations 1
future periods 1

G

generator, calculated measures 1
Global Computing Company
- data requirements 1
GLOBAL QUERY REWRITE privilege 1
Global schema download 1
Gregorian calendar 1

H

hidden items (Application Express) 1
HIER_PARENT function 1
hierarchical average operator (aggregation) 1
hierarchical operators 1
hierarchical queries 1
hierarchies
- creating 1
- defined 1, 2
- level-based 1
- supported types 1
hierarchy views 1

I

index 1
init.ora file 1
initialization parameters 1
installing Analytic Workspace Manager 1
installing OLAP option, validation 1
integration in database 1

J

JOB_QUEUE_PROCESSES parameter 1
joining cubes 1

L

LAG function 1
language support 1
layout template (BI Publisher) 1
LEAD function 1
level-based dimensions 1
level-based hierarchy 1
levels
- creating 1
- defined 1
loading data 1, 2
load step (cube scripts) 1
localization 1
login names 1
LOVs (list of values) 1, 2

M

maintenance alternatives 1
maintenance scripts 1
Maintenance Wizard 1, 2
mappings
- cube 1
- dimension 1
materialized views
- access privileges 1
- creating cube 1
- refresh logs 1
MAX function 1
maximum
- cumulative 1
- moving 1
measure dimensions
- aggregation method of cube 1
- and calculated measures 1
- mapping 1
measure dimension table
- mapping dimension to 1
measure folders
- creating 1
- saving and re-creating 1
measures
- copying and pasting 1
- creating 1
- defined 1
MIN function 1
minimum
- cumulative 1
- moving 1
moving calculations 1

N

natural keys 1
nested calculations 1
NO_USE_CUBE hint 1
normal hierarchies 1

O

objects
- copying and pasting 1
- mapping 1, 2
- saving and re-creating 1
object security 1, 2, 3
OLAP_DBA role 1
OLAP_USER role 1
OLAP_XS_ADMIN role 1, 2
OLAP data security roles 1
OLAP DML
- calculated measures 1
- expressions for data security policies 1
OLAP DML step (cube scripts) 1
OLAP option, verifying installation 1
optimizer statistics 1
Oracle Application Express 1
OracleBI Discoverer Plus OLAP 1
OracleBI Spreadsheet Add-In 1
OracleBI Suite Enterprise Edition 1
Oracle Business Intelligence 1
Oracle Real Application Clusters 1, 2
Oracle Real Application Security 1, 2
Oracle Recovery Manager 1
owners of analytic workspaces, identifying 1

P

page definition (Application Express) 1
parallel periods 1
parallel processing 1
parameter file 1
parent-child relations 1
partitioning
- analyzing partition members 1
- benefits 1
- cubes 1
- discussed 1
- selecting partitions 1
performance counters 1
period to date 1
pfile settings 1
PL/SQL step (cube scripts) 1
plug-ins
- configuring 1
- installing 1
prior periods 1
privileges 1
proxy server
- configuring 1

Q

queries, filtering 1
QUERY_REWRITE_ENABLED parameter 1
querying dimensions and cubes 1
query rewrite 1
query tools 1

R

RAC
- See: Oracle Real Application Clusters
ragged hierarchies 1
rank 1
Real Application Clusters
- See: Oracle Real Application Clusters
refresh logs 1
refresh methods 1, 2
Relational Schema Advisor 1, 2
report entry (BI Publisher) 1
report layout (BI Publisher) 1
reports 1
RMAN 1

S

sample schema download 1
saving
- analytic workspaces to EIF files 1
- objects
  - to XML Templates 1
scaled operators 1
scheduling maintenance 1
security 1
- See also: data security
- about 1
- data 1
- materialized views 1
- object 1
server parameter file 1
SESSIONS parameter 1
share 1
single-row functions 1
size of analytic workspace 1
skip-level hierarchies 1
source data 1
Spreadsheet Add-In 1
static data dictionary views 1, 2
step types 1
SUM function 1
sum operator (aggregation) 1
surrogate keys 1
system tables 1

T

tablespaces 1
templates
- BI Publisher 1
- calculation 1
- creating XML 1
- saving object definitions to 1
time dimensions 1
time ranges in calculations 1
time span attributes 1
total
- cumulative 1
- moving 1
transportable tablespaces 1

U

unique key attributes 1
upgrading metadata 1
USE_CUBE hint 1
USER_AW_OBJ view 1
USER_AW_PROP view 1
USER_AW_PS view 1
USER_CUBE_DIM_VIEWS view 1
USER_CUBE_VIEW_COLUMNS view 1
USER_MVIEWS view 1
user names 1

V

value-based dimensions 1
value-based hierarchies 1

W

weighted operators 1
weighted sum (aggregation) 1
WHERE clause operations 1

X

XML templates
- about 1
- creating objects from 1
- saving object definitions to 1