Essbase for System Administrators training will teah you to configure, secure, optimize & maintain the Essbase environment for block storage. Learn to aggregate storage applications and maintain databases, including backup, recovery and more.
Preview
By the end of this training you will learn to:
- Perform backup, recovery, application migration and task automation.
- Optimize Essbase system caches.
- Configure the block storage and aggregate storage kernels.
- Design and manage Essbase security.
- Configure, secure, optimize and maintain the Essbase environment for both block storage and aggregate storage applications.
Course Contents
Day 1
Online Analytical Processing Overview
Data Transformation
Multidimensional View of Information
Dimensional Modeling
Data Cubes
Dimension Hierarchies
OLAP Solutions
Essbase architecture, components, and production cycle
Aggregate Storage and Block Storage
Outlines
Load Rules
Calculation Scripts
Aggregations
Reporting in Smart View
Block Storage Data Structure
Data Blocks and the Index System
Block Storage Database Statistics
Data Block Creation
Database Calculation Process
Aggregate Storage Data Structure
Table space Overview
Data Aggregation
Aggregate Storage Database Statistics
Day 2
Configuring Essbase Servers
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
Essbase Data Integrity
Ensuring Essbase Data Integrity
Transactions and Locks
Isolation Levels
Essbase Security Overview
Essbase Native Security
Global Access Security Layer
User and Group Security Layer
Application Access Type Security
The Essbase Security File
Creating Essbase Security Filters
The Essbase Security Filter Layer
Creating Security Filters
Filter Behavior
Resolving Security Conflicts
Day 3
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 Block Storage Caches
Optimizing the Database
Optimizing Caches
Setting RAM Caches
Cache Hit Ratios
Optimizing Aggregate Storage Cache
Aggregate Storage Cache Optimization
Managing Aggregate Storage Cache
Viewing Aggregate Storage Cache Statistics
Optimizing Buffers and Compression
Setting Data Retrieval Buffers
Data Compression Methods
Setting the Optimal Compression Method
Day 4
Managing Fragmentation
Measuring Database Fragmentation
Preventing and Reducing Database Fragmentation
Removing Security File Fragmentation
Managing Applications, Sessions, Usernames, and Passwords
About Application and Session Management
Migrating Applications and Databases
Enabling/Disabling Usernames in Administration Services Console
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
Task Automation
Automating Tasks Using MaxL
The MaxL Command Shell
MaxL Statements and Syntax
MaxL Username and Password Encryption
Debugging MaxL scripts