Essbase: Bootcamp (5 days)

Audience

Essbase Developers and Hyperion Planning Administrators

Learning objectives

Learn about the design of Essbase Block Storage (BSO) and Aggregate Storage (ASO) databases. Understand Essbase multidimensionality, the loading and manipulation of data through calculation scripts and how to maintain and optimise Essbase databases.

Course description

This course covers everything you'll need to know to design and maintain Essbase Block Storage (BSO) and Aggregate Storage (ASO) databases. No prior knowledge is assumed. Learn the primary methods for the design of Essbase block storage databases. Understand Essbase multidimensionality, dense and sparse settings, building outlines with load rules, maintaining the Essbase environment, creation and calculation of data blocks, storage types, dynamic calc shared members, the order of operations, member formulas, dynamic calculations, two-pass calcs and sparse rollups. The course also covers detailed information about database outlines, loading data and analysis within a spreadsheet environment. There's also focus on the creation and optimisation of calculation scripts and the backup and system administration of the system.

Day summary

Day 1:

Overview, navigation, outline creation, ASO and BSO comparison and conversion

Day 2:

Loading metadata and data, enhanced reporting capabilities, reporting tool comparison

Day 3:

Smart View, block storage optimisation, task automation and security

Day 4:

Aggregate storage optimisation, calculation methodologies and scope control (calc scripts)

Day 5:

MDX queries, calculation conversion, case study

Detailed course agenda / Justification for your manager

Course title: Essbase Bootcamp

Duration: 5 days

Audience: Financial and Technical System Administrators

Pre-requisites: None

Delivery method: Classroom (group - live)

Advanced preparation: None

Recommended CPE credits: 35 credits - specialised knowledge and applications

Programme level: Intermediate

Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org
Essbase: Bootcamp (5 days)
Oracle Essbase Training Courses