Oracle Essbase 11.1.2 for System Administrators Ed 1

Download Course Contents

Oracle Essbase 11.1.2 for System Administrators Ed 1 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

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • • View video
  • • The course will be free if we are not able to start within 7 days of booking.
  • • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Online Analytical Processing Overview
  • Data Transformation
  • Multidimensional View of Information
  • Dimensional Modeling
  • Data Cubes
  • Dimension Hierarchies
  • OLAP Solutions
  • Aggregate Storage and Block Storage
  • Outlines
  • Load Rules
  • Calculation Scripts
  • Aggregations
  • Reporting in Smart View
  • Data Blocks and the Index System
  • Block Storage Database Statistics
  • Data Block Creation
  • Database Calculation Process
  • Table space Overview
  • Data Aggregation
  • Aggregate Storage Database Statistics
  • 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
  • Ensuring Essbase Data Integrity
  • Transactions and Locks
  • Isolation Levels
  • Essbase Native Security
  • Global Access Security Layer
  • User and Group Security Layer
  • Application Access Type Security
  • The Essbase Security File
  • The Essbase Security Filter Layer
  • Creating Security Filters
  • Filter Behavior
  • Resolving Security Conflicts
  • Shared Services Security
  • Converting Essbase Users to Shared Services Security
  • Provisioning Users in Shared Services
  • External Authentication and Single Sign-on
  • Optimizing the Database
  • Optimizing Caches
  • Setting RAM Caches
  • Cache Hit Ratios
  • Aggregate Storage Cache Optimization
  • Managing Aggregate Storage Cache
  • Viewing Aggregate Storage Cache Statistics
  • Setting Data Retrieval Buffers
  • Data Compression Methods
  • Setting the Optimal Compression Method
  • Measuring Database Fragmentation
  • Preventing and Reducing Database Fragmentation
  • Removing Security File Fragmentation
  • About Application and Session Management
  • Migrating Applications and Databases
  • Enabling/Disabling Usernames in Administration Services Console
  • 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
  • Automating Tasks Using MaxL
  • The MaxL Command Shell
  • MaxL Statements and Syntax
  • MaxL Username and Password Encryption
  • Debugging MaxL scripts
Live Online Training (Duration : 24 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 24 hours. We can offer you an Ultra-Fast Track for 12 hours

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

Trending Technologies

 Cloud Computing
 Security
 Fundamentals
 Cloud Management
 CRM
 Cloud Architect
 Cloud Administration
 Data Analytics
 DevOps
 Virtualization

Request More Information

Add Name and Email Address of participant (If different from you)

Privacy Policy

FAQ's

Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Oracle Learning Partner