Administering SAS OLAP Servers

Installing and Configuring SAS OLAP Servers

Consider the following with regard to the installation and configuration of SAS OLAP Servers:

Cubes are built and updated on SAS Workspace Servers. Cubes are queried on SAS OLAP Servers.
Install one SAS OLAP Server per host.
Workspace servers and OLAP servers need to access the same physical locations.
Workspace servers and OLAP servers do not need to be installed on the same host.
Workspace servers require sufficient storage capacity for temporary files that are generated during cube builds, as described in Configure Storage for Temporary OLAP Cube Build Files on SAS Workspace Servers.

You initially install SAS OLAP Servers with the rest of the SAS Intelligence Platform using your SAS software depot, your deployment plan, and the SAS Deployment Wizard, as described in the SAS Intelligence Platform: Installation and Configuration Guide.

After your initial installation, you:

Configure source data libraries, as described in SAS Intelligence Platform: Data Administration Guide
Configure access control, as described in SAS Intelligence Platform: Security Administration Guide. You have the capability of limiting access within cubes by preventing the display of specified dimensions, hierarchies, levels, and members.
Configure cube viewers, as described in SAS Intelligence Platform: Desktop Application Administration Guide

Add a SAS OLAP Server

After your initial deployment, demand for additional cubes might require you to add another SAS OLAP Server. Contact a SAS support representative to receive assistance with your hardware configuration plan.

To install a new SAS OLAP Server, you install a new SAS Application Server on a new host using the SAS Deployment Wizard. Use the wizard in Configuration mode to install metadata, software, and configuration files in a single pass. After installation, you either add cubes to the new OLAP schema file or you assign the new server to the cubes that are listed in an existing OLAP schema. To work with OLAP schemas in SAS Management Console, select the Folders tab, open the Shared Data folder, right-click the OLAP schema file, and select Properties.

Add a Load-Balancing Cluster of SAS OLAP Servers

Load-balancing clusters of OLAP servers improve query response times by dividing concurrent client sessions across multiple hosts. You can add or remove servers from the cluster in response to changes in the average number of concurrent sessions. To add a load-balancing OLAP cluster, see Understanding Server Load Balancing.

Top of Page