Yes, it is true that Groovy is available in on-premise and cloud (PBCS) versions of Hyperion Planning.  No, it is not true that the same flavor of Groovy exists in both.  Both have their advantages, and both have their drawbacks.  The likelihood that they will ever be the same is extremely low, and here is why.

The Difference Is

On-Premise gives developers the ability to write and use independent Groovy compiled applications.  These can be used in Business Rules as CDFs (custom defined functions).  Developers have complete functionality to make this do whatever they want.  It can return results to save to Essbase/Planning, it can interact with SQL, can run other programs, pretty much anything you can access that has a JAVA API.

PBCS doesn’t have the same flexibility.  Custom defined functions can’t be compiled and stored on the server.  PBCS, rather, has “Groovy Calculations.”  This gives developers the flexibility to interact with the Data Forms that on-premise doesn’t have.  Developers can iterate through the cells and act accordingly.  It can stop the form from saving, calculate and override data entered, color code cells, customize Data Maps, Smart Pushes, dynamically generate calculations, move data between databases, all with access to much of the Groovy functionality.

PBCS also supports the REST API, so Groovy can be used to access that and do everything, even more, that EPM Automate can do.

Why They Will Never Be The Same

This is just an opinion.  Technology changes so rapidly that this may change.  Corporate strategy changes almost as rapidly.

If PBCS had to ability to do what on-premise does, the ability for Oracle to support the instance would be a challenge.  CDFs can delete all the files on a server, for instance, and I don’t see a cloud provider giving developers this much control in a shared environment.

I also don’t see on-premise to have the same proactive interaction that PBCS has with Groovy Calculations purely because Oracle is pushing the cloud, and they want the most current functionality to exist in the platform they are pushing clients to use.

My Two Cents

I understand why there is a difference, and I don’t expect it to change in the near future.  3 years ago I didn’t expect that I would tell you that I would rather do a cloud implementation than on prem, either.  I do think as people get more comfortable with the cloud, and security improves, there will be advances.  I think there will be a future state where the cloud offerings will be closer to having the flexibility to the on-premise implementations.


6 replies
  1. Phil C says:

    Love your blog! Thank you for sharing such great info. You mention “as security improves” that cloud adoption will increase. What security risks do you see in the cloud that should be addressed?

    • Kyle Goodfriend says:

      Thank you. So many people helped me along the way – take a penny, give a penny, right?

      My comment on security is more related to what we have access to do with cloud application, not necessarily the cloud itself. I think as security continues to improve we will have more control inside of these hosted environments. We will also have more options to integrate between cloud and on premise solutions.

      Actually, I did a presentation late last year about the cloud security, and statistically, it is way safer than corporate security. In 2016, only one of the top 34 data breaches was a cloud vendor. in 2016, 81 billion dollars was spend on information security, and cloud vendors can’t afford data breaches. It can ruin organizations, so most cloud vendors have some of the top security resources and budgets to protect against security failures.

      The list of organizations are on slide 6 and 7 ( of the Hyperion Group Session Introduction I help facilitate.

      Thanks for the feedback and I hope this is useful.

  2. Pedro Fernandes says:

    Congrats on your blog ! It has been very usefull !

    You say that PBCS has “Groovy Calculations.” that provides flexibility to interact with the Data Forms.

    How can I enable Groovy ? I was only able to enable and use on EPBCS.

    • Kyle Goodfriend says:

      Thank you for the kind feedback.

      Oracle doesn’t enable it with PBCS alone. If you purchase PBCS+1 (PBCS and one module, or multiple pods), they enable it. Unfortunately, I have been told there is no roadmap to enable it in PBCS. It is a decision to push people to upgrade.

  3. Steve Wyatt says:

    Are there specific “tricks” to using Groovy scripts in Business Rules, on-premise, is our Business Rules version. I have downloaded the specified jar file and restarted the EPM services. Specifically, I’m trying something simple, like executing a “Map Reporting Application”
    Thanks in advance

    • Kyle Goodfriend says:

      Groovy business rules are not available on prem. You can create CDFs with Groovy and execute those, but you can’t interact with forms and dirty cells like we are demonstrating in the series. There is no roadmap to have Groovy calculations available on prem.


Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

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

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