Skip Headers

Oracle9i OLAP Developer's Guide to the OLAP DML
Release 2 (9.2)

Part Number A95298-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

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


Symbols

% wildcard, 4-28
& operator, 4-30, 4-31
= command
ACROSS keyword, 5-12
example of, 5-12, 5-13
introduced, 4-3, 5-3, 5-10
saving calculations, 5-12
with composites, 5-12
with dimensions, 5-14
with models, 8-5
with QDR, 4-8, 5-14
with relations, 5-14
with variables, 5-11, 5-12
with variables using composites, 5-12, 5-13
= operator, See = command
_ wildcard, 4-28

A

ABS function, 4-24, 4-25
ACROSS phrase
used when reading files, 11-17
AGGINDEX command
definition, 12-9
purpose of, 12-9
AGGMAP command, 3-27, 12-7
aggmap object, See aggregation map
AGGMAPINFO command, 9-4
AGGREGATE command
introduced, 12-4
multiple variables, 12-11
AGGREGATE function
adding as a property to the variable, 12-23
introduced, 12-4
aggregating data
best practice, 12-24
for multiple variables, 12-11
list of commands, 12-3
methods, 12-14
on-the-fly, 12-2
overview, 12-2
precomputing, 12-2
process, 12-4
aggregation functions, NA values in, 4-33
aggregation map
commands for allocation, 9-5
compiling, 12-10
creating aggmap object, 12-7
for allocation, 9-5
how to define, 12-7
performance tip, 12-12
RELATION command, 9-6, 12-12
alias
analytic workspace, 2-8
directory, 11-4
ALLOCATE command, 9-2, 9-4
allocating data
introduction to, 9-2
list of related commands, 9-4
preparing for, 9-5
ALLOCERRLOGFORMAT command, 9-4
ALLOCERRLOGHEADER command, 9-4
ALLOCMAP command, 3-27, 9-4, 9-5
ampersand (&) operator, 4-30, 4-31
ampersand substitution
avoiding, 4-31
defined, 4-30
effect performance, 7-9
example of, 4-31
prevents compiling, 7-29
program arguments and, 7-9
QDR with, 4-10
restrictions, 8-6
using to pass arguments, 7-9
when required, 7-9
analytic workspaces
access from Java, 1-10
access from OLAP Worksheet, 1-6
access from SQL, 1-9
acquiring description of, 2-15
active workspace, 2-2
alias, 2-8
attached read-only or read/write, 2-4
attached workspace, 2-2
attaching, 2-3
committing changes, 2-9
controlling access to, 2-12
copying data into relational tables, 10-28 to  10-32
creating, 2-3
current workspace, 2-2
deleting, 2-5
detaching, 2-5
exporting, 2-14
importing, 2-14
introduction to, 1-2
list of attached, 2-2
minimizing growth of, 2-10
multiple, 2-6
name, 2-7
objects, acquiring information about, 2-15, 2-16, 2-17
objects, defining, 3-2
objects, defining in a program, 7-29
permission programs, 2-12, 2-13
populating, 5-1
populating from relational tables, 10-3 to  10-20
reorganizing, 2-10
retrieving name of, 2-2
saving changes to, 2-8
security, 2-12
sharing across sessions, 2-4
updating, 2-9
waiting for access, 2-5
AND operator, 4-21, 4-22
ARG function, 7-7
ARGFR function, 7-7
ARGS function, 7-7
ARGUMENT command
placement of, 7-7
use of, 7-7
using multiple, 7-8
arguments
in programs, 7-7
in user-defined functions, 7-12
passing as text, 7-9
using ampersand substitution with, 7-9
arithmetic expressions. See arithmetic operators, numeric expressions
arithmetic operators, 4-16
assignment operator. See = command
assignment statement. See = command
AUTOGO programs, 2-11
AW command, 2-5
ATTACH keyword, 2-3
CREATE keyword, 2-3
DETACH keyword, 2-5
LIST keyword, 2-2
NAME keyword, 2-2
WAIT keyword, 2-5
AW function, 2-15
AWDESCRIBE program, 2-15

B

backslash (escape sequence), 3-6
backspace (escape sequence), 3-6
BADLINE option, 7-30
base model, 8-4
batch window for aggregation, 12-2
Boolean
constants, 3-7, 4-21
data type, 3-7, 4-21
Boolean expressions
creating, 4-22
defined, 4-21
example of, 4-23
involving NA values, 4-24
operators, 4-21
values, 4-21
with more than one dimension, 6-6
Boolean operators
evaluation order, 4-21
table of, 4-21
branching in programs, 7-17
BTREE indexes in aggregation, 12-4, 12-6

