Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
For a given variable and aggmap object, the CHANGEDRELATIONS function determines if there are any changes in the aggmap and the relations in the aggmap since the last time the variable was aggregated.
BOOLEAN.
TRUE
when changes have occurred, FALSE
when they have not, or NA
when the function cannot determine if changes have occurred.
CHANGEDRELATIONS( variable [ [(PARTITION partition [,PARTITION partition]...) ] aggmap] )
The name of the variable whose aggmap object you want to check for changes.
The name of one or more partitions of variable, separated by commas, whose aggmap you want to check for changes.
The name of the aggmap object you want to check for changes. When you do not specify a value for aggmap, the function uses the aggmap specified in the $AGGMAP property for variable, if any.