creating & Exploiting olap using the sas system

Duration: 2 Days

Course Description
This course defines SAS OLAP cubes and explores their characteristics. This course also demonstrates how to create and exploit SAS OLAP cubes using a variety of SAS products, including SAS OLAP Cube Studio, SAS Enterprise Guide, SAS Information Delivery Portal, SAS Web OLAP Viewer for JAVA, and Microsoft Excel with the SAS OLAP Data Provider.

Prerequisites
Familiarity with SAS programming and table structures is helpful but not required. You can gain SAS knowledge by completing the SAS Programming I: Essentials course. Familiarity with Structured Query Language (SQL) or Multidimensional expressions (MDX) is also helpful, but not required.

Course Contents  Introduction to the SAS Intelligence Platform
	SAS Business Intelligence overview
	Business Intelligence Information consumers
	overview of the Orion Star data
Introduction to OLAP Cubes
	introduction to Online Analytical Processing
	overview of SAS OLAP Cube Studio
	registering metadata
Working with SAS OLAP Cubes Derived from Detail Tables
	creating a SAS OLAP Cube from a detail table
	generating aggregations using cross-dimensional tuning
	setting permissions using SAS Management Console
	viewing a SAS OLAP cube with SAS Enterprise Guide
Working with SAS OLAP Cubes Derived from Star Schemas
	creating a SAS OLAP cube from a star schema
	viewing a SAS OLAP cube with Microsoft Excel
Monitoring and Tuning a SAS OLAP Cube
	using Application Response Measurement (ARM) for tuning
	building an information map from a SAS OLAP cube
	viewing a SAS OLAP cube with the Visual Data Explorer
	creating a report with SAS Web Report Studio
	generating aggregations using ARM analysis
Additional Features of the SAS OLAP Cube Designer
	ragged hierarchies
	subsetting during Build
	viewing a SAS OLAP cube with SAS Web OLAP Viewer for Java
Using MDX in SAS Enterprise Guide (Self-Study)
	utilizing MDX in SAS Enterprise Guide
	creating named sets and calculated members with MDX
Working with SAS OLAP Cubes Derived from Summary Tables
	creating a SAS OLAP cube from a summary table
Working with SAS MDDBs in SAS 9
	introduction to multidimensional databases
	using the SAS Open OLAP Server
	viewing MDDBs in SAS Enterprise Guide 3

Prerequisites
Familiarity with SAS programming and table structures is helpful but not required. You can gain SAS knowledge by completing the SAS Programming I: Essentials course. Familiarity with Structured Query Language (SQL) or Multidimensional eXpressions (MDX) is also helpful, but not required.

Course Materials
Students attend classroom courses in one of our public training centers. You receive a hardcopy of the course notes and can also choose to take home a copy of the course data.