• Print  |
  • Feedback  |

Knowledge Base

SAS Products

SASŪ OLAP Cube Studio and SASŪ OLAP Server

Product Specific Resources See the SAS OLAP Server Focus Area for extended information on using this Software.
News about SAS OLAP Cube Studio and SAS OLAP Server
What's New in SAS 9.3 OLAP Server

The SAS 9.3 OLAP Server provides the following changes and enhancements:

  • restructure and enhance the Cube Designer wizard
  • add Multiple Language Support for drill-through tables and caption tables
  • add support for shared dimensions
  • new and improved functions and options
In addition, in SAS Management Console 4.3, the SAS OLAP Server Monitor has been redesigned for efficiency and to enable the control of load-balanced SAS OLAP Servers.

Cube Migration

OLAP cubes that were built in SAS 9.2 can be used in SAS 9.3 without changes or migration.

For cubes built in SAS 9.1.3 or earlier, follow the migration steps in the SAS Intelligence Platform: Migration Guide.


Overview

Online Analytical Processing (OLAP) is a technology that is used to create decision-support software. OLAP enables application users to quickly analyze information that has been summarized into multidimensional views and hierarchies.

SAS OLAP Server
SAS OLAP Server is a scalable server that provides multi-user access to data that is stored in SAS OLAP cubes. The purpose of the SAS OLAP Server is to respond to queries from cube viewers. SAS OLAP queries are performed using the Multidimensional Expressions (MDX) query language in client applications that are connected to the OLAP server by using either OLE DB for OLAP or a similarly designed Java interface. SAS OLAP Server runs in the background on specially configured host computers.

SAS OLAP Cube Studio
SAS OLAP Cube Studio provides an easy-to-use graphical user interface to create and manage SAS OLAP cubes. You can use it to build and edit SAS OLAP cubes, to incrementally update cubes, to tune aggregations, and to make various other modifications to existing cubes. SAS OLAP Cube Studio is part of the SAS software offerings, SAS OLAP Server and SAS Enterprise BI Server.

SAS OLAP Server Monitor
SAS OLAP Server Monitor plug-in for SAS Management Console enables you to manage tasks that are specific to the SAS OLAP Server. You can configure SAS OLAP Servers, administer the connection to a SAS OLAP Server, monitor sessions that are running on a SAS OLAP Server, and monitor queries that are being processed by a SAS OLAP Server. You can also enable and disable cubes and refresh cube metadata.



System Requirements at a Glance

SAS OLAP Server runs in the following operating environments: Windows, UNIX, and z/OS. SAS OLAP Cube Studio is a component of SAS OLAP Server and of SAS Enterprise BI Server.

Stay Informed

Documentation

Need help?

SAS Publishing Representatives are available in the U.S. from 8-5 ET to answer your documentation questions. Contact us at 1-800-727-3228 or e-mail.

Training

Need help?

Curriculum consultants are available in the U.S. from 9-5 EST. Contact us at 1-800-333-7660 or e-mail.

International customers, please contact your country office.

Conversations
The SAS Dummy - A SAS blog for the rest of us.


SAS Enterprise Guide Forum

Share your experiences, questions and ideas with other SAS Enterprise Guide users.

Enter the forum