C

CACHE command
definition, 12-9
purpose of, 12-9
calculation on-the-fly
a typical strategy, 12-25
requirements for, 12-22
calculations
controlling errors during, 4-19
in models, 8-6
CALL command, 7-2
carriage return (escape sequence), 3-6
CDA command, 2-14, 7-17, 11-4
cells, empty, 3-18
characters
representing as decimals, 3-6
representing as hexadecimals, 3-6
representing as Unicode, 3-6
CHGDFN command
aggregation, 12-6
for variables, 3-28
CHILDLOCK command, 9-6
CLEANUP statement (SQL), 10-14
CLOSE statement (SQL), 10-13, 10-14
comments in programs, 7-4
COMMIT command, 2-9
comparison operators, 4-21
COMPILE command
example of, 7-28
in models, 8-5, 8-7
introduction to, 7-28
composites
assigning names to unnamed, 3-20
defined, 3-18
defining single-dimension, 3-22
in expressions, 4-13
limiting base dimensions, 6-18
limiting dimensions used by, 4-14, 6-18
maintaining, 5-9
named, 3-18
naming, 3-20
renaming, 3-20
single-dimension, 3-22
unnamed, 3-18, 3-21
unnaming, 3-20
using commands with, 4-14
concat dimensions, 3-8
defined, 3-25
defining variables for, 3-26
example of, 3-26
limiting, 6-20
maintaining, 5-10
self-relations for, 3-26
conditional expressions, 4-29, 4-30
conditional operators
defined, 4-29
example of, 4-30
conjoint dimensions
deleting values from, 5-8
limiting, 6-19
maintaining, 5-9
maintaining when reading files, 11-10
merging values into, 5-6
CONSIDER command, 3-27
CONTEXT
command, 7-22
function, 7-22
control structures in programs, 7-14
controlled sparsity, 3-18
CONVERT function, 4-3
COPY operator for allocation, 9-10
current analytic workspace, defined, 2-2
current outfile, 7-18
current status, 6-2
cursors (SQL)
closing, 10-13, 10-14
declaring, 10-5
opening, 10-8

D

data aggregation
best practice, 12-24
creating the aggregation map, 12-7
for multiple variables, 12-11
data types
converting, 4-3, 4-17
date, 3-7
numeric, 3-4
of expressions, 4-2
of numeric expressions, 4-15, 4-17
of user-defined function, 7-12
text, 3-5
data values
accessing variable, 4-13
converting when reading files, 11-10
numeric, 4-15
saving calculations, 5-12
DATE data type, 3-7
dates
comparing with times, 4-27
in arithmetic expressions, 4-18
in text expressions, 4-20
reading from files, 11-15
DATETIME data type, 3-7, 4-20
DBGOUTFILE command, 7-31, 8-11
DEADLOCK command, 9-6
debugging programs, 7-29
DECIMAL data type, 3-4, 4-25
decimal data types, comparing, 4-25
DECIMALOVERFLOW option, 4-20
DECIMALS option, 4-24, 4-25
DECLARE CURSOR statement (SQL), 10-5
default outfile, 7-18
DEFINE command, 3-2
AGGMAP, 12-7
COMPOSITE keyword, 3-18, 3-19
DIMENSION keyword, 3-22, 3-25
MODEL keyword, 8-5
PROGRAM keyword, 7-3
RELATION keyword, 3-13
SPARSE keyword, 3-18
SURROGATE keyword, 3-11
VALUESET keyword, 6-22
VARIABLE keyword, 3-18
definitions
changing, 3-27
displaying, 2-15, 2-16
distinct from data, 3-2
DELETE keyword, 2-5
DESCRIBE command, 2-16
DIMENSION command, 8-5, 8-6, 9-6
dimension order in models, 8-6
dimension status, 6-2
effect of MAINTAIN command on, 5-4
effect on expressions, 4-6
examining, 6-25
if dimension is empty, 6-21
if valueset is empty, 6-21
null, 6-21
of concat dimension, 6-20
of conjoint dimension, 6-19
of dimensions used by composites, 4-14, 6-18
restoring, 6-4, 6-22, 7-20
retrieving current values, 6-25
retrieving default values, 6-25
saving, 6-22
saving current status, 6-4, 7-20
setting to a list of values, 6-4
setting to a literal value, 6-5
setting to null, 6-21
setting using position in dimension, 6-12, 6-13
when reading files, 11-20
dimension surrogates
defining, 3-11
differences from dimensions, 3-12
in expressions, 4-12
dimension values
comparing, 4-26
translating when reading files, 11-11
dimension-based equations, 8-2
dimensions
adding values to, 5-5
assigning values to, 5-14
comparing values, 4-26
concat, 3-8, 3-25
defined, 3-8
defining, 3-22, 3-23, 3-25
defining in a program, 7-29
deleting values from, 5-7
examining values in status, 6-25
hierarchical, 3-22, 3-23
how data is stored, 3-10
in expressions, 4-12
level of detail, 3-9
limiting to a percentage of values, 6-9
limiting to Boolean expressions, 6-5
limiting to bottom performers, 6-10
limiting to related dimension, 6-11
limiting to single value, 4-6
limiting to top performers, 6-10
limiting when reading files, 11-20
limiting, based on position, 6-12, 6-13
limiting, using a valueset, 6-23
limiting, using hierarchical relationship, 6-13, 6-16
looping over values of, 7-15, 7-16
maintaining when reading files, 11-7
merging values into, 5-5
numeric value of text dimension, 4-18
of expression, 4-5, 4-6
of relations, 3-13
position of values in valueset, 6-25
QDR with, 4-6, 4-10
relations between, 3-15
repositioning values in, 5-8, 5-9
restoring previous values, 7-20
retrieving default status list, 6-25
retrieving list of objects related to, 2-16
running programs when limiting, 6-16
saving current values, 7-20
sorting values in, 5-8
storage of, 3-10
surrogate for, 3-11
types of, 3-8
ways to define, 3-22, 3-25
direct allocation, 9-8, 9-13
directory alias, 2-14, 7-17, 11-4
DIVIDEBYZERO option, 4-19
DML
and SQL, 1-3
and the OLAP API, 1-3
definition, 1-2
using, 1-3
double quotes (escape sequence), 3-6

