Moving from Essbase On-Premises to Cloud

Moving from Essbase On-Premises to Cloud


PARC consulting has both on-premises and cloud-based Essbase customers, and we are seeing an industry trend toward moving Essbase to the cloud. In addition, Oracle is heavily promoting its cloud offering as a key part of its product direction. This blog covers some of the advantages of moving Essbase from on-premises to the cloud.


To begin, the features available in the on-premises and cloud-based Essbase products are similar, though those in the cloud version add significant functionality.

Essbase’s added cloud features include:

  • The Cube Designer. This downloadable Excel add-in allows you to design, create, and modify both BSO and ASO Essbase applications using Excel application workbooks. These workbooks contain application and cube information, alias table and substitution variable worksheets, and full metadata worksheets for each of the dimensions. For those familiar with Planning, this is the Excel Admin Extension on steroids.
  • Hybrid Mode. The Essbase Hybrid mode, which takes the typical block storage mode of Essbase and enhances it with the benefits of aggregate storage technology, is now the default mode for block storage cubes. Make any (or even all) of your sparse dimensions dynamic and eliminate aggregation calculations!
  • Catalog. New in the cloud is the Catalog, a cloud-based file structure in which you can store files and artifacts of any kind and includes a Gallery of cube templates in the form of Excel application workbooks.
  • Connections and Datasources. These reusable artifacts eliminate having to code connection details (like SQL source information) into artifacts like rule files or filters.
  • Scenario Management. This offers the ability to build private work areas or sandboxes where users can model different assumptions within the data and see the effect on aggregated results without affecting the primary cube data set.


A key technology consideration – far and away above any others – is the sheer power in the Essbase Cloud infrastructure. Most companies would be challenged to justify the capital expense of acquiring the hardware to match Oracle’s cloud servers’ powerful capability and then maintain it. Performance-wise, PARC’s experience has shown dramatic improvements in calculation performance and data retrieval capacity of cloud-based Essbase.

As for the architecture, Essbase is now part of the Oracle Cloud Infrastructure (OCI) platform. A key benefit of OCI infrastructure is purchasing Essbase as a standalone product instead of the former requirement of acquiring it as a bundled component of Oracle Analytics Cloud (OAC). This required purchasing the entire OAC suite, which, for many customers, provided unneeded and unused products and capabilities.

For a complete comparison of Essbase Cloud to on-premises Essbase, see the Oracle summary here: Essbase On-premise to Essbase Cloud


The cloud-based Essbase offering is Oracle’s path to the future. At PARC, we have found the cloud product’s learning curve quite manageable, and we are impressed with both its new features and the notable gains in performance we have seen. PARC currently has customers using Essbase cloud version 19c, and the 21c version will be released for the cloud later in Q1 2021.

Cloud-based solutions are not for everyone, and in a future post, we will discuss what factors may have you desiring to stay on-premises. However, for most customers, the cloud’s power and convenience outweigh most of the minor downsides.

If you are considering moving your Essbase environment to the cloud, need on-premises guidance, or would like an assessment on cloud readiness and strategy, PARC can provide roadmaps, guidelines, installation and migration assistance, and ongoing management and support for your Essbase environment. Contact us today!

1 Comment

  • Larry

    Now with Essbase 21c, it is essentially an on prem product again. It is no longer exclusive to OCI. This was mainly in response to customers complaining about the inability to access the file system on the Oracle cloud pods directly. So, now, Essbase will be the same code line for on prem or if you decide to deploy on OCI or any other cloud infrastructure.

Leave a Reply

  • Oracle EPM Cloud Update – Jan’22 (22.01)

    These Oracle EPM updates are scheduled to take place during the first nightly maintenance period on or after 2AM ET on Saturday Jan 8, 2022 (test environments) and on or after 2AM ET on Saturday, Jan 22, 2022 (production environments)

    January 7, 2022
  • Oracle EPM Cloud Update – Dec’21 (21.12)

    These Oracle EPM updates are scheduled to take place during the first nightly maintenance period on or after 2AM ET on Saturday Dec 3, 2021 (test environments) and on or after 2AM ET on Saturday, Dec 17, 2021 (production environments).

    December 2, 2021
  • Oracle EPM Cloud Update – Nov’21 (21.11)

    These Oracle EPM updates are scheduled to take place during the first nightly maintenance period on or after 2AM ET on Saturday Nov 5, 2021 (test environments) and on or after 2AM ET on Saturday, Nov 19, 2021 (production environments).

    November 3, 2021
  • Block Creation in Essbase – Part 2

    The previous post ended with a discussion on using DATACOPY to create blocks. I stated that it was my preferred method of making sure the right blocks were created for use. However, we may run into a situation requiring an “IF” test to determine when we create the blocks. In this situation, we cannot use DATACOPY as it is not syntactically valid inside an IF test.

    October 22, 2021