This course is designed for users who want to analyze the business information that is stored in a SAS OLAP cube. The course provides opportunities to practice in a simulated SAS environment.

Learn how to

• interact with a SAS OLAP cube using SAS Enterprise Guide 4.3
• interact with a SAS OLAP cube using the SAS Add-In for Microsoft Excel Office 4.3
• interact with SAS OLAP data using SAS Web Report Studio 4.3
• build a multidimensional report using SAS Web Report Studio 4.3
• build a SAS Information Map from a SAS OLAP cube using SAS Information Map Studio 4.2.

Who should attend

Business users and other information consumers who want to interact with SAS OLAP cubes and create multidimensional reports based on SAS OLAP data

Formats available	Duration
e-Learning:	8 hours/180 day license

There are no formal prerequisites for this course.

This course addresses SAS Add-in for Microsoft Office, SAS Enterprise Guide, SAS Information Map Studio, SAS Web Report Studio software.

Exploring Online Analytical Processing

• defining OLAP terminology

Viewing a SAS OLAP Cube with SAS Enterprise Guide

• the OLAP Analyzer
• MDX queries

Working with SAS OLAP Cubes in Microsoft Excel

• the SAS OLAP Viewer

Viewing Multidimensional Data on the Web

• accessing and navigating multidimensional data
• working with multidimensional data

Building an Information Map from a SAS OLAP Cube

• creating SAS Information Maps