Essbase

Get Involved. Join the Conversation.

Topic

    Harry Gates
    OAC Essbase Google Sheets add-on
    Topic posted April 16, 2019 by Harry Gates, last edited April 16, 2019, tagged Essbase, OAC Enterprise Edition, Smart View 
    148 Views, 2 Comments
    Title:
    OAC Essbase Google Sheets add-on
    Summary:
    You can now access your OAC data from Google Sheets exactly like you do in Excel using Smart View.
    Content:

    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.

    Thanks,

    Harry Gates

    Casabase Software

    Oracle Silver Partner

    Comment

     

    • Ashish Jain

      Thanks Harry. This is an excellent add on for google sheets.

    • Harry Gates

      We are excited to announce that our Google Sheets add-on now supports on-premise Essbase, as well as OAC. Connectivity to your on-prem Essbase environment is provided by our ExoInsight product. This facilitates a seamless transition when your company eventually makes the decision to move to OAC.

      Just search for "OAC Essbase by Casabase" in the GSuite Marketplace or directly from Google Sheets using the "Add-ons" -> "Get add-ons..." menu.

      Thanks,

      Harry Gates

      Casabase Software