$AGGMAP |
The $AGGMAP property specifies the default AGGMAP type aggmap for a variable. This is the aggmap that Oracle OLAP uses when the variable is the target of an AGGREGATE command or AGGREGATE function that does not include a USING phrase.
When calculating the data in a variable, Oracle OLAP checks to see if the variable has an $AGGMAP property and, if it does, uses the aggmap object specified by that property as the default aggregation specification for a variable.
Syntax
You add or delete an $AGGMAP property to the most recently defined or considered object (see DEFINE and CONSIDER) using a PROPERTY statement:
To add the property, issue the following statement.
PROPERTY '$AGGMAP' agggmap-name
To delete the property, issue the following statement.
PROPERTY DELETE '$AGGMAP'
Arguments
A TEXT expression that is the name of a previously defined aggmap object.
Examples
Using the $AGGMAP Property
Example: Using the $AGGREGATE_FROM Property illustrates how the AGGREGATE command shown in Example: Using a CACHE Statement in an Aggregation Specification can be simplified to the following statement.
AGGREGATE sales_by_revenue USING revenue_aggmap
You can further simplify the AGGREGATE command if you place an $AGGMAP property on the sales_by_revenue variable. To define an $AGGMAP property on the sales_by_revenue variable, issue the following statements.
CONSIDER sales_by_revenue
PROPERTY ('$AGGMAP' 'revenue_aggmap')
Now you can aggregate the data by issuing the following AGGREGATE command that does not include a USING clause.
AGGREGATE sales_by_revenue