Administrative Overview for SAS OLAP Servers

references cube data 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.

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.

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

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.

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

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

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.

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

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.

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.