About this course:

This course is designed to provide the knowledge and skills to design, build, deploy, and manage the aggregate storage database. Also, it will assist you to construct the 16 dimensions in-class database with a range of guided practices.

Learn to:

• How to design, build, implement, and manage aggregate storage databases
• How to implement time intelligence for time interval reporting
• Calculate mix, variance, and other calculation utilizing MDX
• Explain custom allocations and calculations in aggregate storage databases

Other topics provide you the detailed understanding of significant components of ASO development, incorporating time intelligence, complex member formulas, allocation and calculation templates, partitioning, and the new function in release 11.1.2.

Course Objective:

• Design ASO (Aggregate Storage databases)
• Build Aggregate Storage databases
• Aggregate ASO data
• Upload data in ASO databases
• Calculate member formulas
• Manage and handle ASO databases
• Define custom allocations and calculations in aggregate storage databases
• Create time-intelligent models

Audience:

• Support Engineer
• Developer
• Technical Consultant
• Sales Consultants

Prerequisite:

• Understanding of Microsoft Excel and Windows
• Understanding of Oracle Essbase Bootcamp course