Designing, Tuning, and Maintaining SAS OLAP Cubes

This course addresses SAS Analytics Platform, SAS OLAP Server software.

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

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

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

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

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

• designing aggregations
• tuning aggregations

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

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

• viewing a SAS OLAP cube with SAS Enterprise Guide
• working with SAS OLAP cubes in Microsoft Excel
• building an information map from a SAS OLAP cube
• viewing multidimensional data on the Web

• SAS resources
• beyond this course