On March 22, 2018, I am hosting a webinar featuring the work delivered at Breakthru Beverage Group in Chicago, Illinois. Breakthru had the traditional challenges, but it had some additional obstacles other don’t. With requirements of entering budget at any level, complex allocation and seeding logic, and the need for consolidated reporting in real time, we had to get creative. Welcome, Groovy Calculations! Read more
If your environment is a cloud product, whether it be PBCS or ePBCS, one thing that is critical to understand is the backups produced in the Migration area, may not be what you think. Learning this after the fact may have negative consequences on your ability to restore data. Read more
I was lucky enough to be invited to talk about the new Groovy Calculation in PBCS and ePBCS at the Ohio Valley OAUG meeting today. If you have read the Groovy series, you know how strongly I feel about the advancements in Hyperion Planning with the addition of Groovy Calculations. I want to share the presentation with a wider audience. This is a functional overview for those who are new to the concepts. This also introduces readers how to develop their first Groovy Calculation, and provides some examples. Read more
One of the challenges with EPM Automate has been eliminated this month. Although it was a minor issue, the need to update EPM Automate regularly was something that had to be considered monthly. Read more
Last year I presented an in-depth overview on PowerShell and how it can be utilized in the Hyperion environment. I have been asked many times to share it. Read more
I have been selected to speak at the OVOAUG on February 16, 2018. I have been there before, and it is a very nice group of people to engage with. If you are in the area, or would like to hear more about how Groovy in PBCS can change the landscape of performance, user interaction, improvement of data input, and reduced user frustration, please go to http://ohio.communities.oaug.org/ and register. I would love to see as many of you there as possible.
Here is the agenda. It is going to be a functional overview, but we will touch on how to start writing Groovy, and if you show up, I will be more than happy to talk before and/or after the session.
When moving data in PBCS with Data Maps or Smart Pushes, they have limits on how much data can be moved. The amount of data can be seen in the logs, and look something like this. Read more
Data Map Error:
Push Data failed. Error: Exported data size of data map that is being executed from groovy is more than permissible amount: 100 MB.
If you are confused, join the club. The results are inconsistent as some data pushes are successful that are over the 100MB limit. So, why the following error? Read more
If you have jumped into Groovy Calculations, one of the things you likely would try to do is grab a value for a sub var. Hopefully, you haven’t spent too much time before reading this. I wasted a ton of time trying to get this to work before I opened a ticket with Oracle. This class is NOT available yet and was inadvertently included in the public docs at https://docs.oracle.com/cloud/latest/epm-common/GROOV/. The development team told me they are going to remove it from the API docs. Read more
A bug with EPM Automate has been identified. This is not replicated on every version or client. Please pay attention to any EPM Automate updates installed. In the past, I was able to install the latest version without any issues. Currently, the install prompts users to uninstall the older version. In the past, this worked as expected, but now, when selected, this has no effect and the new EPM Automate is NOT installed, leaving you with the existing version. Read more