Home / Hyperion DRM

Hyperion Tutorial

Rating: 5.0Blog-star
Views: 8399
by Ravindra Savaram
Last modified: April 27th 2021

This tutorial gives you an overview and talks about the fundamentals of Hyperion.

Hyperion Tutorial - List of Contents

Hyperion Essbase Overview

Essbase products incorporate powerful architectural features to handle a wide range of analytic applications across large multi-user environments.

If you want to enrich your career and become a professional in Hyperion, then visit Mindmajix - a global online training platform: "Hyperion Training" This course will help you to achieve excellence in this domain. 


A multi-threaded OLAP database software that takes advantage of symmetric multiprocessing hardware platforms - is based on Web-deployable, thin-client architecture. The server acts as a shared resource, handling all data storage, caching, calculations, and data security. The Essbase Server client needs only to retrieve and view data that resides on a server.

Aggregate storage databases provide an alternative to block storage databases and enable dramatic increases in database dimensionality. Using aggregate storage, Essbase serves a wide range of analytic needs - financial analysis, planning, budgeting, sales analysis, marketing analysis, supply-chain analysis, profitability analytics - all from a single analytic infrastructure.

Administration Services

The database and system administrators’ interface to Essbase - provides a single-point-of-access console to multiple Essbase Servers. Using Administration Services, you can design, develop, maintain, and manage multiple Essbase Servers, applications, and databases.

You can preview data from within the console without having to open a client application, such as Spreadsheet Add-in. You can also use custom Java plug-ins to leverage and extend key functionality.

A single common metadata repository, or catalog, captures all metadata related to all Essbase applications built in the enterprise and allows the reuse of metadata at the lowest level of granularity. The catalog makes Essbase Studio inherently aware of the common metadata that is shared across the various applications enterprise-wide.

Oracle Essbase Integration Services

An optional product component - provides a metadata-driven environment to bridge the gap between data stored in Essbase databases and detailed data stored in relational databases. The Hybrid Analysis feature gives business users more detail for decision-making and IT managers more modularity in designing and maintaining large-scale analytic applications.

Hybrid Analysis allows portions of Essbase databases to be stored in a relational database. This relational-stored data is mapped to the appropriate Essbase hierarchies.

We have compiled a few more articles to get you acquainted with our Hyperion training. We’ll cover this in-depth in our Hyperion Essbase online training.

Frequently asked Hyperion Interview Questions

About Author

NameRavindra Savaram
Author Bio


Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.