Designing, Tuning, and Maintaining SAS OLAP Cubes - SBAOLAP

This course teaches students how to use the SAS OLAP environment to build, tune, and maintain multidimensional cubes.

Duration

3 days - Classroom

Learn how to

• access requirements and examine options for building efficient OLAP cubes
• create and set security on SAS OLAP cubes
• extend the functionality of the cube using both wizards and the Multidimensional Expressions(MDX)language
• tune a SAS OLAP cube and perform cube maintenance
• use an OLAP cube in reporting applications.

Who should attend

Business analysts

Prerequisites

There are no formal prerequisites for this course. Knowledge of the platform for SAS Business Analytics is helpful but not required. You can gain the SAS platform knowledge by completing Creating Business Intelligence for Your Organisation 1: Essentials or Creating Business Intelligence for Your Organisation: Fast Track Familiarity with Structured Query Language (SQL) or Multidimensional eXpressions (MDX) is also helpful, but not required.

Course Contents

Getting Started with the Platform for SAS Business Analytics and OLAP

• exploring online analytical processing (OLAP)
• examining the SAS platform architecture
• working with the SAS OLAP environment
• discussing the course environment and scenario

Designing a SAS OLAP Cube

• assessing requirements
• identifying data-dependent factors
• examining options for efficiencies

Creating a SAS OLAP Cube

• identifying the cube structure
• registering the metadata
• creating a cube using the Cube Designer wizard

Extending the Cube Using Pre-defined Calculations

• adding members to an existing cube
• using simple calculations
• using time-related calculations

Extending the Cube Using Custom Calculations

• investigating MDX concepts
• working with members
• using conditional expressions
• exploiting SAS functions

Tuning a SAS OLAP Cube

• designing aggregations
• tuning aggregations

Performing Cube Updates

• incrementally updating a SAS OLAP cube
• performing an in-place cube update
• performing a managed cube update
• managing cube generations

Setting Security on a SAS OLAP Cube

• understanding OLAP security
• securing dimension, hierarchy, and level objects
• establishing member-level security

Using a SAS OLAP Cube in Reporting Applications

• working with PivotTable reports in Microsoft Excel
• viewing a SAS OLAP cube with SAS Enterprise Guide
• building an information map from a SAS OLAP cube
• building a multidimensional report in SAS Web Report Studio
• viewing multidimensional data with the SAS Information Delivery Portal

Learning More

• SAS resources
• identifying next steps
• using SAS documentation

Appendix A: Providing OLAP Data for Multiple Locales

• understanding Multiple Language Support (MLS)
• building translation tables
• creating a cube using MLS

Appendix B: Supported MDX Functions

• dimension functions
• hierarchy functions
• level functions
• logical functions
• member functions
• numeric functions
• set functions
• string functions
• tuple functions
• miscellaneous functions and operators

Software Addressed

TThis course addresses the following software product(s): SAS OLAP Server, Platform for SAS Business Analytics.