Index

Symbols

_ wildcard 2.3.8.6.1
((amp)) operator 2.3.10
$AGGMAP property 4.4
$AGGREGATE_FORCECALC property 4.5
$AGGREGATE_FORCEORDER property 4.6
$AGGREGATE_FROM property 4.7, 9.9.9
$AGGREGATE_FROMVAR property 4.8
$ALLOCMAP property 4.9
$COUNTVAR property 4.10
$DEFAULT_LANGUAGE property 4.11
$GID_DEPTH property 4.12
$GID_LIST property 4.13
$GID_TYPE property 4.14
$LOOP_AGGMAP property 4.15
$LOOP_DENSE property 4.16
- for derived measures in cubes 10.53
$LOOP_TYPE property 4.17
$LOOP_VAR property 4.18
- for derived measures in cubes 10.53
$NATRIGGER property
- calling recursively 5.88
- executing simultaneously 5.104
$STORETRIGGERVAL property 4.20
$VARCACHE property
% wildcard 2.3.8.6.1
= command 10.50
- event 10.66, 10.67
- trigger 10.66, 10.67

Numerics

20th century 9.33
21st century 9.33

A

A.D. datetime format element 9.33
A.M. datetime format element 9.33
ABS function
abstract data types A.1.2, A.3
- automatic A.1.2.2, A.3
- predefining A.1.2.1, A.3
ACQUIRE command
ACROSS command
ADD_ALTER_SESSION procedure (PL/SQL) C.3.1
ADD_CUBE_MODEL program 9.6
ADD_DIMENSION_MEMBER program 9.7
ADD_DIMENSION_SOURCE procedure (PL/SQL) B.6
ADD_MODEL_DIMENSION program 9.8
ADD_MONTHS command
AD datetime format element 9.33
ADT
- See abstract data types A.1.2.1, A.3
ADVISE_CUBE procedure (PL/SQL) B.7
ADVISE_DIMENSIONALITY function (PL/SQL) B.8
ADVISE_DIMENSIONALITY procedure (PL/SQL) B.9
ADVISE_REL procedure B.4.2
ADVISE_REL procedure (PL/SQL) B.12
ADVISE_SPARSITY procedure (PL/SQL) B.13
Aggcount variables 7.6, 8.53, 9.24, 9.35.11
AGGINDEX statement
AGGMAP ADD model command
AGGMAP command
AGGMAPINFO command
aggmap objects
- identifying changes 7.39
AGGMAP REMOVE model command
aggmaps 9.35.1
- See also: aggregation specifications, allocation specifications
- compiling 3.4.3, 9.27
- defining 9.35.1
- deleting 9.36
- in formulas 8.53
- list of 7.26
- removing models from in cube dimensions 10.41
AGGMAP SET command
Aggregate Advisor 3.4.4, 9.9.8, 9.9.9
AGGREGATE command
AGGREGATE function
aggregating data 3.4.1
- See also: aggregation specifications
- caching 5.108
- formulas for 7.8
- on-the-fly 3.4.4
- partitioned variables 8.59
- precomputing 3.4.4
- specifying a relation for 9.9.9
- using an Aggcount variable 7.6
- using an aggmap object 3.4.1
- using TCONVERT 8.124
aggregation
- in analytic workspaces B.4
AGGREGATION function
aggregations
- identifying changes 7.39, 7.40, 7.111
aggregation specifications 3.4.3
- See also: aggregating data
- compiling 3.4.3
- defining 9.35.1
- deleting 9.36
- models in 9.10, 10.16.1.3
- writing 9.9
algorithm for composite values 5.94
alias dimensions
- base dimensions (list of) 8.53
- defining 9.35.3.5
- deleting 9.36
- limiting 9.35.3.5
- maintaining 9.35.3.5
- populating 9.35.3.5
- retrieving list of 8.53
aliases
- for analytic workspaces 2.3.2.2
- for analytic workspaces. See analytic workspace aliases 2.3.2.2
- for dimensions. See alias dimensions 9.35.3.5
ALLCOMPILE program
ALLOCATE command
allocating data 3.5
- See also: allocation specifications
- using an aggmap object 3.5
- using TCONVERT 8.124
allocation specifications 9.15
- See also: allocating data
- defining 9.35.1
- deleting 9.36
- writing 9.15
ALLOCERRLOGFORMAT option 5.4
ALLOCERRLOGHEADER option
ALLOCMAP command
ALLSTAT command
AM datetime format element 9.33
ampersand (((amp))) operator 2.3.10
ampersand substitution
- example of 2.3.10
- program arguments and 6.3.2.3
- QDR with 2.3.2.5.6, 2.3.10
- using to pass arguments 6.3.2.3, 10.9
analytic workspace aliases
- creating 9.18.1
- definition of 2.3.2.2
- deleting 9.18.1
analytic workspace objects
- underlying cubes and cube dimensions 8.55
analytic workspaces
- accessing from SQL B
- aggregation B.4
- aliases. See analytic workspace aliases 2.3.2.2
- attached (list of) 8.53
- attaching 5.6, 9.18.2
- content summary, displaying 9.19
- creating 9.18.3
- current 2.3.2.2
- deleting 9.18.4, 9.18.12
- deleting objects from 9.36
- detaching 6.8.3, 9.18.5
- exporting 6.7.6
- identifying active 9.18.7
- importing 6.7.6
- naming 2.3.2.2
- obtaining information about 7.26
- partitioning 9.18.3
- segmenting 9.18.10
- sharing 5.6
- updating 10.69
ANTILOG10 function
ANTILOG function
ANY function
ARCCOS function
ARCSIN function
ARCTAN2 function 7.18
ARCTAN function 7.17
arc tangent calculation 7.18
ARG command
- See: ARGUMENT command
ARGCOUNT function
ARGFR function
ARG function
ARGS function
ARGUMENT command
arguments 7.19
- in user-defined functions 6.3.1
- passing as text 6.3.2.3, 10.9
- passing to a program 7.19, 7.20, 7.21, 7.22, 9.22
- using ampersand substitution with 6.3.2.3
arithmetic
- with DATE values 2.3.6.3
ASCII function 7.23
ASCIISTR function 7.24
Assign event 10.66
assignment statements
- event 10.66, 10.67
- trigger 10.66, 10.67
- with different dimensionality 8.145
- with QDR 2.3.2.5.2
authentication 8.56
- encoding text expressions 8.56
- within Oracle OLAP 10.26
AUTOGO program 6.8.1
AVERAGE function 7.25
AW_ATTACH procedure (PL/SQL) B.14
AW_COPY procedure (PL/SQL) B.15
AW_CREATE procedure (PL/SQL) B.16
AW_DELETE procedure (PL/SQL) B.17
AW_DETACH procedure (PL/SQL) B.18
AW_RENAME procedure (PL/SQL) B.19
AW_TABLESPACE function (PL/SQL) B.20
AW_UPDATE procedure (PL/SQL) B.21
AW command
- AW ALIASLIST 9.18.1
- AW ATTACH 9.18.2
- AW CREATE 9.18.3
- AW DELETE 9.18.4
- AW DETACH 9.18.5
- AW FREEZE 9.18.6
- AW LIST 9.18.7
- AW PURGE 9.18.8
- AW ROLLBACK 9.18.9
- AW SEGMENTSIZE 9.18.10
- AW THAW 9.18.11
- events 6.8.7
- triggers 6.8.7
AWDESCRIBE program
AW function
AW PURGE 9.18.8
AWWAITTIME option 5.6

B

B.C. datetime format element 9.33
BACK function 7.10, 7.11, 7.27
BADLINE option 5.7, 6.5.2
base dimensions
- finding values of 7.29, 7.119
- identifying 7.28
- setting status list of 10.10
BASEDIM function 7.28
BASEVAL function 7.29
BC datetime format element 9.33
BEGINDATE 7.30
BIN_TO_NUM function 7.31
binary data 2.1.6
BITAND function 7.32
bits, adding 7.32
BLANK command 9.20
blank lines in reports 9.20
BLANKSTRIP function 7.33
BMARGIN option 5.8
Boolean
- data type 2.1.5
- expressions 2.3.8
- operators 2.2.2
- values 5.75, 5.111
branching in programs 9.21, 9.30, 9.59, 10.5, 10.9, 10.61
BREAK command 9.21
bucket numbers, retrieving 8.154
build number of Oracle OLAP 7.69
bytes
- used by expression 8.152
bytes strings 2.1.6

C

