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
: 8 hours/180 day license

There are no formal prerequisites for this course.

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

ESBUO43.