Entries by Kyle Goodfriend

, , , , , ,

Adventures in Groovy – Part 4: Run Time Prompts

Introduction Groovy provides a very easy way to interact with the user via run time prompts, or RTPs.  These can be linked to dimensions, members, and input.  One of the huge benefits of getting RTPs in Groovy is that the result can be validated, and the calculation can be cancelled if they don’t validate (we […]

 
, , , , , , ,

Adventures in Groovy – Part 3: Acting On Edited Cells

Introduction With the introduction of Groovy Calculations this summer, one of the things I use most, especially for applications with data forms that include a large sparse dimension in the rows with suppression on, is the option to loop through cells and identify only the POV on the cells that have changed.   

 
, , ,

Choosing a Reporting Mechanism in Planning

Reports out of Hyperion Planning are typically identified in 2 categories. Standard “canned” reports – These reports are used generically in a global aspect to report data in common formats and standardized views. These are often generated in volume and printed for presentations and executive review. Ad hoc reports – These reports are more flexible, […]

 
, , , ,

Adventures in Groovy – Part 2: Data Validation

Introduction We all know the Data Form validation rules are serviceable, but they are not robust.  When Smart View advanced and forms were opened in Excel, the validation logic developers had in JavaScript became useless.  Since then, we have really missed the ability to communicate with the user interactively with visual cues and validation rules […]

 
, , , , , , , ,

My Adventures in Groovy Calculations – Part 1

What Is Groovy Recently, Groovy scripting was added to ePBCS business rules as an option instead of the GUI, or the go-to scripting for you old-timers who still refuse to change.  These are defined in the Business Rule editor as Groovy calculations.  So, what is Groovy?  

 
, , , , , ,

Using a Shared Connection with HSGetValue/HSSetValue with Planning or PBCS

If you are a fan of the HSGetValue and HSSetValue, you probably are using a private connection. As you know, anybody that uses the template has to either change the connection string to their own predefined private connection, or set up a private connection with the same name. When dealing with inexperience users, both methods […]

 
, , , , , , , ,

Remove Dimensions From Planning LCM Extracts

Problem I am currently working with a client that is updating a planning application and one of the changes is to remove a dimension.  After the new application was setup and the hierarchies were modified to meet the objectives, migrating artifacts was the next step.  As many of you know, if you try to migrate […]