Oracle Essbase is an OLAP (Online Analytical Processing) Server that provides a multidimensional database platform upon which to build analytic applications. Oracle Essbase, along with Oracle BI Suite Enterprise Edition Plus, is part of the Oracle BI Foundation.
Essbase’s multidimensional database format, often called cubes, gives much more reporting flexibility and scalability then two dimensional databases, such as Excel or JD Edwards. 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 with speed of thought response time.
Essbase provides for multiple levels of detail within each dimension by arranging the members of each dimension (i.e. time, accounts, regions) into one or more hierarchies. Users can drill down and roll up hierarchal data, as well as pivot the data to change the visualization. This ad-hoc analysis is done through the Microsoft Office Smart View plug which provides a familiar interface for the analysis of the data through Excel, PowerPoint, and Word.
Essbase Studio is a new module with the EPM System 11.1 Release. Essbase Studio provides a single interface for performing tasks related to data modeling, cube design, and construction of analytic applications. Essbase Studio can directly connect to relational databases to build data models, without needing to create an intermediate data mart. Unlike other third party reporting tools Essbase gives access to all JD Edwards tables so cubes can be built off all owned modules.