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