caches
- See: OLAP session cache
CACHE statement 9.9.3
caching 9.18.8
calculated members
- adding to dimension 10.16.1.3
- identifying 7.113
calculating a linear regression 10.37
CALENDARWEEK option 5.9
CALL command 9.22
CALLTYPE function 7.34
case statement in programs 10.61
CATEGORIZE function 7.35
CDA command 9.23
CEIL function 7.36
CHANGEBYTES function 7.37
CHANGECHARS function 7.38
CHANGEDRELATIONS function 7.39
CHANGEDVALIES function 7.40
characters
- converting 7.24
- replacing 8.76
- representing as decimals 2.1.2.2
- representing as hexadecimals 2.1.2.2
- representing as Unicode 2.1.2.2
- special 2.1.2.2
character sets 8.39, 8.40
CHARLIST function 7.41
CHGDFN command 9.24
CHGDIMS function 7.43
CHILDLOCK statement 9.15.1
CHR function 7.44
CLEAN_ALTER_SESSION procedure (PL/SQL) C.3.2
CLEANUP command
- See: SQL command in OLAP DML
CLEAR command 9.25
CLOSE command
- See: SQL command in OLAP DML
COALESCE function 7.45
code comments 2.1.2.1
columns
- default width in reports 5.10, 5.38
- getting value from a report column 7.46
- headings in a report 10.1
- in reports 5.10
- multiline text 7.72
COLVAL function 7.46
COLWIDTH function 5.10
COMMAS option 5.11
comments
- code 2.1.2.1
comments in programs 6.3
COMMIT command 9.26
comparing
- dates 2.3.8.5
- values 2.3.8.2, 2.3.8.6
comparison operators 2.2.2
compilable objects 5.13
COMPILE command 9.27
COMPILEMESSAGE option 5.12
COMPILEWARN option 5.13
compiling 5.13
- aggmaps 3.4.3
- aggregation specifications 3.4.3
- models 3.3.3
- programs 6.4
- SQL statements 10.58.8
- suppressing error messages 5.12
composites 2.3.2.4, 9.35.11
- See also: unnamed composites
- base dimension values 7.119
- changing to conjoint dimensions 9.24
- defining 1.5.1.2, 9.35.2
- deleting 9.36
- deleting values of 10.16.2.2
- index algorithm 5.94
- index type (determining) 8.53
- listing associated objects 10.11
- maintaining 10.16
- reporting 10.45, 10.49
- showing a value 10.54
- specifying values for 2.3.2.3.1
- specifying values of 2.3.2.3.1, 2.3.2.3.2
- testing for a value 7.114
- unnamed 9.35.11
composites (regular and compressed)
- defined B.3.1
concat dimensions 9.35.3.4
- See also: dimensions
- defining 9.35.3.4
- deleting 9.36
- specifying values for 2.3.2.3.2
conditional execution of commands 9.38
conditional expressions
- Boolean 2.3.9.1
- IF 2.3.9.1
- SWITCH 2.3.9.2
conditional operators 2.3.9
conjoint dimensions 9.35.3.3
- See also: dimensions
- base dimension values 7.119
- changing to composites 9.24
- defining 9.35.3.3
- deleting 9.36
- index type (determining) 8.53
CONSIDER command 9.28
CONTEXT command 6.3.4.6, 9.29
CONTEXT function 6.3.4.6, 7.47
CONTINUE command 9.30
controlled sparsity 9.35.3.1
conversion
- rules, string to date 2.1.4.3, 7.48
CONVERT function 7.48
converting
- characters 7.24
- hexidecimal digits to raw 7.94
- numerics 8.126, 8.127
- raw values 8.64
- ROWID data type 8.84, 8.85
- to ASCII 7.24
- to DSINTERVAL 8.130
- to YMINTERVAL 8.135
converting data types
- decimals to integers 7.107
- introduction to 2.1.8
CONVERT procedure (PL/SQL) B.22
COPYDFN command 9.31
copying definitions 9.31
CORRELATION function 7.49
COS function 7.50
COSH function 7.51
cosine calculation 7.50, 7.51
COUNT function 7.52
CREATE_LOGICAL_MODEL program 9.32
cube dimension members
- adding to a hierarchy 10.71
- removing 10.42
- removing from a hierarchy 10.42
cube dimensions
- adding dimensions to models 9.8
- adding models to 9.6
- adding model to 10.52
- creating models for 9.32
- deleting model from 10.52
- identifying physical characteristics of 8.55
- removing dimensions from models 10.43
- removing models fromaggmaps 10.41
cubes
- identifying physical characteristics of 8.55
CUMSUM function 7.53
cumulative totals 7.53, 8.88
current
- analytic workspace 2.3.2.2
CURRENT_DATE function 7.54
CURRENT_TIMESTAMP function 7.55
current directory 9.23
- changing 9.23
- identifying 9.23
current outfile 5.24, 10.23
current status list
- setting 10.9
cursors 10.58.2
- closing (SQL) 10.58.2
- importing (SQL) 10.58.6
custom measures A.2.1
- examples with OLAP_EXPRESSION A.5

D

data
- binary 2.1.6
DATABASE command
- See: AW command
- name change D.3.4
DATABASE function
- See: AW function
- name change D.3.4
database initialization C, C.1
data export programs 6.7.2
data fetches (SQL) 10.58.5
data import programs 6.7.2
data type conversions A.3
data types
- Boolean 2.1.5
- converting 2.1.8
- creating a report 10.45, 10.49
- date 2.1.4, 2.1.4.4
- DATE 2.1.3
- DATETIME 2.1.4
- determining data type of an object 8.53
- DSINTERVAL 2.1.4.9
- for variables 9.35.11
- numeric 2.1.1
- of expressions 2.3.1.1
- of numeric expressions 2.3.4.1
- of user-defined function 6.3.1
- qualifying data for expressions 8.61
- RAW 2.1.6
- restricting access 10.26
- ROWID 2.1.7.1
- showing a single value 10.54
- text 2.1.2
- TIMESTAMP 2.1.4.5
- TIMESTAMP_LTZ 2.1.4.7
- TIMESTAMP_TZ 2.1.4.6
- transferring from one format to another 8.145
- UROWID 2.1.7.2
- YMINTERVAL 2.1.4.8
DATE_FORMAT 9.33
date data types 2.1.4, 2.1.4.4
DATE data types 2.1.3
date format models 9.33
- long 9.33
- punctuation in 9.33
- short 9.33
- text in 9.33
DATEFORMAT option 5.14
DATEORDER option 5.15
dates 8.117, 8.137
- arithmetic 2.3.6.3
- comparing 2.3.8.5
- current 8.117, 8.137
- in arithmetic expressions 2.3.7
- in text expressions 2.3.5.2
datetime arithmetic 2.3.6.3
datetime data
- format of 9.33
DATETIME data type 2.3.5.2
DATETIME data types 2.1.4
datetime expressions 2.3.6.1
datetime format elements
- and Globalization Support 9.33
- capitalization 9.33
- ISO standard 9.33
- RR 9.33
- suffixes 9.33
datetime values
- truncating 8.142.1
DAYABBRLEN option 5.16
DAY datetime format element 9.33
DAYNAMES option 5.17
DAYOF function 7.56
DBDESCRIBE program
- See: AWDESCRIBE program
- name change D.3.4
DBGOUTFILE command 6.5.3, 9.34
- and ECHOPROMPT 5.24
DBMS_AW package
DBMS_AW PL/SQL package
- ADD_DIMENSION_SOURCE procedure B.6
- ADVISE_CUBE procedure B.7
- ADVISE_DIMENSIONALITY function B.8
- ADVISE_DIMENSIONALITY procedure B.9
- ADVISE_REL procedure B.12
- ADVISE_SPARSITY procedure B.13
- AW_ATTACH procedure B.14
- AW_COPY procedure B.15
- AW_CREATE procedure B.16
- AW_DELETE procedure B.17
- AW_DETACH procedure B.18
- AW_RENAME procedure B.19
- AW_TABLESPACE function B.20
- AW_UPDATE procedure B.21
- CONVERT procedure B.22
- EVAL_NUMBER function B.23
- EVAL_TEXT function B.24
- EXECUTE procedure B.25
- GETLOG function B.26
- INFILE procedure B.27
- INTERP_SILENT function B.30
- INTERPCLOB function B.29
- INTERP function B.28
- OLAP_ON function B.31, B.32
- PRINTLOG procedure B.33
- RUN procedure B.34
- SHUTDOWN procedure B.35
- SPARSITY_ADVICE_TABLE procedure B.36
- STARTUP procedure B.37
DBTIMEZONE function 7.57
DBWAITTIME option
- See: AWWAITTIME option
- name change D.3.4
DDOF function 7.58
DEADLOCK statement 9.15.2
debugging 5.36
- formulas 10.63
- models 3.3.5, 10.63
- programs 6.5, 10.63
DECIMALCHAR option 5.18
decimal data types, comparing 2.3.8.3.3
decimal marker (displayed) 5.18
DECIMALOVERFLOW option 5.19
decimal places (displayed) 5.20
DECIMALS option 5.20
decimal values 5.18
- decimal marker for output 5.18
- truncating to an integer 7.107
DECLARE CURSOR command
- See: SQL command in OLAP DML
DECODE function 7.59
default
- outfile 10.23
- relations 2.3.2.3.3, 10.39
DEFAULTAWSEGSIZE option 5.21
DEFAULTDBFSIZE option
- See: DEFAULTAWSEGSIZE option
- name change D.3.4
default status list
- determining if in effect 8.101
DEFINE AGGMAP command 9.35.1
DEFINE command 9.35
- events 6.8.9
- triggers 6.8.9
DEFINE COMPOSITE command 9.35.2
DEFINE DIMENSION ALIASOF command
DEFINE DIMENSION command 9.35.3
DEFINE FORMULA command 9.35.4
DEFINE MODEL command 9.35.5
DEFINE PARTITION TEMPLATE command 9.35.6
DEFINE PROGRAM command 9.35.7
DEFINE RELATION command 9.35.8
DEFINE SURROGATE command 9.35.9
DEFINE VALUESET command 9.35.10
DEFINE VARIABLE command 9.35.11
DEFINE WORKSHEET command 9.35.12
defining
- aggmap objects 9.35.1
- alias dimensions 9.35.3.5
- analytic workspace objects 9.35
- dimension alias 9.35.3.5
- dimensions 9.35.3
- formulas 9.35.4
- partitions 9.35.6
- programs 9.35.7
- relations 9.35.8
- surrogates 9.35.9
- valuesets 9.35.10
- variables 9.35.11
- worksheet objects 9.35.12
definitions
- copying 9.31
- creating 9.35
- creating object properties 10.31
- deleting 9.36
- moving within NAME dimension 10.22
- report of 9.37, 9.58
- testing for 7.67
DELETE_ALTER_SESSION procedure (PL/SQL) C.3.3
DELETE command 9.36
- event 10.66
- trigger 10.66
Delete event 10.66
deleting
- alias dimensions 9.36
- composites 9.36
- composite values 10.16.2.2
- definitions 9.36
- dimension alias 9.36
- dimensions 9.36
- dimension values 10.16.2, 10.16.2.1
- formulas 9.36
- models 9.36
- objects 9.36
- partitions 9.36
- partition templates 9.36
- programs 9.36
- surrogates 9.36
- triggers 10.66
- valuesets 9.36
DEPRDECL function 7.60
DEPRDECLSW function 7.61
depreciation of assets 7.60, 7.61, 7.62, 7.63
DEPRSL function 7.62
DEPRSOYD function 7.63
DESCRIBE command 9.37
descriptions
- adding to a definition 10.8
- deleting from a definition 10.8
detaching
- analytic workspaces 6.8.3
dimension alias
- See alias dimensions 9.35.3.5
dimensionality, changing 7.43
dimension-based equations 3.3.1
DIMENSION command, in a model 10.17.1
dimensions 9.35.3
- See also: alias dimensions, base dimensions, concat dimensions, conjoint dimensions, simple dimensions
- adding to cube dimension models 9.8
- checking status of 8.101
- comparing values 2.3.8.4
- defining 9.35.3
- defining surrogates for 9.35.9
- deleting 9.36
- determining status of 8.101
- limiting 10.9
- limiting to single value 2.3.2.5
- listing associated objects 10.11
- looping over values of 9.55
- maintaining 10.16
- numeric value of text dimension 2.3.4.2
- of expression 2.3.1.2, 2.3.1.2.1
- order in models 10.17.1
- QDR with 2.3.2.5, 2.3.2.5.5
- related 2.3.2.3.3, 10.39
- removing from cube dimension models 10.43
- restoring previous values 6.3.4.3
- saving current values 6.3.4.3
- status lists 8.102, 8.103
- type of (determining) 8.53
- worksheet 9.35.12
DIMENSION statement
- for aggregation 9.9.4
- for allocation 9.15.3
dimension status
- effect on expressions 2.3.1.2.2
- null 5.77
- restoring 6.3.4.2
- saving current 6.3.4.2
dimension surrogates
- assigning values to 10.50
- defining 9.35.9
dimension values
- comparing 2.3.8.4
- counting related values 8.121
- deleting values of 10.16.2, 10.16.2.1
- latest value 8.109
- null 5.77
- number of (determining) 8.53
- number of values in status 8.107
- place in status list 8.111
- retrieving current status list
  - retrieving 8.108
- returning first value in status 8.105
- returning last value in status 8.106
- setting the status of 10.9
- sorting 8.95, 10.57
- testing for 7.114
- using qualified data reference 8.61
- using result of LIMIT command 8.10
directory
- changing 9.23
- identifying current 9.23
displaying error messages 5.110
DIVIDEBYZERO option 5.22
division 8.70
- by zero 5.22
- calculating the remainder 8.70
DO command 9.38, 9.55
- used with FOR 9.55
- used with SWITCH 10.61
- used with WHILE 10.74
DOEND command 9.38
double quotes 2.1.2.1
DSECONDS option 5.23
DSINTERVAL data type 2.1.4.9
DSINTERVAL function 8.130
DY datetime format element 9.33

E

ECHOPROMPT option 5.24, 6.5.3
EDIT command 9.39
editing previously executed commands 10.36
EIFBYTES option 5.25
EIFEXTENSIONPATH option 5.26
EIF file 6.7.6, 9.41
- exporting data from 9.41
- importing data from 10.6
EIFNAMES option 5.27
EIFSHORTNAMES option 5.28
EIFTYPES option 5.29
EIFUPDBYTES option 5.30
EIFVERSION option 5.31
embedded-total dimension views A.3
embedded-total fact view A.3
encoding 8.56
ENDDATE function 7.64
ENDOF function 7.65
EQ command 9.40
equations, dimension-based 3.3.1
ERRNAMES option 5.32
ERRORLOG statement 9.15.4
ERRORMASK statement 9.15.5
error messages 10.54
- creating your own 6.3.5.4
- deferring 6.3.5.1
- displaying 5.110
- option holding text of 5.34
- producing without error condition 10.54
- signaling error condition 10.55
- suppressing 5.12, 6.3.5.3
- suppressing during compilation 5.12
- wrapping 5.110
ERRORNAME option 5.33, 6.3.5
errors
- controlling during calculations 2.3.4.4
- handling 6.3.5
- handling in nested programs 10.65
- handling in programs 10.65
- name of first-occurring error 5.33
- signaling 6.3.5.4, 10.65
- SQL error codes 5.96
- when comparing numeric data 2.3.8.3, 2.3.8.3.2, 2.3.8.3.3
ERRORTEXT option 5.34, 6.3.5
ESCAPEBASE option 5.35
escape character for LIKE 5.40
escape sequences 2.1.2.2
EVAL_NUMBER function (PL/SQL) B.23
EVAL_TEXT function (PL/SQL) B.24
events
- Assign 10.66, 10.67
- assignment statements 10.66
- Define 6.8.9
- Delete 10.66
- deleting 10.66
- identifying 8.140
- Maintain 10.66
- Property 10.66
- Update 6.8.6, 6.8.8, 10.66
EVERSION function 7.69
EVERY function 7.66
EXECUTE procedure (PL/SQL) B.25
EXISTS function 7.67
EXP function 7.68
exponential forecasting 9.56
exponents, retrieving 7.68
EXPORT command 6.7.6, 9.41
exporting
- metadata 9.41.1
exporting data 5.25, 9.41.1
EXPORT to EIF command 9.41.1
EXPORT to spreadsheet command 9.41.2
expressions
- ampersand substitution 2.3.10
- Boolean 2.3.8, 2.3.9
- changing dimensionality of 7.43
- comparing 8.45
- conditional 2.3.9
- data type of 2.3.1.1
- dates in 2.3.7
- datetime 2.3.6.1
- defined 2.3
- determining dimensions of 2.3.1.2.1
- dimensions of 2.3.1.2, 2.3.1.2.1
- dimensions status 2.3.1.2.2
- empty cells 2.3.3
- internal representation of 8.152
- interval 2.3.6.2
- NA values in 2.3.3
- numeric 2.3.4
- objects in 2.3.2
- padding 8.18, 8.86
- parsing 10.25
- retrieving largest 7.91
- retrieving smallest 8.8
- saving 9.35.4
- size in bytes 8.152
- substitution 2.3.10
- text 2.3.5
- trimming 8.19, 8.87
- using objects in 2.3.2.4
- using qualified data references in 8.61
EXPTRACE option 5.36
EXTBYTES function 7.70
EXTCHARS function 7.71
EXTCOLS function 7.72
EXTLINES function 7.73
EXTRACT function 7.74

F

fastest-varying dimension 9.35.11
FCCLOSE command 9.42
FCEXEC command 9.43
FCOPEN command 7.75
FCQUERY command 7.76
FCSET command 9.44
FETCH command
- See: SQL command in OLAP DML
FETCH command (OLAP DML) A.3
fetching data (SQL) 10.58.5
FILECLOSE command 9.46
FILECOPY command 9.47
FILEDELETE command 9.48
FILEERROR function 7.77
FILEGET function 7.78
file I/O 7.78, 9.51, 7.80, 9.50, 9.46, 9.52, 9.53
- closing 7.78, 9.46
- current directory 9.23
- diagnosing errors when processing 7.77
- forcing a page break 9.50
- gathering information about 7.81
- list of open files 10.12
- opening 7.80
- processing data from 9.54
- reading a record 7.79
- reading data from 9.52
- reading Oracle OLAP commands from a file 7.90, 10.7
- records read 8.65
- setting attributes 9.53
- writing 9.51
FILEMOVE command 9.49
FILENEXT function 7.79
FILEOPEN function 7.80
FILEPAGE command 9.50
FILEPUT command 9.51
FILEQUERY function 7.81
FILEREAD command 9.52
files
- appending output 10.23
- importing data from 10.6.2
- saving output in 10.23
FILESET command 9.53
fileunits 7.80, 7.81
- attributes 7.81
- number of outfile destination 5.78
- opening 7.80, 10.23
- reading data from 9.52
- setting attributes 9.53
FILEVIEW command 9.54
FILTERLINES function 7.82
financial analysis, scenario modeling 3.3.2.6
FINDBYTES function 7.83
FINDCHARS function 7.84
FINDLINES function 7.85
FINTSCHED function 7.86
floating-point format
- limitations when calculating 2.3.4.3
- use of 2.3.4.3
floating point numbers, comparing 2.3.8.3.2
FLOOR function 7.87
FOR command 9.38, 9.55
- breaking out of 9.21
- example of 9.55
- looping over dimension values 9.55
- used with BREAK 9.21
- used with CONTINUE 9.30
- used with OKFORLIMIT 5.76
- used with TEMPSTAT 10.62
FORECAST.REPORT program 9.56, 9.57
FORECAST command 9.56
FORECAST function 7.98.1
forecasting context 9.42
- closing 9.42
- executing 9.43
- opening 7.75
- querying 7.76
- setting characteristics of 7.75
format model 9.33
format models 2.1.4.2
- date
  - changing 2.1.4.2, 9.33
  - default format 2.1.4.2, 9.33
formats
- for dates and numbers. See format models 2.1.4.2
- of return values from the database 2.1.4.2
- of values stored in the database 2.1.4.2
formatting
- datetime data 9.33
formulas
- aggmap objects in 8.53
- aggregating data with 7.8
- compiling 5.13, 9.27
- debugging 10.63
- defining 9.35.4
- deleting 9.36
- expression for (retrieving) 8.53
- recursive 5.88
- specifying new expression 9.40
FPMTSCHED function 7.88
FROM_TZ function 7.89
FULLDSC program 9.58
functions
- calling 9.22
- user-defined 6.3.1, 9.22, 10.47

G

GET function 7.90
GETLOG function (PL/SQL) B.26
GOTO command 9.59
GREATEST function 7.91
GROUPINGID command 9.60
GROUPINGID function 7.92
grouping ids 4.12, 4.13, 4.14
group marker 5.101
GROWRATE function 7.93
growth rate 7.93

H

handling errors in programs 10.65
hash partitions 9.18.3
hash values 8.57
heading 10.1
- for a report 10.1
- for output pages 5.80
- including a page number 5.79
- producing standard report heading 10.60
HEADING command
hexadecimal digits
- converting to raw 7.94
HEXTORAW function 7.94
HIDE command 10.2
hierarchies
- shape of 7.97
hierarchy shape 7.97
HIERHEIGHT command 10.4
HIERHEIGHT function 7.96
HIERSHAPE function 7.97
Holt-Winters forecasting 9.56
hyperbolic
- cosine calculation 7.51
- sine calculation 8.92
- tangent calculation 8.123

I

IDs
- character sets 8.39, 8.40
IF command 9.38, 10.5
IF conditional expression 2.3.9.1
IMPORT command 6.7.6, 10.58.6
- See also: SQL command in OLAP DML
importing
- metadata 10.6.1
importing data 5.25, 5.30
- controlling update frequency 5.30
- from an analytic workspace 10.6.1
- from spreadsheets 10.6.3
- from text files 10.6.2
- tracking names of objects 5.27
- tracking types of objects 5.29
INCLUDE command 10.17.2
INF_STOP_ON_ERROR option
INFILE command 10.7
INFILE procedure (PL/SQL) B.27
infinity
- numbers 7.110, 7.112
INFO function
- FORECAST 7.98.1
- MODEL 7.98.2
- PARSE 7.98.3
- REGRESS 7.98.4
INF values
- in OLAP DML 7.110
INITCAP function 7.99
initialization parameters C, C.1
INLIST function 7.100
input file
- reading from a file 7.90, 10.7
- with SNAPI connection 7.90
- with XCA dialog 7.90
INSBYTES function 7.101
INSCHARS function 7.102
INSCOLS function 7.103
INSLINES function 7.104
INSTAT function 7.105
INSTRB function 7.106
INSTRC function 7.106
INSTR function 7.106
integer part of decimal number 7.107
interest on loans 7.86, 8.150
internal rate of return 7.108
INTERP_SILENT procedure (PL/SQL) B.30
INTERPCLOB function (PL/SQL) B.29
INTERP function (PL/SQL) B.28
interval
- arithmetic 2.3.6.3
INTERVAL expressions 2.3.6.2
INTPART function 7.107
IRR function 7.108
ISDATE program 7.109
ISEMPTY function 7.111
ISINFINITE 7.110
ISNAN 7.112
ISSESSION function 7.113
ISVALUE function 7.114

J

JOINBYTES function 7.115
JOINCHARS function 7.116
JOINCOLS function 7.117
JOINLINES function 7.118

K

KEY function 7.119

L

label column width 5.38
- branching in a program 9.59
- for error handling in programs 10.65
labels 9.59
- in programs 6.3.5.6
- with IFNONE 10.9
LAGABSPCT function 8.2
LAGDIF function 8.3
LAG function 3.3.2.3, 8.1
LAGPCT function 8.4
larger value of two expressions 8.21
LARGEST function 8.5
largest value of an expression 8.5
LAST_DAY function 8.6
LCOLWIDTH option 5.38
LD command 10.8
LEAD function 3.3.2.3, 8.7
LEAST function 8.8
LENGTH2 function 8.9
LENGTH4 function 8.9
LENGTHB function 8.9
LENGTHC function 8.9
LENGTH function 8.9
LIKECASE option 5.39
LIKEESCAPE option 5.40
LIKENL option 5.41
LIKE operator 5.40, 5.41
LIMIT.SORTREL option 5.42
LIMIT BASEDIMS command 10.10
LIMIT command 10.9
- using LEVELREL 10.9.2
- using NOCONVERT 10.9.5
- using parent relation 10.9.4
- using POSLIST 10.9.6
- using related dimension 10.9.3
- using values 10.9.1
LIMIT function 8.10
limiting
- alias dimensions 9.35.3.5
- dimensions 10.9
- multidimensional valuesets 9.35.10
LIMITMAPINFO function 8.11
limit maps A.1, A.3
- order of processing A.3
- syntax A.3
LIMITSTRICT option 5.43, 10.9.1
LINENUM option 5.44
line size for report heading 5.47
LINESLEFT option 5.45
lines on a page of report output 5.81
LISTBY program 10.11
LISTFILES command 10.12
LISTNAMES program 10.13
literals
- numeric 2.1.1
- text 2.3.5
LOAD command 10.14
loans 7.86
- interest payment on 7.86
- interest payments on 8.150
- payment on 7.88
- payments on 8.151
locale independent 9.33
LOCALTIMESTAMP function 8.13
local variables 10.72
LOG10 function 8.15
LOG command 10.15
LOG function 8.14
logical operators 2.2.2
logs
- calculating base 10 logarithm 8.15
- calculating natural logarithm 8.14
LOOP clause in SQL FETCH 10.58.5
looping 9.55
- over dimension status 9.55
looping, explicit 4.15, 4.16, 4.17, 4.18
LOWCASE function 8.16
lowercase, converting to 8.16
LOWER function 8.17
LPAD function 8.18
LSIZE option 5.47
LTRIM function 8.19

