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
- abstract data types
- See object types
- access rights, 5-5, 6-9
- ADD_ALTER_SESSION procedure, 8-3
- administration privileges, 5-4
- ADT, 3-2
- aggregate cache
- performance statistics, 7-3
- AGGREGATE command, 9-4
- aggregation, 2-4, 9-3, 9-4, 9-9, A-6
- ALL$OLAP2_AW_MAP_ATTR_USE view, 14-7
- ALL$OLAP2_AW_MAP_DIM_USE view, 14-4
- ALL$OLAP2_AW_MAP_HIER_USE view, 14-5
- ALL$OLAP2_AW_MAP_LVL_USE view, 14-6
- ALL$OLAP2_AW_MAP_MEAS_USE view, 14-4
- ALL$OLAP2_AW_PHYS_OBJ view, 14-2
- ALL$OLAP2_AW_PHYS_OBJ_EXT view, 14-3
- ALL$OLAP2_AW_PHYS_OBJ_PROP view, 14-4
- ALL$OLAP2_AW_PHYS_OBJ_REL_OBJ view, 14-3
- ALL$OLAP2_CATALOGS view, 13-5
- ALL$OLAP2_CUBE_DIM_USES view, 13-6
- ALL$OLAP2_CUBE_MEAS_DIM_USES view, 13-6
- ALL$OLAP2_CUBE_MEASURE_MAPS view, 13-7
- ALL$OLAP2_CUBE_MEASURES view, 13-7
- ALL$OLAP2_CUBES view, 13-8
- ALL$OLAP2_DIM_ATTR_USES view, 13-8
- ALL$OLAP2_DIM_ATTRIBUTES view, 13-9
- ALL$OLAP2_DIM_HIER_LEVEL_USES view, 13-9
- ALL$OLAP2_DIM_HIERARCHIES view, 13-10
- ALL$OLAP2_DIM_LEVEL_ATTR_MAPS view, 13-10
- ALL$OLAP2_DIM_LEVEL_ATTRIBUTES view, 13-11
- ALL$OLAP2_DIM_LEVELS view, 13-12
- ALL$OLAP2_DIMENSIONS view, 13-12
- ALL$OLAP2_ENTITY_DESC_USES view, 13-13
- ALL$OLAP2_FACT_LEVEL_USES view, 13-14
- ALL$OLAP2_FACT_TABLE_GID view, 13-15
- ALL$OLAP2_HIER_CUSTOM_SORT view, 13-15
- ALL$OLAP2_JOIN_KEY_COLUMN_USES view, 13-16
- ALL$OLAP2_LEVEL_KEY_COLUMN_USES view, 13-17
- allocation, 2-4, A-6
- ALTER SESSION commands, 6-4, 8-2
- analytic workspaces, 5-5
- accessing from SQL, 15-2
- creating from relational tables, 9-1
- creating from tables, 9-1
- creating metadata for, 5-3, 25-1, 26-1
- creating with DML, 9-4
- data manipulation, 2-2
- data refresh, 9-8
- database storage, 6-11
- defined, 1-6
- metadata in OLAP Catalog, 14-1, 25-1
- performance counters, 7-5
- preparing for OLAP_TABLE, 11-3
- preparing for SQL access, 15-3
- applications
- business analysis, 1-3
- comparison, 1-8
- components of SQL-based, 3-2
- differences from Express, A-4
- attributes, 12-8
- See Also dimension attributes
- See Also level attributes
- creating, 5-9, 5-11, 18-2, 21-2
- defined, 4-14
- in analytic workspaces, 15-10
- authentication, 6-9
- AW$ tables, 6-12
B
- BFILE security, 6-9
- BI Beans
- described, 1-7, 3-6, 3-7
- thick-client configuration, 3-8
- thin-client configuration, 3-9
C
- caches
- performance statistics, 7-3
- use in iterative queries, 3-16
- calculation engine, 5-5
- defined, 1-6
- calculations
- runtime, 2-2
- catalogs
- defined, 4-15
- character sets, A-3
- CHARSET option, A-3
- CLEAN_ALTER_SESSION procedure, 8-6
- CMW2_OLAP_AW_ACCESS package
- generated script example, 15-20
- CNV_CWM.TO.ECM program, 3-3, 9-2 to 9-18
- syntax, 9-6
- composite dimensions, 15-4
- configuration procedures, 6-2
- conjoint dimensions, 15-4
- CONNECT role, 6-9
- CreateAWAccessStructures procedure, 9-3
- syntax, 15-25
- CreateAWAccessStructures_FR procedure
- generated script example, 15-20
- syntax, 15-24
- CREATECUBELEVELTUPLE procedure, 30-12
- CREATEDIMLEVTUPLE procedure, 30-11
- CREATEDIMMV_GS procedure, 30-14
- CREATEFACTMV_GS procedure, 30-13
- crosstab bean, 3-12
- Cube Viewer, 5-10
- cubes, 12-7
- creating, 22-3
- defined, 4-14, 5-9, 22-2
- fact table requirements, 22-2
- materialized views, 28-6, 30-1 to 30-14, 31-1 to 31-11
- viewing, 5-10
- cursors, 3-16
- custom aggregates, 2-3
- custom measures, 3-13
- CWM, 5-2, 5-5, 27-2
- See Also OLAP Catalog
- CWM Lite
- See CWM
- CWM_CLASSIFY package, 27-1 to 27-17
- subprograms, 27-3
- CWM2, 5-2 to 5-3, 5-5, 5-11
- See Also OLAP Catalog
- views, 13-1
- write APIs, 5-11
- CWM2_OLAP_AW_ACCESS package, 3-3, 5-3, 15-1 to 15-25
- subprograms, 15-23
- CWM2_OLAP_AW_MAP package, 5-12, 26-1 to 26-15
- subprograms, 26-2
- CWM2_OLAP_AW_OBJECT package, 5-4, 5-11, 25-1 to 25-9
- subprograms, 25-2
- CWM2_OLAP_CUBE package, 5-11, 22-1 to 22-15
- subprograms, 22-4
- CWM2_OLAP_DIMENSION package, 5-11, 17-1 to 17-13
- subprograms, 17-5
- CWM2_OLAP_DIMENSION_ATTRIBUTE package, 5-11, 18-1 to 18-11
- subprograms, 18-4
- CWM2_OLAP_HIERARCHY package, 5-11, 19-1 to 19-12
- subprograms, 19-3
- CWM2_OLAP_LEVEL package, 5-11, 20-1 to 20-14
- subprograms, 20-3
- CWM2_OLAP_LEVEL_ATTRIBUTE package, 5-11, 21-1 to 21-13
- subprograms, 21-3
- CWM2_OLAP_MEASURE package, 5-11, 23-1 to 23-11
- subprograms, 23-4
- CWM2_OLAP_PC_TRANSFORM package, 5-3, 16-1 to 16-4, 17-2
- CWM2_OLAP_TABLE_MAP package, 5-12, 24-1 to 24-23
- subprograms, 24-4
D
- data exchange commands, 2-5
- data formatting, 3-11
- data selection commands, 2-5
- data storage, 4-7
- data striping, 6-5
- database cache, 7-3
- database configuration, 6-2
- database initialization, 8-1, 8-2
- database security, 6-9
- DB_CACHE_SIZE parameter, 6-3
- DBMS_AW package, 2-9, 3-4
- EXECUTE procedure, 10-3, 10-5
- GETLOG function, 10-10
- INTERP function, 10-6
- INTERPCLOB function, 10-8
- overview, 10-1, 10-2
- PRINTLOG procedure, 10-11
- DBMS_ODM package, 28-3, 29-2, 30-1 to 30-14
- subprograms, 30-11
- DEFINE command, 9-4
- DELETE_ALTER_SESSION procedure, 8-5
- demand planning systems, 1-4
- derived data, 4-4
- dimension alias, 12-5
- dimension attributes, 12-9, 17-4
- creating, 18-2
- defined, 4-14, 18-2
- dimension hierarchies
- See hierarchies
- dimension tables, 4-4, 5-8, 12-14, 17-2, 24-2
- joining with fact tables, 24-2
- dimension views
- defining for workspace objects, 15-11
- dimensions, 12-13
- analytic workspace, 15-4
- creating, 5-8, 5-9, 17-3
- defined, 4-10, 17-2
- embedded-total, 16-2
- exposing in views, 15-4
- materialized views, 28-4, 29-1 to 29-11
- parent/child, 5-3, 16-1
- time, 4-11, 5-9, 17-2, 17-3
- valid, 17-4
- directory aliases, 6-9
- drilling
- described, 3-11
- dynamic performance tables, 6-13
- dynamic performance views, 7-1 to 7-6
E
- ECM catalogs, 9-12
- end-date attribute, 4-11, 17-3
- ETL process, 2-2
- ETT tool, 4-2
- Express Common Metadata, A-2, A-5
- Express Connection Utility (obsolete), A-5
- Express databases, A-7
- Express Relational Access Administrator, A-3
- Express Relational Access Manager, A-3
- Express Web Agent support, A-5
F
- fact tables, 4-4, 4-10, 5-9, 12-14, 22-2, 24-2
- joining with dimension tables, 24-2
- supported configurations, 24-2
- fact views
- defining from workspace objects, 15-15
- file read/write commands, 2-5
- files
- allowing access, 6-9
- financial applications, 1-3
- financial operations, 2-6
- fixed views, 7-2
- forecasting commands, 2-6
- formatting
- data, 3-11
G
- GENSQLOBJS program, 9-10
- gid
- See grouping IDs
- globalization, A-3
- Globalization Technology . See NLS
- graph bean, 3-11
- grouping IDs, 12-16
- parent, 15-8
- GROUPINGID command, 11-3, 11-8, 11-11, 15-7
H
- hierarchical dimensions, 15-4
- hierarchies, 12-10, 12-17, 17-2, 17-4
- creating, 5-9, 19-2
- custom sorting, 12-16, 24-8
- defined, 4-13, 19-2
- hierarchy dimension
- defined, 15-4
- HIERHEIGHT command, 11-3, 11-11, 15-5, 15-9
- historical data, 4-3
I
- IDE
- defined, 3-6
- in hierarchy variables, 15-6
- initialization parameters, 8-1, 8-2
- init.ora file, 6-3, 8-2
- Instance Manager (obsolete), A-2
J
- Java
- described, 3-4
- sandbox security, 3-5
- Java Database Connectivity, A-5
- JDBC communications, A-5
- JDeveloper, 3-6
L
- language support, A-3
- level attributes, 12-11, 12-12, 17-4
- creating, 21-2
- defined, 4-14, 21-2
- level dimensions, 15-5
- levels, 12-12, 17-4
- creating, 5-9, 20-2
- defined, 4-13, 20-2
- defining an integer dimension for, 11-3, 15-5
- limit maps
- OLAP_TABLE function, 11-7 to 11-10
- LISTNAMES VARIABLE command, 9-12
- localization, A-3
- login names, 6-9
- lookup tables
- See dimension tables
M
- materialized views, 4-4
- asymmetric materialization, 28-8
- concatenated rollup, 28-3, 28-7, 31-1 to 31-11
- cubes, 30-1 to 30-14, 31-1 to 31-11
- CWM2, 30-2
- defined, 28-2
- dimensions, 29-1 to 29-11
- for OLAP API, 28-1 to 28-9
- grouping sets, 28-3, 28-7, 30-2 to 30-14, 30-2 to 30-14
- MDI
- defined, 3-6
- measure folders, 12-4, 13-4, 27-2
- defined, 4-15, 12-4
- measures, 12-7
- analytic workspace, 15-3
- creating, 23-2
- custom, 3-13
- defined, 4-9, 22-2, 23-2
- exposing in a view, 15-3
- metadata
- defined, 4-4, 4-8
- modeling commands, 2-7
- modeling support, A-6
- multibyte character sets
- Express equivalents, A-4
N
- NLS_LANG configuration parameter, A-3
- n-pass functions, 3-16
- number formatting, 3-11
- numeric computation, 2-7
O
- object types, 3-2
- object-oriented programming, 3-13
- OCI communications, A-5
- ODBC support (obsolete), A-3
- oescmd program (obsolete), A-2
- oesmgr program (obsolete), A-2
- OLADM, 10-3, 10-6, 10-8
- OLAP
- defined, 1-2
- OLAP 1 Catalog
- See CWM
- OLAP 2 Catalog
- See CWM2
- OLAP API, 5-5
- defined, 1-7
- described, 3-6, 3-13
- OLAP API optimization, 8-1, 8-2
- OLAP beans, 3-7, 3-12
- OLAP Catalog, 5-2
- classification system, 12-5, 12-14, 13-4, 27-2
- CWM, 5-2, 5-7
- CWM and CWM2, 5-4, 5-5, 27-2
- CWM2 views, 13-3
- defined, 1-8, 5-5
- metadata model tables, 5-6
- preprocessors, 5-6, 16-1, 17-2
- read APIs, 5-6, 12-1, 13-1, 14-1
- union views, 12-1
- write APIs, 5-6
- OLAP commands
- executing in SQL, 10-3, 10-5, 10-8, 10-10
- OLAP DML
- defined, 1-6
- described, 2-1 to 2-9, 25-2
- executing commands, 2-9
- OLAP Management tool, 5-7
- OLAP metadata
- creating for a dimension table, 5-12
- creating for a fact table, 5-15
- logical steps for creating, 5-6
- mapping, 5-14 to 5-16, 12-6, 12-11, 12-18, 17-4, 24-2, 26-2
- materialized views, 28-3
- tools for creating, 5-2
- OLAP performance views, 7-2
- OLAP Summary Advisor, 28-3, 29-2, 31-1 to 31-11
- OLAP Worksheet, 2-9, A-5
- OLAP_API_SESSION_INIT package, 8-1 to 8-7
- OLAP_DBA role, 5-4
- OLAP_TABLE function, 9-4
- example, 11-11
- limit map, 11-7 to 11-10
- preparing analytic workspace for, 11-3
- retrieving session log, 10-10
- syntax, 11-5
- type definitions, 11-4 to 11-5
- use in SELECT statement, 11-2
- uses, 3-4
- OLAP2_CATALOG_ENTITY_USES view, 12-4
- OLAP2_CATALOGS view, 12-4
- OLAP2_CUBE_DIM_USES view, 12-5
- OLAP2_CUBE_MEAS_DIM_USES view, 12-6
- OLAP2_CUBE_MEASURE_MAPS view, 12-6
- OLAP2_CUBE_MEASURES view, 12-7
- OLAP2_CUBES view, 12-7
- OLAP2_DIM_ATTR_USES view, 12-8
- OLAP2_DIM_ATTRIBUTES view, 12-9
- OLAP2_DIM_HIER_LEVEL_USES view, 12-10
- OLAP2_DIM_HIERARCHIES view, 12-10
- OLAP2_DIM_LEVEL_ATTR_MAPS view, 12-11
- OLAP2_DIM_LEVEL_ATTRIBUTES view, 12-12
- OLAP2_DIM_LEVELS view, 12-12
- OLAP2_DIMENSIONS view, 12-13
- OLAP2_FACT_LEVEL_USES view, 12-14
- OLAP2_FACT_TABLE_GID view, 12-16
- OLAP2_HIER_CUSTOM_SORT view, 12-16
- OLAP2_JOIN_KEY_COLUMN_USES view, 12-17
- OLAP2_LEVEL_KEY_COLUMN_USES view, 12-18
- OLAPSYS user, 5-4
- OLTP
- defined, 1-2
- optimization
- OLAP API, 8-1, 8-2
- optimization techniques, 6-5
- Oracle Call Interface, A-5
- Oracle Globalization Support. See also NLS, xxxv
- Oracle Instance Manager (obsolete), A-2
P
- page pool
- performance statistics, 7-3
- paging
- described, 3-11
- parallel_max_servers parameter, 6-3
- parameter file, 6-3
- parent-child relation
- defined, 15-5
- parent-child relations, 15-5
- performance counters, 6-13, 7-1 to 7-6
- Personal Express (obsolete), A-5
- pfile settings, 6-3
- PGA allocation, 7-3
- pivoting
- described, 3-11
- predictive analytsis applications, 1-3
- Presentation Beans, 3-7
- PS$ tables, 6-12
Q
- query builder, 3-13
- QUERY REWRITE system privilege, 6-9
- querying methods, 1-9
R
- rank formatting, 3-11
- referential integrity, 2-3
- regressions, 2-6
- Relational Access Administrator (obsolete), A-3
- Relational Access Manager (obsolete), A-3
- reporting applications, 1-3
- repository
- application runtime, 3-10
- result sets, 3-16
- roles, 6-9
S
- schemas
- star, snowflake defined, 4-6
- star,snowflake, 5-2, 5-7
- SELECT privilege, 6-9
- SELECT statements
- using OLAP_TABLE function, 11-2
- server parameter file, 6-3
- session cache
- performance statistics, 7-3
- session counters, 7-6
- session logs
- printing, 10-11
- retrieving, 10-10
- session sharing, A-5
- session statistics, 7-5
- sessions parameter, 6-3
- simultaneous equations, 2-7
- SNAPI communications (obsolete), A-5
- SNAPI support (obsolete), A-5
- SPLExecutor class, 2-9
- SQL
- embedding OLAP commands, 10-3, 10-5, 10-8, 10-10
- SQL command (OLAP DML), A-3
- SQL FETCH command, 2-5, 9-4
- SQL IMPORT command, 9-4
- SQL-99 extensions, 1-5
- SQL-based applications
- components, 3-2
- star schema
- materialized views, 28-2
- statistical operations, 2-8
- stoplight formatting, 3-11
- striping, 6-5
- summary management
- See materialized views
- summary tables
- See materialized views
T
- table bean, 3-12
- table functions
- defined, 1-7, 3-2
- tablespaces
- for analytic workspaces, 6-5
- text manipulation, 2-8
- thick-client applications
- defined, 3-5
- illustrated, 3-8
- thin-client applications
- defined, 3-5
- illustrated, 3-9
- tiers, 3-8, 3-9
- time dimensions, 4-11, 5-9, 17-2, 17-3
- time periods
- regular, irregular defined, 4-11
- time series functions, 2-8
- time-span attributes, 4-11
- transaction statistics, 7-6
- translation tables, A-3
- type definitions
- for OLAP_TABLE, 11-4 to 11-5
U
- Unicode, A-4
- union views, 12-2
- user access rights, 6-9
- user names, 6-9
- utl_file_dir parameter, 6-3, 15-2
V
- V$AW_CALC view, 7-3
- V$AW_OLAP view, 7-5
- V$AW_SESSION_INFO view, 7-6
- views
- analytic workspace metadata objects, 14-1
- creating for analytic workspaces, 11-2, 15-1, 15-2
- CWM and CWM2, 12-1, 12-2
- CWM2, 13-1
W
- wizards
- Beans, 3-12
- workspaces
- See Also analytic workspaces, 9-1
X
- XCA support, A-5