Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle Essbase - for System Administrators

( Duration: 5 Days )

The Oracle Essbase - for System Administrators training course will help you develop specific Essbase administrative skills so you are able to support the projects.

By attending Oracle Essbase - for System Administrators workshop, delegates will learn to:

  • 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

  • Knowledge of Oracle Essbase
  • General technical background
  • Basic system administration experience
This Oracle Essbase - for System Administrators class is intended for:
  • Administrators
  • Architects
  • Database Administrators
  • Developers

COURSE AGENDA

1

Online Analytical Processing Overview

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

Essbase architecture, components, and production cycle

  • Aggregate Storage and Block Storage
  • Outlines
  • Load Rules
  • Calculation Scripts
  • Aggregations
  • Reporting in Smart View
3

Block Storage Data Structure

  • Data Blocks and the Index System
  • Block Storage Database Statistics
  • Data Block Creation
  • Database Calculation Process
4

Aggregate Storage Data Structure

  • Table space Overview
  • Data Aggregation
  • Aggregate Storage Database Statistics
5

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
6

Essbase Data Integrity

  • Ensuring Essbase Data Integrity
  • Transactions and Locks
  • Isolation Levels
7

Essbase Security Overview

  • Essbase Native Security
  • Global Access Security Layer
  • User and Group Security Layer
  • Application Access Type Security
  • The Essbase Security File
8

Creating Essbase Security Filters

  • The Essbase Security Filter Layer
  • Creating Security Filters
  • Filter Behavior
  • Resolving Security Conflicts
9

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
10

Optimizing Block Storage Caches

  • Optimizing the Database
  • Optimizing Caches
  • Setting RAM Caches
  • Cache Hit Ratios
11

Optimizing Aggregate Storage Cache

  • Aggregate Storage Cache Optimization
  • Managing Aggregate Storage Cache
  • Viewing Aggregate Storage Cache Statistics
12

Optimizing Buffers and Compression

  • Setting Data Retrieval Buffers
  • Data Compression Methods
  • Setting the Optimal Compression Method
13

Managing Fragmentation

  • Measuring Database Fragmentation
  • Preventing and Reducing Database Fragmentation
  • Removing Security File Fragmentation
14

Managing Applications, Sessions, Usernames, and Passwords

  • About Application and Session Management
  • Migrating Applications and Databases
  • Enabling/Disabling Usernames in Administration Services Console
15

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
16

Task Automation

  • Automating Tasks Using MaxL
  • The MaxL Command Shell
  • MaxL Statements and Syntax
  • MaxL Username and Password Encryption
  • Debugging MaxL scripts

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X