Oracle Essbase 11.1.1 for System Administrators Training  

Online Analytical Processing Overview

• Data Transformation
• Multidimensional View of Information
• Dimensional Modeling
• Data Cubes
• Dimension Hierarchies
• OLAP Solutions

Essbase architecture, components, and production cycle

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