Administering SAS OLAP Cube Studio

SAS OLAP Cube Studio Overview for Administrators

SAS OLAP Cube Studio is used to build, edit, and tune OLAP cubes. To build a cube, the application generates metadata and a SAS program. It then submits the program for execution on a SAS Workspace Server. The SAS Workspace Server builds the cube and stores the result in a physical location that can be accessed by a SAS OLAP Server.

When a cube becomes available on a SAS OLAP Server, it is queried by users working with OLAP clients. These clients can include SAS Web Report Studio, SAS Web OLAP Viewer, and SAS Enterprise Guide. The cube viewers submit queries to the SAS OLAP Server in the industry-standard MDX query language. The SAS OLAP Server responds to queries by delivering result sets to the cube viewers for display.

To configure your enterprise for SAS OLAP Cube Studio, perform the following tasks:

Install and register SAS OLAP Servers and SAS Workspace Servers.
Create libraries for cubes and cube data.
Set up users, groups, and roles for OLAP cube builds, updates, and queries.
Use the OLAP Server Monitor and Server Manager plug-ins in SAS Management Console to monitor, control, and tune SAS OLAP Servers.

For information about the administration of SAS OLAP Servers, see the chapter "Administering SAS OLAP Servers" in the SAS Intelligence Platform: Application Server Administration Guide.

Top of Page