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_FROMVAR property specifies two or more objects 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_FROMVAR property and, if it does, obtains the detail data for the aggregation from the variables 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 $AGGGREGATE_FROMVAR 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 or formula that specifies the names of the objects from which to obtain detail data when performing a capstone aggregation. Specify NA to indicate that a node does not need detail data to calculate the value.

ACROSS dimname

Specifies the dimension or a named composite that the aggregation loops over to discover the cells in the objects specified by textvar. Because the objects specified by textvar can be formulas, you can realize a significant performance advantage by supplying a looping dimension that eliminates the sparsity.


Deletes the $AGGREGATE_FROMVAR property.


Example 6-3 Capstone Aggregation Using the $AGGREGATE_FROMVAR Property

Example 7-7, "Capstone Aggregation" uses the following AGGREGATE command to perform the final capstone aggregation.

AGGREGATE sales_capstone76 USING capstone_aggmap FROMVAR capstone_source

You can omit the FROMVAR clause in the second AGGREGATE command if there is a $AGGREGATE_FROMVAR property on the sales_capstone76 variable.

To create a $FROMVAR property, issue the following OLAP DML statements.

CONSIDER sales_capstone76
PROPERTY ('$AGGREGATE_FROMVAR'  'capstone_source')

Now you can perform the final capstone aggregation by issuing the following statement.

AGGREGATE sales_capstone76 USING capstone_aggmap