Essbase

Deep business insights from scenario modeling

Quickly and easily forecast company and departmental performance. Develop and manage analytic applications by using business drivers to model multiple what-if scenarios.

Simple workflows

Manage workflow for multiple scenarios within a single user interface for centralized submissions and approvals. With sandboxing capabilities, quickly test and evaluate your models to determine the most appropriate one for production.

Out-of-the-box calculations

Financial and business analysts can use more than 100 prebuilt, out-of-the-box mathematical functions that can be easily applied to derive new data.

Hybrid query engine

Hybrid mode for block storage cubes provides robust dependency analysis, fast aggregation, the ability to process more calculations, and flexible tuning options.

Depict complex business structures without the need to simplify

Financial and business analysts can easily model complex hierarchical relationships that accurately reflect business structures, such as employee organizational charts or multilevel product hierarchies. Oracle Essbase represents in-depth business metrics without the need to modify the source data—saving time and delivering greater detailed insights.

Advanced dimensional design and modeling

Develop, maintain, and report from multidimensional models for faster analysis and to better understand data at different levels in the hierarchy.

Designed to meet your custom analytical needs

Support thousands of simultaneous connections and provide up-to-the-minute, dependable information for users around the globe. Multiple Oracle Essbase applications can be designed and deployed across the organization for any analytics purpose you require.

Automation and developer tools

REST API helps you automate management of Essbase resources over secured HTTP. Java API, command-line interface, MaxL administrative language, and Report Writer are also available.

MDX helps you define queries, and you can use Insert and Export directives to shape, copy, move, filter, and update any custom slice of multidimensional data.

Smart View—Office 365 integration

Oracle Smart View (Mac and browser) provides a multiplatform, zero-footprint interface for Essbase query, analysis, and reporting.

Cube Designer

The Cube Designer extension helps you build Essbase cubes from workbooks, offering a portable and iterative design and administration interface in Excel.

Federated partitions

Federated partitions integrate Essbase cubes with Oracle Autonomous Data Warehouse, combining Essbase’s analytical power with the benefits of Oracle Autonomous Database. Data storage remains in Autonomous Data Warehouse while the logic you build in Essbase provides multidimensional analysis of the data set.