---

$AGGMAP

The $AGGMAP property specifies the default AGGMAP type aggmap for a variable. 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.

Tip: You can also use a AGGMAP SET statement to specify the default aggregation specification for a variable or the $ALLOCMAP property to specify the default allocation specification for a variable.

See: The PROPERTY command for general information on using properties in the OLAP DML.

Syntax

You add or delete an $AGGMAP 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.

  '$AGGMAP' agggmap-name

• deleteproperty has the following syntax.

  DELETE '$AGGMAP'

Arguments

aggmap-name

A TEXT expression that is the name of a previously defined aggmap object.

DELETE '$AGGMAP'

Deletes the $AGGMAP property.

Examples

Example 6-1 Using the $AGGMAP Property

Example 6-2, "Using the $AGGREGATE_FROM Property" illustrates how the AGGREGATE command shown in Example 6-22, "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