Hyperion Tutorial

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

Hyperion Essbase Overview

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

Essbase - 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 metadatadriven 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 few more articles to get you acquainted with our Hyperion training. We’ll cover this in-depth in our Hyperion Essbase online training.


Get Updates on Tech posts, Interview & Certification questions and training schedules