Database Reference
In-Depth Information
Figure 11.20
SPREADSHEET
Clause Syntax.
11.5.1
SPREADSHEET (MODEL) Clause Syntax
Refer to Oracle documentation for more specific details, particularly with
respect to cell measures. Figure 11.20 shows a brief picture of SPREAD-
SHEET clause syntax. That's brief?
The PARTITION BY clause effectively creates multiple arrays. The
DIMENSION BY clause is a subset of partitions in that it creates identify-
ing columns for each row within each of multiple partitions. The MEA-
SURE clause defines the cells in the rows (dimensions) within each array
(partitions). Some examples will explain more shortly. Now let's look at
some SPREADSHEET clause-specific functions.
11.5.2
SPREADSHEET (MODEL) Clause Functions
The SPREADSHEET clause is new to Oracle Database 10
g
. There are sev-
eral SPREADSHEET clause-specific functions also introduced in Oracle
Database 10
g
. These new functions apply to interrow calculations and only
as part of SPREADSHEET clause rules.
CURRENTV
2
(dimension)
. Returns a dimensional value or current
value.
PRESENTNNV(cell, expression, expression)
. Returns one expres-
sion if a value exists, otherwise another.
PRESENTV(cell, expression, expression)
. As for PRESENTNNV,
but allowing null values.
