1. Index

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
  • 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
  • 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

B

C

  • calculated measures
    • and measure dimensions 1.3.3
    • copying and pasting 3.10
    • creating 5.3
    • defined 5.1
    • generator 5.3
  • 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
  • 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
  • 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
    • 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
    • policies 8.3
    • roles 8.4
  • 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
  • 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

  • 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

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_PARENT function 5.5.4
  • hierarchical average operator (aggregation) 9.1
  • hierarchical operators 9.2.3
  • hierarchical queries 4.2.3
  • hierarchies
  • hierarchy views 4.1.2

I

  • index 5.4.2
  • init.ora file 7.1
  • initialization parameters 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.4.3
  • joining cubes 4.6

L

M

N

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
    • 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
  • 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

Q

  • queries, filtering 4.2.1
  • QUERY_REWRITE_ENABLED parameter 7.10.4
  • querying dimensions and cubes 4
  • query rewrite 7.10.4
  • query tools 1.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
    • analytic workspaces to EIF files 3.9.4
    • objects
  • 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

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
  • transportable tablespaces 7.8

U

V

  • 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