Oracle Essbase 11.1.2 for System Administrators

Prerequisiti obbligatori:

• General technical background
• Basic system administration experience

Prerequisiti suggeriti :

• Oracle Essbase 11.1.2 Bootcamp

Recommended Related Training Courses:

Hyperion Web Analysis 11.1.2: Design Reports

This Hyperion Web Analysis 11.1.2: Design Reports training teaches you how to create, manipulate and maintain Web Analysis documents. Though hands-on exercises, you’ll learn how to do so in Workspace and Web Analysis Studio.

Hyperion Reporting & Analysis 11.1.2 Administration

In this course, you learn the architecture and tasks required to install, configure, and administer Reporting and Analysis for EPM System. You also learn how to install and configure Essbase. Exercises help you practice the skills taught.

Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases

This course shows you how to design, develop and deploy aggregate storage (ASO) databases in Oracle Essbase. An essential course for ASO developers.

Oracle Essbase 11.1.2: Calculate Block Storage Databases

Learn to develop calculations for Essbase 11.1.2 block storage databases. This course is an important step toward success as an Essbase professional. It is designed to give you a firm foundation in basic database structure and calculation. 

* This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1 or Oracle Essbase 11.1.1.

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3)

This Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training teaches you how to develop calculations for Essbase 11.1.2.3 block storage databases. It's designed to give you a firm foundation in basic database structure and calculation.

Il corso è rivolto a:

• Amministratore di database
• Sviluppatori di applicazioni

The typical Essbase project is a high visibility, high priority development project designed to enhance bottom line performance. This 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.
• Learn Essbase Survival Skills

Whether you're a new or seasoned Essbase user, you'll benefit from the Essbase experience and best practices built into the lectures, student guide, numerous exercises and case study. This course will prove to be a valuable addition to your administrator's survival kit.

Objectives:

• 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

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

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