PARTITIONCHECK
The PARTITIONCHECK function identifies whether an aggmap object is compatible with the partitioning specified by a partition template object.
Aggregation can cross partitions; however, the data flow must always be in one direction. The data cannot go both in and out of the same partition; this processing causes Oracle OLAP to produce an error during the aggregation.
Return Value
BOOLEAN.
YES when Oracle OLAP would not issue an error when aggregating a variable partitioned using the specified partition template using the specified aggmap; or NO when an error would occur.
Syntax
PARITITONCHECK (aggmap parttition-template)
Parameters
- aggmap
-
A text expression that is the name of an aggmap object.
- partition-template
-
A text expression that is the name of the partition template object to check for compatibility with aggregation.
