Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


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.


"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.


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}




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.


Deletes the $AGGREGATE_FROM property.


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