Using Groovy Scripts on Essbase Cloud

Continuing on with my love-fest on Essbase Cloud, I wanted to explore another little trick that the nice folks at Oracle have shipped with OAC. Specifically, the ability to run Groovy scripts from Essbase Cloud. The first clue that this is possible, comes from the “Jobs” tab.

Well that’s great, but how do we get a script up and running with Essbase Cloud? No easy answers from the documentation yet. But after a bit of trial and error, this is what I landed on. The “Scripts” section of the database does not give us the ability to create Groovy scripts.

So where do we go from here? Let’s first set up a simple Groovy script. Here’s a 2-liner that basically gives us the version of Groovy that’s available.

Once we save it off with a “.groovy” extension, we can upload the file using the “Files” section of the “Inspect” action. But what happens when we do this?

We run into the error seen above. So, what gives? Turns out there are different ways to save off groovy scripts. Thanks to Mr.Haki, I was able to narrow down the problem to the file extension. BTW, this is an excellent resource for all developers.

Rename the file with a “.gsh” extension, and we are good to go.

If we come back to the “Jobs” area, we can now select the script that we uploaded, and run it.

And there you have it, folks. Another cool little feature that has been slipped in, over the last couple of versions of OAC. Interestingly, also my 50th post. Now back to watching the World Cup.

 

 

 

 

Avatar

About Vijay Kurian

Known as the Clem Fandango of EPM consulting, Vijay Kurian has been developing enterprise solutions for companies for the last 12 years (increment years if reading post-2015). Having worked with Essbase, Planning, DRM and other assorted technologies during that time, he’s made the frankly, average decision, to write about them. He is, surprisingly, an Oracle ACE Associate. He hopes to contribute frequently to US Weekly, People and Sensible Chuckle magazines on improving reporting solutions, creating master data management systems and zzz…

One Comment

  1. 🙂 Agree. To what extent Groovy can be used is something that I still have to explore

    I did stumbled upon the same issue that you faced with groovy. It’s ironly that only .gsh is supported in OAC whereas .groovy is supported in EPBCS 🙂 I did mention about the extension for groovy in my blogpost
    http://amarnath-analytics-blog.blogspot.com/2018/06/oac-new-interface.html

Leave a Reply

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