Hyperion Essbase

Oracle's Hyperion Essbase (Essbase) is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications.

With a rapid application development environment, Essbase enables business users to quickly model complex business scenarios. Aside from its high scalability, a key strength of Essbase lies in its ability to allow users to "write back" to an application's data repository under security. This makes it ideal for developing forward looking applications such as forecasting, scenario modeling, and "what if" type analysis.

With Essbase, organizations define a dimensional view of their business—and provide business users with new levels of self-sufficiency to access, navigate, and gain actionable insight into critical business issues. All of this through the various end-user tools for Essbase.
For example, Hyperion Smart View for Office (Excel, PowerPoint, Word, Outlook), Hyperion Visual Explorer, and several modules of Oracle BI Suite Enterprise Edition Plus, such as Hyperion Interactive Reporting, Hyperion Web Analysis, Hyperion Financial Reporting, are some of the various Oracle tools that enable users to interact with an Essbase application.

Essbase provides adaptable data storage mechanisms for specific types of analytic and performance management applications, thereby ensuring sub-second response times regardless of the complexity of the analytics. For example, Block data storage option (BSO) enables driver-based scenario modeling, forecasting, and predictive analytic applications. Aggregate data storage option (ASO) is optimized for massive sparse data sets, supporting thousands of concurrent business users performing sophisticated analyses at the speed of thought.

Products / Options
Hyperion Essbase Administration Services
Hyperion Essbase Integration Services
Hyperion Essbase Provider Services
Hyperion Essbase Visual Explorer

What's New
Release 9.3 Highlights
Supports dates as first class objects
Time dimension wizard automates creation of time dimension hierarchies within Essbase ASO databases
Out of the box support for five predefined calendars: Gregorian, Manufacturing, ISO 8601, Fiscal, Retail
Supports query hints for frequently used queries
MDX optimizations:
  • New functions enhance string processing
  • Handling formulae that involve tuple/cross dimensional references
  • Ranking tuples in sets
  • Analysis of date hierarchies
Supports high speed subset data export:
  • Data slices (including dynamic calc members and aggregates) can be selected and exported lights out in a number of different formats including directly into relational tables
  • This feature is calculation script enabled
Expanded 64-bit support for AIX and Sun Solaris
"Reference cubes" improve @XREF performance
EXCLUDE / ENDEXCLUDE construct allows calculation scripts to specify which members NOT to calculate
MAXL has been enhanced to provide a means to encrypting usernames and passwords in scripts
What's New in Hyperion Essbase Release9.3? (PDF)

Discussions | See All
Hyperion Essbase Planning and Budgeting Hyperion Query and Reporting
Untitled Document
Re: update outline
Jul 4, 2008
by: user645376
Re: update outline
Jul 4, 2008
by: user645376
Re: Data Export problem
Jul 4, 2008
by: user645318
Alternate Hierarchy
Jul 4, 2008
by: user616464
update outline
Jul 4, 2008
by: akki
Untitled Document
Re: How to Display variable i...
Jul 3, 2008
by: zhangdong
Re: What is the relationship b...
Jul 3, 2008
by: zhangdong
Re: How to set FIX based on se...
Jul 3, 2008
by: user594245
thick client and thin client
Jul 3, 2008
by: user644704
global variables
Jul 3, 2008
by: user644704
Untitled Document
Re: Problem in Exporting (URGE...
Jul 4, 2008
by: user616464
update outline
Jul 4, 2008
by: akki
Re: Interactive Reporting Migr...
Jul 4, 2008
by: user616464
Re: Problem in Exporting (URGE...
Jul 4, 2008
by: Rahul Kumar
Re: Migration of cube in Grid
Jul 4, 2008
by: Rahul Kumar
 
Left Curve
Downloads
Right Curve
 download Hyperion Essbase

Left Curve
Learn More
Right Curve
 · Documentation
 · Hyperion Essbase Data Sheet (PDF)
 · Supported Platforms Matrix
 · EPM / BI White papers

Left Curve
Related Technologies
Right Curve
 · Hyperion Essbase Visual Explorer
 · Hyperion Foundation Services
 · Hyperion Planning
 · Hyperion Financial Management
 · Hyperion Interactive Reporting
 · Oracle BI Suite Enterprise Edition Plus
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy