Will Oscar Andreelli

Will Oscar Andreelli

Footballer (soccer to Americans), free diver and Tough Mudder (er?), Will is as comfortable in the outdoors as he is in front of an allocation script. His mom calls him “the best EPM consultant in the West of Versailles”. Having helped a number of clients with their planning and forecasting needs, he is now intent on writing about his exploits...

Workflow Task Calculate Name and Calculate Parent features

DRM (Data Relationship Management) version 11.1.2.4.341 brings some new features to DRG, specifically to the workflow tasks and in this post we will talk about the Calculate Name and Calculate Parent features. (Hopefully, a Calculate Description option will be added in a future release) Before I start, I just want to mention that I had not personally used……

Continue reading

Reduce size of Runtime Prompts in Hyperion Planning applications

Hyperion planning users sometimes, when running a business rule that require some kind of selection through a runtime prompts window will complain that the OK and Cancel button are not displayed on their screen, as seen below. The runtime prompt window is too big for their screen resolution, so those buttons don’t show up and users……

Continue reading

Planning PasswordEncryption utility

It’s been a few months since my last post. In this post, I will detail the step (in Windows and Unix) to encrypt a password (using the PasswordEncryption utility) in order to use it with planning utilities, like for example the outline utility. This post will be the first one of a series that will end on with loading……

Continue reading

Hyperion Planning Security – Import, Export Utilities and More

Today, I’d like to review how we can quickly and easily setup Security in a Planning application using the Import & Export Utilities, as well as a custom Excel VBA template. Before anything else, I should probably explain or remind some basics about Planning security. Why do we need to setup security and how is security……

Continue reading

Download, install and configure Smart View

Here is an easy one. So you were told you have to start using Smart View: instead of using the old Essbase Excel add-in or because your company chose to use Essbase, Planning, HFM… for all their EPM needs. Either way, you’ll have to download, install and configure Smart View. You can download Smartview directly from the Oracle……

Continue reading

Update the Workspace Smart View version

This is quick tip for any admin that needs to update the Smart View version that is available to users for download from the Hyperion Workspace console. I was able to follow these steps so far since  Hyperion version 11.1.2.2 and this is still accurate for 11.1.2.3.500. As always be careful, and make sure the Smart……

Continue reading

Blank Hyperion Workspace Homepage

Sometimes when connecting to Workspace, you will get a message saying the start up document couldn’t load, resulting in a blank Hyperion Workspace homepage. This is because most of the time users have not been granted access to the location where the homepage is stored or sometimes it’s because the homepage file is simply gone, deleted by mistake.……

Continue reading