Skip Headers
Oracle® OLAP User's Guide
12c Release 1 (12.1)

E17638-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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
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.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
See also data security
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.4
source data, 3.2
Spreadsheet Add-In, 1.3
static data dictionary views, 4.8, 7.3.1
step types, 3.6.1
SUM function, 3.5.2, 5.5.4
sum operator (aggregation), 9.1
surrogate keys, 3.4.1.1
system tables, 7.3.2

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