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...

2 sessions at Kscope19

2/3 of the unlocked cube team was at Kscope19 with 2 awesome sessions… (at least we think so) Maybe next year the full team will be together! (we missed you Pete!) Anyway, during our sessions we were asked if we were going to share the videos we were showing since the pdf you can download……

Continue reading

New Smart View version brings Drill through to Excel sheets from EPM Cloud

Up until last week, clients kept asking me if there was a way to get to the drill through reports without having to leave the excel world. Up until now, most of my clients leveraging Data Management wanting to run a drill through report needed to: find the desired cell to run the drill through……

Continue reading

PBCS ePBCS Update – September 2019 – What’s new?

Last week, Test pods have been gifted with the latest PBCS update. Let’s see what September 2019 brings to PBCS. Welcomed new features: Data Management: Drilling down from Summary members. Before this update drill through via Data Management only supported drill through at level 0. Apparently now we can drill from summary members and Drill is limited……

Continue reading

Calc Manager Error:The dimension needs to be a text attribute dimension

After creating a new attribute dimension in PBCS/EPBCS, I tried leveraging it in a Business Rule right away but surprisingly the rule wouldn’t validate without throwing the following error “Error:The dimension needs to be a text attribute dimension” Supposedly, the new text attribute dimension isn’t being recognized as a text attribute dimension. It’s not a big issue……

Continue reading

Leverage the DRG Calculate Name and Calculate Parent features – Part 1

A long time ago (i.e. a little bit more than a year ago) I started playing with DRM and more specifically with the new DRG features that had just been added like Calculate Name and Calculate Parent, and so I had made a quick post about their availability and how to enable them and I……

Continue reading

Data load performance in PBCS/EPBCS

My last post was almost a year ago. I have been tied up on pretty large projects and never got a chance to find time to share some more insights on the daily issues we may encounter. I have been trying to stay away from the cloud as I felt it wasn’t quite there yet compared to……

Continue reading

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