E

ECHOPROMPT option, 7-19, 7-31
EIF file, 2-14
embedded totals dimension, 3-24, 3-26
empty cells, 3-18
EQ command, 3-28
EQ operator, 4-21, 4-22
equations
cyclic dependence (in models), 8-9
dimension-based, 8-2
in models, 8-6
simple blocks, 8-8
step blocks, 8-8
error log, 9-5, 9-17
error messages
creating your own, 7-25
deferring, 7-23
routing to a file, 7-19, 9-17
suppressing, 7-24
system, 7-24
error names, 7-24
ERRORLOG command, 9-6
ERRORMASK command, 9-6
ERRORNAME option, 7-23, 7-24
errors
controlling during calculations, 4-19
handling, 7-23
handling in nested programs, 7-26, 7-27
identifying, 7-24
names of, 7-24
signaling, 7-25, 7-26, 7-27
when comparing numeric data, 4-24, 4-25
ERRORTEXT option, 7-23
escape sequences, 3-6
EVEN operator for allocation, 9-2
EXECUTE statement (SQL), 10-28
EXPORT command, 2-14
expressions
ampersand substitution, 4-30, 4-31
Boolean, 4-21, 4-29, 4-30, 6-5, 6-6
changing the default behavior, 5-12
conditional, 4-29, 4-30
data type of, 4-2
dates in, 4-18
defined, 4-2
dimension surrogates in, 4-12
dimensions in, 4-12
dimensions of, 4-5, 4-6
evaluating, default behavior, 5-12
formulas in, 4-12
functions in, 4-12
mixing numeric data types, 4-17
numeric, 4-15
objects in, 4-12
relations in, 4-12, 4-15
substitution, 4-30, 4-31
text, 4-20
using composites in, 4-13
using text dimension in numeric expression, 4-18
valuesets in, 4-12
variables in, 4-12

F

fastest-varying dimension, 3-17
FETCH statement (SQL), 10-9
file identifier, 11-4
file names, 11-4
FILENEXT function, 11-15
FILEOPEN function, 11-4
FILEREAD command, 5-3
files
appending output, 7-18
fileunit, 11-4
maintaining dimensions from, 11-7, 11-10
modifying data from, 11-14
names and identifiers, 11-4
reading, 11-1
reading coded dimension values, 11-12
reading in programs, 11-5
reading individual records, 11-15
reading structured PRN, 11-6
reading with FILENEXT function, 11-15
saving output in, 7-17, 7-18
scaling input data from, 11-13
fileunit, 11-4
FILEVIEW command, 11-15
financial analysis, scenario modeling, 8-12
floating point numbers, comparing, 4-25
floating-point format
limitations when calculating, 4-18
use of, 4-18
FOR command
example of, 7-16
looping over dimension values, 7-15, 7-16
forecasting data, 5-15
form feed (escape sequence), 3-6
formulas in expressions, 4-12
functions
defined, 4-15
in expressions, 4-12
numeric, 5-16
user-defined, 7-3, 7-11, 7-12
writing, 7-11

