$AGGREGATE

$AGGREGATE_FROM

The $AGGREGATE_FROM property specifies the name of an object from which to obtain detail data when aggregating data. When aggregating the data in a variable, Oracle OLAP checks to see if the variable has an $AGGREGATE_FROM property and, if it does, obtains the detail data for the aggregation from the variable specified by that property.

See:

"Ways of Specifying Where to Obtain Detail Data for Aggregation " for a discussion of all of the ways in which you can specify the variables from which detail data should be obtained when performing aggregation.

The PROPERTY command for general information on using properties in the OLAP DML.

Syntax

You add or delete an $AGGREGATE_FROM property to the most recently defined or considered object (see DEFINE PROGRAM and CONSIDER) using a PROPERTY statement with the following syntax.

PROPERTY {addproperty | deleteproperty}

where

addproperty has the following syntax.

'$AGGREGATE_FROM' fromspec ACROSSdimname
deleteproperty has the following syntax.

DELETE '$AGGREGATE_FROM'

Arguments

fromspec: A TEXT expression that specifies an arbitrarily dimensioned variable, formula, or relation from which the detail data for the aggregation is obtained.
ACROSS dimname: Specifies the dimension or a named composite that the aggregation loops over to discover the cells in fromspec. Because fromspec can be a formula, you can realize a significant performance advantage by supplying a looping dimension that eliminates the sparsity from the fromspec loop.
DELETE '$AGGREGATE_FROM': Deletes the $AGGREGATE_FROM property.

Examples

Example 6-2 Using the $AGGREGATE_FROM Property

Example 6-22, "Using a CACHE Statement in an Aggregation Specification" uses the following AGGREGATE command to aggregate the data.

AGGREGATE sales_by_revenue USING revenue_aggmap FROM units_aggmap

You can place a $AGGREGATE_FROM property on the sales_by_revenue variable by issuing the following statements.

CONSIDER sales_by_revenue
PROPERTY ('$AGGREGATE_FROM' 'units_aggmap')

Now you can aggregate the data by issuing the following AGGREGATE command that does not include a FROM clause.

AGGREGATE sales_by_revenue USING revenue_aggmap