Hyperion Training (4 Weeks)
Hyperion Essbase Version 9.3.1
Session I
o Introducing Hyperion Essbase
o Understanding Multidimensional database
o Quick Start for implementing Analytic Services
o Basic Architectural Elements
o About Essbase Administrative Services
o Designing and Creating Applications and Databases (ASO / BSO)
o Difference between ASO and BSO
o Creating and changing database outline
Session II
o Setting Dimensions and Member Properties
o Working with Attributes
o Creating and managing Aliases
o Features supported by Aggregate Storage and Block Storage
o Designing and Building Currency conversion applications
o Designing, Building and maintaining partitions
o Designing and Building a security system
Session III
o Understanding Data loading and Dimension Building
o Creating a Rules file to Perform operations on Records, Fields & Data
o Performing and Debugging data loads and Dimension builds
o Understanding advanced dimension building concepts
o Calculating Analytic services databases
o Developing Formulas
o Developing Calculation Scripts
o Reviewing Examples of Calculation Scripts
o Understanding Report script basics
o Developing report scripts
o Managing Security for Users and Applications
o Using MaxL Data definition language
o Optimizing database restructuring
o Comparison of Aggregate Storage and Block Storage
Essbase Administrative Services (EAS)
Session IV
o Understanding Essbase Administrative Services
o Comparison of Aggregate and Block storage
o Aggregate storage Applications, Database, Outlines
o Loading, Calculating and Retrieving Aggregate Storage data
o Managing Aggregate Storage Application and Database
o Handling errors and Trouble shooting analytic services
Financial Reporting Studio / Interactive Reporting / Web Analysis
Session V
o Introduction to Financial Reporting Studio
o Configuring the Report Server
o Managing Security
o Introduction to Interactive Reporting
o Introduction to Web Analysis
Session VI
o Hyperion Planning
o Hyperion Business Rules
o Hyperion Application Link (HAL)
Contact:
Haritha
201-887-2351
essbasetrng@yahoo.com
