Tuesday, April 16, 2019

OAC Essbase Google Sheets add-on

We're happy to announce the availability of our "OAC Essbase by Casabase" Google Sheets add-on. Our add-on has been tested and approved by Google for inclusion in the G Suite Marketplace. You can find more information, including the installation link here.

The "OAC Essbase by Casabase" Google Sheets add-on now allows you to combine the cloud advantages of Sheets (no local install, accessible from any connected device, built-in sharing) with the benefits of Oracle Analytics Cloud. You can now access your OAC data from Google Sheets exactly like you do in Excel using Smart View. All the familiar functions are there: 

·        Free-form: type in member names/alias directly in the sheet
·        Member Selection
·        Pivot
·        Unpivot
·        Drill-down
·        Drill-up
·        Keep Only
·        Remove Only
·        Submit Data
·        Execute MDX queries

The ability to pull your OAC data into Google Sheets in real-time opens up a new world of possibilities. Accessing your data in the Oracle Analytics Cloud using a cloud-based spreadsheet is the logical progression in the trend from on-premises applications. It’s easy to get started and we offer a 5-day free trial. If you have an OAC instance and credentials, you can get started in just a few minutes.
The add-on can also be installed from the G Suite Marketplace here.

Here's a blog post with more details.

Please give it a try and let us know if you have any questions.