Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Hyperion Essbase & PBCS training

No Reviews Yet

Course type: Online Instructor led Course


Course ID: 42062

Course type: Online Instructor led Course


Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

Oracle Essbase and Planning and Budgeting Cloud Service Training

An Introduction to Multi-Dimensional Database

  • Understating Multi Dimensional Database concepts

  • Dimensional Modeling Concepts

  • Dimension and Fact

  • Dimension Hierarchy

  • Confirm Dimension

  • Full and Semi additive Measure

  • Star Schema, Snowflake schema and galaxy model

  • Operation on Multidimensional database

Essbase Overview

  • Essbase

  • Production Environment Components

Designing Applications and Databases

  • Essbase Implementation Process

  • Analyzing and Planning Implementations

  • Creating Applications and Databases

Creating Outlines

  • Data Descriptor Dimensions Overview

  • Designing Time Dimensions

  • Designing Scenario Dimensions

  • Outline Calculations

  • Designing Accounts Dimensions

  • Testing Outline Calculations

  • Creating Member Aliases

  • Dimension Types

  • Creating Period-to-Date Totals

  • Dynamic Calc Members

  • Enhancing Accounts Dimensions

  • Optimizing Data Storage

  • Attribute Dimensions Overview

  • Adding Attribute Dimensions to Outlines

  • Design ConsiderationsÃ? 

Creating Basic & Advance Dimension Build Rules Files

  • Rules Files Overview

  • Creating Dimension Build Rules Files

  • Configuring Dimension Maintenance Settings

  • Advanced Dimension Build Rules Files Overview

  • Creating Shared Members

  • Manipulating Fields

  • Creating User-Defined Attributes

  • Creating Attribute Dimensions with Rules Files

Loading Data

  • Data Load Overview

  • Free form Data Loading

  • Data Loading using Rule file

  • Creating Data Load Rules Files

  • Selecting and Rejecting Records

  • Capturing New Members

Working with Essbase Integration Service

  • Creating OLAP Model and Meta-outline

  • Loading Metadata and Data using Oracle Database

  • Working with Drill through reports

Working with Essbase Studio.

  • Essbase Studio Deployment Architecture

  • Data Source Connections

  • Metadata Elements and Alias Sets

  • Working with Minischemas

  • Hierarchies

  • Cube Schemas

  • Essbase Models

Working with Essbase Spreadsheet client

  • Configuring Essbase Spread sheet client

  • Understanding various Essbase Client Options

  • Writing Queries, Member selections, Drill Down, Drill Up, Keep only remover only etc

Data Storage and Calculation

  • Calculation Overview

  • Database Calculation Order

  • Data Block Fundamentals

  • Data Blocks and the Index System

  • Interpreting Database Statistics

  • Data Block Creation

  • Database Calculation ProcessÃ? 

Creating Calculation Scripts

  • Calculation Script Organization

  • Returning Correct Calculation Results

  • Troubleshooting CALC DIM Processes

  • Top-Down Calculation

  • Focusing Calculations with FIX Statements

  • Calculating Conditionally with IF Statements

  • Performance Considerations

  • Referencing Members Dynamically

  • Creating Calculation Variables

  • Developing and Testing Complex Calculation Scripts

  • Implementing a Script Development Process

  • Upper-Level Data Loads

  • Intelligent Calculation

Essbase Security Overview

  • Essbase Native Security

  • Global Access Security Layer

  • User and Group Security Layer

  • Application Access Type Security

  • The Essbase Security File

Optimizing Block Storage Caches

  • Optimizing the Database

  • Optimizing Caches

  • Setting RAM Caches

  • Cache Hit Ratios

Essbase Automation using MaxL

  • Understand MaxL script structure.

  • Automate Metadata, Data Load Process

  • Automate Calculation and consolidation process

  • Automate Data Export Using Report Script and Data Export Command

Essbase Optimization and Memory management� 

  • Optimizing the Database

  • Optimizing Caches

  • Setting RAM Caches

  • Cache Hit Ratios

Analyzing Text and Dates

  • Typed Measures Overview

  • Enabling Typed Measures

  • Creating Text Measures

  • Creating Date Measures

  • Viewing Typed Measures

  • Calculations Based on Typed Measures

Hyperion Planning

  • Hyperion Planning Overview

  • Creating Hyperion Planning Classic Application and EPMA Application Part I

  • Creating Hyperion Planning Classic Application and EPMA Application Part II

  • Dimension Overview and their properties

  • Loading Data and Calculate the Database

  • Setting up Security

  • Desigining Data Form

  • Entering Data in Data Form

  • Migrating Planning using LCM Ulitility[Setting Up Application Setting]

  • Creating Planning Task List

  • Planning Process Management

  • Working with Business Rule

Aggregate Storage Overview

  • Aggregate storage key characteristics and design considerations

  • Key differences between ASO and BSO design

  • Understanding the aggregate storage production cycle

  • Creating aggregate storage outline hierarchies

  • Loading Data

Getting Started with Smart View

  • Navigating Smart View

  • Connecting to Data Sources

  • Creating Ad Hoc Grids

  • Setting the Point of View

  • Associating Data Sources with Worksheets

  • Creating Free-Form Grids

Creating Reports with Smart View

  • Updating Essbase Data

  • Integrating Essbase Data with Microsoft Office

  • Creating Shared Database Perspectives

  • Creating Custom Reports

Get started using Oracle Planning and Budgeting Cloud

  • Use Oracle Planning and Budgeting Cloud to complete the business budgeting and forecasting process

  • Configure, test and maintain the components of a Planning application

  • Set up the Planning application with dimensions, aliases, currencies and time periods

  • Set up Planning and Budgeting scenarios and versions

  • Load metadata and data

  • Implement security and manage users

  • Implement business rules and processes

  • Manage the approval process, which includes moving a plan through the budget review-and-approval process

  • Create and enhance forms for user input

Date and Time

Not decided yet.

About the Trainer

Sathish picture

Avg Rating

0 Reviews

1 Students

2 Courses

8 Years of experience in PeopleSoft.


No reviews currently Be the First to Review


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Hyperion Essbase Training Post your requirement now


Submit your enquiry for Hyperion Essbase & PBCS training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Hitendra

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more