title
SAS® OLAP Server
shelf-menu
title
SAS® OLAP Server and SAS® OLAP Cube Studio
description

Quickly analyze information that has been summarized into multidimensional views and hierarchies. Online Analytical Processing (OLAP) enables you to build consistent OLAP cubes using an integrated ETL process, and allows you to get the reports you need without involving IT.

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 server is to respond to queries from cube viewers. SAS OLAP Server runs in the background on specially configured host computers.

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.

support-dropdown
background-image


The most recent releases are SAS OLAP Server 9.4 and SAS OLAP Cube Studio 4.4.

What’s New

New features include:

  • OLAPCONTENTS procedure for generating reports of OLAP cube information.
  • OLAPCONFIG method for setting SAS OLAP Server options in batch mode.
  • Updated OLAPOPERATE procedure.
  • MDX Case statement.
  • VISUALTOTALS_BEHAVIOR option for calculated measures.
  • Starting in the first maintenance release for SAS 9.4, a new LOGICALSERVERNAME option has been added to the OLAPOPERATE procedure.
  • Beginning in SAS 9.4, you can enable execution of user defined (FORMAT procedure style) formats in SPDS. See the topic" Improving ROLAP Throughput Performance with SPDS" in the SAS 9.4 OLAP Server User's Guide.
  • Starting in the first maintenance release for SAS 9.4, a new INSTR MDX function has been added. See "INSTR" in the SAS 9.4 OLAP Server MDX Guide.
  • Starting in the first maintenance release for SAS 9.4, the LOCKDOWN option and statement are supported by the SAS OLAP Server.
  • The EXISTS MDX function is now documented in the SAS 9.4 OLAP Server: MDX Guide.

In addition, properties for multilingual cubes are automatically updated in multiple languages when reports are generated. The SQLRC macro can be used with the SQL pass-through facility for OLAP.

icon
heading

Training Courses

subheading
Learn SAS technology quickly and efficiently by taking a course from the analytics experts.
text-align
center

SAS® OLAP Environment: Administration

This recorded course is designed for platform administrators who need to administer SAS OLAP functionality. You'll learn how to administer using the SAS OLAP client applications, manage the SAS OLAP Server and manage the cube creation process.

Designing, Tuning, and Maintaining SAS® OLAP Cubes

Learn how to use the SAS OLAP environment to build, tune and maintain multidimensional cubes. You'll also learn how to access requirements and examine options for building efficient OLAP cubes, and how to create and set security on SAS OLAP cubes.

Learning path for Business Intelligence

icon
heading

Documentation

subheading
Find user's guides and other technical documentation for SAS OLAP Server.
text-align
center

SAS OLAP Cube Studio 4.4 and SAS OLAP Server 9.4

heading

Previous Versions

text-align
center
9.X

SAS OLAP Cube Studio 4.3 and SAS OLAP Server 9.3

  • What's New in SAS OLAP Server 9.3 HTML
  • SAS 9.3 OLAP Server: User's Guide PDF | HTML
  • SAS 9.3 OLAP Server: MDX Guide PDF | HTML

Related Documentation

  • "Administering SAS OLAP Servers" in the SAS 9.3 Intelligence Platform: Application Server Administration Guide PDF | HTML
  • "Managing OLAP Cube Data" in the SAS 9.3 Intelligence Platform: Data Administration Guide, Second Edition PDF | HTML

SAS OLAP Cube Studio 4.2 and SAS OLAP Server 9.2

  • What's New in SAS OLAP Server 9.2 HTML
  • SAS 9.2 OLAP Server: User's Guide PDF | HTML
  • SAS 9.2 OLAP Server: MDX Guide PDF | HTML

Related Documentation

  • "Administering SAS OLAP Servers" in the SAS 9.2 Intelligence Platform: Application Server Administration Guide PDF | HTML
  • "Managing OLAP Cube Data" in the SAS 9.2 Intelligence Platform: Data Administration Guide PDF | HTML

SAS OLAP Cube Studio 3.1 and SAS OLAP Server 9.1.3

  • What's New in SAS OLAP Server 9.1.3 HTML
  • SAS OLAP Server: User's Guide PDF
  • SAS OLAP Server: MDX Guide PDF

Related Documentation

  • "Administering SAS OLAP Servers" in the SAS 9.1.3 Intelligence Platform: Application Server Administration Guide PDF
  • "Managing OLAP Cube Data" in the SAS 9.1.3 Intelligence Platform: Data Administration Guide PDF
  • "SAS OLAP Server Monitoring and Logging" in the SAS 9.1.3 Intelligence Platform: System Administration Guide PDF
heading

SAS Technical Papers

subheading
Read technical papers to learn how to complete a task or achieve a goal.
text-align
center

SAS Technical Papers for SAS OLAP Cube Studio and SAS OLAP Server

heading

Hot Fixes

subheading
Find quick solutions to problems or conduct routine system maintenance. SAS hot fixes have been tested and are fully supported.
text-align
center
4.X
/en/fragments/software/get-help