The OLAP Procedure

Maintaining Cubes

Building a Cube from an Existing Definition

It is possible to have cube definitions in the SAS metadata that do not have associated physical cubes. For example, you can use the DELETE_PHYSICAL= option in the PROC OLAP statement to delete a cube but leave its definition intact. You can also use SAS OLAP Cube Studio to save only the definition 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 definition:

Statements and Options Used to Build a Cube from an Existing Definition
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. [cautionend]

Note: You cannot add aggregations to a cube that contains aggregated data from a source other than the input data source. [cautionend]

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. [cautionend]

Note: You cannot delete aggregations from a cube that contains aggregated data from a source other than the input data source. [cautionend]

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 definition, 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 definition remains intact.

Statements and Options Used to Delete a Cube but Retain Its Metadata
Statements	Options
METASVR	OLAP_SCHEMA=
PROC OLAP	CUBE=
	DELETE_PHYSICAL

Top of Page