Hyperion System 9 BI+ Enterprise Analytics: Deploy Aggregate Storage Databases (for version 9.0)
NOTE: This course covers the same content as the Hyperion Essbase 7X New Features course.

• Define Aggregate Storage Option
• Differentiate between aggregate storage and block storage databases
• Describe at a high level the new Essbase features of aggregate storage, MaxL Data Manipulation Language (MDX) and Hyperion Visual Explorer

• Create an aggregate storage database from scratch
• Create an aggregate storage database from an existing block storage database
• Describe dimension load processes for aggregate storage databases
• List dimension and member properties in aggregate storage models

• Define the different partition types
• Describe the characteristics of partition models
• Create transparent, replicated and linked partitions

• Compare partitioning needs in aggregate storage to block storage
• Implement partitioning for aggregate and block storage databases manually
• Implement partitioning for aggregate storage databases with the partition wizard

• Explain the aggregate storage data load process
• Perform aggregate storage data loads using different methods
• Apply the Aggregate Design Wizard for calculation and data storage
• Retrieve data with Hyperion Visual Explorer

• Manage tablespaces and storage caches
• Optimize outline paging
• Identify security considerations
• Explain database statistics
• Recognize files for back-up

• Define MDX
• Identify MDX function types and basic language elements
• List available and required query elements

• Create MDX queries
• Reference member properties in queries
• Identify MDX function return types

• Indicate the presence of calculated members in a query
• Identify syntax of basic MDX calculation functions
• Perform conditional tests in calculations

• Differentiate between the fundamental elements of calculation language and MDX language
• Translate calculation language to MDX
• Comprehend the guidelines and steps for translating calculation language and formulae to MDX

• Create Account member formulae in an aggregate storage database using the formula editor
• Write basic MDX member formulae
• Write formulae that reference ancestral values
• Write formulae that perform conditional tests

• Write member formulae containing dynamic ranges
• Reference attribute values for calculation purposes
• Allocate data values in member formulae
• Implement dynamic time series and variance reporting calculations

For general training questions or to schedule classroom training, please contact Hyperion Education Support at 203-703-3535 or via education@hyperion.com.

MTG's Training Center is based in the New York Information Technology Center in the heart of New York's Financial District.  For information about convenient local transportation, lodging, and business services, please contact us at 212-824-2900 or info@mtgny.com.