Products & Solutions / Foundation Tools

SAS® OLAP Server

A multidimensional data store designed to provide quick access to presummarized data

SAS® OLAP Server is a multidimensional data store designed from the outset to provide quick access to presummarized data generated from vast amounts of detailed data. Decision makers need quick access to summarized data so they can make timely decisions based on knowledge instead of gut feelings.

Benefits

  • Provides a transparent and integrated ETL process for building consistent OLAP cubes.
  • Delivers fast, stable, summarized data for business intelligence applications.
  • Frees IT from constantly creating ad hoc reports and data summaries.

Read more

Features

  • Industrial-strength, multidimensional database
  • Fast processing of queries
  • Easy-to-use GUIs for building and maintaining OLAP cubes
  • Optimization of summarized data to conserve system resources
  • Centralized metadata with security credentials preserved on drill-through
  • Multiple-language support
  • Powerful interfaces for OLAP server monitoring

Read more

How SAS® Is Different

  • SAS provides support for several OLAP architectures: multidimensional OLAP (MOLAP), relational OLAP (ROLAP) and hybrid OLAP (HOLAP) to address various reporting and analysis requirements.
  • SAS provides a single shared layer of metadata to ensure traceability from the operational data source through the ETL process to the destination OLAP report.

Benefits

  • Provides a transparent and integrated ETL process for building consistent OLAP cubes. Using a simplified ETL process, SAS OLAP Server makes it easy to build consistent OLAP cubes from disparate systems. Integrated metadata ensures that consistent information is delivered across the enterprise and enables IT to quickly justify data integrity.
  • Delivers fast, stable, summarized data for business intelligence applications. SAS OLAP Server quickly delivers information to business intelligence applications, irrespective of the amount of underlying data. Summarizing data at several levels of detail before storing provides the summarized data that business intelligence applications require without the need for additional "on-the-fly" processing.
  • Frees IT from constantly creating ad hoc reports and data summaries. Because summarized data is organized along business lines, users can get the reports they need without involving IT, freeing IT from the constant work of creating reports and data summaries.

Features

Industrial-strength, multidimensional database
  • Designed to handle large volumes of business intelligence data.
  • Supports multidimensional (MOLAP) and hybrid (HOLAP) data stores.
  • Routines enable SAS procedures to query the SAS OLAP Server by using SQL Pass-Through with reach-through from multidimensional data to the underlying detailed data.
  • Native support for open industry standards:
    • OLE DB for OLAP.
    • Fully compliant implementation of MDX query language for communication with third-party clients.
  • With SAS software's open architecture, cubes can be surfaced via the Web, through Microsoft Excel as pivot tables, as well as through SAS or other standards-based browsers.
Fast processing of queries
  • Multithreaded query engine.
  • Data can be spread across multiple disk systems, providing parallel read access for query threads.
  • Cluster management for load-balanced servers.
Easy-to-use GUIs for building and maintaining OLAP cubes
  • Included with SAS OLAP Server, SAS OLAP Cube Studio makes it easy to define data dimensions and aggregations.
  • SAS OLAP Cube Studio is integrated with SAS Data Integration Studio so you can build cubes from cleansed data sources and load them for later use and updating.
  • Java-based wizard facilitates designing, creating, updating and tuning OLAP cubes.
  • Create a set of dimensions once, then share those with other cubes, providing consistent hierarchies and saving system resources. Update the set and apply across shared cubes.
Optimization of summarized data to conserve system resources
  • Seldom accessed data can be stored in a compressed format.
  • Frequently queried data can be cached in memory for faster access.
  • Dimensions, hierarchies, and metrics (metadata) are stored in the cube itself, while data remains in the database and is only queried at run time, reducing data duplication and cube processing time.
Centralized metadata with security credentials preserved on drill-through
  • All metadata is stored in a single, open location – the SAS Metadata Server. SAS OLAP Server is fully integrated into the open security model maintained in SAS Metadata Server that is used across all SAS products and solutions.
Multiple-language support
  • Use translated captions via caption tables.
  • Support for natural language format for measures.
  • Sophisticated, language-aware ordering of data.
Powerful interfaces for OLAP server monitoring
  • Define OLAP data servers and their configuration parameters, including performance logging options.
  • Application Response Management (ARM) classes used to monitor all server activities. Result sets can be transferred to SAS or third-party clients, such as HP-UX Workload Manager, in order to monitor activity and performance.

System Requirements

Host Platforms/Server Tier
  • HP/UX on Itanium: 11iv3 (11.31)
  • IBM AIX R64 on POWER architecture 7.1
  • IBM z/OS: V1R11 and higher
  • Linux x64 (64-bit): Novell SuSE 11 SP1; Red Hat Enterprise Linux 6.1; Oracle Linux 6.1
  • Microsoft Windows on x64 (64-bit):
    Desktop: Windows 7* x64 SP1; Windows 8** x64
    Server: Windows Server 2008 x64 SP2 Family; Windows Server 2008 R2 SP1 Family; Windows Server 2012 Family
  • Solaris on SPARC: Version 10 Update 9
  • Solaris on x64 (x64-86): Version 10 Update 9; Version 11
Client Tier
  • Microsoft Windows (64-bit): Windows 7* x64 SP1; Windows 8** x64
Required SAS® Software
  • Base SAS®
Required Third-Party Software
  • SAS OLAP Cube Studio, included in the SAS OLAP Server bundle, is a Java desktop client and requires the Java Runtime Environment (JRE). See Third-Party Software for SAS 9.4 for specific requirements.

* NOTE: Windows 7 supported editions are: Professional, Ultimate and Enterprise.
** NOTE: Supported editions include: Windows 8, Windows 8 Pro, Windows 8 Enterprise.

Ready to learn more?

Call us at 1-800-727-0025 (US and Canada) or request more information.