Essbase: Bootcamp (5 days)
Essbase: Bootcamp (5 days) On Premises Software
Audience
Essbase On Premises 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