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

Copy Planning Security to Essbase II

As we’ve seen in the last post, we have a list of users and their filter names as they exist in Planning. Continuing on, let’s take a look at what the documentation tells us about filters. It’s not evident at first glance, the importance of the section, “as FILTER-NAME”. If you dig one step deeper,……

Continue reading

Copy Planning Security to Essbase I

Today, I thought we’d look at a little proof of concept, in this part 1 of a 2-part series of posts. One of my co-authors and I were trying to figure out how to replicate security from a Planning application to an Essbase cube. Imagine the scenario, where we might have a planning application, for inputs……

Continue reading

Changing the Plan Type for Hyperion Planning Webforms

You may find yourself needing to change the plan type that a Hyperion Planning webform references and wondering “How do I do that?”. Hyperion Planning will not allow a change to the plan type for an existing webform from the Planning web interface. The following steps will demonstrate how to do it leveraging the Hyperion Life……

Continue reading

Fixing the new Essbase FIXPARALLEL calculation command

Recently, Oracle released a fantastic new calculation command in the 11.1.2.3.500 patch set – the FIXPARALLEL calculation command (click here for details of this command).  Expanding the horizon of ways that Essbase developers can perform multi-threaded calculations. I recently finished a project at client that had some stellar Exalytics machines chock full of CPUs and……

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