By Thomas Thuresson
November 1st, 2017
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 220.127.116.11.x 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.