Skip Headers
Oracle® OLAP DML Reference
11g Release 1 (11.1)

B28126-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  Y  Z 

Symbols

$AGGMAP property, 5.3
$AGGREGATE_FORCECALC property, 5.3
$AGGREGATE_FORCEORDER property, 5.3, 5.3
$AGGREGATE_FROM property, 5.3, 9.3
$AGGREGATE_FROMVAR property, 5.3
$ALLOCMAP property, 5.3
$COUNTVAR property, 5.3
$DEFAULT_LANGUAGE property, 5.3
$GID_DEPTH property, 5.3
$GID_LIST property, 5.3
$GID_TYPE property, 5.3
$LOOP_AGGMAP property, 5.3
$LOOP_DENSE property, 5.3
$LOOP_VAR property, 5.3, 5.3
$NATRIGGER property
calling recursively, 6.3
executing simultaneously, 6.3
$STORETRIGGERVAL property, 5.3
$VARCACHE property, 5.3
% wildcard, 2.3.8.6.1
& operator, 2.3.10
= command, 10
event, 10, 10, 10
trigger, 10, 10, 10
_ wildcard, 2.3.8.6.1

Numerics

20th century, 9.3
21st century, 9.3

A

ABS function, 7.3
abstract data types, A.1.2, A.2.2
automatic, A.1.2.2, A.2.2
predefining, A.1.2.1, A.2.2
ACQUIRE command, 9.3
ACROSS command, 9.3
ACROSS keyword, 10
$AGGREGATE_FROMVAR property, 5.3, 5.3
= command, 10
FETCH command, 9.3
FILEREAD command, 9.3, 9.3, 10
FILEVIEW command, 9.3
HEADING command, 10
models, 3.3.4.2
REPORT command, 10
ROW command, 10
SQL FETCH command, 10
SQL SELECT command, 10
AD datetime format element, 9.3, 9.3
ADD_DIMENSION_SOURCE procedure (PL/SQL), B.5.2
ADD_MONTHS command, 7.3
ADT
See abstract data types
ADVISE_CUBE procedure (PL/SQL), B.5.2, B.5.2
ADVISE_DIMENSIONALITY function (PL/SQL), B.5.2
ADVISE_DIMENSIONALITY procedure (PL/SQL), B.5.2
ADVISE_REL procedure, B.5.2
ADVISE_REL procedure (PL/SQL), B.5.2
ADVISE_SPARSITY procedure (PL/SQL), B.5.2
Aggcount variables, 7.3, 8, 9.3, 9.3, 9.3, 9.3
AGGINDEX statement, 9.3
AGGMAP ADD model command, 9.3
AGGMAP command, 9.3
aggmap objects
identifying changes, 7.3
AGGMAP REMOVE model command, 9.3
AGGMAP SET command, 9.3
AGGMAPINFO command, 7.3
aggmaps
compiling, 3.4.3, 9.3
defining, 9.3
deleting, 9.3
in formulas, 8
list of, 7.3
See also aggregation specifications, allocation specifications
Aggregate Advisor, 3.4.4, 9.3, 9.3, 9.3, 9.3, B.5
AGGREGATE command, 9.3
AGGREGATE function, 7.3
aggregating data
caching, 6.3
formulas for, 7.3
on-the-fly, 3.4.4
partitioned variables, 8
precomputing, 3.4.4
specifying a relation for, 9.3
using an Aggcount variable, 7.3
using an aggmap object, 3.4.1
using TCONVERT, 8
See also aggregation specifications
aggregation
in analytic workspaces, B.5
AGGREGATION function, 7.3
aggregation specifications
compiling, 3.4.3
defining, 9.3
deleting, 9.3
models in, 9.3, 10, 10
writing, 9.3
See also aggregating data
aggregations
identifying changes, 7.3, 7.3, 7.3
algorithm for composite values, 6.3
alias dimension
deleting, 9.3
alias dimensions
base dimensions (list of), 8
defining, 9.3
deleting, 9.3, 9.3, 9.3, 9.3
limiting, 9.3
maintaining, 9.3
populating, 9.3
retrieving list of, 8
aliases
for analytic workspaces, 2.3.2.2
for analytic workspaces. See analytic workspace aliases
for dimensions See alias dimensions
ALLCOMPILE program, 9.3
ALLOCATE command, 9.3
allocating data
using an aggmap object, 3.5
using TCONVERT, 8
See also allocation specifications
allocation specifications
defining, 9.3
deleting, 9.3
writing, 9.3
See also allocating data
ALLOCERRLOGFORMAT option, 6.3
ALLOCERRLOGHEADER option, 6.3
ALLOCMAP command, 9.3
ALLSTAT command, 9.3
ALTER SESSION commands, C.1
AM datetime format element, 9.3, 9.3
ampersand &(amp;) operator, 2.3.10
ampersand substitution
example of, 2.3.10
program arguments and, 4.3.2.3
QDR with, 2.3.2.5.6, 2.3.10
using to pass arguments, 4.3.2.3, 10
analytic workspace aliases
creating, 9.3
definition of, 2.3.2.2
deleting, 9.3
analytic workspaces
accessing from SQL, B
aggregation, B.5
aliases. See analytic workspace aliases
attached (list of), 8
attaching, 6.3, 9.3
content summary, displaying, 9.3
converting to 10g storage format, B.2
creating, 9.3
current, 2.3.2.2
deleting, 9.3, 9.3
deleting objects from, 9.3
detaching, 4.8, 9.3
exporting, 4.7.6
identifying active, 9.3
importing, 4.7.6
importing from Oracle 9i, B.2.1
naming, 2.3.2.2
obtaining information about, 7.3
partitioning, 9.3
permission programs for, 4.7.1
segmenting, 9.3
sharing, 6.3
storage format, B.2
updating, 10
ANTILOG function, 7.3
ANTILOG10 function, 7.3
ANY function, 7.3
arc tangent calculation, 7.3
ARCCOS function, 7.3
ARCSIN function, 7.3
ARCTAN function, 7.3
ARCTAN2 function, 7.3
ARG command
See ARGUMENT command
ARG function, 7.3
ARGCOUNT function, 7.3
ARGFR function, 7.3
ARGS function, 7.3
ARGUMENT command, 9.3
arguments, 7.3
in user-defined functions, 4.3.1
passing as text, 4.3.2.3, 10
passing to a program, 7.3, 7.3, 7.3, 7.3, 9.3
using ampersand substitution with, 4.3.2.3
arithmetic
with DATE values, 2.3.6.3
ASCII function, 7.3
Assign event, 10
assignment statements
event, 10, 10, 10
trigger, 10, 10, 10
with different dimensionality, 8
with QDR, 2.3.2.5.2
authentication, 8
encoding text expressions, 8
within Oracle OLAP, 10
AVERAGE function, 7.3
AW command, 9.3
AW ALIASLIST, 9.3
AW ATTACH, 9.3
AW CREATE, 9.3
AW DELETE, 9.3
AW DETACH, 9.3
AW FREEZE, 9.3
AW LIST, 9.3
AW PURGE, 9.3
AW ROLLBACK, 9.3
AW SEGMENTSIZE, 9.3
AW THAW, 9.3
events, 4.8
triggers, 4.8
AW function, 7.3
AW PURGE, 9.3
AW_ATTACH procedure (PL/SQL), B.5.2
AW_COPY procedure (PL/SQL), B.5.2
AW_CREATE procedure (PL/SQL), B.5.2
AW_DELETE procedure (PL/SQL), B.5.2
AW_DETACH procedure (PL/SQL), B.5.2
AW_RENAME procedure (PL/SQL), B.5.2
AW_TABLESPACE function (PL/SQL), B.5.2
AW_UPDATE procedure (PL/SQL), B.5.2
AWDESCRIBE program, 9.3
AWWAITTIME option, 6.3

