Oracle Essbase 11.1.2 for System Administrators Training

Oracle Essbase 11.1.2 for System Administrators Training (HY-EB-SYST-ADM)


Oracle Essbase 11.1.2 for System Administrators Training Course with labs

The typical Essbase project is a high visibility, high priority development project designed to enhance bottom line performance. This Oracle Essbase 11.1.2 for System Administrators Training course will help you develop specific Essbase administrative skills so you're able to support these projects.

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.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

● Administrator
● Application Developers
● Database Administrators
● Database Designers
● Security Administrators

Oracle Essbase 11.1.2 for System Administrators Training (HY-EB-SYST-ADM)Related Courses:

Duration: 3 days

Class Prerequisites:

● General technical background
● Oracle Essbase 11.1.2 Bootcamp
● Basic system administration experience

Skills Gained:

● 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

Course Content:

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
Load Rules
Calculation Scripts
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

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

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

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

Request More Information

Time Frame: 0-3 Months4-12 Months

Print Friendly, PDF & Email