Entries by Kyle Goodfriend

, , , , , , ,

Ohio Valley OAUG – Getting Groovy in Louisville

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, […]

 
, , , , ,

Adventures in Groovy – Part 7: Validating Run Time Prompts

Introduction When developing applications in PBCS, there are times when we need to request information from users.  This is especially useful in workforce application, but certainly not limited to them.  With Groovy, we can take validation to the next level.  We can compare inputs to each other, we can limit input, and we can now […]

 
, , , ,

Bug Report: Push Data failed. Error: Exported data size violates permissible amount: 100 MB

Introduction 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? […]

 
, , , , , , ,

Adventures in Groovy – Part 6: Converting a POV into a Fix

Introduction One of the fundamental features of a Groovy calculation is the ability to dynamically grab aspects of a grid, and getting the POV is something that is required to dynamically generate an Essbase calculation.  There are times when the entire POV is required, times when only members from specific dimensions are needed, and situations […]

 
, , , , ,

Adventures in Groovy – Part 5: Accessing Substitution Variables

Introduction Accessing Substitution Variables is critical in most calculations, and accessing them in Groovy is a little more complex than it needs to be with not having an API to get them.  Since the SubstitutionVariable is not available, there are a couple ways to get them.  The precursor to this post is three-fold. Read the Bug Report: […]

 
, , , ,

Easy Way to Randomize Data in PBCS

Introduction When an application is used to demonstrate sensitive information, a training class includes people that shouldn’t see live data, or security is being tested, often times using real data is not an option.  I have written PowerShell scripts and .NET applications to randomize data from Essbase exports, as well as Custom Defined Functions to […]

 
, , , ,

Bug Report: Groovy SubstitutionVariable Class Not Functioning

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 […]