Author Archives: Will Oscar Andreelli
New Smart View version brings Drill through to Excel sheets from EPM Cloud
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……
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……
Leverage the DRG Calculate Name and Calculate Parent features – Part 1
Data load performance in PBCS/EPBCS
Export Essbase Substitution variables to SQL
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……
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……
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……
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……
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……
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……
Unlocked Cube team at Tough Mudder in LA
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.……