What is Oracle Essbase?

Oracle Essbase is a business analytics solution that uses a proven, flexible, best-in-class architecture for analysis, reporting, and collaboration. Named by InfoWorld Magazine as one of the top 10 technologies of the 20th century, Essbase allows users to model, analyze, and interpret the most complex business scenarios.

Essbase is a database that provides users with multidimensional analysis capabilities

Essbase Databases are often called “Cubes” and are defined by dimensions, which themselves are hierarchical groups of members. Data is organized into cross sectional groups that can be accessed by users depending on what sections of the dimensions they wish to see. The Dimensions are hierarchical representations of descriptors that business users are familiar with, such as a Product Hierarchy. By simply choosing any point in the various dimension hierarchies users are instantly presented with the data values. Users can drill up or down, or users can pivot different dimensions to form new cross sections and better analyze the data. Essbase is optimized to support On-Line Analytical Processing (OLAP) as opposed to the more traditional transaction processing (OLTP) found in relational databases. This enables rapid response times for large volumes of users and large volumes of data.

Essbase gets its name from Extended Spreadsheet Database and is commonly accessed via a spreadsheet add-in that provides users the capability to analyze data within a familiar environment such as Microsoft Excel. Essbase can accept data input from end users which makes it a very capable budgeting tool in addition to its analytic capabilities. Essbase also contains a very powerful calculation engine and is often used to create Profitability Costing models or other types of analytic models that require allocations or more advanced calculations.

Essbase is mainly used in budgeting and financial services because it is easy to run scenarios using dimensions that allow you to see how any point in the database changes with changes to a single variable. Essbase makes it easier for forecasting results and comparing actual performance to the forecast so that variables can be adjusted quickly and efficiently. Dodeca eliminates the need to switch back and forth between applications by combining the best reporting & analysis features of Smart View, Hyperion Financial Reporting, and Hyperion Planning into a single platform. Dodeca provides an interface similar to Excel with regard to formulas and formatting along with the automated report production, managed report templates, and point-of-view selectors of HFR. Dodeca was purpose built for Oracle Essbase. It supports budgeting, analysis, reporting, and planning applications and comes with a number of features such as drill-through.

Ease of Use for Essbase Financial Reporting & Data Analysis

  • Dodeca has the look and feel of Excel, leveraging existing knowledge to reduce or eliminate training.
  • It is read/write capable with Oracle Essbase and relational data sources, such as SQL, DB2, and Oracle.
  • Any edits made in Dodeca are automatically written to Oracle Essbase upon saving, based on Essbase security permissions.
  • Dodeca’s many features let users easily access and understand their data.

Integrate Data from Multiple Sources with the Dodeca Spreadsheet Management System

Companies can import transactional data held in SQL databases together with Oracle Essbase data. This feature can be especially helpful when performing data validations. You can have different sourced data all on one sheet so you can easily see where there might be an issue with your data. General ledger, financial, and operational data detail in other platforms and applications can be brought together with Essbase data. This includes product inventory data, product images, transactional data from point-of-sale, invoicing, invoice messages, and purchase-order system data. Dodeca can also pull information directly from SQL when that is used as a data source without an EPM platform or other business application.

Request your demo today and find out why Dodeca is the top choice for Essbase compatible complete database management in business.