The OLAP Procedure

Maintaining Cubes

Building a Cube from an Existing Registration

It is possible to have cube argumentDescriptions in the SAS metadata that do not contain the associated physical cubes. For example, you can use the DELETE_PHYSICAL= option in the PROC OLAP statement to delete a cube but leave its argumentDescription intact. You can also use SAS OLAP Cube Studio to save only the argumentDescription of a new cube.
The following table lists the PROC OLAP statements and options that you use to build a cube from an existing metadata argumentDescription:
Statements and Options Used to Build a Cube from an Existing Registration
Statements
Options
PROC OLAP
CUBE=
METASVR
OLAP_SCHEMA=

Adding Aggregations to an Existing Cube

The following table lists the PROC OLAP statements and options that you use to add aggregations to an existing cube.
Statements and Options Used to Add Aggregations to an Existing Cube
Statements
Options
Required or Optional?
PROC OLAP
CUBE=
Required
METASVR
OLAP_SCHEMA=
Required
AGGREGATION
Names of the contiguous levels to be used to create the aggregation
Required
NAME=
Optional
DATAPATH=
Optional
INDEXPATH=
Optional
COMPRESS | NOCOMPRESS
Optional
INDEX | NOINDEX
Optional
PARTSIZE=
Optional
SEGSIZE=
Optional
Note: You can add and delete aggregations in the same PROC OLAP script.
Note: You cannot add aggregations to a cube that contains aggregated data from a fully summarized data source.

Deleting Aggregations from an Existing Cube

The following table lists the PROC OLAP statements and options that you use to delete aggregations from an existing cube.
Statements and Options Used to Drop Aggregations from an Existing Cube
Statements
Options
DROP_AGGREGATION
Specify one or more level names that correspond to the aggregations that you want to remove, or use the aggregation name to specify the aggregation that you want to remove.
METASVR
OLAP_SCHEMA=
PROC OLAP
CUBE=
Note: You can add and delete aggregations in the same PROC OLAP script.
Note: You cannot delete aggregations from a cube that contains aggregated data from a source other than the input data source.

Deleting Cubes

The following table lists the PROC OLAP statements and options that you use to delete existing cubes.
If you use the DELETE option, then both the physical cube and its argumentDescription, which is stored in the metadata server, are deleted.
Statements and Options Used to Delete a Cube and Its Metadata
Statements
Options
METASVR
OLAP SCHEMA=
PROC OLAP
CUBE=
DELETE
If you use the DELETE_PHYSICAL option, then only the physical cube is deleted; the argumentDescription remains intact.
Statements and Options Used to Delete a Cube but Retain Its Metadata
Statements
Options
METASVR
OLAP_SCHEMA=
PROC OLAP
CUBE=
DELETE_PHYSICAL