PRECOMPUTE

Within an aggregation specification, a PRECOMPUTE statement specifies which of the variable's aggregate values will be precomputed as a data maintenance procedure using the AGGREGATE command.

Note:

An aggregation specification that has a PRECOMPUTE statement cannot have any PRECOMPUTE clauses in its RELATION (for aggregation) statements.

Syntax

PRECOMPUTE precompute-phrase

where:

precompute-phrase is one of the following:

n% | AUTO

ALL

NA | NONE

Arguments

n%: Specifies an explicit percentage of the aggregate variable values that will be aggregated as a database maintenance procedure using an AGGREGATE command. Oracle OLAP uses special functionality called the Aggregate Advisor to determine exactly which values are in the percentage.
AUTO: Specifies that Oracle OLAP uses the he Aggregate Advisor to determine how many and which aggregate variable values to aggregate as a database maintenance procedure using an AGGREGATE command.
ALL: Specifies that all aggregated data will be precomputed using an AGGREGATE command.
NA
NONE: Specifies that all values should be calculated on the fly using the AGGREGATE function (that is, that no data should be precalculated with the AGGREGATE command).