OVERVIEW

This training will provide hands-on experience in creating Essbase analytical cubes. An independent project will be given at the end that will integrate all topics covered in the course.

DURATION
2-3 weeks (2-4 hours a day)

PREREQUISITE

Experience in working with relational databases and writing basic SQL queries. Experience with other OLAP data structures highly desired.

TOPICS COVERED

OLAP Cubes

• Dimension Modeling
• Smart View
• Load Rules
• BSO/ASO
• Calculations
• Security
• MaxL
• Partitioning