$AGGREGATE_FROMVAR

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.

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 $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}

where

addproperty has the following syntax.

'$AGGREGATE_FROMVAR' textvar ACROSSdimname
deleteproperty has the following syntax.

DELETE '$AGGREGATE_FROMVAR'

Arguments

textvar: 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.
DELETE $AGGREGATE_FROMVAR: Deletes the $AGGREGATE_FROMVAR property.

Examples

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