SAS OLAP Cube Studio and the OLAP Procedure

SAS OLAP Cube Studio contains several tools and functions that enable you build, modify, and maintain OLAP cubes. Specifically, the Cube Designer wizard guides you through the cube building process. You can specify the data used to build the cube, the structure of the cube, and the measures and aggregations that will be used to process queries for the cube. After you have built your cube in theCube Designer wizard, you can view a simple display of the cube and verify your cube data and structure.

SAS OLAP Cube Studio also provides tools and functions for modifying and maintaining cubes. After a cube is built you can make various changes and updates to the cube. Here are some functions that you can perform on a cube after it is created:

For more information about functions and tasks that you can perform on a cube after it is created, see Modifying and Maintaining Cubes.

In addition to using SAS OLAP Cube Studio, you can define and build SAS OLAP cubes with the OLAP procedure. The OLAP procedure contains various statements and options to help you define a cube in batch mode if needed or preferred. See The OLAP Procedure for detailed information about the OLAP procedure.

This chapter discusses and refers primarily to building cubes in SAS OLAP Cube Studio. The comparable OLAP procedure statements and options are referred to where necessary in each topic.