ERP Products Other Products Virtual Classroom


paypal verified
paypal cartes de crédit

Oracle Essbase 11.1.1 for System Administrators

Oracle Essbase 11.1.1 for System Administrators

Now you can study at home by your self and
get certified.

The tests are based directly from the information from these books

What you will learn:

The typical Essbase project is a high visibility, high priority development project designed to enhance bottom line performance. Strong Essbase administrative skills are essential in supporting these projects.

Learn how to configure, secure, optimize, and maintain the Essbase environment for both block storage and aggregate storage applications. Whether you are a new or seasoned Essbase user, you will benefit from the Essbase experience and best practices built into the lectures, student guide, numerous exercises, and case study, and this course will prove to be a valuable addition to your administrator’s survival kit.

Learn To:

Design and manage Essbase security
Optimize Essbase system caches
Perform backup, recovery, application migration, and task automation
Configure the block storage and aggregate storage kernels

Course Objectives:

Configure the Essbase environment
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
Automate routine tasks using MaxL scripts

Course Topics:

Online Analytical Processing Overview
Data Transformation
Multidimensional View of Information
Dimensional Modeling
Data Cubes
Dimension Hierarchies
OLAP Solutions
Essbase architecture, components, and production cycle
Load Rules
Calculation Scripts
Essbase Integration Services
Essbase Spreadsheet Add-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
Tablespace Overview
Data Aggregation
Aggregate Storage Database Statistics
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
Creating an essbase.cfg (server configuration) file
Configuring Smart View for Office
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
Synchronizing Essbase and Shared Services Security
External Authentication and Single Sign-on
Optimizing Block Storage Cache Settings
Optimizing the Database
Optimizing Caches
Setting RAM Caches
Cache Hit Ratios
Optimizing Aggregate Storage Cache Settings
Aggregate Storage Cache Optimization
Managing Aggregate Storage Cache
Viewing Aggregate Storage Cache Statistics
Optimizing Buffers, Compression, and Fragmentation
Setting Data Retrieval Buffers
Data Compression Methods
Setting the Optimal Compression Method
Removing Database Fragmentation
Removing Security File Fragmentation
Managing Applications and Sessions
About Application and Session Management
Migrating Applications and Databases
Backing Up and Recovering Essbase Databases
About Backup and Recovery
Backup Options
Export Considerations
Subset Data Export Capability
Database Recovery
Task Automation
Automating Tasks Using MaxL
The MaxL Command Shell
MaxL Statements and Syntax
MaxL Username and Password Encryption
Debugging MaxL scripts


Shipping is free IMMEDIATE DOWNLOAD AFTER PAYMENT .Receive a direct download link in your email in 1 - 3 minutes.

[Do NOT forget to check the junk or Spam mails of your email box]

29.99 $

Enter promotionnal code:

Terms & Policy

Website hosting and design by       admin