M

MAINTAIN command
- event 10.66
- MAINTAIN ADD 10.16.1
- MAINTAIN ADD for DAY, WEEK, MONTH, QUARTER and YEAR values 10.16.1.2
- MAINTAIN ADD for TEXT, ID, and INTEGER values 10.16.1.1
- MAINTAIN ADD SESSION 10.16.1.3
- MAINTAIN DELETE 10.16.2, 10.16.2.1, 10.16.2.2
- MAINTAIN MERGE 10.16.3
- MAINTAIN MOVE 10.16.4.1
- MAINTAIN RENAME 10.16.5
- trigger 10.66
Maintain event 10.66
maintaining
- alias dimensions 9.35.3.5
- composites 10.16
- dimensions 10.16
- partitions 10.16
- partition templates 10.16
MAKEDATE function 8.20
margins 5.8
- setting bottom margin 5.8
- setting top margin 5.102
MAXBYTES function 8.22
MAXCHARS function 8.23
MAXFETCH option
MAX function 8.21
maximum values 8.31
- for each time period in the status 8.31
- larger of two expressions 8.21
MEASUREDIM statement
- for aggregation 9.9.6
- for allocation 9.15.6
MEDIAN function 8.24
median value 8.24
messages, suppressing 5.12
metadata
- exporting 9.41.1
- importing 10.6.1
MIN function 8.25
minimum value 8.32
- for each time period in the status 8.32
- smaller of two expressions 8.25
MMOF function 8.26
MODDAMP option 5.49
MODE function 8.27
MODEL.XEQRPT program
- compiling 5.13
- defining 9.35.5, 9.35.6
- including 10.17.2
- nesting 10.17.2
- options 5.49, 5.51, 5.52, 5.53, 5.54, 5.55, 5.56
MODEL command 10.17
model dimensions
- adding to cube dimensions 9.8
- removing from cube dimensions 10.43
models
- adding a specification 10.17
- adding to aggmap 9.10
- adding to cube dimensions 10.52
- adding to cubes 9.6
- compiling 3.3.3, 9.27, 10.17
- creating 10.17
- creating for cube dimensions 9.32
- debugging 3.3.5, 10.63
- defining 9.35.5
- deleting 9.36
- deleting from cube dimensions 10.52
- editing 10.17
- in aggregation specifications 9.10, 10.16.1.3
- obtaining information about 7.98.2
- removing from aggmap 9.10
- removing from aggmaps of cube dimensions 10.41
- running 3.3.4, 10.17
- scenario 3.3.2.6
- solution variables 3.3.1
MODERROR option 5.50
MOD function 8.28
MODGAMMA option 5.51
MODINPUTORDER option 5.52
MODMAXITERS option 5.53
MODOVERFLOW option 5.54
MODSIMULTYPE option 5.55
MODTOLERANCE option 5.56
MODTRACE option 5.57
module version numbers 7.69
MODULO function 8.28
MON datetime format element 9.33
MONITOR command 10.21
monitoring 10.21
- cost of program lines 10.21
- cost of programs 10.64
MONTHABBRLEN option 5.58
MONTH datetime format element 9.33
MONTHNAMES option 5.59
MONTHS_BETWEEN function 8.29
MOVE command 10.22
MOVINGAVERAGE function 8.30
MOVINGMAX function 8.31
MOVINGMIN function 8.32
MOVINGTOTAL function 8.33
multidimensional valuesets 9.35.10
multiline text
- columns 7.72
MULTIPATHHIER option 5.60
multiwriter mode 7.26, 9.4, 9.18.2

N

NA2 bits 2.3.3, 9.35.11
NA2 function 8.34
NA2 values 8.34, 8.36
NAFILL function 8.35
NAFLAG function 8.36
name 10.13
- changing object name 10.44
- dimension 10.13
- listing names of dictionary entries 10.13
NAME dimension
names
- listing for objects 10.13
- listing objects by 10.11
- qualified object 2.3.2.2
NaN values
- in OLAP DML 7.112
NASKIP2 option 5.62
NASKIP option 5.61
NASPELL option 5.63, 9.17
NATRIGGER
- See: $NATRIGGER
natural logarithm 8.14
NA values
- about 2.3.3
- accepted as numeric input 5.61, 5.62
- caching 5.108
- comparing 2.3.8.2
- controlling how treated 2.3.3.2
- in Boolean expression 2.3.8.2
- in expressions 2.3.3
- NA2 bits 2.3.3, 9.35.11
- permanently replacing 5.105
- replacing 8.52
- replacing with strings 8.51
- retrieving 7.45
- spelling of 5.63
- substituting another value 8.35
- triggers 5.104, 5.105
negative value 5.83
- in output 5.83
- obtaining the root 5.90
net present value 8.44
NEW_TIME function 8.37
NEXT_DAY function 8.38
NLS_CALENDAR option 5.64
NLS_CHARSET_ID function 8.39
NLS_CHARSET_NAME function 8.40
NLS_CURRENCY option 5.65
NLS_DATE_FORMAT option 5.66
NLS_DATE_LANGAUGE option 5.67
NLS_DATE_LANGUAGE initialization parameter 9.33
NLS_DUAL_CURRENCY option 5.68
NLS_ISO_CURRENCY option 5.69
NLS_LANG option 5.70
NLS_LANGUAGE initialization parameter 9.33
NLS_LANGUAGE option 5.71
NLS_NUMERIC_CHARACTERS option 5.72
NLS_SORT option 5.73
NLS_TERRITORY initialization parameter 9.33
NLS_TERRITORY option 5.74
NLSSORT function 8.41
NONE function 8.42
NORMAL function 8.43
NOSPELL option 5.75
NPV function 8.44
NULLIF function 8.45
null values
- See: NA values
numbers
- assigning random numbers 8.62
- commas in output 5.11
- decimal marker for output 5.18
- decimal places in output 5.20
- determining sign of 8.90
- negative values in output 5.83
- rounding 8.82
- spelling out 9.33
- thousands marker for output 5.101
NUMBYTES function 8.46
NUMCHARS function 8.47
numeric conversion 8.126, 8.127
numeric data types 2.1.1
- comparing 2.3.8.3, 2.3.8.3.3
- mixing 2.3.4.1
numeric expressions
- data type of the result 2.3.4.1
- dates in 2.3.7
- mixing data types 2.3.4.1
- text dimensions in 2.3.4.2
numeric values
- rounding 8.82
NUMLINES function 8.48
NUMTODSINTERVAL function 8.49
NUMTOYMNTERVAL function 8.50
NVL2 function 8.52
NVL function 8.51

O

