Building Cubes and Administering Cubes

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 the Cube 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:

tune the aggregations for the cube
add and edit calculated members and measures for the cube
incrementally update the cube
export and then import a SAS package between SAS environments

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

SAS OLAP Procedure

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 OLAP Procedure for detailed information on the OLAP procedure.

Top of Page