Administering SAS OLAP Servers

Administrative Overview for SAS OLAP Servers

The SAS OLAP implementation consists of the following components:

SAS OLAP Server

references cube data held in memory to generate result data sets that are delivered to OLAP clients in response to queries from cube viewers. One server supports one or more concurrent client connections. SAS OLAP Servers can be grouped into load-balancing clusters to provide scalable support for one or more cubes.

SAS OLAP Cube Studio

generates cube metadata and creates SAS code that is executed to build cubes. . Other tools define aggregations, generate calculated members, export and import cubes between metadata repositories, and generate new OLAP schemas.

SAS Language Elements

PROC OLAP creates and updates cubes. PROC OLAPOPERATE provides programmatic administration of SAS OLAP Servers, as described in the SAS OLAP Server: User's Guide

OLAP Schema

groups cubes that are exclusively accessed by one or more SAS OLAP Servers. Each cube is listed in one and only one OLAP schema. Each SAS OLAP Server is required to use one OLAP schema. Multiple servers can use the same schema.

SAS Workspace Server

executes SAS code to build or update cubes in host memory. For information about the administration of SAS Workspace Servers, see Managing Workspace Servers and Stored Process Servers.

SAS Metadata Server

stores metadata that defines cubes, cube data, cube data access permissions, and load-balancing data.

Cube Viewer

generates queries in the MDX language and displays result data sets as they are received from SAS OLAP Servers. The primary cube viewers are SAS Web OLAP Viewer, SAS Web Report Studio, and SAS Enterprise Guide. Because queries are submitted in the OLE DB for OLAP application programming interface, you can also view cubes with third-party viewers such as Microsoft Excel.

For more information about the MDX query language, see the SAS OLAP Server: MDX Guide.

SAS Management Console

displays SAS OLAP Servers and OLAP schemas and contains the OLAP server administrative plug-ins Server Manager and SAS OLAP Server Monitor.

Server Manager

displays OLAP servers and logical OLAP servers, provides server controls, and manages advanced server options. This application is provided in the Environment Management folder in the Plug-ins tree in SAS Management Console.

SAS OLAP Server Monitor

displays all OLAP servers and schemas, provides session controls, and manages advanced server options. This application is provided in the Monitoring folder in the Plug-ins tree in SAS Management Console.

Administrators support SAS OLAP Servers by configuring hosts, installing and configuring SAS OLAP Servers and SAS Workspace Servers, starting, stopping, and restarting servers, monitoring servers, managing server logs, tuning servers, and configuring libraries and permissions for users. These tasks are accomplished using the SAS Deployment Wizard and SAS Management Console.

User tasks for SAS OLAP Server include building cubes, viewing cubes, and tuning cubes. These tasks are accomplished with SAS OLAP Cube Studio. User tasks are documented in the SAS OLAP Server User's Guide and in the Help for SAS OLAP Cube Studio.

Top of Page