B

BACK function, 7.3, 7.3, 7.3
BADLINE option, 4.5.2, 6.3
base dimensions
finding values of, 7.3, 7.3
identifying, 7.3
setting status list of, 10
BASEDIM function, 7.3
BASEVAL function, 7.3
BC datetime format element, 9.3, 9.3
BEGINDATE, 7.3
BIN_TO_NUM function, 7.3
binary data, 2.1.6, 2.1.6
BITAND function, 7.3
bits, adding, 7.3
BLANK command, 9.3
blank lines in reports, 9.3
BLANKSTRIP function, 7.3
BMARGIN option, 6.3
Boolean
data type, 2.1.5
expressions, 2.3.8
operators, 2.2.2
values, 6.3, 6.3
branching in programs, 9.3, 9.3, 9.3, 10, 10, 10
BREAK command, 9.3
bucket numbers, retrieving, 8
build number of Oracle OLAP, 7.3
bytes strings, 2.1.6, 2.1.6

C

CACHE statement, 9.3, 9.3, 9.3, 9.3, 9.3
caches
See OLAP session cache
caching, 9.3
calculated members
adding to dimension, 10
identifying, 7.3
calculating a linear regression, 10
CALENDARWEEK option, 6.3
CALL command, 9.3
CALLTYPE function, 7.3
case statement in programs, 10
CATEGORIZE function, 7.3
CDA command, 9.3
CEIL function, 7.3
CHANGEBYTES function, 7.3
CHANGECHARS function, 7.3
CHANGEDRELATIONS function, 7.3
CHANGEDVALIES function, 7.3
characters
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
CHARLIST function, 7.3
CHGDFN command, 9.3
CHGDIMS function, 7.3
CHILDLOCK statement, 9.3
CHR function, 7.3
CLEANUP command
See SQL command in OLAP DML
CLEAR command, 9.3
CLOSE command
See SQL command in OLAP DML
COALESCE function, 7.3
code comments, 2.1.2.1
columns
default width in reports, 6.3, 6.3
getting value from a report column, 7.3
headings in a report, 10
in reports, 6.3
multiline text, 7.3
COLVAL function, 7.3
COLWIDTH function, 6.3
COMMAS option, 6.3
comments
code, 2.1.2.1
comments in programs, 4.3
COMMIT command, 9.3
comparing
dates, 2.3.8.5
values, 2.3.8.2, 2.3.8.6
comparison operators, 2.2.2
compilable objects, 6.3
COMPILE command, 9.3
COMPILEMESSAGE option, 6.3
COMPILEWARN option, 6.3
compiling, 6.3
aggmaps, 3.4.3
aggregation specifications, 3.4.3
models, 3.3.3
programs, 4.4
SQL statements, 10
suppressing error messages, 6.3
composites, 2.3.2.4
base dimension values, 7.3
changing to conjoint dimensions, 9.3
defining, 1.5.1.2, 1.5.1.2, 9.3, 9.3
deleting, 9.3, 9.3, 9.3, 9.3
deleting values of, 10
index algorithm, 6.3, 6.3
index type (determining), 8
listing associated objects, 10
maintaining, 10
reporting, 10, 10
showing a value, 10
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.3
unnamed, 9.3
See also unnamed composites
composites (regular and compressed)
defined, B.4.1
concat dimensions
defining, 9.3
deleting, 9.3, 9.3
specifying values for, 2.3.2.3.2, 2.3.2.3.2
See also dimensions
conditional, 2.3.9.1
conditional execution of commands, 9.3
conditional expressions, 2.3.9
IF, 2.3.9.1
SWTICH, 2.3.9.2
conditional operators, 2.3.9, 2.3.9
conjoint dimensions
base dimension values, 7.3
changing to composites, 9.3
defining, 9.3
deleting, 9.3, 9.3
index type (determining), 8
See also dimensions
CONSIDER command, 9.3
CONTEXT command, 4.3.4.6, 9.3
CONTEXT function, 4.3.4.6, 7.3
CONTINUE command, 9.3
controlled sparsity, 9.3
conversion
rules, string to date, 2.1.4.3, 7.3
CONVERT function, 7.3
CONVERT procedure (PL/SQL), B.5.2
converting
ROWID data type, 8, 8
to DSINTERVAL, 8
to YMINTERVAL, 8
converting data types
decimals to integers, 7.3
introduction to, 2.1.8
COPYDFN command, 9.3
copying definitions, 9.3
CORRELATION function, 7.3
COS function, 7.3
COSH function, 7.3
cosine calculation, 7.3, 7.3
COUNT function, 7.3
CUMSUM function, 7.3
cumulative totals, 7.3, 8
current
analytic workspace, 2.3.2.2
current directory, 9.3
changing, 9.3
identifying, 9.3
current outfile, 6.3, 10
current status list
setting, 10
CURRENT_DATE function, 7.3, 7.3
CURRENT_TIMESTAMP function, 7.3
cursors, 10
closing (SQL), 10
importing (SQL), 10
custom measures, A.2.1
examples with OLAP_EXPRESSION, A.2.2

D

