Go to main content
19/19
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
Active Catalog,
11.2.1
aggregation
average operator,
8.1
calculated measures,
4.6.2
definition,
8.1
hierarchical average operator,
8.1
hierarchical operators,
8.1
over attributes,
4.6
performance issues,
8.7
status (regular composites only),
8.6
sum operator,
8.1
weighted operators,
8.1
aggregation operators,
4.6
comparison with allocation operators,
9.5.4
defined,
8.2
aggregation strategies
compressed composites,
8.4
regular composites,
8.5
skip-level,
8.5.1
ALL_AW_OBJ view,
12.4.1
ALL_AW_PROP view,
12.4.1
ALL_AW_PS view,
12.4.1
ALL_AWS view,
12.4.1
allocation,
9
basis measures,
9.2.2
creating,
9.4
even operator,
9.1
,
9.1
proportional operator,
9.1
source measures,
9.2.1
status,
9.3
,
9.3.1
target measures,
9.2.3
weight measures,
9.2.4
allocation operators
comparison with aggregation operators,
9.5.4
descriptions,
9.5
ALTER SESSION commands,
12.1
analysis tools,
1.3
analytic functions,
6.2
Analytic Workspace Java API,
11.3
Analytic Workspace Manager,
3
installation,
2.4.1
opening,
2.4.2
analytic workspaces
basic steps for creating,
3.3.1
creating,
3.3.1
database storage,
12.4.3
defined,
1.2
disk space consumption,
12.6.5
enhancing functionality,
3.3.2
listing,
12.6.2.2
size,
12.6.2.3
,
12.6.2.3
Application Express,
1.3
,
10.3
attribute aggregation,
4.6
attributes
creating,
3.4.3.2
description,
3.4.3
logical,
1.5.5
authentication,
2.3
Automatic Database Diagnostic Monitor,
12.6
Automatic Storage Management,
12.2.4
Automatic Workload Repository,
12.6
average operator (aggregation),
8.1
AW$ tables,
12.4.2
AW$AWCREATE10G table,
12.4.2
AW$AWMD table,
12.4.2
AWXML package,
11.3
B
backup and recovery,
12.7
backup options
for analytic workspaces,
12.8
basis measures (allocation),
9.2.2
batch processing,
12.5.2
BI Beans
described,
11.1.2
,
11.2
BI Publisher,
10.2
bind variables,
10.1
,
10.2.4.3
,
10.3.2.4
,
10.3.3.2
branches (Application Express),
10.3.2.3
build log,
3.4.5
C
calculated measures
creating,
6.2
defined,
6.1
calculation plan
allocation step,
9.4
forecast,
7.4
calculation plans
creating,
6.5
forecast steps,
7.4.5
Calculation Wizard,
1.4.2
calculations
in queries,
4.5
causal analysis,
7.2.2
changes
saving,
3.3.3
character functions,
4.3.3
column links,
10.3.3.3
connect string
for Analytic Workspace Manager,
2.4.4
connections
defining,
2.4.3
copy allocation operators,
9.5.1
CREATE SESSION privilege,
2.3
,
2.3
creation
analytic workspaces,
12.6.2.4
crosstab bean,
11.2.5
cubes,
1.2
creating,
3.5
description,
3.5
mapping,
3.5.2
custom measures
BI Beans support,
11.2.7
D
dashboard,
1.3
data
displaying,
3.5.5
data dictionary views,
12.4.1
data display,
3.4.6
data formatting,
11.2.3
data loads,
3.4.5
,
3.5.4
Data Mining
forecasting,
7.2.2
data model
designing,
3.1
data models,
1.5
Data Pump,
12.8
data sources
mapping,
3.4.4
database connections
defining,
2.4.3
Database Control,
12.6
database integration,
1.1.1
database security,
2.3
DBA scripts download,
12.6.3
DBA_AW_OBJ view,
12.4.1
DBA_AW_PROP view,
12.4.1
DBA_AW_PS view,
12.4.1
DBA_AWS view,
12.4.1
,
12.6.2.2
DBA_OBJECTS view,
12.6.2.4
DBA_REGISTRY view,
12.6.2.1
DBMS_LOB PL/SQL package,
12.6.2.3
DECIMAL data type
comparison with NUMBER,
8.7.2
dimension hierarchies
See
hierarchies
dimension members
selecting (allocation),
9.3
selecting for aggregation,
8.6
dimensions
creating,
3.4
description,
3.4
logical,
1.5.3
viewing members,
3.4.6
Discoverer Plus OLAP,
1.4
,
3.4.3.1
disk
spreading data,
12.2.4
disk space consumption,
12.6.5
displaying data,
3.5.5
drillable reports,
10.2
drilling,
4.3.3
,
10.3.3.3
,
11.2.2
drilling (Application Express),
10.3.3
dump files,
12.8
dynamic performance tables,
12.6.1
E
edits
saving,
3.3.3
Enterprise Manager Database Control,
12.6
even distribution allocation operators,
9.5.2
even operator (allocation),
9.1
,
9.1
Excel add-in,
5.1
EXP_FULL_DATABASE privilege,
12.8
expert opinion in forecasting,
7.2.3
Expert System,
7.5.1
extensibility using plug-ins,
2.4.5
EXTENT MANAGEMENT LOCAL,
12.2
F
filtering queries,
4.3.1
forecast steps
creating,
7.4.5
forecasting,
7
applications,
7.3
Data Mining,
7.2.2
dimension levels,
7.4.4
Expert System,
7.5.1
time horizons,
7.2
verification window,
7.5.2
,
7.5.2
forecasts
creating,
7.4
formatting
data,
11.2.3
G
Global Computing Company
data requirements,
A.1.1
Global schema
download,
2.1
graph bean,
11.2.4
H
hidden items (Application Express),
10.3.3.1
hierarchical average (aggregation),
8.1
hierarchical average operator (aggregation),
8.1
hierarchical queries,
4.3.3
hierarchies
creating,
3.4.2
description,
3.4.2
logical,
1.5.4
I
IDE
defined,
11.1.3
initialization parameters,
12.1
,
12.1
init.ora file,
12.1
,
12.1
installation
Analytic Workspace Manager,
2.4.1
installation of OLAP option
validating,
12.6.2.1
integration in database,
1.1.1
J
Java
described,
11.1
sandbox security,
11.1.1
Java APIs for OLAP,
11
JDeveloper,
11.1.3
JOB_QUEUE_PROCESSES parameter,
12.1
,
12.5.2
L
language support,
3.7
layout template (BI Publisher),
10.2.1
level-based dimensions,
3.4
levels
creating,
3.4.1
logical,
1.5.4.1
loading data,
3.4.5
,
3.5.4
localization,
3.7
login names,
2.3
LOVs (list of values),
10.2.4
,
10.3.2.2
M
Maintenance Wizard,
3.4.5
,
3.5.4
mappings
creating,
3.4.4
MDI
defined,
11.1.3
measure folders
creating,
3.6
measures
creating,
3.5.1
custom,
11.2.7
logical,
1.5.2
model
saving,
3.8
multidimensional data,
1.2
N
natural keys,
3.4
normal hierarchies,
3.4.2
NUMBER data type
comparison with DECIMAL,
8.7.2
number formatting,
11.2.3
O
objects
mapping,
3.4.4
OLAP API
described,
11.1.2
OLAP option
verifying installation,
12.6.2.1
OLAP_DBA role,
2.3
OLAP_USER role,
2.3
,
2.3
OLAPSYS.XML_LOAD_LOG file,
12.4.4
Oracle Application Express,
1.3
Oracle Business Intelligence
OracleBI Discoverer Plus OLAP,
1.4
OracleBI Spreadsheet Add-In,
1.4
Oracle Real Application Clusters,
1.1.4
,
12.5.2
Oracle Recovery Manager,
12.7
OracleBI Beans,
3.4.3.1
,
11.2
,
11.2.6
owners
identifying for analytic workspaces,
12.6.2.2
P
page definition (Application Express),
10.3.2
paging,
11.2.2
parallel processing,
12.5.2
parameter file,
12.1
parent-child relations,
1.5.4.1
partitioning
benefits,
3.5.3.1
description,
3.5.3.3
Partitioning Advisor,
3.5.3.1
partitioning strategies,
3.5.3.2
performance checklist,
8.7.3
performance counters,
12.6.1
pfile settings,
12.1
PGA_AGGREGATE_TARGET parameter,
8.7.1
,
12.1
PGA_TARGET parameter,
12.1
pivoting,
11.2.2
plug-ins,
2.4.5
Presentation Beans,
11.2
proportional allocation operators,
9.5.3
proportional operator (allocation),
9.1
PS$ tables,
12.4.2
Q
queries
filtering,
4.3.1
query builder,
11.2.7
query tools,
1.3
Query Wizard,
1.4.1
querying dimensions and cubes,
4.1
R
RAC,
1.1.4
,
12.5.2
ragged hierarchies,
3.4.2
report entry (BI Publisher),
10.2.1
report layout (BI Publisher),
10.2.3
reports,
10.2
response time
improving,
8.7.3
RMAN,
12.7
S
sample schema
download,
2.1
scheduling maintenance,
12.5.2
server parameter file,
12.1
SESSIONS parameter,
12.1
SGA_TARGET parameter,
8.7.1
share,
6.4.5
size
analytic workspace,
12.6.2.3
,
12.6.2.3
skip-level aggregation,
8.5.1
skip-level hierarchies,
3.4.2
source measures (allocation),
9.2.1
,
9.2.1
Sparsity Advisor,
3.5.3
Spreadsheet Add-In,
1.4
,
3.4.3.1
described,
5.1
static data dictionary views,
12.4.1
status
aggregation,
8.6
,
8.6
allocation,
9.3
,
9.3.1
stoplight formatting,
11.2.3
sum operator (aggregation),
8.1
summary data methods,
1.2.4
surrogate keys,
3.4
system tables,
12.4.2
T
tablespaces
defining for OLAP,
12.2
target measures (allocation),
9.2.3
templates
BI Publisher,
10.2.2
logical model
saving,
3.8
time dimensions,
3.4
time-series forecasting,
7.2.1
transportable tablespaces,
12.8
,
12.8
U
UNDO_MANAGEMENT parameter,
12.1
UNDO_TABLESPACE parameter,
12.1
user names,
2.3
USER_AW_OBJ view,
12.4.1
USER_AW_PROP view,
12.4.1
USER_AW_PS view,
12.4.1
USER_AWS view,
12.4.1
V
V$AW_AGGREGATE_OP view,
12.6.1
V$AW_ALLOCATE_OP view,
12.6.1
V$AW_CALC view,
12.6.1
V$AW_LONGOPS view,
12.6.1
V$AW_OLAP view,
12.6.1
V$AW_SESSION_INFO view,
12.6.1
value-based dimensions,
3.4
value-based hierarchies,
3.4.2
verification window,
7.5.2
,
7.5.2
W
weight measures (allocation),
9.2.4
weighted sum (aggregation),
8.1
WHERE clause operations,
4.3.3
wizards
BI Beans,
11.2.7
X
XML metadata,
11.3
XML Templates,
12.8
Scripting on this page enhances content navigation, but does not change the content in any way.