object definitions
- adding descriptions to 10.8
- deleting descriptions from 10.8
objects 9.31
- checking for changes 8.53
- compiling 5.13
- creating by copying 9.31
- creating properties 10.31
- data type of (determining) 8.53
- defining 9.35
- definition (retrieving) 8.53
- deleting 9.36
- describing its definition 9.37
- describing its properties 9.58
- dimensions of (retrieving) 8.53
- dropping changes 10.48
- exporting from analytic workspace 9.41
- identifying triggers 8.140
- importing into analytic workspace 10.6
- in expressions 2.3.2
- listing 8.54
- listing names of 10.11, 10.13
- loading 10.14
- making current 9.28
- obtaining information 8.53
- pages used to store (determining) 8.53
- qualified name 2.3.2.2
- recalculating permissions 10.27
- renaming 10.44
- restrictions on name 9.35
- storage class (determining) 8.53
- testing for existence 7.67
object types
- automatic A.1.2.1, A.3
- predefining A.1.2.1, A.3
- syntax for creating A.1.2, A.3
OBJ function 8.53
OBJLIST function 8.54
OBJORG function 8.55
OBSCURE function 8.56
OESEIFVERSION option
- See: EIFVERSION option
- name change D.3.4
OKFORLIMIT option 5.76
OKNULLSTATUS option 5.77, 10.9
OLAP_API_SESSION_INIT PL/SQL package
- ADD_ALTER_SESSION procedure C.3.1
- CLEAN_ALTER_SESSION procedure C.3.2
- DELETE_ALTER_SESSION procedure C.3.3
OLAP_CONDITION function (SQL) A.3
OLAP_EXPRESSION_BOOL function (SQL) A.6
OLAP_EXPRESSION_DATE function (SQL)
OLAP_EXPRESSION_TEXT function (SQL)
OLAP_EXPRESSION function (SQL) B.2.1
OLAP_ON function (PL/SQL) B.31, B.32
OLAP_TABLE
- optimizing looping 4.15, 4.16, 4.17, 4.18
OLAP_TABLE function (SQL)
- custom measures A.5, A.6, A.7, A.8
- data map parameter A.3
- data type conversions A.3
- examples A.3
- FETCH command A.3
- limit map A.1, A.3
- retrieving session log B.26
- specifying an OLAP DML command A.3
- specifying a ROW2CELL column A.3
- specifying the analytic workspace A.3
- specifying the logical table A.3
OLAP API
- optimization C
OLAP DML
- executing in SQL A.4, A.5, A.8, B.2, B.33
- quotation marks in B.2.2
OLAP session cache
- blocking creation of 5.92
- checking if empty 8.53
- defined 5.92
- for variable 8.53
- non-NA values 8.53
- populating with aggregated values 5.108, 9.9.3
- populating with NA values 5.108
ONATTACH program 6.8.2
ONDETACH program 6.8.3
OPEN command See SQL command in OLAP DML 10.58.7
operating system, identifying 8.119
operators 5.41
- Boolean 2.2.2
- comparisons 2.2.2
- conditional 2.3.9
- LIKE 5.39, 5.40, 5.41
- logical 2.2.2
- overview 2.2
- substitution 2.3.10
optimization
- OLAP API C, C.1
options
- displaying value of 5.1
- restoring previous values 6.3.4.3
- retrieving 5.1
- saving current values 6.3.4.3
- specifying 5.1
ORA_HASH function 8.57
Oracle OLAP
- internal build number 7.69
ordinal numbers
- specifying 9.33
- spelling out 9.33
outfile
- current 5.24
OUTFILE command 10.23
- affect on DBMS_AW.EXECUTE B.25
- affect on DBMS_AW.RUN B.34
OUTFILEUNIT option 5.78
out-of-range decimal values 5.19
output 10.23
- redirecting 10.23
- saving in a file 10.23
overflow condition 5.19

P

P.M. datetime format element 9.33
padding expressions 8.18, 8.86
PAGE command 10.24
PAGENUM option 5.79
PAGEPRG option 5.80
PAGESIZE 5.81
paging in reports 10.24
- forcing a page break 10.24
- line number on current page 5.44
- lines for bottom margin 5.8
- lines for top margin 5.102
- lines left on page 5.45
- lines on a page 5.81
- page number 5.79
- producing a custom heading 5.80
- producing a standard heading 10.60
- turning on 5.82
PAGING option 5.82
PARENS option 5.83
PARSE command 7.98.3, 10.25
parsing expressions 10.25
PARTITIONCHECK function
partitioned variables 9.35.6, 9.35.11
- aggregating 8.59
- defining 9.35.11
- deleting data from 10.16.2.3
- maintaining 10.16.4.2
- retrieving dimensions of 8.53
- retrieving partitioning method 8.53
PARTITION function 8.58
partitioning methods 8.53
partitions 9.35.6, 9.35.11
- adding values to 10.16.1.4, 10.16.4.2
- defining 9.35.6
  - list partitions 9.35.6
- deleting 9.36
- deleting data 10.16.2.3
- identifying for value 8.58
- list 9.35.6
- locking segments of 10.58.8
- moving values 10.16.4.2
- range 8.53, 9.35.6
- retrieving dimensions of 8.53
- retrieving names of 8.53
- specifying values of 10.16.4.2
partition templates 9.35.6
- defining 9.35.6
- deleting 9.36
- maintaining 10.16
- retrieving partitioning method 8.53
- retrieving partition names 8.53
pattern matching 2.3.8.6.1
payment schedules 7.86
- for loan interest 7.86, 8.150
- for loans 7.88, 8.151
PERCENTAGE function 8.60
permission programs 6.7.1.1, 6.8.1, 6.8.2, 6.8.4, 6.8.5
permissions 10.26
- assigning to an object definition 10.26
- recalculating permission 10.27
- specifying conditions for accessing 10.27
- violations of 5.84
PERMIT_READ program 6.7.1.1, 6.8.4
PERMIT_WRITE program 6.7.1.1, 6.8.5
PERMIT command 10.26
PERMITERROR option 5.84
PERMITREADERROR option 5.85
PERMITRESET command 10.27
phonetic representation, of text expression 8.97
platform, determining 8.119
PM datetime format element 9.33
POP command 6.3.4.3, 6.3.4.4, 10.28, 10.29
- popping a whole series at once 10.29
POPLEVEL command 10.29
- nesting 10.33
- using 6.3.4.5
populating
- alias dimensions 9.35.3.5
PRECOMPUTE statement 9.9.8
PREPARE command
- See: SQL command in OLAP DML
PRGTRACE option 5.86
print buffer B.25, B.34
PRINTLOG procedure (PL/SQL) B.33
PROCEDURE statement
- See: SQL command in OLAP DML
profiles 8.118
PROGRAM command 10.30
programs
- adding program contents to a definition 10.30
- branching 9.21, 9.30, 10.61
- branching in 10.9
- branching labels 9.59
- calling 9.22
- case statement 10.61
- comment lines in 6.3
- compiling 5.13, 6.4, 9.27
- conditional execution of commands 10.5, 10.74
- data export 6.7.2
- data import 6.7.2
- debugging 5.36, 6.5, 10.63
- declaring arguments in 6.3.2.1
- defining 9.35.7
- deleting 9.36
- determining how invoked 7.34
- error handling 5.33, 5.34, 10.65
- errors in 6.3.5
- executing 6.6
- halting execution with an error 10.55
- hiding 10.2
- local variable 10.72
- OnAttach 6.7.1.2, 6.7.1.3
- passing arguments to 7.19, 7.20, 7.21, 7.22
- performance cost 10.64
- permission 6.7.1.1, 6.8.1, 6.8.2, 6.8.4, 6.8.5
- preserving environment 6.3.4
- preserving status 7.47, 9.29
- repeating commands 9.55
- restoring previous values 6.3.4.3
- restoring status 10.28, 10.29
- returning a value 10.47
- saving compiled code 6.4
- saving current values 6.3.4.3
- saving status 10.32, 10.33
- startup 6.7.1
- suspending execution 10.56
- terminating execution of 10.47
- timing execution 10.21, 10.64
- trigger 6.7.3.2, 6.8.6, 6.8.7, 6.8.8, 6.8.9, 10.67
- unhiding 10.68
properties 10.31
- copying with an object definition 9.31
- creating for objects 10.31
- listing for objects 9.58
PROPERTY command 10.31
- event 10.66
- trigger 10.66
Property event 10.66
PUSH command 6.3.4.4, 10.32, 10.33
- marking start of series 10.33
- placement 6.3.5.6
- using 6.3.4.3
PUSHLEVEL command 10.33
- nesting 10.33
- placement 6.3.5.6

Q

QUAL function 2.3.2.5, 8.61
qualified data references
- ampersand substitution 2.3.2.5.6, 2.3.10
- creating 2.3.2.5
- definition of 2.3.2.5
- for dimensions 2.3.2.5.5
- qualifying a relation 2.3.2.5.4
- replacing dimension of variable 2.3.2.5.2, 2.3.2.5.3
- specifying explicitly 8.61
- using with relation 2.3.2.5.4
- with assignment statement 2.3.2.5.2
- with dimensions 2.3.2.5
- with relations 2.3.2.5.4
- with variables 2.3.2.5.2, 2.3.2.5.3
qualified object name 2.3.2.2
quotation marks
- double 2.1.2.1
- in OLAP DML B.2.2

R