G

GE operator, 4-21, 4-22
globalization, 2-6
GT operator, 4-21, 4-22

H

HASH indexes in aggregation, 12-6
HEVEN operator for allocation, 9-8
HFIRST operator for allocation, 9-13
hierarchical dimensions
defined, 3-22
defining variables for, 3-24
drilling down, 6-16
example of, 3-23, 3-24
limiting based on relationship within, 6-13, 6-16
self-relations for, 3-24
HLAST operator for allocation, 9-13
horizontal tab (escape sequence), 3-6
host variables (SQL)
input, 10-6
output, 10-9

I

ID data type, 3-5
IFNONE keyword, 7-17
implicit relations, 3-13
IMPORT command, 2-14, 5-3
IMPORT statement (SQL), 10-9
IN operator, 4-21, 4-22
INCLUDE command, 8-4, 8-5, 8-6
INFO function
determining dimensionality with, 4-5
DIMENSION keyword, 4-6
with models, 8-11
input host variables (SQL), 10-6
INSTAT function, 6-3, 6-25
INTEGER data type, 3-4

L

labels
in programs, 7-24
with IFNONE, 7-17
LAG function, 4-18, 8-10
LD command, 3-28
LE operator, 4-21, 4-22
LEAD function, 4-18, 8-10
level relation, defined, 12-4
LIKE operator, 4-21, 4-22, 4-28
LIMIT command
DESCENDANT keyword, 6-14
examples of, 6-5, 6-9, 6-10, 6-11, 6-16, 6-23
HIERARCHY keyword, 6-13, 6-14
NOCONVERT keyword, 6-13
NULL keyword, 6-21
overview, 6-4
POSLIST keyword, 6-12
relation dimension, 6-11
RUN keyword, 6-16
with Boolean expression, 6-5, 6-6
with concat dimension, 6-20
with conjoint dimension, 6-19
with variables with composite, 4-14, 6-18
linefeed (escape sequence), 3-6
LISTNAMES program, 2-16
literals
numeric, 3-4
text, 4-20
local variables, 7-5
localization, 2-6
locking values in an allocation, 9-12, 9-15
logical operators, 4-21
LONGINTEGER data type, 3-4
LT operator, 4-21, 4-22

M

MAINTAIN command
adding values using, 5-5
deleting values using, 5-7, 5-8
effect on dimension status, 5-4
introduced, 5-3
merging values using, 5-5, 5-6
overview of, 5-3
repositioning values using, 5-8
when objects are updated, 5-4
with composites, 5-9
with concat dimensions, 5-10
with conjoint dimensions, 5-9
MAX operator for allocation, 9-8
MODEL command, 3-28, 8-5
MODEL.COMPRPT program, 8-11
MODEL.DEPRPT program, 8-11
models
base, 8-4
basic commands, 8-5
compiling, 8-3, 8-7
creating, 8-2
creating a nested hierarchy, 8-4
debugging, 8-11
defined, 8-2
editing, 8-2
parent, 8-4
running, 8-3, 8-9
scenario, 8-12
solution variables, 8-2
types of solution blocks, 8-8
MODEL.XEQRPT program, 8-11
MODTRACE option, 8-11
multidimensional data model, 3-16
multiple analytic workspaces, 2-6

N

NA values, 3-18
comparing, 4-24
controlling how treated, 4-32
defined, 4-32
in aggregation functions, 4-33
in an allocation, 9-6, 9-7
in arithmetic operations, 4-34
in Boolean expression, 4-24
substituting another value for, 4-34
times when relevant, 4-32
NAFILL function, 4-32, 4-34
NAME dimension, 2-16
named composites, defined, 3-18
NASKIP option, 4-32, 4-33
NASKIP2 option, 4-32, 4-34
NASPELL option, 7-7
NE operator, 4-21, 4-22
NLS options, 2-6
NOL_SORT option, 4-27
NOPRINT keyword (TRAP), 7-24, 7-27
NOSPELL option, 3-7
NOT operator, 4-21, 4-22
NTEXT data type, 3-5
NUMBER data type, 3-5
NUMBER dimension, surrogate for, 3-11
numeric data types
automatic conversion of, 4-17
comparing, 4-24, 4-25
list of, 3-4
mixing, 4-17
numeric expressions
data type of the result, 4-15, 4-17
dates in, 4-18
defined, 4-15
evaluating, 4-16
mixing data types in, 4-17
NA values in, 4-34

