Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4

This Oracle Essbase 11 course is designed for Essbase Administrators and provides excellent Hands-on training in Oracle Essbase 11.

Course Outline

This Oracle Essbase 11 course is designed for Essbase Administrators and provides excellent Hands-on training in Oracle Essbase 11. The course provides detailed description of Essbase 11 Server, Web Tier and Client Components and how to configure them using Oracle EPM System. Students will learn to use Essbase Administration Console (EAS) to create Block Storage (BSO) and Aggregate Storage (ASO) Applications and Databases. Students will learn to build Essbase Outlines, Build Rule Files and perform Loading Data for BSO and ASO databases. Students will integrate Spread Sheet Add-in and Smart View for Office components with Essbase database server and perform analysis of data. Students will also learn to create and use Calc scripts for BSO calculations and use MDX for ASO Calcualtions. This course also teaches about Sharing Data, Using Partitions and how to use Essbase MAXL Command Line Interface.


At the end of this course, students will be able to:
  • Understand the Architecture of Essbase 11 (Clients, Web Tier and Database Tier)
  • Configure Essbase Server, Middleware and Clients in Oracle EPM System
  • Use Essbase Administration Console (EAS)
  • Create BSO and ASO Applications and Databases
  • Build Essbase Outlines for ASO and BSO Databases
  • Build Dimension Rule Files and Data Load Rule Files Load Data from different Data Sources
  • Integrate Smart View for Office with Essbase Servers Use Smart View for Office and Spreadsheet Add in Components to Analyze Data
  • Create and Use Calculation Scripts for BSO Database Use MDX to perform ASO Calculations
  • Understand Sharing Data and Partitions Use MAXL Command Line Interface
  • Essbase Overview
  • Designing Applications and Databases
  • Common Dimensions
  • Essbase Outline for ASO and BSO Databases
  • Attributes Dimensions
  • BSO Database Features
  • Dimension Build Rule Files I
  • Dimension Build Rule Files II
  • Loading Data
  • Database Administrators
  • Business Intelligence (BI) Developers
  • Essbase Analysts, Developers and Administrators
  • BI Professionals
Course Outline

I. Essbase Overview

A. Multidimensional Analysis
B. Dimensional Modeling Overview
C. Oracle Enterprise Performance Management (EPM) System
D. Oracle EPM Overview
E. Oracle EPM Components
F. Essbase Database Servers
G. Essbase Middle Tier Components
H. Essbase Clients
I. Essbase Administration Console (EAS)

II. Designing Applications and Databases
A. Essbase Analytic Implementation Process
B. Block Storage Implementation Process
C. Analysis and Planning of Implementations
D. Creating Block Storage Applications
E. Creating Block Storage Databases
F. Creating Aggregate Storage Applications
G. Creating Aggregate Storage Databases
H. Creating Outline Structures
I. Dimensions and Members
J. Modifying Member properties
K. BSO Vs ASO Databases

III. Common Dimensions
A. Data Descriptors Dimensions Overview
B. Time Dimensions
C. Measures
D. Scenario Dimensions
E. Tracking Data Sets and Processes
F. Outline Calculations
G. Account Dimensions
H. Testing Outline Calculations

IV. Essbase Outline for ASO and BSO Databases
A. Creating Members
B. Dimension Types
C. Account Dimensions
D. Consolidation Operators
E. Data Storage Property
F. Member Types
G. Member Formulae
H. Time Balance Attributes
I. Aggregate Storage Hierarchies
J. User Defined Attributes
K. Alternate Hierarchies
L. Alternate Hierarchy Rules for ASO Databases
M. Alternate Hierarchy Rules for BSO Databases

V. Attributes Dimensions
A. Attribute Dimensions Overview
B. Attribute Dimensions Types
C. Create an Attribute Dimension
D. Adding Attribute Dimensions to Outlines
E. Attribute Dimension Rules for ASO Databases
F. Attribute Dimension Rules for BSO Databases
G. Design Considerations

VI. BSO Database Features
A. Expense Reporting
B. Dynamic Time Series (DTS)
C. Varying Attributes Dimensions
D. Creating Varying Attributes
E. Viewing Varying Attributes Data
F. Dense and Parse Dimensions
G. Block Structure
H. Outline Consolidation
I. Default Calc

VII. Dimension Build Rule Files I
A. Dimension Build Rule Files Overview
B. Parent-Child Build Method
C. Generation Build Method
D. Level Build Method
E. Using Data Prep Editor
F. Creating Dimension Build Rules Files
G. Configuring Data Source Properties
H. Configuring Dimension Build Settings
I. Perform Dimension Build

VIII. Dimension Build Rule Files II
A. Dynamically Build Alternate Hierarchies
B. Dynamically Assign Member Properties
C. Valid Codes for ASO Databases
D. Valid Codes for BSO Databases
E. Rules files for Attribute Dimensions
F. Select/Reject Records
G. Create Columns Using Text or Join
H. Print a Rule File
I. Configure SQL Datasources

IX. Loading Data
A. Data Load Overview
B. Data Sources
C. Data Load Rules Overview
D. Creating Data Load Rules Files
E. Selecting and Rejecting Records
F. Capturing New Members
G. Load Data

Prerequisites & Certificates

- Working Knowledge of Business Intelligence/Data Warehouse - Basic Knowledge of Spread Sheets and Databases

Certificates offered

Certificate of Completion

Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
Map & Reviews
Protech Training
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I took the training remotely so I cannot comment on some of the questions. I think that this seminar has too much content to squeeze it into one week.... might be better as a two week course?
Reviewed by 2013
found the material very helpful - although there was a lot of material covered - the pace was well set. Would definitely recommend people to have explored Microsoft Access beforehand to be familiarized with the program before taking the course. I would imagine someone without any exposure would find it confusing. Environment really good - people very, very nice and helpful. Would definitely take the next level of access with the same training facility.
Reviewed by 2013
I was not in the physical classroom. Feedback centered around online training would be good because now I have to rate items that I was not present for. Those items are getting half a star because I was not there to rate them. The course material must go through an editing process. There are a lot of grammar mistakes, but also a lot of actual procedure/activity mistakes.
Reviewed by 2012

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 201 times.