|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
The $AGGREGATE_FROMVAR property specifies the same behavior as that specified by a FROMVAR clause in an AGGREGATE command or an AGGREGATE function. By adding an $AGGREGATE_FROMVAR property to a variable you can ensure this behavior when the variable is aggregated — even when it is aggregated by an AGGREGATE statement does not include the FROMVAR clause.
Both the $AGGREGATE_FROMVAR property and the FROMVAR clause specify two or more objects from which Oracle OLAP obtains the detail data for the aggregation.
To add the property, issue the following statement.
PROPERTY '$AGGREGATE_FROMVAR' textvar ACROSS dimname
To delete the property, issue the following statement.
PROPERTY DELETE '$AGGREGATE_FROMVAR'
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.
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.
Example 9-31, "Capstone Aggregation" uses the following AGGREGATE command to perform the final capstone aggregation.
AGGREGATE sales_capstone76 USING capstone_aggmap FROMVAR capstone_source
As the following statements illustrate, you can omit the FROMVAR clause if you create the appropriate FROMVAR property on
CONSIDER sales_capstone76 PROPERTY '$AGGREGATE_FROMVAR' 'capstone_source' AGGREGATE sales_capstone76 USING capstone_aggmap