2017

Yearly Archives

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.

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.

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, often adjusted to explain current variances and market conditions. These reports are most likely generated by analysts and managers producing unique views to explain variances that exist at a point in time. The need to alter, change, and customize these reports are essential to identify and explaining current business conditions.

With more and more time dependent related data, grabbing the month from a Smart List is becoming more common. Associating that with a value in the application is required for a number of calculations, including things like

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 that halted the saving of data. Well, Groovy calculations to the rescue!

If you use Smart View, you are familiar with the Smart View Shared Connection URL, which is unique to the environment that Smart View connects. That property is saved in a file on your computer and has the default URL, as well as all the saves URLs in the drop-down list.

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?

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 can be problematic.

You may be surprised to know that the Get and Set Value functions can use a shared connection.