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.