Index
A
- ADVISOR privilege 2.3
- aggregate functions 3.5.2
- aggregation
- 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
- analysis tools 1.2
- analytic functions 5.2.2, 5.5.4
- Analytic Workspace Manager
- analytic workspaces
- analytic workspace security 8.2.1.1, 8.2.2.1
- analyze step (cube scripts) 3.6.1
- Application Express 1.2, 6.3
- arithmetic operations 5.2.1
- attachment modes
- attribute aggregation 4.5
- attributes
- authentication 2.3
- Automatic Database Diagnostic Monitor 7.6
- Automatic Storage Management 7.2.4
- Automatic Workload Repository 7.6
- average
- AVERAGE_RANK function 5.5.4
- average operator (aggregation) 9.1
- average rank 5.4.6
- AVG function 3.5.2
C
- calculated measures
- calculations
- calculation templates 5.3.1, 5.4
- 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
- connections, defining 2.4.3
- connect string, for Analytic Workspace Manager 2.4.4
- 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
- creation dates of analytic workspaces 7.6.2.4
- CUBE_TABLE function 8.1.3
- CUBE_TEMPLATES table 3.9
- CUBE JOIN 4.6
- cube materialized views 3.6.3, 7.10
- cubes
- 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
- cumulative calculations 5.4.9
- cursors 1.1.5
D
- dashboard 1.2
- database connections, defining 2.4.3
- database integration 1.1.1
- database security 2.3
- 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
- Data Pump 7.8
- data security 8.1.2
- data sources
- 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.6.2.2
- DBA_OBJECTS view 7.6.2.4
- DBA_REGISTRY view 7.6.2.1
- DBA scripts download 7.6.3
- DBMS_AW_STATS PL/SQL package 7.5
- DBMS_CUBE PL/SQL package 3.6
- DBMS_LOB PL/SQL package 7.6.2.3
- DBMS_METADATA PL/SQL package 7.10.5
- DBMS_MVIEW PL/SQL package 7.10.5
- DBMS_SCHEDULER PL/SQL package. 3.6
- DBMS_XPLAN PL/SQL package 7.10.5
- dense rank 5.4.6
- dimension hierarchies
- See hierarchies 1.3.4
- dimension object security 8.2.2.2
- dimension order, affecting aggregation 9.3.1
- dimensions
- dimension security 8.2.1.2
- dimension views 4.1.2
- Discoverer Plus OLAP 1.3
- disks, spreading data across 7.2.4
- disk space consumption 7.6.5
- 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
L
M
O
- objects
- object security 8.1.2, 8.2.1, 8.2.2.1
- OLAP_DBA role 2.3
- OLAP_USER role 2.3
- OLAP_XS_ADMIN role 2.3, 8.3
- OLAP data security roles 8.4
- OLAP DML
- OLAP DML step (cube scripts) 3.6.1
- OLAP option, verifying installation 7.6.2.1
- optimizer statistics 7.5
- Oracle Application Express 1.2
- OracleBI Discoverer Plus OLAP 1.3
- OracleBI Spreadsheet Add-In 1.3
- OracleBI Suite Enterprise Edition 1.3
- Oracle Business Intelligence 1.3
- Oracle Real Application Clusters 1.1.5, 7.4.3
- Oracle Real Application Security , 8.1.2
- Oracle Recovery Manager 7.7
- 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
- partitioning
- performance counters 7.6.1
- period to date 5.4.4
- pfile settings 7.1
- PL/SQL step (cube scripts) 3.6.1
- plug-ins
- prior periods 5.4.3
- privileges 8.1.3
- proxy server
- configuring 2.4.2
R
- RAC
- See: Oracle Real Application Clusters
- ragged hierarchies 3.4.4
- rank 5.4.6
- 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
S
- sample schema download 2.1
- saving
- scaled operators 9.2.2
- scheduling maintenance 7.4.3
- security 8.3
- See also: data security
- server parameter file 7.1
- SESSIONS parameter 7.1
- share 5.4.5
- 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
- sum operator (aggregation) 9.1
- surrogate keys 3.4.1.1
- system tables 7.3.2