PROC OLAP: The OLAP Procedure

The OLAP Procedure

The OLAP procedure is one of the SAS tools that you can use to create, update, and delete cubes. This includes adding and deleting cube aggregations.

Note: You can also use the Cube Designer wizard to maintain OLAP cubes. The Cube Designer wizard can be launched from SAS Data Integration Studio and SAS OLAP Cube Studio. Help on using the wizard to build cubes is available from within both applications.

[cautionend]

In addition to the basic cube creation tasks, PROC OLAP also enables you to do the following:

build cubes with ragged hierarchies
rename cubes
change nonstructural cube elements
control resummarization behavior on cube security
control options that can be used to optimize cube creation and query performance
specify data set options on detail, fact, dimension, and drill-through tables
create TIME dimensions
design dimensions that have more than one hierarchy
define global calculated members and named sets
include SAS code when you submit PROC OLAP in batch mode
read alternate locale data sets and create locale-specific metadata for use at query time

Top of Page