designing, tuning, and maintaining SAS OLAP cubes

By attending Designing, Tuning, and Maintaining SAS OLAP Cubes workshop, Participants will learn 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

The Designing, Tuning, and Maintaining SAS OLAP Cubes training course teaches Participants how to use the SAS OLAP environment to build, tune, and maintain multidimensional cubes.

Knowledge of the platform for SAS Business Analytics is helpful but not required. Participants can gain the SAS platform knowledge by completing the Getting Started with the Platform for SAS Business Analytics course. Familiarity with Structured Query Language (SQL) or Multidimensional eXpressions (MDX) is also helpful but not required.

  • Power users

COURSE AGENDA

  • identifying the cube structure
  • registering the metadata
  • creating a cube using the Cube Designer
  • assessing requirements
  • identifying data-dependent factors
  • examining options for efficiencies
  • exploring online analytical processing (OLAP)
  • examining the SAS platform architecture
  • working with the SAS OLAP environment
  • discussing the course environment and scenario
  • 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

Copyright © 2025 All Rights Reserved by Cuesys Infotech.

Designed By  99 DESIGN AGENCY