Aggregation Options


A number of options can impact aggregation as outlined in Table: Aggregation Options.

Aggregation Options

Option Description
MULTIPATHHIER
An option that specifies that a given cell that contains detail data can have more than one path into a cell that contains aggregated data.
POUTFILEUNIT
An option that identifies a destination for status information about an aggregation operation.
SESSCACHE
An option that controls whether Oracle OLAP uses the session cache to store variable data that has been aggregated on the fly.
VARCACHE
An option that specifies if and where variable data that has been aggregated on the fly should be stored. (The VARCACHE option is only one factor that can determine this decision.)