The OLAP Procedure

DROP_AGGREGATION Statement

Removes an aggregation from the specified cube. You can specify the levels that are in the aggregation, or the name of the aggregation, or both the levels and the name. The slash character ( / ) is required to separate level names from option specifications.

Syntax

Details

Required Arguments

Syntax

DROP_AGGREGATION level-name1 < level-name2 ...level-nameN> /
NAME=aggregation-name;

Details

Required Arguments

At least one of the following arguments is required for a DROP_AGGREGATION statement:

level-name1: specifies the names of the level that is in the aggregation that you want to drop. Additional levels can be specified using blank spaces to separate the level names, as shown in the following example. drop_aggregation Year Month Product / name=Sales ;

NAME='aggregation-name': specifies the name of the aggregation that you want to drop. If the name includes blank spaces or any characters that are not permitted in a valid SAS name, then the name must be enclosed within quotation marks.