Check out the store for many more

OAC Essbase by Casabase

6 users


Access and analyze your OAC data in Google Sheets, just as you do with Smart View in Excel.
Casabase Software has created the first and only way to connect Google Sheets to Oracle Essbase Cloud.
Our add-on for Oracle Essbase Cloud gives Google Sheets the familiar ad-hoc retrieval capability for Essbase you’ve known and loved for years in Microsoft Excel with first the classic Essbase Add-In and then Smart View. Retrieve directly from your Oracle Analytic Cloud Essbase cubes into Google Sheets using all your favorite functions:

·        Pivot
·        Unpivot
·        Drill-down
·        Drill-up
·        Retrieve with Formulas
·        Keep Only
·        Remove Only

Plus, the OAC Essbase by Casabase add-on gives you the ability to submit data directly back to your cube.
The add-on acts as a conduit for your Oracle Analytics Cloud assets to your Google Sheets documents. If you’ve been retrieving your Essbase data with Smart View and then copying/pasting into Google Sheets, or converting your Microsoft Excel spreadsheets to Google Sheets, these steps are no longer necessary. 

No longer are you restricted to only using Microsoft Excel, now you’re free to utilize the best cloud-based spreadsheet solution for your Essbase data. Google Sheets provides a robust, completely cloud-based spreadsheet solution that can now be utilized by Essbase Cloud users everywhere. Incorporating Essbase data into Google Sheets allows you to take advantage of all the functionality it offers, such as:

·        Simultaneous real-time collaboration on a single spreadsheet across multiple users
·        Access your spreadsheets anywhere, on any device
·        Robust visualization options
·        Automatic file saving

NOTE: This add-on is not compatible with on-premises versions of Essbase.


Version: 5
Updated: April 8, 2019
Language: English (United States)