Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
Specifies the default aggmap for a variable.
Note:
You can also use an $AGGMAP property to specify the default aggregation specification for a variable or the $ALLOCMAP property to specify the default allocation specification for a variable.Syntax
AGGMAP SET aggmap AS DEFAULT FOR variables
Arguments
The name of a previously defined aggmap object.
A text expression that is the name of one or more variables for which the specified aggmap is the default aggmap. When you specify a literal value, separate the names of the variables with commas.
Examples
Example 8-41 Using AGGMAP SET to Specify a Default Aggmap
Example 8-3, "Using the $AGGREGATE_FROM Property" illustrates how the AGGREGATE command shown in Example 8-28, "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 make revenue_aggmap
the default aggmap for the sales_by_revenue
variable. You can do this either by defining an $AGGMAP property on the sales_by_revenue
variable or by issuing the following statement.
AGGMAP SET revuienue_aggmap AS DEFAULT FOR sales_by_revenue
Now you can aggregate the data by issuing the following AGGREGATE command that does not include a USING clause.
AGGREGATE sales_by_revenue