Considering a Move to Essbase in the Cloud?

Thomas Thuresson

November 1st, 2017

In my blog post, Oracle Analytics and Essbase in the Cloud, I mentioned a few instances that were compelling reasons to move to Essbase in the Cloud. Let’s take a deeper look at one of them.

Your existing on-premise Essbase environment is old, needs upgrading, and is costly to maintain

One of the major benefits of an OAC and Essbase cloud platform is that there are no hardware capital and direct operating costs and no software maintenance fees. Instead, you pay a monthly subscription fee based on the performance you require. There is even a metered option available to pay by the hour adding flexibility for customers that might only use their cubes periodically. In many cases, a subscription model can be more cost-effective than hosting and maintaining your own environments.

Another cloud benefit is the patching and update process. Oracle provide patches on a regular basis, making it easy to always keep your environment up to date with the latest fixes and functionality. This is not always the case in the on-prem world where patches and upgrades are not released that regularly and customer adoption of patches and new functionality often lag behind, sometimes by years.

Oracle is rapidly adding functionality to OAC to match and improve upon on-prem functionality and even add net new functionality not available on-prem. The latest monthly patch has added support for SQL based load rules, RDBMS drill-through, and transparent partitions. The Cube Designer add-in has also been improved with functionality to manage cubes, such as defining data loads and dimension builds, deleting applications, running jobs and exporting data.  Another very cool and useful feature only available in OAC is the ability to trace calculations to debug and fine-tune calculation scripts.

So how would you migrate your applications to the cloud? The utilities described in the previous post provide the tools needed to rapidly migrate your Essbase cubes to OAC.  Depending on the version of your on-prem Essbase, either the LCM utility or the DBXTool in combination with the Cube Designer Excel add-in can be used. The LCM utility supports versions only.

Once your Essbase environment has moved to the OAC cloud new possibilities and opportunities opens up. Here are just a few ideas:

  • Take advantage of new functionality, such as Hybrid storage to get the best of both BSO calculation power and ASO aggregation speed while drastically reducing disk footprint.
  • Introduce the power of Essbase to new groups of users, such as analysts using advanced Excel models. With Essbase in the Cloud, they can easily create their own cubes based on their data and still use Excel for analysis using SmartView.
  • Start exploring the Data Visualization functionality of OAC to modernize your reporting and analytics capabilities with state of the art visualizations, collaboration, and mobility.
  • The Data Visualization Cloud Service can connect not only to Essbase but to a host of other sources such as relational databases, Apache Hive, Redshift, Salesforce and other Oracle cloud services such as EPBCS and FCCS.

Thomas Thuresson

About Thomas Thuresson

Thomas Thuresson has over 15 years of experience in all phases of design, development, and implementation of performance management and business intelligence applications. He has exceptional problem solving and architecting skills with a solid technical background. He is a specialist in data integration using FDM/FDMEE and ODI, in Hyperion Planning, Essbase and Essbase Studio and in reporting solutions with FR, OBIEE and other tools. Thomas is also a certified Essbase consultant with a minor in DRM and HFM.

Leave a Reply

Your email address will not be published. Required fields are marked *