RANDOM.SEED.1 option 5.87
RANDOM.SEED.2 option 5.87
RANDOM function 8.62
random numbers 8.43, 8.57, 8.62
random sparsity 9.35.3.1
range partitions
- defining 9.35.6
- retrieving calculation for 8.53
RANK_CALLS option 8.63
RANK_CELLS option 8.63
RANK_SORTS option 8.63
RANK function 8.63
- number of calls to 8.63
- number of computed values 8.63
- number of triggered sorts 8.63
ranking performance monitoring 8.63
RAW data type 2.1.6
raw values
- converting 8.64
reading files 8.65
- current record number 8.65
- error diagnosis 7.77
- FILEREAD command 9.52
- processing a record 9.54
- reading a record 7.79
RECAP command 10.34
RECNO function 8.65
RECURSIVE option 5.88
REDO command 10.35
REEDIT command 10.36
REGEXP_COUNT function 8.66
REGEXP_INSTR function 8.67
REGEXP_REPLACE function 8.68
REGEXP_SUBSTR function 8.69
REGRESS command 7.98.4, 10.37
regressions
- linear 10.37
related dimensions 2.3.2.3.3, 8.121, 10.39
- limiting to 5.42
relational tables See tables 10.58
RELATION command 10.39
relations
- assigning values to 10.50
- comparing to text literals 2.3.8.6.2
- default 2.3.2.3.3, 10.39
- defining 9.35.8
- limiting to single value 2.3.2.5.4
- QDR with 2.3.2.5.4
- replacing dimension of 2.3.2.5.4
relations, in aggmaps
- identifying changes 7.39
RELATION statement
- for aggregation 9.9.9
- for allocation 9.15.7
RELEASE command 10.40
remainder after division 8.70
REMAINDER function 8.71
REMBYTES function 8.72
REMCHARS function 8.73
REMCOLS function 8.74
REM function 8.70
REMLINES function 8.75
REMOVE_CUBE_MODEL program 10.41
REMOVE_DIMENSION_MEMBER program 10.42
REMOVE_MODEL_DIMENSION program 10.43
RENAME command 10.44
REPLACE function 8.76
replacing
- characters 8.76
REPLBYTES function 8.77
REPLCHARS function 8.78
REPLCOLS function 8.79
REPLLINES function 8.80
REPORT command 10.45
reporting 10.45
reports
- processing ROW command output 8.83
- producing 8.83, 10.45
- producing with ROW commands 10.49
RESERVED function 8.81
reserved words 8.81
RESYNC command 10.46
RETURN command 10.47
return value of a program 10.47
REVERT command 10.48
ROLE option 5.89
roles 8.118
root of negative number 5.90
ROOTOFNEGATIVE option 5.90
ROUND function
- described 8.82
- for datetimes 8.82.1
- for numbers 8.82.2
ROW2CELL column A.3, A.4
ROW command 10.49
- processing output 8.83
ROW function 8.83
ROWID data type 2.1.7.1
- converting 8.84, 8.85
ROWIDTOCHAR function 8.84
ROWIDTONCHAR function 8.85
ROWTOHEX function 8.64
RPAD function 8.86
RR datetime format element 9.33
RTRIM function 8.87
running totals 8.88, 10.75
RUN procedure (PL/SQL) B.34
run-time aggregation 3.4.4
RUNTOTAL function 8.88

S

scenario models 3.3.2.6
seasonal data 9.56
SECONDS option 5.91
segments
- analytic workspace 9.18.3
- locking 10.58.8
- retrieving maximum size of 7.26
segment width 9.24
selecting
- alias dimension values 9.35.3.5
- data 10.9
SELECT statements (in OLAP DML) 10.58.3, 10.58.10
- See also: SQL command in OLAP DML
SERVEROUTPUT option B.25, B.33, B.34
SESSCACHE option 5.92
session
- shutting down B.35
- starting up B.37
session cache
- See: OLAP session cache
session logs
- printing B.33
- retrieving B.26
sessions 10.15
- preserving environment 6.3.4
- recording in disk file 10.15
- restoring environment 6.3.4.3
- user ID 8.118
SESSIONTIMEZONE function 8.89
SET_INCLUDED_MODEL program 10.52
SET_PROPERTY program 10.53
SET1 command 10.51
SET command 10.50
SHOW command 10.54
SHUTDOWN procedure (PL/SQL) B.35
SIGNAL command 6.3.5.4, 10.55
SIGN function 8.90
simultaneous equations in models 3.3.2.5
sine calculation 8.91, 8.92
SIN function 8.91
single-row functions A.2.1
SINH function 8.92
SLEEP command 10.56
slowest-varying dimension 9.35.11
smaller value of two expressions 8.25
SMALLEST function 8.93
smallest value of an expression 8.93
SMOOTH function 8.94
solution variables
- defined 3.3.1
- example of 10.17
SORT
- command 10.57
- function 8.95
sorting
- status list of a dimension 5.42, 8.95, 10.57
- valuesets 8.95, 10.57
SORTLINES function 8.96
SOUNDEX function 8.97
SOURCEVAL statement 9.15.8
sparse data 7.119
- base dimension value 7.119
- changing definitions 9.24
- eliminating 9.35.11
- exporting 9.41.1
- importing 10.6.1
- index algorithm 5.94
- obtaining information 8.53
- reading from files 9.52
- renaming composites 10.44
- reporting 10.45, 10.49
- specifying composites 9.35.11
SPARSEINDEX option 5.94
sparsity 9.35.3.1
- See also: sparse data
- controlled 9.35.3.1
- random 9.35.3.1
SPARSITY_ADVICE_TABLE column descriptions B.13
SPARSITY_ADVICE_TABLE procedure (PL/SQL) B.36
Sparsity Advisor
SP datetime format element suffix 9.33
special characters 2.1.2.2
spelled numbers
- specifying 9.33
spreadsheets 9.35.12
- See also: worksheet objects
- defining 9.35.12
- exporting to 9.41.2
- importing data from 10.6, 10.6.3
SPTH datetime format element suffix 9.33
SQL
- embedding OLAP commands A.4, A.5, A.6, A.7, A.8
- managing analytic workspaces B
SQL (in OLAP DML)
- defining cursors 10.58.3
- embedding statements 6.7.2.1.1, 10.58
- precompiling statements 10.58.8
- retrieving errors 5.96, 5.97
- stored procedures 10.58.9
SQLBLOCKMAX option 5.95
SQLCODE option 5.96
SQLCOLUMNS procedure 10.58.3, 10.58.10
SQL command in OLAP DML
- CLEANUP 10.58.1
- CLOSE 10.58.2
- DECLARE CURSOR 10.58.3
- EXECUTE 10.58.4
- FETCH 10.58.5
- IMPORT 10.58.6
- PREPARE 10.58.8
- PROCEDURE 10.58.9
- SELECT 10.58.10
SQLERRM option 5.97
SQLFETCH function 8.98
SQLMESSAGES option 5.98
SQLTABLES procedure 10.58.3, 10.58.10
SQRT command 8.99
square root 8.99
- calculating 8.99
- result for negative number 5.90
standard deviation calculation 8.113
STARTOF function 8.100
STARTUP procedure (PL/SQL) B.37
STATALL function 8.101
STATCURR function 8.102
STATDEPTH function 8.103
statements
- altering order of execution 9.59
- editing previously executed 10.36
- reading from a file 10.7
- reexecuting 10.35
- sending to file 10.34
STATEQUAL 8.104
STATFIRST function 8.105
STATIC_SESSION_LANGUAGE option 5.99
STATLAST function 8.106
STATLEN function 8.107
STATLIST function 8.108
STATMAX function 8.109
STATMIN function 8.110
STATRANK function 8.111
status
- determining 8.101
- setting 10.9
- setting inside a statement 10.62
- setting to null 5.77
status lists
- base dimensions 10.10
- comparing 8.104
- current 1.7.1.2
- default 1.7.1.1
- defined 1.7
- empty 5.77
- first value in 8.105
- last value in 8.106
- looping over 5.76, 9.55, 10.62
- most recent value 8.109
- null values 5.77
- number of values in 8.107
- position in 8.111
- restoring 10.28, 10.29
- result of LIMIT command 8.10
- retrieving 8.108
- retrieving depth of 8.103
- retrieving value by position 8.112
- retrieving values from 8.110, 8.149
- returning values 8.102
- saving 7.47, 9.29, 10.32, 10.33
- saving in a context 9.29
- sending to outfile 10.59
- setting to null 5.77
- sorting 5.42, 8.95, 10.57
STATUS program 10.59
STATVAL function 8.112
STDDEV function 8.113
STDHDR program 10.60
- line size for centering 5.47
storage
- changing 9.24
- of variables 9.35.11
stored procedures
- creating 10.58.9
stored procedures (SQL)
- executing 10.58.9
STORETRIGGERVAL property 10.31
strings
- byte 2.1.6
- length of 8.9
subevents, identifying 8.140
substitution expressions
substitution operator 2.3.10
SUBSTR2 function 8.114
SUBSTR4 function 8.114
SUBSTRB function 8.114
SUBSTRC function 8.114
SUBSTR function 8.114
substrings
- counting 8.66
- replacing 8.68
- retrieving 8.67, 8.69, 8.114
- retrieving position of 7.106
SUBTOTAL function 8.115
subtotals 8.115
- in a report 8.115
- resetting to zero 10.75
surrogate dimension 9.35.9
- defining 9.35.9
surrogates
- defining 9.35.9
- deleting 9.36
SWITCH
- conditional expression 2.3.9.2
SWITCH command 9.21, 9.38, 10.61
SYS_CONTEXT function 8.116
SYSDATE function 8.117
SYSINFO function 8.118
SYSTEM function 8.119
SYSTIMESTAMP function 8.120