data
binary, 2.1.6, 2.1.6
data fetches (SQL), 10
data type conversions, A.2.2
data types
Boolean, 2.1.5
converting, 2.1.8
creating a report, 10, 10
DATE, 2.1.3
date, 2.1.4, 2.1.4, 2.1.4.4
DATETIME, 2.1.4
determining data type of an object, 8
DSINTERVAL, 2.1.4.9
for variables, 9.3
numeric, 2.1.1
of expressions, 2.3.1.1
of numeric expressions, 2.3.4.1
of user-defined function, 4.3.1
qualifying data for expressions, 8
RAW, 2.1.6, 2.1.6
restricting access, 10
ROWID, 2.1.7.1
showing a single value, 10
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
UROWID, 2.1.7.2
YMINTERVAL, 2.1.4.8
DATABASE command
name change, Preface
See AW command
DATABASE function
name change, Preface
See AW function
database initialization, C, C.1
DATE data types, 2.1.3
date data types, 2.1.4, 2.1.4, 2.1.4.4
date format models, 9.3
long, 9.3
punctuation in, 9.3
short, 9.3
text in, 9.3
DATE_FORMAT, 9.3
DATEFORMAT option, 6.3
DATEORDER option, 6.3
dates, 8, 8
arithmetic, 2.3.6.3
comparing, 2.3.8.5, 2.3.8.5
current, 8, 8
in arithmetic expressions, 2.3.7
in text expressions, 2.3.5.2
datetime arithmetic, 2.3.6.3
datetime data
format of, 9.3
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.3
capitalization, 9.3
ISO standard, 9.3
RR, 9.3
suffixes, 9.3
datetime values
truncating, 8
DAY datetime format element, 9.3
DAYABBRLEN option, 6.3
DAYNAMES option, 6.3
DAYOF function, 7.3
DBDESCRIBE program
name change, Preface
See AWDESCRIBE program
DBGOUTFILE command, 4.5.3, 9.3
and ECHOPROMPT, 6.3
DBMS_AW package, B
DBMS_AW PL/SQL package
ADD_DIMENSION_SOURCE procedure, B.5.2
ADVISE_CUBE procedure, B.5.2
ADVISE_DIMENSIONALITY function, B.5.2
ADVISE_DIMENSIONALITY procedure, B.5.2
ADVISE_REL procedure, B.5.2
ADVISE_SPARSITY procedure, B.5.2
AW_ATTACH procedure, B.5.2
AW_COPY procedure, B.5.2
AW_CREATE procedure, B.5.2
AW_DELETE procedure, B.5.2
AW_DETACH procedure, B.5.2
AW_RENAME procedure, B.5.2
AW_TABLESPACE function, B.5.2
AW_UPDATE procedure, B.5.2
CONVERT procedure, B.5.2
EVAL_NUMBER function, B.5.2
EVAL_TEXT function, B.5.2
EXECUTE procedure, B.5.2
GETLOG function, B.5.2
INFILE procedure, B.5.2
INTERP function, B.5.2
INTERP_SILENT function, B.5.2
INTERPCLOB function, B.5.2
OLAP_ON function, B.5.2, B.5.2
PRINTLOG procedure, B.5.2
RUN procedure, B.5.2
SHUTDOWN procedure, B.5.2
SPARSITY_ADVICE_TABLE procedure, B.5.2
STARTUP procedure, B.5.2
DBMS_AW$_COLUMNLIST_T table, B.4.2
DBMS_AW$_DIMENSION_SOURCE_T object type, B.4.2
DBMS_AW$_DIMENSION_SOURCES_T table type, B.4.2
DBTIMEZONE function, 7.3
DBWAITTIME option
name change, Preface
See AWWAITTIME option
DDOF function, 7.3
DEADLOCK statement, 9.3
debugging, 6.3
models, 3.3.5
programs, 4.5
decimal data types, comparing, 2.3.8.3.3
decimal marker (displayed), 6.3
decimal places (displayed), 6.3
decimal values, 6.3
decimal marker for output, 6.3
truncating to an integer, 7.3
DECIMALCHAR option, 6.3
DECIMALOVERFLOW option, 6.3
DECIMALS option, 6.3
DECLARE CURSOR command
See SQL command in OLAP DML
DECODE function, 7.3
default
outfile, 10
relations, 2.3.2.3.3, 10
default status list
determining if in effect, 8
DEFAULTAWSEGSIZE option, 6.3
DEFAULTDBFSIZE option
name change, Preface
See DEFAULTAWSEGSIZE option
DEFINE AGGMAP command, 9.3, 9.3
DEFINE command, 9.3
events, 4.8
triggers, 4.8
DEFINE COMPOSITE command, 1.5.1.2, 9.3
DEFINE DIMENSION ALIASOF command, 9.3
DEFINE DIMENSION command, 9.3
DEFINE FORMULA command, 9.3
DEFINE MODEL command, 9.3
DEFINE PARTITION TEMPLATE command, 9.3
DEFINE PROGRAM command, 9.3
DEFINE RELATION command, 9.3
DEFINE SURROGATE command, 9.3, 9.3
DEFINE VALUESET command, 9.3
DEFINE VARIABLE command, 9.3
DEFINE WORKSHEET command, 9.3
defining
aggmap objects, 9.3
alias dimensions, 9.3
analytic workspace objects, 9.3
dimension alias, 9.3
dimensions, 9.3
formulas, 9.3
partitions, 9.3
programs, 9.3
relations, 9.3, 9.3
surrogates, 9.3
valuesets, 9.3, 9.3
variables, 9.3
worksheet objects, 9.3
definitions
copying, 9.3
creating, 9.3
creating object properties, 10
deleting, 9.3
moving within NAME dimension, 10
report of, 9.3, 9.3
testing for, 7.3
DELETE command, 9.3
event, 10, 10
trigger, 10, 10
Delete event, 10
deleting
alias dimensions, 9.3
composite values, 10
composites, 9.3
definitions, 9.3
dimension alias, 9.3
dimension values, 10, 10
dimensions, 9.3
formulas, 9.3
models, 9.3
objects, 9.3
partition templates, 9.3
partitions, 9.3
programs, 9.3
surrogates, 9.3
triggers, 10, 10, 10
valuesets, 9.3
DEPRDECL function, 7.3
DEPRDECLSW function, 7.3
depreciation of assets, 7.3, 7.3, 7.3, 7.3
DEPRSL function, 7.3
DEPRSOYD function, 7.3
DESCRIBE command, 9.3
descriptions
adding to a definition, 10
deleting from a definition, 10
detaching
analytic workspaces, 4.8
dimension alias
See alias dimensions
DIMENSION command, in a model, 10
DIMENSION statement
for aggregation, 9.3
for allocation, 9.3
dimension status
effect on expressions, 2.3.1.2.2
null, 6.3
restoring, 4.3.4.2
saving current, 4.3.4.2
dimension surrogates
assigning values to, 10
defining, 9.3
dimension values
comparing, 2.3.8.4, 2.3.8.4
counting related values, 8
deleting values of, 10, 10
latest value, 8
null, 6.3
number of (determining), 8, 8
number of values in status, 8
place in status list, 8
retrieving current status list
retrieving, 8
returning first value in status, 8
returning last value in status, 8
setting the status of, 10
sorting, 8, 10
testing for, 7.3
using qualified data reference, 8
using result of LIMIT command, 8
dimensionality, changing, 7.3
dimension-based equations, 3.3.1
dimensions
acquired, 7.3
checking status of, 8
comparing values, 2.3.8.4
defining, 9.3, 9.3
defining surrogates for, 9.3
deleting, 9.3, 9.3
determining status of, 8
limiting, 10
limiting to single value, 2.3.2.5
listing associated objects, 10
looping over values of, 9.3, 9.3, 9.3
maintaining, 10
numeric value of text dimension, 2.3.4.2
of expression, 2.3.1.2, 2.3.1.2.1
order in models, 10
QDR with, 2.3.2.5, 2.3.2.5.5
related, 2.3.2.3.3, 10
restoring previous values, 4.3.4.3
saving current values, 4.3.4.3
See also alias dimensions, base dimensions, concat dimensions, conjoint dimensions, simple dimensions
sorting values, 10
status lists, 8
type of (determining), 8
worksheet, 9.3
directory
changing, 9.3
identifying current, 9.3
displaying error messages, 6.3
DIVIDEBYZERO option, 6.3
division, 8
by zero, 6.3
calculating the remainder, 8
DO command, 9.3, 9.3
used with FOR, 9.3
used with SWITCH, 10
used with WHILE, 10
DOEND command, 9.3
double quotes, 2.1.2.1
DSECONDS option, 6.3
DSINTERVAL data type, 2.1.4.9
DSINTERVAL function, 8
DY datetime format element, 9.3

E

