Oracle Essbase 11.1.2 for System Administrators Ed 1

Oracle Essbase 11.1.2 for System Administrators Ed 1 Certification Training Course Overview

Oracle Essbase 11.1.2 for System Administrators training course is designed for System Administrators to learn how to configure, secure, optimize & maintain the Essbase environment for block storage and how to aggregate storage applications and maintain databases, including backup, recovery and more.

Target Audience:

  • Administrator
  • Architect
  • Database Administrator
  • Developer

Oracle Essbase 11.1.2 for System Administrators Ed 1 (24 Hours) Download Course Contents

Live Virtual Classroom Fee For Both Group Training & 1-on-1 Training On Request
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Online Analytical Processing Overview
  • Data Transformation
  • Multidimensional View of Information
  • Dimensional Modeling
  • Data Cubes
  • Dimension Hierarchies
  • OLAP Solutions
Module 2: Essbase architecture, components, and production cycle
  • Aggregate Storage and Block Storage
  • Outlines
  • Load Rules
  • Calculation Scripts
  • Aggregations
  • Reporting in Smart View
Module 3: Block Storage Data Structure
  • Data Blocks and the Index System
  • Block Storage Database Statistics
  • Data Block Creation
  • Database Calculation Process
Module 4: Aggregate Storage Data Structure
  • Table space Overview
  • Data Aggregation
  • Aggregate Storage Database Statistics
Module 5: Configuring Essbase Server
  • 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
Module 6: Essbase Data Integrity
  • Ensuring Essbase Data Integrity
  • Transactions and Locks
  • Isolation Levels
Module 7: Essbase Security Overview
  • Essbase Native Security
  • Global Access Security Layer
  • User and Group Security Layer
  • Application Access Type Security
  • The Essbase Security File
Module 8: Creating Essbase Security Filters
  • The Essbase Security Filter Layer
  • Creating Security Filters
  • Filter Behavior
  • Resolving Security Conflicts
Module 9: 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
Module 10: Optimizing Block Storage Caches
  • Optimizing the Database
  • Optimizing Caches
  • Setting RAM Caches
  • Cache Hit Ratios
Module 11: Optimizing Aggregate Storage Cache
  • Aggregate Storage Cache Optimization
  • Managing Aggregate Storage Cache
  • Viewing Aggregate Storage Cache Statistics
Module 12: Optimizing Buffers and Compression
  • Setting Data Retrieval Buffers
  • Data Compression Methods
  • Setting the Optimal Compression Method
Module 13: Managing Fragmentation
  • Measuring Database Fragmentation
  • Preventing and Reducing Database Fragmentation
  • Removing Security File Fragmentation
Module 14: Managing Applications, Sessions, Usernames, and Passwords
  • About Application and Session Management
  • Migrating Applications and Databases
  • Enabling/Disabling Usernames in Administration Services Console
Module 15: 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
Module 16: Task Automation
  • Automating Tasks Using MaxL
  • The MaxL Command Shell
  • MaxL Statements and Syntax
  • MaxL Username and Password Encryption
  • Debugging MaxL scripts
Download Course Contents

Request More Information

Course Prerequisites
  • General technical background
  • Basic system administration experience
  • Set up user, group, and application access type security
  • Create database filters
  • Describe the components of the Oracle Essbase product family
  • Optimize Essbase caches and buffers
  • Perform database maintenance, including backup and recovery and application migration
  • Configure the Essbase environment
  • Automate routine tasks using MaxL scripts