Stay in Touch
Not sure what course to take?
Speak with an expert curriculum consultant at 800-333-7660 or send an e-mail.Submit Your Course Requests
Want this course at another location or on a different date? Let us know your course needs.On-site Pricing
Course fee and EPTO/APTO units differ for on-site training.Advanced OLAP Techniques Using the SAS System
|
Duration: 2.0 days Course fee: $1,150 EPTO units: 2.2 CEUs: 1.2 | ||
 |
This course provides detailed information about different cube design and cube building methods for SAS OLAP cubes. In addition, the course covers aggregation tuning, query performance, and how to monitor and use the logs provided with the SAS OLAP Server. The Multidimensional Expressions (MDX) language is covered in-depth as a mechanism for extending the capabilities that a cube offers.
Learn how to
- design and create a SAS OLAP cube
- set security on a SAS OLAP cube
- use MDX to extend cube capabilities
- monitor and tune a SAS OLAP cube.
Who should attend
Data modelers and system experts who want to build, administer, and maintain OLAP environments
Expand All
Collapse All
Print version
Prerequisites
Before attending this course, you should have at least six months of experience creating SAS OLAP cubes or have completed the Creating and Exploiting OLAP Using the SAS System course and worked with SAS OLAP cubes for at least one month. 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. Familiarity with Structured Query Language (SQL) or Multidimensional eXpressions (MDX) is also helpful, but not required.
Course Contents
Discovering the SAS OLAP Environment
- exploring Online Analytical Processing (OLAP)
- working with the OLAP environment
- investigating the course data and user roles
- assessing requirements
- identifying data-dependent factors
- investigating the build process
- examining options for efficiencies
- identifying the cube structure
- registering the metadata
- creating a cube using the Cube Designer Wizard
- maintaining SAS OLAP cubes
- understanding OLAP server authorization
- authorizing on dimension, hierarchy, and level objects
- applying member level security
- describing multidimensional data
- working with calculated members
- using time-related calculations
- employing conditional expressions
- exploiting SAS functions
- designing aggregations
- tuning aggregations
- manually maintaining aggregations
- working with the SAS OLAP server
- understanding Multiple Language Support (MLS)
- building the translation tables
- creating a cube using Multiple Language Support
- dimension functions
- hierarchy functions
- level functions
- logical functions
- member functions
- numeric functions
- set functions
- string functions
- tuple functions
- miscellaneous functions and operators
Software
This course addresses SAS Enterprise Guide, SAS Intelligence Platform, SAS Information Delivery Portal, SAS Information Map Studio, SAS Management Console.
Course Materials
Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.
Share Your Thoughts
Are there additional topics you'd like for this course to address?
Would you like for this course to be offered at another training facility?
Let us know by adding to our Interest List.
This page was created using SAS software.