ECHOPROMPT option, 4.5.3, 6.3
EDIT command, 9.3
editing previously executed commands, 10
EIF file, 4.7.6, 9.3
exporting data from, 9.3
importing data from, 10
EIFBYTES option, 6.3
EIFEXTENSIONPATH option, 6.3
EIFNAMES option, 6.3
EIFSHORTNAMES option, 6.3
EIFTYPES option, 6.3
EIFUPDBYTES option, 6.3
EIFVERSION option, 6.3
embedded-total dimension views, A.2.2
embedded-total fact view, A.2.2
encoding, 8
ENDDATE function, 7.3
ENDOF function, 7.3
EQ command, 9.3
equations, dimension-based, 3.3.1
ERRNAMES option, 6.3
error messages, 10
creating your own, 4.3.5.4
deferring, 4.3.5.1
displaying, 6.3
option holding text of, 6.3
producing without error condition, 10
signaling error condition, 10
suppressing, 4.3.5.3, 6.3
suppressing during compilation, 6.3
wrapping, 6.3
ERRORLOG statement, 9.3
ERRORMASK statement, 9.3
ERRORNAME option, 4.3.5, 6.3
errors
controlling during calculations, 2.3.4.4
handling, 4.3.5
handling in nested programs, 10, 10
handling in programs, 10
name of first-occurring error, 6.3
signaling, 4.3.5.4, 10, 10
SQL error codes, 6.3
when comparing numeric data, 2.3.8.3, 2.3.8.3.2, 2.3.8.3.3
ERRORTEXT option, 4.3.5, 6.3
escape character for LIKE, 6.3
escape sequences, 2.1.2.2, 2.1.2.2
ESCAPEBASE option, 6.3
EVAL_NUMBER function (PL/SQL), B.5.2
EVAL_TEXT function (PL/SQL), B.5.2
events
Assign, 10, 10
assignment statements, 10
Define, 4.8
Delete, 10, 10
deleting, 10, 10, 10
identifying, 8
Maintain, 10, 10
Property, 10, 10
Update, 4.8, 4.8, 10
EVERSION function, 7.3
EVERY function, 7.3
EXECUTE procedure (PL/SQL), B.5.2
EXISTS function, 7.3
EXP function, 7.3
exponential forecasting, 9.3
exponents, retrieving, 7.3
EXPORT command, 4.7.6, 9.3
EXPORT to EIF command, 9.3
EXPORT to spreadsheet command, 9.3
exporting data, 6.3, 6.3, 9.3
expressions
ampersand substitution, 2.3.10
Boolean, 2.3.8, 2.3.9, 2.3.9, 2.3.9.1
changing dimensionality of, 7.3
comparing, 8
conditional, 2.3.9, 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
interval, 2.3.6.2
NA values in, 2.3.3
numeric, 2.3.4
objects in, 2.3.2
padding, 8, 8
parsing, 10
retrieving largest, 7.3
retrieving smallest, 8
saving, 9.3
substitution, 2.3.10
text, 2.3.5
trimming, 8, 8
using objects in, 2.3.2.4
using qualified data references in, 8
EXPTRACE option, 6.3
EXTBYTES function, 7.3
EXTCHARS function, 7.3
EXTCOLS function, 7.3
EXTLINES function, 7.3
EXTRACT function, 7.3

F

fastest-varying dimension, 9.3
FCCLOSE command, 9.3
FCEXEC command, 9.3
FCOPEN command, 7.3
FCQUERY command, 7.3
FCSET command, 9.3
FETCH command
See SQL command in OLAP DML
FETCH command (OLAP DML), A.2.2, A.2.2
fetching data (SQL), 10
file I/O, 7.3, 7.3, 9.3, 9.3, 9.3, 9.3, 9.3
closing, 7.3, 9.3, 9.3
current directory, 9.3
diagnosing errors when processing, 7.3
forcing a page break, 9.3
gathering information about, 7.3
list of open files, 10
opening, 7.3
processing data from, 9.3
reading a record, 7.3
reading data from, 9.3
reading Oracle OLAP commands from a file, 7.3, 10
records read, 8
setting attributes, 9.3
writing, 9.3
FILECLOSE command, 9.3
FILECOPY command, 9.3
FILEDELETE command, 9.3
FILEERROR function, 7.3
FILEGET function, 7.3
FILEMOVE command, 9.3
FILENEXT function, 7.3
FILEOPEN function, 7.3
FILEPAGE command, 9.3
FILEPUT command, 9.3
FILEQUERY function, 7.3
FILEREAD command, 9.3
files
appending output, 10
importing data from, 10
saving output in, 10
FILESET command, 9.3
fileunits, 7.3, 7.3
attributes, 7.3
number of outfile destination, 6.3
opening, 7.3, 10
reading data from, 9.3
setting attributes, 9.3
FILEVIEW command, 9.3
FILTERLINES function, 7.3
financial analysis, scenario modeling, 3.3.2.6
FINDBYTES function, 7.3
FINDCHARS function, 7.3
FINDLINES function, 7.3
FINTSCHED function, 7.3
floating point numbers, comparing, 2.3.8.3.2
floating-point format
limitations when calculating, 2.3.4.3
use of, 2.3.4.3
FLOOR function, 7.3
FOR command, 9.3, 9.3
breaking out of, 9.3
example of, 9.3
looping over dimension values, 9.3, 9.3, 9.3
used with BREAK, 9.3
used with CONTINUE, 9.3
used with OKFORLIMIT, 6.3
used with TEMPSTAT, 10
FORECAST command, 9.3
FORECAST function, 7.3
forecasting context, 9.3
closing, 9.3
executing, 9.3
opening, 7.3
querying, 7.3
setting characteristics of, 7.3
FORECAST.REPORT program, 9.3, 9.3
format model, 9.3
format models, 2.1.4.2
date
changing, 2.1.4.2, 9.3
default format, 2.1.4.2, 9.3
formats
for dates and numbers. See format models
of return values from the database, 2.1.4.2
of values stored in the database, 2.1.4.2
formatting
datetime data, 9.3
formulas
aggmap objects in, 8
aggregating data with, 7.3
compiling, 6.3, 9.3
defining, 9.3, 9.3
deleting, 9.3, 9.3
expression for (retrieving), 8
recursive, 6.3
specifying new expression, 9.3
FPMTSCHED function, 7.3
FROM_TZ function, 7.3
FULLDSC program, 9.3
functions
calling, 9.3
user-defined, 4.3.1, 4.3.1, 9.3, 10

G

GET function, 7.3
GETLOG function (PL/SQL), B.5.2
GOTO command, 9.3
GREATEST function, 7.3
group marker, 6.3
grouping ids, 5.3, 5.3, 5.3
GROUPINGID command, 9.3
GROUPINGID function, 7.3
GROWRATE function, 7.3
growth rate, 7.3

H

handling errors in programs, 10
hash partitions, 9.3
heading, 10
for a report, 10
for output pages, 6.3
including a page number, 6.3
producing standard report heading, 10
HEADING command, 10
HIDE command, 10
HIERHEIGHT command, 10
HIERHEIGHT function, 7.3
Holt-Winters forecasting, 9.3
hyperbolic
cosine calculation, 7.3
sine calculation, 8
tangent calculation, 8

I

IF command, 9.3, 10
IF conditional expression, 2.3.9.1
IFNONE keyword, 10
IMPORT command, 4.7.6, 10
See also SQL command in OLAP DML
importing data, 6.3, 6.3
controlling update frequency, 6.3
from an analytic workspace, 10
from spreadsheets, 10
from text files, 10
tracking names of objects, 6.3
tracking types of objects, 6.3
INCLUDE command, 10
INF_STOP_ON_ERROR option, 6.3
INFILE command, 10
INFILE procedure (PL/SQL), B.5.2
INFO function, 7.3
FORECAST, 7.3
MODEL, 7.3
PARSE, 7.3
REGRESS, 7.3
INITCAP function, 7.3
initialization parameters, C, C.1
init.ora file, C.1
INLIST function, 7.3
input file
reading from a file, 7.3, 10
with SNAPI connection, 7.3
with XCA dialog, 7.3
INSBYTES function, 7.3
INSCHARS function, 7.3
INSCOLS function, 7.3
INSLINES function, 7.3
INSTAT function, 7.3
integer part of decimal number, 7.3
interest on loans, 7.3, 8
internal rate of return, 7.3
INTERP function (PL/SQL), B.5.2
INTERP_SILENT procedure (PL/SQL), B.5.2
INTERPCLOB function (PL/SQL), B.5.2
interval
arithmetic, 2.3.6.3
INTERVAL expressions, 2.3.6.2
INTPART function, 7.3
IRR function, 7.3
ISDATE program, 7.3
ISEMPTY function, 7.3
ISSESSION function, 7.3
ISVALUE function, 7.3

J

JOINBYTES function, 7.3
JOINCHARS function, 7.3
JOINCOLS function, 7.3
JOINLINES function, 7.3

K

KEY function, 7.3

L

