About SAS OLAP Cube Studio and SAS OLAP Server

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.

The most current releases are SAS OLAP Cube Studio 9.3 and SAS OLAP Server 9.3.

---

News

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.

 Online Documentation         Purchase from Bookstore          Technical Papers

Free Online Documentation

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.

Online Support Resources

This page contains online support resources that are specific to this product. Visit the Support page to access various self-help and assisted-help resources or submit a problem through the SAS Technical Support form.

---

 Downloads         Highlighted Samples         Notes          Videos

Downloads

Hot Fixes by Release

• 4.2_M2

Software Downloads

---

Highlighted Samples

• Shared dimensions can be used to allow incremental update of dimensions for a ROLAP cube
• Using the SQL Pass-Through facility for OLAP to test queries against a cube on a SAS OLAP Server)
• Using the SECURITY_SUBSET feature of SAS® OLAP Server
• Enabling the ARM log in a SAS® 9.2 OLAP Server
• Using PROC OLAPOPERATE to close all sessions for a particular cube

Notes

---

Videos

 

Real BI For Real Users