Hyperion System 9 BI+ Analytic Services for System Administrators

Configuring the Essbase Environment

• Licensing Overview
• Essbase Architecture
• Essbase Data Storage and Data Management Processes
• Configuring Essbase to Run as a Service
• Setting Connection Options and Disk Allocation
• Transaction and Locking Behavior
• Gathering System Information Through Logs
• Creating an Essbase Server Configuration File
• Estimating Disk Requirements

Securing the Essbase Environment

• Security Layers
• Security Roles and Permissions
• Creating User and Group Profiles
• Application Access Type Security
• Creating and Testing Security Filters
• Resolving Security Conflicts and Permission Overlap

Securing the Essbase Environment in Shared Services

• Shared Services Security
• Coverting Analytic Services Security to Shared Services
• Managing Users in Shared Services
• Provisioning Users in Shared Services
• External Authentication
• Single Sign-on

Optimizing the Essbase Environment

• Setting RAM Caches for Optimal Performance
• Specifying Retrieval Buffers and Data Compression
• Using the Calculator Cache
• Removing Database Fragmentation
• Restructuring Databases
• Removing Security File Fragmentation

Maintaining the Essbase Environment

• Backing Up and Recovering the Essbase Database
• Managing Object Locks and User Sessions
• Migrating Applications and Databases
• Porting Applications Across Platforms
• Automating Database Processes with MaxL and Esscmd

Case Study: Optimizing a Database

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.