Hyperion Essbase

Oracle Essbase is the market leading online analytical processing (OLAP) server for enterprise performance management (EPM) applications. Designed specifically for business users, Oracle Essbase supports forecasting, variance analysis, root cause identification, scenario planning and what-if modeling for both custom and packaged applications. It can be tightly integrated with multiple data sources and the information generated can be delivered through a wide variety of reporting options. Engineered for scalability, security, and rapid-response, Oracle Essbase brings advanced analytics to the business user to enable greater understanding of the business, alignment of resources and improved business results.

Most highly advanced calculation engine
At its core Oracle Essbase contains a high performance calculation engine with over 350 pre-built, out-of-the-box functions. This comprehensive library enables Oracle Essbase to scale from simple aggregations to complex, cross-dimensional allocations. Financial formulas of all types are included to support business model development. In addition, business rules can be created to manage complex calculation requirements using a spreadsheet-like syntax

Multi-dimensional representation and extension
Data is categorized in Oracle Essbase in the form of dimensions, a dimension could for instance represent a time period or a product or a customer. Thus a query may be to compare actual sales for a product in a specified state during the month of March 2010 with the corresponding budgeted value for that month. There are often relationships between members of a dimension and these relationships are represented by a hierarchy. A hierarchy enables mathematical calculations to be executed against the data, so for example all the sales for individual states can be aggregated to create a value for the entire USA. Oracle Essbase allows multiple hierarchies to be established so data can be speedily calculated or aggregated. Structures in Oracle Essbase such as dimensions and hierarchies are displayed in the “Outline”, which is a graphical representation that enables authorized users to easily review and maintain structures as business requirements change.Users can extend data by using metrics or drivers to estimate what results will be in the future. These driver metrics can be based upon history, trends or entered by the user. These forecasted results can be compared with actual results and the reasons for variances investigated so that more accurate forecasts may then be produced. Users can also create further scenarios where they may model for exceptional changes in business and be prepared for turbulent trading conditions through this “what-if” analysis. This assists fast resolution of business issues and for risks to be managed.