O

OBJ function
PROPERTY keyword, 12-5
workspace object information, 2-17
objects
assigning values to, 4-3, 5-10
changing definition of, 3-27
definitions, 3-2
displaying definitions of, 2-16
in expressions, 4-12
list of, 3-3
maintaining, 5-4
retrieving information about, 2-17
retrieving list of, 2-16
updating, 5-4
OKNULLSTATUS option, 6-21, 7-17
OLAP Worksheet, 1-6
OPEN statement (SQL), 10-8
operators
arithmetic, 4-16
Boolean, 4-21
comparison, 4-21
conditional, 4-29, 4-30
for allocation, 9-7
logical, 4-21
substitution, 4-30, 4-31
options
restoring previous values, 7-20
saving current values, 7-20
OR operator, 4-21, 4-22
OUTFILE command, 7-17, 7-18
OUTFILEUNIT option, 12-21
output
host variables, 10-9
saving in a file, 7-17, 7-18

P

parent model, defined, 8-4
parent relation, defined, 12-4
PARSE command, 4-5, 4-6
pattern matching, 4-28
permission programs, 2-12
PERMIT command, 2-13, 3-28
PERMIT_READ program, 2-12, 2-13
PERMIT_WRITE program, 2-12, 2-13
POP command, 7-20, 7-21
POPLEVEL command
nesting, 7-22
using, 7-21
populating analytic workspaces, 5-1
POUTFILEUNIT option, 9-4, 12-4, 12-21
PREPARE statement (SQL), 10-28
PRGERR keyword (SIGNAL), 7-26
PRGTRACE option, 7-31
PRN files, reading, 11-6
PROGRAM command, 3-28
programs
analytic workspace permission, 2-13
arguments, 7-7
AUTOGO, 2-11
automatic running of, 2-11, 6-16
branching in, 7-17
branching labels, 7-14
comment lines in, 7-4
compiling, 7-9, 7-28
control structures, 7-14
debugging, 7-29
declaring arguments in, 7-7, 7-8
defined, 7-2
defining, 7-3
designing, 7-5, 7-14
errors in, 7-23
executing, 7-2
LISTNAMES, 2-16
permission, 2-12
PERMIT_READ, 2-12, 2-13
PERMIT_WRITE, 2-12, 2-13
preserving environment, 7-19
restoring previous values, 7-20
running, 7-29
sample, 7-12
saving compiled code, 7-28
saving current values, 7-20
testing by running, 7-29
variables in, 7-4, 7-5
PROPERTY command, 3-28
PROPORTIONAL operator for allocation, 9-15
protecting values in an allocation, 9-12, 9-15
PUSH command, 7-21
placement, 7-23
using, 7-20
PUSHLEVEL command
nesting, 7-22
placement, 7-23

Q

QON, 2-6
QUAL function, 4-10
qualified data references
ampersand substitution, 4-10
creating, 4-6
defined, 4-6
qualifying a relation, 4-9
replacing dimension of variable, 4-7, 4-8
using with = command, 4-8, 5-14
using with relation, 4-9
with dimensions, 4-6
with relations, 4-9
with variables, 4-7, 4-8
qualified object names, 2-6
quotation marks (escape sequence), 3-6

R

random sparsity, 3-18
RAW DATE attribute
when reading files, 11-15
records, reading, 11-15
recursive allocation, 9-10, 9-15
RELATION command, 12-7
arguments for allocation, 9-7
for allocation, 9-6
operators for allocation, 9-7
syntax for aggregation, 12-12
relational data, 10-1
See also SQL
copying into analytic workspace, 10-3 to  10-20
inserting from analytic workspace, 10-28 to  10-32
updating from analytic workspace, 10-28 to  10-32
relations
assigning values to, 5-14
between two dimensions, 3-15
comparing to text literals, 4-29
defined, 3-13
defining, 3-15
dimensionality of, 3-13
example of, 3-15, 3-24, 3-26
how data is stored, 3-14
implicit, 3-13
in aggregation, 12-4
in allocation, 9-5, 9-6, 9-9
in expressions, 4-12, 4-15
limiting to single value, 4-9
QDR with, 4-9
replacing dimension of, 4-9
self, 3-15, 3-24, 3-26
used when reading files, 11-13
REMOPERATOR in an allocation, 9-9
REPORT command
for viewing objects, 2-17
with sparse data, 4-14
RETURN command, 7-11
ROLLBACK, effect on changes, 2-10
ROOTOFNEGATIVE option, 4-20
ROUND function, 4-24, 4-25
run-time aggregation, 12-2

S

scenario model, defined, 8-12
scenarios for financial modeling, 8-12
sessions
preserving environment, 7-19
restoring environment, 7-20
sharing analytic workspaces across, 2-4
SHORTDECIMAL data type, 4-25
SHORTINTEGER data type, 3-4
SIGNAL command, 7-25
simple blocks (in models), 8-8
simultaneous equations in models, 8-10
single quotes (escape sequence), 3-6
slowest-varying dimension, 3-17
solution variables
defined, 8-2
example of, 8-12
source object for allocation, 9-5
SOURCEVAL command, 9-6
sparse data, 3-18
controlled sparsity, 3-18
defined, 3-18, 4-32
eliminating, 3-18 to  3-21
random sparsity, 3-18
setting dimension status, 6-18
SQL, 10-1
See also relational data
error handling, 10-34
OLAP DML command, introduced, 5-3
precompiling code, 10-28
stored procedures, 10-32
triggers, 10-32
SQL statements
issuing through OLAP DML, 10-2 to  10-33
STATFIRST function, 6-3, 6-25
STATLAST function, 6-3, 6-25
status. See dimension status
step blocks (in models), 8-8
storage
of dimensions, 3-10
of relations, 3-14
of variables, 3-17
stored procedures, 7-2
structured files, reading, 11-6
substitution expressions, 4-30, 4-31
substitution operator, 4-30, 4-31
surrogates. See dimension surrogates
SYSINFO function, 2-13

T

tab (escape sequence), 3-6
temporary variables, 7-5, 11-20
text
comparing values, 4-27, 4-28
comparing values to a pattern, 4-28
data types, 3-5
NLS_SORT option in comparisons, 4-27
passing arguments as, 7-9
TEXT data type, 3-5
text expressions
dates in, 4-20
defined, 4-20
text literals
comparing to relations, 4-29
defined, 4-20
TRAP command, 7-23, 7-26, 7-27

U

unnamed composites, 3-18, 3-21
defining, 3-21
example of, 3-21
naming, 3-20
UPDATE command, 2-9
user-defined functions, 7-11
arguments in, 7-12
data type of, 7-12
defined, 7-2
executing, 7-3

V

VALUE keyword
used in reading files, 11-12
used when reading files, 11-14
values
assigning to dimensions, 5-14
assigning to objects, 5-10
assigning to relations, 5-14
assigning to variables, 5-12
assigning to variables with composites, 5-12, 5-13
assigning, using a QDR, 5-14
in current status list, 6-25
in default status list, 6-25
NA, 3-18
restoring previous, 7-20
saving current, 7-20
VALUES function, 6-3, 6-25
valuesets
creating, 6-22
defined, 6-22
defining, 6-22
in expressions, 4-12
limiting using, 6-23
listing dimension positions in, 6-25
VARIABLE command, 7-6
variables
accessing, 4-13
aggregating data for multiple, 12-11
assigning values to, 5-11, 5-12, 5-13, 5-14
controlling sparsity in, 3-18
defined, 3-16
defining in a program, 7-29
defining with composite, 3-18 to  3-21
defining with unnamed composite, 3-21
dimensioned, 3-17
how data is stored, 3-17
in expressions, 4-12
limiting to single value, 4-7, 4-8
local, 7-5
NA values in, 3-18
persistence of, 7-4, 7-5
QDR with, 4-7, 4-8
replacing dimension of, 4-7, 4-8
sparse data in, 4-14
storage of, 3-17
temporary, 7-5
undimensioned, 3-17
with embedded totals, 3-24, 3-26
with NA values, 3-18
with single-dimension composite, 3-22

W

WHERE clauses (SQL), 10-7
wildcards, 4-28

Y

YESSPELL option, 3-7

Z

zero, dividing by, 4-19

Go to previous page
Oracle
Copyright © 2001, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback