OTN Appreciation Day : Groovy in EPM


This was a wonderful idea that Tim Hall proposed through his blog. I really liked that idea, everyone involved with OTN(ACE Program) blogging about an Oracle feature that you like šŸ™‚

To me there are a lot of features that I like, however I thought I’ll write about something that I’m now known for, or something that I talk about a lot these days. I presented at OOW’16 about this and moment I finished and was leaving the podium, I was called the Groovy Man šŸ˜‰ I enjoyed that name :D.

Now you got the idea what feature I like, yes it is Groovy in EPM, you now have the opportunity to write your code in Groovy in Essbase calc scripts. PBCS allows Groovy scripting (last I heard it’ll be released to all in 16.11). Essbase Cloud Service (I hope Gabby will forgive me if the name is not correct) is getting a Groovy component for the API. Soon it is going to be Groovy everywhere šŸ™‚

If you want to look at what it is like or how powerful it can be, have a look here. I wrote that article for OTN on writing CDFs from a regular Calc script itself, you can query tables, update them, run SQL procedures and what not!!!!

PBCS Groovy is different and how different and powerful that is – some of you might have seen my OOW presentation(Tips and Tricks: Oracle Enterprise Planning Cloud [CON7530]), for those who haven’t I’m planning to write an article on that one too šŸ™‚ Ok Ok I’ll talk about it here šŸ™‚

  • You can change the way the calc code based on a user selection (Bigger brother from completely different set of parents, Cameron Lackpour was excited seeing this and tweeted this)
  • It is intelligent and you can fire the script only for the changes/updated cells/rows/columns
  • It can even look at the validation colors and create a script based on the different colors on the form

Now you know why I love the feature šŸ˜€

Embrace Groovy, and that is the feature I love in Oracle right now. #ThanksOTN


About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with ā€œIntekgrate Corporationā€ based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.