Designing, Tuning, and Maintaining SAS OLAP Cubes

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

• 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

Formats available	Duration
e-Learning:	21 hours/180 day license

There are no formal prerequisites for this course. Familiarity with Structured Query Language (SQL) or Multidimensional eXpressions (MDX) is also helpful but not required.

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.