label column width, 6.3
branching in a program, 9.3
for error handling in programs, 10
labels, 9.3
in programs, 4.3.5.6
with IFNONE, 10
LAG function, 3.3.2.3, 8
LAGABSPCT function, 8
LAGDIF function, 8
LAGPCT function, 8
larger value of two expressions, 8
LARGEST function, 8
largest value of an expression, 8
LAST_DAY function, 8
LCOLWIDTH option, 6.3
LD command, 10
LEAD function, 3.3.2.3, 8
LEAST function, 8
LENGTH function, 8
LENGTH2 function, 8
LENGTH4 function, 8
LENGTHB function, 8
LENGTHC function, 8
LIKE operator, 6.3, 6.3
LIKECASE option, 6.3
LIKEESCAPE option, 6.3
LIKENL option, 6.3
LIMIT BASEDIMS command, 10
LIMIT command, 10
using LEVELREL, 10
using NOCONVERT, 10
using parent relation, 10
using POSLIST, 10
using related dimension, 10
using values, 10
LIMIT function, 8
limit maps, A.1, A.2.2, A.2.2
order of processing, A.2.2
syntax, A.2.2
limiting
alias dimensions, 9.3
dimensions, 10
multidimensional valuesets, 9.3
LIMITMAPINFO function, 8
LIMIT.SORTREL option, 6.3
LIMITSTRICT option, 6.3, 10
line size for report heading, 6.3
LINENUM option, 6.3
lines on a page of report output, 6.3
LINESLEFT option, 6.3
LISTBY program, 10
LISTFILES command, 10
LISTNAMES program, 10
literals
numeric, 2.1.1
text, 2.3.5
LOAD command, 10
loans, 7.3
interest payment on, 7.3
interest payments on, 8
payment on, 7.3
payments on, 8
local variables, 10, 10
locale independent, 9.3
LOCALTIMESTAMP function, 8
LOG command, 10
LOG function, 8
LOG10 function, 8
logical operators, 2.2.2
logs
calculating base 10 logarithm, 8
calculating natural logarithm, 8
LOOP clause in SQL FETCH, 10
looping, 9.3
over dimension status, 9.3
looping, explicit, 5.3, 5.3, 5.3, 5.3
LOWCASE function, 8
lowercase, converting to, 8
LPAD function, 8
LSIZE option, 6.3
LTRIM function, 8

M

MAINTAIN command
event, 10, 10
MAINTAIN ADD, 10
MAINTAIN ADD for DAY, WEEK, MONTH, QUARTER and YEAR values, 10
MAINTAIN ADD for TEXT, ID, and INTEGER values, 10
MAINTAIN ADD SESSION, 10
MAINTAIN DELETE, 10, 10, 10
MAINTAIN MERGE, 10
MAINTAIN MOVE, 10
MAINTAIN RENAME, 10
trigger, 10, 10
Maintain event, 10
maintaining
alias dimensions, 9.3
composites, 10
dimensions, 10
partition templates, 10
partitions, 10
MAKEDATE function, 8
margins, 6.3
setting bottom margin, 6.3
setting top margin, 6.3
MAX function, 8
MAXBYTES function, 8
MAXCHARS function, 8
MAXFETCH option, 6.3
maximum values, 8
for each time period in the status, 8
larger of two expressions, 8
MEASUREDIM statement
for aggregation, 9.3
for allocation, 9.3
MEDIAN function, 8
median value, 8
messages, suppressing, 6.3
MIN function, 8
minimum value, 8
for each time period in the status, 8
smaller of two expressions, 8
MMOF function, 8
MOD function, 8
MODDAMP option, 6.3
MODE function, 8
models
adding to aggmap, 9.3
compiling, 3.3.3, 9.3, 10
creating, 10
debugging, 3.3.5
defining, 9.3
deleting, 9.3
editing, 10
in aggregation specifications, 9.3, 10, 10
obtaining information about, 7.3
removing from aggmap, 9.3, 9.3
running, 3.3.4, 10
scenario, 3.3.2.6
solution variables, 3.3.1
MODEL.XEQRPT program
compiling, 6.3
defining, 9.3, 9.3
including, 10
nesting, 10
options, 6.3, 6.3, 6.3, 6.3, 6.3, 6.3, 6.3
MODERROR option, 6.3
MODGAMMA option, 6.3
MODINPUTORDER option, 6.3
MODMAXITERS option, 6.3
MODOVERFLOW option, 6.3
MODSIMULTYPE option, 6.3
MODTOLERANCE option, 6.3
MODTRACE option, 6.3
module version numbers, 7.3
MODULO function, 8
MON datetime format element, 9.3
MONITOR command, 10
monitoring, 10
cost of program lines, 10
cost of programs, 10
MONTH datetime format element, 9.3
MONTHABBRLEN option, 6.3
MONTHNAMES option, 6.3
MONTHS_BETWEEN function, 8
MOVE command, 10
MOVINGAVERAGE function, 8
MOVINGMAX function, 8
MOVINGMIN function, 8
MOVINGTOTAL function, 8
multidimensional valuesets, 9.3
multiline text
columns, 7.3
MULTIPATHHIER option, 6.3
multiwriter mode, 7.3, 9.3, 9.3

N

NA values
accepted as numeric input, 6.3, 6.3
caching, 6.3
comparing, 2.3.8.2, 2.3.8.2
controlling how treated, 2.3.3.2, 2.3.3.2
in Boolean expression, 2.3.8.2
in expressions, 2.3.3
NA2 bits, 2.3.3, 9.3
permanently replacing, 6.3
replacing, 8
replacing with strings, 8
retrieving, 7.3
spelling of, 6.3
substituting another value, 8
triggers, 6.3, 6.3
NA2 bits, 2.3.3, 9.3
NA2 function, 8
NA2 values, 8, 8
NAFILL function, 8
NAFLAG function, 8
name, 10
changing object name, 10
dimension, 10
listing names of dictionary entries, 10
NAME dimension, 10
names
listing for objects, 10
listing objects by, 10
qualified object, 2.3.2.2
NASKIP option, 6.3
NASKIP2 option, 6.3
NASPELL option, 6.3, 9.3
NATRIGGER
See $NATRIGGER
natural logarithm, 8
negative value, 6.3
in output, 6.3
obtaining the root, 6.3
net present value, 8
NEW_TIME function, 8
NEXT_DAY function, 8
NLS_CALENDAR option, 6.3
NLS_CURRENCY option, 6.3
NLS_DATE_FORMAT option, 6.3
NLS_DATE_LANGAUGE option, 6.3
NLS_DATE_LANGUAGE initialization parameter, 9.3
NLS_DUAL_CURRENCY option, 6.3
NLS_ISO_CURRENCY option, 6.3
NLS_LANG option, 6.3
NLS_LANGUAGE initialization parameter, 9.3
NLS_LANGUAGE option, 6.3
NLS_NUMERIC_CHARACTERS option, 6.3
NLS_SORT option, 6.3
NLS_TERRITORY initialization parameter, 9.3
NLS_TERRITORY option, 6.3
NLSSORT function, 8
NONE function, 8
NORMAL function, 8
NOSPELL option, 6.3
NPV function, 8
null values
See NA values
NULLIF function, 8
numbers
assigning random numbers, 8
commas in output, 6.3
decimal marker for output, 6.3
decimal places in output, 6.3
determining sign of, 8
negative values in output, 6.3
rounding, 8
spelling out, 9.3
thousands marker for output, 6.3
NUMBYTES function, 8
NUMCHARS function, 8
numeric data types, 2.1.1
comparing, 2.3.8.3, 2.3.8.3.3
mixing, 2.3.4.1
numeric expressions, 2.3.4
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
NUMLINES function, 8
NUMTODSINTERVAL function, 8
NUMTOYMNTERVAL function, 8
NVL function, 8
NVL2 function, 8

O

