A Day as Essbase Administrator Online Analytical Processing Overview
- Data Transformation
- Multidimensional View of Information
- Dimensional Modeling
- Data Cubes
- Dimension Hierarchies
- OLAP Solutions
Aggregate Storage Data Structure
- Table space Overview
- Data Aggregation
- Aggregate Storage Database Statistics
Essbase Security Overview
- Essbase Native Security
- Global Access Security Layer
- User and Group Security Layer
- Application Access Type Security
- The Essbase Security File
Optimizing Block Storage Caches
- Optimizing the Database
- Optimizing Caches
- Setting RAM Caches
- Cache Hit Ratios
Managing Fragmentation
- Measuring Database Fragmentation
- Preventing and Reducing Database Fragmentation
- Removing Security File Fragmentation
Task Automation
- Automating Tasks Using MaxL
- The MaxL Command Shell
- MaxL Statements and Syntax
- MaxL Username and Password Encryption
- Debugging MaxL scripts
Essbase architecture, components, and production cycle
- Aggregate Storage and Block Storage
- Outlines
- Load Rules
- Calculation Scripts
- Aggregations
- Reporting in Smart View
Configuring Essbase Servers in distributed environment
- Setting up runtime and connection options for Essbase
- Configuring block storage and aggregate storage disk allocation
- Identifying the primary information logs available to Essbase system administrators
- Maintaining the Essbase Server configuration file
Creating Essbase Security Filters
- The Essbase Security Filter Layer
- Creating Security Filters
- Filter Behavior
- Resolving Security Conflicts
Optimizing Aggregate Storage Cache
- Aggregate Storage Cache Optimization
- Managing Aggregate Storage Cache
- Viewing Aggregate Storage Cache Statistics
Managing Applications, Sessions, Usernames, and Passwords
- About Application and Session Management
- Migrating Applications and Databases
- Enabling/Disabling Usernames in Administration Services Console
Applying Path in Essbase
- Essbase Multiple Server Environment
- An introduction to Perl Script for Essbase Developer
Block Storage Data Structure
- Data Blocks and the Index System
- Block Storage Database Statistics
- Data Block Creation
- Database Calculation Process
Essbase Data Integrity
- Ensuring Essbase Data Integrity
- Transactions and Locks
- Isolation Levels
Securing the Essbase Environment in Shared Services
- Shared Services Security
- Converting Essbase Users to Shared Services Security
- Provisioning Users in Shared Services
- External Authentication and Single Sign-on
Optimizing Buffers and Compression
- Setting Data Retrieval Buffers
- Data Compression Methods
- Setting the Optimal Compression Method
Backing Up, Restoring, and Recovering Essbase Databases
- About Backup, Restore, and Recovery
- Manual Backup and Restore
- Automated Backup and Restore
- Manual Recovery
- Automated Recovery
- Recovering from a Server Interruption
- Recovering Corrupted Essbase Databases
Planning Administration
Configuring Planning
- Configuring Planning
- Installing and Configuring Offline Planning
Accessing Planning
- Verifying the Installation
- Starting Services
- Logging on to Workspace
- Creating and Deploying Applications
- Provisioning Users and Groups
- Configuring Smart View
- Accessing Planning Applications
- Testing Report Connectivity
Switching Application Modes
- Application Upgrade Wizard
- Switching Classic Applications to Performance Management Architect Applications
- Switching Performance Management Architect Applications to Classic Applications
Performing System Maintenance
- Backup and Recovery Overview
- Backing Up Databases and File Systems
- Backing Up Windows Registry Settings
- Backing Up and Recovering EPM System Products
- Managing EPM System Log Files