Call Us: 1-800-497-0151
Follow Us:

What is Essbase?

What is Oracle Essbase?

  • 15.5.15
  • Admin

Named by InfoWorld Magazine as one of the top 10 technologies of the 20th century, Oracle's Hyperion Essbase allows users to model, analyze, and interpret the most complex business scenarios.

Essbase is an object oriented 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 hierarchal 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 the analytical engine of packaged applications such as Hyperion Planning, Oracle BI Solutions, and the multi-dimensional data store for analytical applications

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 on the fly.

Essbase Cloud Service (ESSCS)

Essbase Cloud Service (EssCS) is now available as part of the Oracle Analytics Cloud (OAC), a suite of analytics software solutions which also includes Business Intelligence Cloud Service (BICS), and Data Visualization Cloud Service (DVCS).

EssCS makes your multidimensional databases accessible through a wide variety of mobile devices. It makes it easier for teams to access the system securely from anywhere in the world.

Essbase Cloud can also be extended to business intelligence solutions by accessing your data from corporate dashboard and reporting tools.

Major benefits of moving to the Essbase Cloud Service (ESSCS) include:
  • Cloud infrastructure.
  • Better ontrol for BICS, PBCS, EPCRS and other cloud based reporting solutions.
  • Faster, if not near unlimited, scale and computing power for large and complex Essbase models.

MindStream Analytics can help you learn more about Essbase and its full analytic capabilities.

MindStream's experienced staff includes former Hyperion Essbase developers and certified Hyperion Essbase consultants. We hold various positions throughout the Essbase community including the Oracle Application User Group's (OAUG) Hyperion Special Interest Group Domain Lead for Essbase. MindStream has the expertise to make your next Essbase implementation a success.

Share:

Contact MindStream Analytics

For more information on how MindStream Analytics can help you, contact us at info@mindstreamanalytics.com or fill the form below to send us an message.


Search

Partner SpotLight

Anaplan

Anaplan

Anaplan is the planning cloud for Sales, Operations, Finance, and HR. We built our platform from the ground up to empower you to plan, collaborate, and act-in real-time. Anaplan enables you to deploy easy-to-use applications to solve complex planning challenges across your organization.

Anaplan Profile

Latest testimonial

MindStream Analytics is a leading consulting firm focused on helping clients improve business understanding and decision making. With years of experience in the analytics and Business Performance Management area, MindStream offers customers services ranging from software selection and implementation to best practices for financial planning. MindStream will work with customers towards a solution that enhances value and offers more insight into their data. MindStream believes in the power of technology combined with new procedures to give customers better analytic capabilities


Planet Big Data News

 

Twitter Feed

About Us

MindStream Analytics is a leading consulting firm focused on helping clients improve business understanding and decision making. With years of experience in the analytics and Business Performance Management area, MindStream offers services ranging from software selection and implementation to best practices for financial planning.

Contact Us
  • Address: 400 Commonwealth Ave, Unit 2
    Boston, MA 02215
  • Phone: 1-800-497-0151
  • Monday - Friday: 9:00 am - 6:00 pm
    Saturday - Sunday: Closed
Newsletter
MindStream Analytics
Join Our Newsletter
© 2017. MindStream Analytics. All right reserved. SiteMap