OBJ function, 8
object definitions
adding descriptions to, 10
deleting descriptions from, 10
object types
automatic, A.1.2.1, A.2.2
predefining, A.1.2.1, A.2.2
syntax for creating, A.1.2, A.2.2
objects, 9.3
acquired (list of), 7.3
checking for changes, 8
compiling, 6.3
creating by copying, 9.3
creating properties, 10
data type of (determining), 8
defining, 9.3
definition (retrieving), 8
deleting, 9.3, 9.3
describing its definition, 9.3
describing its properties, 9.3
dimensions of (retrieving), 8, 8
dropping changes, 10, 10
exporting from analytic workspace, 9.3
identifying triggers, 8
importing into analytic workspace, 10
in expressions, 2.3.2
listing, 8
listing names of, 10, 10, 10
loading, 10
making current, 9.3
obtaining information, 8
pages used to store (determining), 8
qualified name, 2.3.2.2
recalculating permissions, 10
renaming, 10
restrictions on name, 9.3
storage class (determining), 8
testing for existence, 7.3
OBJLIST function, 8
OBSCURE function, 8
OESEIFVERSION option
name change, Preface
See EIFVERSION option
OKFORLIMIT option, 6.3
OKNULLSTATUS option, 6.3, 10
OLAP API
optimization, C
OLAP DML
executing in SQL, A.2.2, A.2.2, A.2.2, B.3, B.5.2
quotation marks in, B.3.2
OLAP session cache
blocking creation of, 6.3
checking if empty, 8
defined, 6.3
for variable, 8
non-NA values, 8
populating with aggregated values, 6.3, 9.3
populating with NA values, 6.3
OLAP_API_SESSION_INIT package, C
OLAP_CONDITION function (SQL), A.2.2, A.2.2
OLAP_EXPRESSION function (SQL), A.2.2, B.3.1
OLAP_EXPRESSION_BOOL function (SQL), A.2.2
OLAP_EXPRESSION_DATE function (SQL), A.2.2
OLAP_EXPRESSION_TEXT function (SQL), A.2.2
OLAP_ON function (PL/SQL), B.5.2, B.5.2
OLAP_TABLE
optimizing looping, 5.3, 5.3, 5.3, 5.3
OLAP_TABLE function (SQL), A.2.2
custom measures, A.2.2, A.2.2, A.2.2, A.2.2
data map parameter, A.2.2
data type conversions, A.2.2
examples, A.2.2
FETCH command, A.2.2, A.2.2
limit map, A.1, A.2.2, A.2.2
retrieving session log, B.5.2
specifying a ROW2CELL column, A.2.2
specifying an OLAP DML command, A.2.2
specifying the analytic workspace, A.2.2
specifying the logical table, A.2.2
ONATTACH program, 4.8
ONDETACH program, 4.8
OPEN command See SQL command in OLAP DML, 10
operating system, identifying, 8
operators, 6.3
Boolean, 2.2.2
comparisons, 2.2.2
conditional, 2.3.9, 2.3.9
LIKE, 6.3, 6.3, 6.3
logical, 2.2.2
overview, 2.2
substitution, 2.3.10
optimization
OLAP API, C, C.1
options
displaying value of, 6.1
restoring previous values, 4.3.4.3
retrieving, 6.1
saving current values, 4.3.4.3
specifying, 6.1
Oracle OLAP
internal build number, 7.3
ordinal numbers
specifying, 9.3
spelling out, 9.3
outfile
current, 6.3
OUTFILE command, 10, 10
affect on DBMS_AW.EXECUTE, B.5.2
affect on DBMS_AW.RUN, B.5.2
OUTFILEUNIT option, 6.3
out-of-range decimal values, 6.3
output, 10
redirecting, 10
saving in a file, 10
overflow condition, 6.3

P

padding expressions, 8, 8
PAGE command, 10
PAGENUM option, 6.3
PAGEPRG option, 6.3
PAGESIZE, 6.3
paging in reports, 10
forcing a page break, 10
line number on current page, 6.3
lines for bottom margin, 6.3
lines for top margin, 6.3
lines left on page, 6.3
lines on a page, 6.3
page number, 6.3
producing a custom heading, 6.3
producing a standard heading, 10
turning on, 6.3
PAGING option, 6.3
PARENS option, 6.3
PARSE command, 7.3, 10
parsing expressions, 10
PARTITION function, 8
partition templates, 9.3, 9.3
defining, 9.3, 9.3
deleting, 9.3
maintaining, 10
retrieving partition names, 8
retrieving partitioning method, 8
PARTITIONCHECK function, 8
partitioned variables, 9.3, 9.3
aggregating, 8
defining, 9.3
deleting data from, 10
maintaining, 10
retrieving dimensions of, 8
retrieving partitioning method, 8
partitioning methods, 8
partitions, 9.3, 9.3, 9.3
adding values to, 10, 10
defining, 9.3
list partitions, 9.3
deleting, 9.3
deleting data, 10
identifying for value, 8
list, 9.3
locking segments of, 10
moving values, 10
range, 8, 9.3
retrieving dimensions of, 8
retrieving names of, 8
specifying values of, 10
pattern matching, 2.3.8.6.1
payment schedules, 7.3
for loan interest, 7.3, 8
for loans, 7.3, 8
PERCENTAGE function, 8
permission programs, 4.7.1.1, 4.8, 4.8, 4.8
permissions, 10
assigning to an object definition, 10
recalculating permission, 10
specifying conditions for accessing, 10
violations of, 6.3
PERMIT command, 10
PERMIT_READ program, 4.7.1.1, 4.8
PERMIT_WRITE program, 4.7.1.1, 4.8
PERMITERROR option, 6.3
PERMITRESET command, 10
platform, determining, 8
P.M. datetime format element, 9.3, 9.3
POP command, 4.3.4.3, 4.3.4.4, 10, 10
popping a whole series at once, 10
POPLEVEL command, 10
nesting, 10
using, 4.3.4.5
populating
alias dimensions, 9.3
POUTFILEUNIT option, 6.3
PRECOMPUTE statement, 9.3
PREPARE command
See SQL command in OLAP DML
PRGERR keyword (SIGNAL), 10
PRGTRACE option, 6.3
print buffer, B.5.2, B.5.2
PRINTLOG procedure (PL/SQL), B.5.2
PROCEDURE statement
See SQL command in OLAP DML, 10
profiles, 8
PROGRAM command, 10
programs
adding program contents to a definition, 10
branching, 9.3, 9.3, 10
branching in, 10
branching labels, 9.3
calling, 9.3
case statement, 10
comment lines in, 4.3
compiling, 4.4, 4.4, 6.3, 9.3, 9.3
conditional execution of commands, 10, 10
debugging, 4.5, 6.3
declaring arguments in, 4.3.2.1
defining, 9.3
deleting, 9.3
determining how invoked, 7.3
error handling, 6.3, 6.3, 10
errors in, 4.3.5
executing, 4.6
halting execution with an error, 10
hiding, 10
local variable, 10
passing arguments to, 7.3, 7.3, 7.3, 7.3
performance cost, 10
permission, 4.7.1, 4.7.1.1, 4.8, 4.8, 4.8, 4.8, 4.8, 4.8
preserving environment, 4.3.4, 4.3.4
preserving status, 7.3, 9.3
repeating commands, 9.3
restoring previous values, 4.3.4.3
restoring status, 10, 10
returning a value, 10
saving compiled code, 4.4
saving current values, 4.3.4.3
saving status, 10, 10
startup, 4.7.1
suspending execution, 10
terminating execution of, 10
timing execution, 10, 10
trigger, 4.7.3.2, 4.8, 4.8, 4.8, 4.8, 4.8, 4.8, 4.8, 10
unhiding, 10
properties, 10
copying with an object definition, 9.3
creating for objects, 10
listing for objects, 9.3
PROPERTY command, 10
event, 10, 10
trigger, 10, 10
Property event, 10
PUSH command, 4.3.4.4, 10, 10
marking start of series, 10
placement, 4.3.5.6
using, 4.3.4.3
PUSHLEVEL command, 10
nesting, 10
placement, 4.3.5.6

