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


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.


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


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}




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


Deletes the $AGGMAP property.


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