Adhoc Analysis within Hyperion Planning

I was trying to be creative and think up of ways to show the analytical capabilities of the Hyperion Planning system to demonstrate to a client (who had strongly suggested that these capabilities would play a very important role in their evaluation of a budgeting and planning solution) and came up with one approach that I’d like to share here.
Continue reading


Creating a dimension with Interface tables

For the ones who have started using BPMA to manage the outline in Hyperion Planning, there are two options to create the dimensions. Either make the .ads file or populate the Interface tables with the relevant information.

Maintaining and developing an .ads file is rather cumbersome and updating the Master version takes considerably more time as compared to pulling the data from the Interface tables.

Continue reading

Required Dimensions for a Hyperion Planning Application

Some people who are new to Hyperion Planning but have a little experience of Essbase ask me ‘what are the required dimensions for a Hyperion Planning Application?’

This isn’t something that’s too difficult to find in the documentation, but just to make it a little easier for the lazier of us, I’m going to list here the required dimensions for a Hyperion Planning Application.

Required Dimensions*

  • Period
  • Year
  • Scenario
  • Version
  • Entity
  • Account

Other Dimensions

  • Alias
  • Smart Lists

*multicurrency applications require two additional dimensions

  • Currency
  • HSP_Rates

Continue reading

Installation Guide: Hyperion Planning – System 9 (Coming Soon)

I’ve often been contacted by people who have had problems with the installation of Hyperion Planning – System 9. I’ve done it quite a few times so I’m quite comfortable in doing the installation, but it took me a long time to wade through all the documentation that is relevant for a complete installation.

I am in the process of compiling a document (complete with pictures – and loads of ’em) to guide you through the installation process. This initial guide makes some assumptions regarding the environment, but at the very least it gets you started with Hyperion Planning – System 9.

Once the guide is complete, I would be posting it on this blog. So do check back!

Technorati Tags: , , , , , , , , , , , ,

Starting Hyperion Planning – System 9

The startup sequence of Hyperion Planning has a lot of people confused. Although the documentation that comes bundled with the product is ample and very comprehensive, it does take a little getting used to. When I first started working on the product, it did take me a while to get the hang of it. I personally feel its better to start the services manually (you can write a script to automate it of course) than to use the shortcuts (they point to batch files) that are created in the Hyperion menu as you install/configure each product.

Continue reading

Migrating Security

Migrating an application across different environments is something one must do in any implementation. In the “Migration” series I intend to highlight how each of the key components of an Essbase/Hyperion application need to be migrated.

Continue reading

Enabling logging for Hyperion Planning

I cannot stress enough the need for logging. When everything is going well, there is absolutely no need to look at the logs. This is why most people forget to enable logging. It is always a good practice to enable as much logging as possible. Disk space is nothing to be stingy about and I wouldn’t be particularly concerned if the logs took up some space, but in the event of something failing they can be a lifesaver.

Continue reading