Q

QUAL function, 2.3.2.5, 8
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
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.2, 2.3.2.5.3
qualified object name, 2.3.2.2
quotation marks
double, 2.1.2.1
in OLAP DML, B.3.2

R

RANDOM function, 8
random numbers, 8, 8
random sparsity, 9.3
RANDOM.SEED.1 option, 6.3
RANDOM.SEED.2 option, 6.3
range partitions
defining, 9.3
retrieving calculation for, 8
RANK function, 8
number of calls to, 8
number of computed values, 8
number of triggered sorts, 8
RANK_CALLS option, 8
RANK_CELLS option, 8
RANK_SORTS option, 8
ranking performance monitoring, 8
RAW data type, 2.1.6, 2.1.6
reading files, 8
current record number, 8
error diagnosis, 7.3
FILEREAD command, 9.3
processing a record, 9.3
reading a record, 7.3
RECAP command, 10
RECNO function, 8
RECURSIVE option, 6.3
REDO command, 10
REEDIT command, 10
REGRESS command, 7.3, 10
regressions
linear, 10
REGRESS.REPORT program, 10
related dimensions, 2.3.2.3.3, 8, 10
limiting to, 6.3
RELATION command, 10
RELATION statement
for aggregation, 9.3
for allocation, 9.3
relational tables See tables
relations
assigning values to, 10, 10, 10
comparing to text literals, 2.3.8.6.2
default, 2.3.2.3.3, 10
defining, 9.3, 9.3
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.3
RELEASE command, 10
REM function, 8
remainder after division, 8
REMAINDER function, 8
REMBYTES function, 8
REMCHARS function, 8
REMCOLS function, 8
REMLINES function, 8
RENAME command, 10
REPLBYTES function, 8
REPLCHARS function, 8
REPLCOLS function, 8
REPLLINES function, 8
REPORT command, 10
reporting, 10
reports
processing ROW command output, 8
producing, 8, 10
producing with ROW commands, 10
RESERVED function, 8
reserved words, 8, 8
RESYNC command, 10
RETURN command, 10
return value of a program, 10
REVERT command, 10, 10
ROLE option, 6.3
roles, 8
root of negative number, 6.3
ROOTOFNEGATIVE option, 6.3
ROUND function
for numbers, 8
ROW command, 10
processing output, 8
ROW function, 8
ROW2CELL column, A.1.3, A.2.2, A.2.2, A.2.2, A.2.2, A.2.2, A.2.2, A.2.2
ROWID data type, 2.1.7.1
converting, 8, 8
ROWIDTOCHAR function, 8
ROWIDTONCHAR function, 8
RPAD function, 8
RR datetime format element, 9.3
RTRIM function, 8
RUN procedure (PL/SQL), B.5.2
running totals, 8, 10
run-time aggregation, 3.4.4
RUNTOTAL function, 8

S

scenario models, 3.3.2.6
seasonal data, 9.3
SECONDS option, 6.3
segment width, 9.3
segments
analytic workspace, 9.3
locking, 10
retrieving maximum size of, 7.3
SELECT statements (in OLAP DML), 10
See also SQL command in OLAP DML
selecting
alias dimension values, 9.3
data, 10
SERVEROUTPUT option, B.5.2, B.5.2, B.5.2
SESSCACHE option, 6.3
session
shutting down, B.5.2
starting up, B.5.2
session cache
See OLAP session cache
session logs
printing, B.5.2
retrieving, B.5.2
sessions, 10
preserving environment, 4.3.4, 4.3.4
recording in disk file, 10
restoring environment, 4.3.4.3
user ID, 8
SESSIONTIMEZONE function, 8
SET command, 10
SET1 command, 10
SHOW command, 10
SHUTDOWN procedure (PL/SQL), B.5.2
SIGN function, 8
SIGNAL command, 4.3.5.4, 10
simultaneous equations in models, 3.3.2.5
SIN function, 8
sine calculation, 8, 8
single-row functions, A.2.1
SINH function, 8
SLEEP command, 10
slowest-varying dimension, 9.3
smaller value of two expressions, 8
SMALLEST function, 8
smallest value of an expression, 8
SMOOTH function, 8
solution variables
defined, 3.3.1
example of, 10
SORT
command, 10
function, 8
SORTCOMPOSITE option, 6.3
sorting
dimension values, 10
status list of a dimension, 6.3, 8, 10
valuesets, 8, 10
SORTLINES function, 8
SOURCEVAL statement, 9.3
SP datetime format element suffix, 9.3
sparse data, 7.3
base dimension value, 7.3
changing definitions, 9.3
eliminating, 9.3
exporting, 9.3
importing, 10
index algorithm, 6.3
obtaining information, 8
reading from files, 9.3
renaming composites, 10
reporting, 10, 10
specifying composites, 9.3
SPARSE keyword, 1.5.1.2, 9.3
SPARSEINDEX option, 6.3
sparsity
controlled, 9.3
random, 9.3
See also sparse data
Sparsity Advisor, B.4
SPARSITY_ADVICE_TABLE column descriptions, B.5.2
SPARSITY_ADVICE_TABLE procedure (PL/SQL), B.5.2
special characters, 2.1.2.2
spelled numbers
specifying, 9.3
spreadsheets
defining, 9.3
exporting to, 9.3
importing data from, 10, 10, 10
See also worksheet objects
SPTH datetime format element suffix, 9.3
SQL
embedding OLAP commands, A.2.2, A.2.2, A.2.2, A.2.2, A.2.2
managing analytic workspaces, B
SQL (in OLAP DML)
defining cursors, 10
embedding statements, 4.7.2.1.1, 10
precompiling statements, 10
retrieving errors, 6.3, 6.3
stored procedures, 10
SQL command in OLAP DML, 10
CLEANUP, 10
CLOSE, 10
DECLARE CURSOR, 10
EXECUTE, 10
FETCH, 10
IMPORT, 10
PREPARE, 10
PROCEDURE, 10
SELECT, 10, 10
SQLBLOCKMAX option, 6.3
SQLCODE option, 6.3
SQLCOLUMNS procedure, 10, 10
SQLERRM option, 6.3
SQLFETCH function, 8
SQLMESSAGES option, 6.3
SQLTABLES procedure, 10, 10, 10
SQRT command, 8
square root, 8
calculating, 8
result for negative number, 6.3
standard deviation calculation, 8
STARTOF function, 8
STARTUP procedure (PL/SQL), B.5.2
startup programs, 4.7.1
STATALL function, 8, 8
STATDEPTH function, 8
statements
altering order of execution, 9.3
editing previously executed, 10
reading from a file, 10
reexecuting, 10
sending to file, 10
STATEQUAL, 8
STATFIRST function, 8
STATIC_SESSION_LANGUAGE option, 6.3
STATLAST function, 8
STATLEN function, 8
STATLIST function, 8
STATMAX function, 8
STATMIN function, 8
STATRANK function, 8
status
determining, 8
setting, 10
setting inside a statement, 10
setting to null, 6.3
status lists
base dimensions, 10
comparing, 8
empty, 6.3
first value in, 8
last value in, 8
looping over, 6.3, 9.3, 10
most recent value, 8
null values, 6.3
number of values in, 8
position in, 8
restoring, 10, 10
result of LIMIT command, 8
retrieving, 8
retrieving depth of, 8
retrieving value by position, 8
retrieving values from, 8, 8
saving, 7.3, 9.3, 10, 10
saving in a context, 9.3
sending to outfile, 10
setting to null, 6.3
sorting, 6.3, 8, 10
STATUS program, 10, 10
STATVAL function, 8
STDDEV function, 8
STDHDR program, 10
line size for centering, 6.3
storage
changing, 9.3
of variables, 9.3
stored procedures
creating, 10
stored procedures (SQL)
executing, 10
STORETRIGGERVAL property, 10
strings
byte, 2.1.6, 2.1.6
length of, 8
subevents, identifying, 8
substitution expressions, 2.3.10
substitution operator, 2.3.10
SUBSTR function, 7.3, 8
SUBSTR2 function, 7.3, 8
SUBSTR4 function, 7.3, 8
SUBSTRB function, 7.3, 8
SUBSTRC function, 7.3, 8
substrings
retrieving, 7.3, 8
SUBTOTAL function, 8
subtotals, 8
in a report, 8
resetting to zero, 10
surrogate dimension, 9.3
defining, 9.3
surrogates
defining, 9.3
deleting, 9.3
SWITCH command, 9.3, 9.3, 10
SWTICH
conditional expression, 2.3.9.2
SYS_CONTEXT function, 8
SYSDATE function, 8
SYSINFO function, 8
SYSTEM function, 8
SYSTIMESTAMP function, 8