T

tables
- exporting from analytic workspaces 10.58
- importing into analytic workspaces 10.58
table type A.3
- automatic A.1.2.1, A.3
- predefining A.1.2.1, A.3
- syntax for creating A.1.2, A.3
TALLY function 8.121
TAN function 8.122
tangent calculation 8.122
- angle value 7.17
- arc 7.17, 7.18
- hyperbolic 8.123
TANH function 8.123
TCONVERT function 8.124
temporary members
- adding to dimension 10.16.1.3
- identifying 7.113
TEMPSTAT command 10.62
text
- comparing values 2.3.8.6
- converting to raw 7.94
- data types 2.1.2
- date and number formats 2.1.4.2
- literals 2.3.5, 2.3.8.6.2
- passing arguments as 6.3.2.3, 10.9
- special characters 2.1.2.2
text expressions 2.3.4.2, 2.3.5
- phonetic representation of 8.97
TEXTFILL function 8.125
text formatting
- importing worksheet data 10.6
TH datetime format element suffix 9.33
THOUSANDSCHAR option 5.101
thousands marker 5.101
THSP datetime format element suffix 9.33
time format models
- short 9.33
time of day 8.117, 8.136
time series 8.1
- cumulative totals over 7.53
- data from previous time period 8.1
- data from subsequent time period 8.7
- difference between time periods 8.3
- maximum value in period 8.31
- minimum value in period 8.32
- moving totals over 8.33
- percent difference between time periods 8.2, 8.4
timestamp
- converting to local time zone 2.3.6.1
TIMESTAMP_LTZ data type 2.1.4.7
TIMESTAMP_TZ data type 2.1.4.6
TIMESTAMP data type 2.1.4.5
time zone
- formatting 9.33
timezone offsets 8.143
time zones
- converting data to particular 2.3.6.1
timing 10.21
- execution of program lines 10.21
- execution of programs 10.64
title for a report 10.1
TMARGIN option 5.102
TO_BINARY_DOUBLE function 8.126
TO_BINARY_FLOAT function 8.127
TO_CHAR function 8.128
TO_DATE function 8.129, 9.33
TO_NCHAR function 8.131
TO_NUMBER function 8.132
TO_TIMESTAMP_TZ function 8.134
TODAY function 8.137
TOD function 8.136
TOTAL function 8.138
totals
- calculating 8.138
- cumulative 7.53
- in a report 8.88, 8.115, 10.45, 10.49
- moving 8.33
- over time 8.33
- running 8.88
TRACE command 10.63
TRACEFILEUNIT option 5.103
tracking 10.21
- cost of program lines 10.21
- cost of programs 10.64
TRACKPRG command 10.64
TRACKREPORT program 10.64
TRANSLATE function 8.139
TRAP command 6.3.5.1, 10.65
TRIGGER_AFTER_UPDATE program 6.8.6
TRIGGER_AW program 6.8.6, 6.8.7
TRIGGER_BEFORE_UPDATE program 6.8.8
TRIGGER_DEFINE program 6.8.9
TRIGGERASSIGN command 10.67
TRIGGER command 10.66
TRIGGER function 8.140
TRIGGERMAXDEPTH option 5.104
trigger objects 8.140
trigger programs
- Assign 10.66
- Delete 10.66
- designing 6.7.3.2
- Maintain 10.66
- Property 10.66
- Update 6.8.6, 10.66
triggers
- Assign 10.66, 10.67
- creating 10.66
- Define 6.8.9
- Delete 10.66
- deleting 10.66
- events 8.140
- Maintain 10.66
- NA 4.19, 5.104, 5.105
- objects 8.140
- Property 10.66
- subevents 8.140
- Update 6.8.6, 6.8.8, 10.66
TRIGGERSTOREOK option 5.105
TRIM function 8.141
trimming expressions 8.19, 8.87
trimming strings 8.141
TRUNCATE function
- described 8.142
- for datetimes 8.142.1
- for numbers 8.142.2
TRUNC function
- See: TRUNCATE function
tuples B.3.1
TZ_OFFSET function 8.143

U

UNHIDE command 10.68
UNIQUELINES function 8.144
unnamed composites 9.35.11
- defining 9.35.11
- example of 9.35.11
UNRAVEL function 8.145
UPCASE function 8.146
UPDATE_ATTRIBUTE_VALUE program 10.70
UPDATE_DIMENSION_MEMBER program 10.71
UPDATE command 10.69
- event 10.66
- events 6.8.6, 6.8.8
- trigger 10.66
- triggers 6.8.6, 6.8.8
UPPER function 8.147
UROWID data type 2.1.7.2
user-defined functions
- arguments in 6.3.1
- data type of 6.3.1
user ID, retrieving 8.118
USERID option 5.106
USETRIGGERS option 5.107
UTC offset
- replacing with time zone region 2.1.4.6

V

VALSPERPAGE program 8.148
value name format 10.73
values 2.3.8
- See also: Boolean values
- restoring previous 6.3.4.3
- saving current 6.3.4.3
valuesets
- assigning values to 9.35.10
- checking status of 10.59
- defining 9.35.10
- deleting 9.36
- limiting 9.35.10
- multidimensional 9.35.10
- null 5.77
- number of values in 8.107
- retrieving values 8.105, 8.106, 8.109, 8.149
- retrieving values from 8.110
- setting the status of 10.9
- sorting values 8.95, 10.57
VALUESET statement
VALUES function 8.149
VARCACHE option 5.108
VARIABLE command 10.72
variables
- Aggcount 7.6, 8.53, 9.24, 9.35.11
- assigning values to 10.50
- defining 9.35.11
- defining with composite 9.35.11
- deleting 9.36
- how data is stored 9.35.11
- identifying changes 7.40, 7.111
- limiting to single value 2.3.2.5.2, 2.3.2.5.3
- local to a program 10.72
- partitioned 9.35.6, 9.35.11
- populating 8.145
- QDR with 2.3.2.5.2, 2.3.2.5.3
- replacing dimension of 2.3.2.5.2, 2.3.2.5.3
- reshaping dimensionality of 8.61
- session cache 8.53
- storage of 9.35.11
version of Oracle OLAP 7.69
views
- creating embedded total dimensions A.3
- creating embedded total measures A.3
- creating rollup form A.3
- template for creating with OLAP_TABLE A.1.2.1
VINTSCHED function 8.150
VNF
- See: value name format
VNF command 2.1.3.2, 10.73
VPMTSCHED function 8.151
VSIZE function 8.152

W

WEEKDAYSNEWYEAR option 5.109
WEEKOF function 8.153
WHILE command 9.21, 10.74
- used with BREAK 9.21
- used with CONTINUE 9.30
WIDTH_BUCKET function 8.154
wildcards 2.3.8.6.1
WKSDATA function 8.155
worksheet objects 9.35.12
- See also: spreadsheets
- cells 8.155
- data type of cells 8.155
- defining 9.35.12
- deleting 9.36
- dimensions 9.35.12
workspaces See analytic workspaces 9.18.3
WRAPERRORS option 5.110

Y

YESSPELL option 5.111
YMINTERVAL data type 2.1.4.8
YMINTERVAL function 8.135
YRABSTART option 5.112
YYOF function 8.157

Z

zero 5.22
- dividing by 2.3.4.4, 5.22
- spelling of 5.114
- suppressing all-zero report rows 5.113
ZEROROW option 5.113
ZEROTOTAL command 10.75
ZSPELL option 5.114