SAS

      NEWS EVENTS SERVICES Careers CONTACT US

HOME PRODUCTS AND SOLUTIONS SUCCESS STORIES PARTNERS COMPANYTRAININGCERTIFICATIONTECHNICAL SUPPORT

SAS.COM
TRAINING / CURRICULUM
 
Training
CurriculumView all Courses
 CurriculumRoles Based Courses
Find a CoursePublic Training
 Experienced with SASCourse Details
SAS Data IntegratinTraining Schedule
 SAS Data IntegratinSpecial Offers
 Find a CourseOn-Site Training
Find a CourseBusiness Knowledge Series
Find a CourseSAS Solution Lines
Find a CourseAuthorized Training Center
 

Creating and Exploiting OLAP Using the SAS System
Duration: 2 Days

Audience
The course is designed for data modelers and system experts who want to understand, create, and exploit Online Analytical Processing (OLAP) using SAS. This course requires the SAS Intelligence Platform.
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.

Course Contents

 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
 

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.
 
 

call: 91-22-6749 2222
 fax: 91-22-6749 2299

training.india@sas.com
enquire now
register now
Back to Top
 

 

 

   Contact Us     Search     Terms of Use & Legal Information     Privacy Statement   Copyright © 2007 SAS Institute Inc. All Rights Reserved