About this course:

You learn the principles of aggregate storage database design, then how to build, load, report from, and manage aggregate storage databases, constructing the sixteen-dimension in-class database through a series of guided exercises.

Learn to:

• Design, develop, and deploy aggregate storage databases
• Manage aggregate storage databases
• Construct variance, mix, and other member calculations using MDX
• Implement time intelligence for time period reporting
• Describe custom calculations and allocations in aggregate storage databases

Additional topics give you an in-depth view of (and hands-on practice in) important elements of ASO development, including complex member formulas, time intelligence, partitioning, and the new features in Release 11.1.2, calculation templates and allocations.

Course Objective:

• Create ASO databases
• Load data into ASO databases
• Aggregate ASO data
• Design aggregate storage (ASO) databases
• Manage ASO databases
• Construct member formulas
• Build time-intelligent models
• Describe custom calculations and allocations in aggregate storage databases

Audience:

• Developer
• Sales Consultants
• Support Engineer
• Technical Consultant

Prerequisite:

• Knowledge of principles from Oracle Essbase Bootcamp course
• Knowledge of Microsoft Windows and Excel