Hyperion /
Essbase

Essbase

ESSBASE Online Training

What is ESSBASE

Essbase is widely considered to be the industry leading OLAP (On-Line Analytical Processing) server.Essbase is a multidimensional database management system(MDBMS). Essbase provides BI and EPM users the ability to quickly dissect and analyse data through an intuitive interface. Essbase end-users have multiple options for interacting with data including Microsoft Excel, Hyperion Financial Reporting and Hyperion Web Analysis. By bringing Essbase together with other Oracle applications, breaking down large datasets, working with best-case/worst-case scenarios, forecasting multi-line expenses, and reporting variance analysis is now at your fingertips. Essbase ultimately allows end-users to interact and analyse real-time data through an integrated, rapid-response, and secure environment.

Who is Eligible:

Any Graduates/Post Graduates are eligible.
Anyone having knowledge in Data Warehousing technologies.
Any technical background consultants are eligible to learn Hyperion Essbase Online Training.

  • 1

    Introduction to Hyperion Essbase

    20:56
  • 2

    What is the requirement of Essbase?

    20:56
  • 3

    History Of Essbase

    20:56
  • 4

    Hyperion Essbase Architecture

    20:56
  • 5

    Hyperion Essbase Versions

    20:56
  • 6

    Hyperion Essbase Clients

    20:56
  • 7

    Hyperion Essbase Clients

    20:56
  • 8

    EAS Thin Client

    20:56
  • 9

    EAS Thick Client

    20:56
  • 10

    Excel Add-In(Spread Sheet Services)

    20:56
  • 12

    MaxL or ESSCMD

    20:56
  • 13

    Essbase Interaction Services

    20:56
  • 14

    Essbase Studio

    20:56
  • 1

    BSO Application

    20:56
  • 2

    Business Requirement of BSO App

    20:56
  • 3

    ASO Application

    20:56
  • 4

    Business Requirement of ASO App

    20:56
  • 1

    Data/Meta Data Explanation

    20:56
  • 2

    What is Essbase Outline?

    20:56
  • 1

    What is Dimension?

    20:56
  • 2

    Standard Dimension

    20:56
  • 3

    Dense Dimension

    20:56
  • 4

    Sparse Dimension

    20:56
  • 5

    Attribute Dimension

    20:56
  • 1

    Account type Dimension

    20:56
  • 2

    Time type Dimension

    20:56
  • 3

    Currency Type Dimension

    20:56
  • 4

    Country Type Dimension

    20:56
  • 1

    Consolidation Properties

    20:56
  • 2

    Data Storage Properties

    20:56
  • 1

    What is the need of Attribute Dimension?

    20:56
  • 1

    What is the requirement of Alias and UDA’s?

    20:56
  • 1

    Generation Reference

    20:56
  • 2

    Level Reference

    20:56
  • 3

    Parent/Child Reference

    20:56
  • 1

    Data loading using flat files

    20:56
  • 2

    Data loading using SQL

    20:56
  • 3

    Free Form Loading

    20:56
  • 3

    Calculation Script

    20:56
  • 4

    Two-Pass Calculation

    20:56
  • 5

    Intelligent Calculation

    20:56
  • 1

    Implicit Restructure

    20:56
  • 2

    Dense Restructure

    20:56
  • 3

    Sparse Restructure

    20:56
  • 4

    Outline Restructure

    20:56
  • 5

    Explicit Restructure

    20:56
  • 2

    What is the requirement of Report Script

    20:56
  • 1

    What is the requirement of Partiton?

    20:56
  • 2

    Partition Types

    20:56
  • 3

    Replicated Partition

    20:56
  • 4

    Transparent Partition

    20:56
  • 5

    Linked Partition

    20:56
  • 1

    Outline Optimization

    20:56
  • 2

    Dataload Optimization

    20:56
  • 3

    Calculation Sript Optimization

    20:56
  • 4

    Database Optimization

    20:56
  • 1

    How to automate Essbase Tasks using MaxL?

    20:56
  • 2

    How to automate Essbase Tasks using ESSCMD?

    20:56
  • 1

    Requirement of ASO Apps?

    20:56
  • 2

    Hierarchy Types

    20:56
  • 3

    ASO DB Calculation Process

    20:56
  • 1

    BSO Advantages and Disadvantages

    20:56
  • 2

    ASO Advantages and Disadvantage

    20:56
  • 3

    Shared Service Security

    20:56
  • 4

    Creation of Users

    20:56
  • 5

    Creation of Groups

    20:56
  • 6

    Creation of Essbase Filters

    20:56
  • 7

    Assigning users to groups

    20:56
  • 8

    Creation of Essbase Filters

    20:56
  • 9

    Assigning filters to groupss

    20:56
  • 1

    Migration of App from DEV to QA/PROD

    20:56
  • 2

    Essbase Artifacts Backups

    20:56
N/A