SAS Technical Papers » SAS OLAP Server and OLAP Cube Studio

Papers Topic List 
Date Title
November 2013 The OLAPCONTENTS Procedure: Shine the light onto your OLAP Cubes (PDF)
New to SAS® 9.4, the OLAPCONTENTS procedure gives you a clear picture of your OLAP cube structure. This paper explores how easy it is to use PROC OLAPCONTENTS, and the benefits this new SAS procedure provides to OLAP cube management.
June 2013 SAS® OLAP Cube Tuning and Query Performance Optimization (PDF)
This paper will help advanced OLAP users and administrators analyze OLAP cubes‘ usage and tune the cubes‘ aggregations set. It will also cover common factors that impact querying performance and include tips for query processing troubleshooting.
April 2011 How to Customize Your Data Analysis with SAS® OLAP Cube Calculations (PDF)
This paper is targeted toward OLAP cube designers and advanced OLAP cube users. It discusses how to design OLAP cube calculations, where to define them, what functions are available for your use, and how to embed more control into a flow of your MDX programs.
April 2011 SAS® OLAP Cubes Go Green: Reusable Shared Dimensions in SAS® 9.3 (PDF)
SAS OLAP cube administrators and designers will be glad to know that, in SAS 9.3, you can create a dimension to be shared among multiple OLAP cubes. Re-using a shared dimension in multiple OLAP cubes helps ensure consistency and is also good for the environment, since it reduces the amount of metadata and member data stored.
February 2011 SAS®9 OLP Server: Data Management for ROLAP Aggregations (PDF)
SAS OLAP cubes allow you to either create pre-summarized aggregations as part of the cube itself (called MOLAP aggregations) or point to external data (this is called ROLAP data access). This paper focuses on using ROLAP aggregations in your SAS OLAP Cube.
March 2010 Getting Your Cube from Here to There: Migration and Promotion of OLAP Cubes in SAS® 9.2 (PDF)
In SAS 9.2 there are several ways to move your OLAP cube metadata from one SAS environment to another. This paper will explain your choices and help you develop a strategy for cube migration and promotion by evaluating the benefits of each technology.
March 2009 The SAS® OLAP Server: Understanding and Solving Common Problems (PDF)
This paper provides information intended to empower you with the knowledge and skills required to address these issues with confidence. Strategies and examples for resolving issues in both SAS 9.1.3 and SAS 9.2 are presented.
March 2009 Using SAS® OLAP Server for a ROLAP Scenario (PDF)
This paper is targeted to advanced SAS users and discusses the following topics: Relational OLAP (ROLAP) using SAS OLAP Server and Teradata; Design aspects for a ROLAP implementation; Teradata performance features and enhancements.
March 2009 Best Practice: Optimizing the Cube Build Process in SAS® 9.2 (PDF)
This paper discusses factors that affect the cube building process; options that are available to control and optimize the cube building process; best practices for cube building; logging options and understanding possible problems that can occur, in relation to these improvements in SAS® 9.2.
March 2008 Avoid Growing Pains: New Cube Update Features You Should Know About (PDF)
You may have heard about the new cube update feature coming in SAS 9.2 but may not be sure of just what it entails. Learn exactly what cube update is and how to get started with it.
March 2008 What’s New in SAS OLAP Cube Studio 4.2 (PDF)
This paper highlights and demonstrates the new functionality and the benefits that the user will have with SAS OLAP Cube Studio 4.2.
March 2008 Controlling OLAP Applications End to End (PDF)
In SAS 9.2, there are several new features that help administrators to secure and control the use of OLAP Cubes in a reporting environment. This paper highlights the new and existing features.
April 2006 The Practical Union of OLAP Analysis and Geographic Mapping (PDF)
March 2005 Loading Cube Data at Non-Leaf Levels (PDF)
April 2004 SAS9 OLAP Server: Cube Building - Data Preparation and Cube Storage (PDF)
May 2003 OLAP Server: Focusing on Performance (presented at SUGI28) (PDF)