T

table type, A.2.2
automatic, A.1.2.1, A.2.2
predefining, A.1.2.1, A.2.2
syntax for creating, A.1.2, A.2.2
tables
exporting from analytic workspaces, 10
importing into analytic workspaces, 10
TALLY function, 8
TAN function, 8
tangent calculation, 8
angle value, 7.3
arc, 7.3, 7.3
hyperbolic, 8
TANH function, 8
TCONVERT function, 8
temporary members
adding to dimension, 10
identifying, 7.3
TEMPSTAT command, 10
text
comparing values, 2.3.8.6
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, 4.3.2.3, 10
special characters, 2.1.2.2
text expressions, 2.3.4.2, 2.3.5
text formatting
importing worksheet data, 10
TEXTFILL function, 8
TH datetime format element suffix, 9.3
thousands marker, 6.3
THOUSANDSCHAR option, 6.3
THSP datetime format element suffix, 9.3
time format models
short, 9.3
time of day, 8, 8
time series, 8
cumulative totals over, 7.3
data from previous time period, 8
data from subsequent time period, 8
difference between time periods, 8
maximum value in period, 8
minimum value in period, 8
moving totals over, 8
percent difference between time periods, 8, 8
time zone
formatting, 9.3
time zones
converting data to particular, 2.3.6.1
timestamp
converting to local time zone, 2.3.6.1
TIMESTAMP data type, 2.1.4.5
TIMESTAMP_LTZ data type, 2.1.4.7
TIMESTAMP_TZ data type, 2.1.4.6
timezone offsets, 8
timing, 10
execution of program lines, 10
execution of programs, 10
title for a report, 10
TMARGIN option, 6.3
TO_CHAR function, 8
TO_DATE function, 8, 9.3
TO_NCHAR function, 8
TO_NUMBER function, 8
TO_TIMESTAMP_TZ function, 8
TOD function, 8
TODAY function, 8
TOTAL function, 8
totals
calculating, 8
cumulative, 7.3
in a report, 8, 8, 10, 10
moving, 8
over time, 8
running, 8
TRACEFILEUNIT option, 6.3
tracking, 10
cost of program lines, 10
cost of programs, 10
TRACKPRG command, 10
TRACKREPORT program, 10
TRANSLATE function, 8
TRAP command, 4.3.5.1, 10, 10, 10, 10
TRIGGER command, 10
TRIGGER function, 8
trigger objects, 8
trigger programs
Assign, 10, 10
Delete, 10, 10
designing, 4.7.3.2
Maintain, 10, 10
Property, 10, 10
Update, 4.8, 10
TRIGGER_AFTER_UPDATE program, 4.8
TRIGGER_AW program, 4.8, 4.8
TRIGGER_BEFORE_UPDATE program, 4.8
TRIGGER_DEFINE program, 4.8
TRIGGERASSIGN command, 10
TRIGGERMAXDEPTH option, 6.3
triggers
Assign, 10, 10
creating, 10
Define, 4.8
Delete, 10
deleting, 10, 10, 10
events, 8
Maintain, 10
NA, 5.3, 6.3, 6.3
objects, 8
Property, 10
subevents, 8
Update, 4.8, 4.8, 10
TRIGGERSTOREOK option, 6.3
TRIM function, 8
trimming expressions, 8, 8
trimming strings, 8
TRUNC function, 8
for numbers, 8
TRUNCATE function, 8
for datetimes, 8
for numbers, 8
tuples, B.4.1
TZ_OFFSET function, 8

U

UNHIDE command, 10
UNIQUELINES function, 8
unnamed composites, 9.3
defining, 9.3
example of, 9.3
UNRAVEL function, 8
UPCASE function, 8
UPDATE command, 10
event, 10
events, 4.8, 4.8
trigger, 10
triggers, 4.8, 4.8, 4.8
UROWID data type, 2.1.7.2
user ID, retrieving, 8
user-defined functions
arguments in, 4.3.1
data type of, 4.3.1
USERID option, 6.3
USETRIGGERS option, 6.3
UTC offset
replacing with time zone region, 2.1.4.6

V

VALSPERPAGE program, 8
value name format, 10
values
restoring previous, 4.3.4.3
saving current, 4.3.4.3
See also Boolean values
VALUES function, 8
VALUESET statement, 9.3
valuesets
assigning values to, 9.3
checking status of, 10
defining, 9.3, 9.3
deleting, 9.3
limiting, 9.3
multidimensional, 9.3
null, 6.3
number of values in, 8
retrieving values, 8, 8, 8, 8
retrieving values from, 8
setting the status of, 10
sorting values, 8, 10
VARCACHE option, 6.3
VARIABLE command, 10
variables
acquired, 7.3
Aggcount, 7.3, 8, 9.3, 9.3, 9.3, 9.3
assigning values to, 10
defining, 9.3, 9.3
defining with composite, 9.3
deleting, 9.3
how data is stored, 9.3
identifying changes, 7.3, 7.3
limiting to single value, 2.3.2.5.2, 2.3.2.5.2, 2.3.2.5.3
local to a program, 10
partitioned, 9.3, 9.3, 9.3
populating, 8
QDR with, 2.3.2.5.2, 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
session cache, 8
storage of, 9.3
version of Oracle OLAP, 7.3
views
creating embedded total dimensions, A.2.2
creating embedded total measures, A.2.2
creating rollup form, A.2.2
template for creating with OLAP_TABLE, A.1.2.1
VINTSCHED function, 8
VNF
See value name format
VNF command, 2.1.3.2, 10
VPMTSCHED function, 8

W

WEEKDAYSNEWYEAR option, 6.3
WEEKOF function, 8
WHILE command, 9.3, 10
used with BREAK, 9.3
used with CONTINUE, 9.3
WIDTH_BUCKET function, 8
wildcards, 2.3.8.6.1, 2.3.8.6.1
WKSDATA function, 8
worksheet objects
cells, 8
data type of cells, 8
defining, 9.3, 9.3, 9.3
deleting, 9.3
dimensions, 9.3
See also spreadsheets
workspaces See analytic workspaces
WRAPERRORS option, 6.3

Y

YESSPELL option, 6.3
YMINTERVAL data type, 2.1.4.8
YMINTERVAL function, 8
YRABSTART option, 6.3
YYOF function, 8

Z

zero, 6.3
dividing by, 2.3.4.4, 6.3
spelling of, 6.3
suppressing all-zero report rows, 6.3
ZEROROW option, 6.3
ZEROTOTAL command, 10
ZSPELL option, 6.3