Creating and Exploiting OLAP Using the SAS System (SBIOLAP)

Duration

2 days

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.

Prerequisite Skills

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 Topics

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 SAS Web OLAP Viewer for JAVA

Monitoring and Tuning a SAS OLAP Cube

• using Application Response Measurement (ARM) for tuning
• building an information map from a SAS OLAP cube
• creating a report with SAS Web Report Studio
• generating aggregations using ARM analysis

Working with Input Data

• establishing a ragged hierarchy
• subsetting data during the build process

Using MDX in SAS Enterprise Guide

• 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
• viewing a SAS OLAP cube with Microsoft Excel

Booking

Please contact the Education Team at SAS for the latest information on all SAS courses or to put your name on our specialised course waiting list.