Johnson & Associates Consulting

Business Intelligence using Hyperion

  • Increase font size
  • Default font size
  • Decrease font size
Johnson & Associates Consulting

Hyperion Planning Infrastructure Install

E-mail Print PDF

The install of the Oracle EPMA or Hyperion Planning software is key to a successful project.

I am amazed at the folks that are looking for an infrastructure install who are pinching pennies.  I hear rates that are below many consuting rates that are for the actual install of the environment.  There is a reason that some of the large Hyperion Partners are outsourcing this install work.  It can get pretty nasty.

The baseline for the installation of an environment for Hyperion is roughly 1 week per environment.  2 environments means 2 weeks.  This is the best case scenario.  I've yet to see a unix install go smoothly enough to be done in 2 weeks for 2 environments. 

If you look at the install as the foundation of a house, something upon which all other items will be built, you'd think you want the most solid foundation possible.

Key items to ask of your install personnel:

-are you going to install all the patches (the answer is yes).  Can I get a listing of all the applicable patches and what they fix

-you will provide me with startup / shutdown scripts for the environment and this will be tested before you leave.

-can you help us increase our default java cache settings for the environment as I understand that they are set ridiculously low upon a default install?

If you get these questions answered, you can be a little more assured that your environment isn't broken coming out of the gate.

Oh yeah, don't forget a sanity check on the server specs.

A typical Hyperion Planning or Oracle EPM environment for production is at least 3 servers, each with at least 2 processors and 8 gig of ram.

server1: essbase: 8 way minimum (16 gig ram)

server2: planning, epma, 2 way minimum (8 gig ram)

server3: bi+, reports 2 way minimum (8 gig ram)

If you're going virtual make sure the above is met as well.

hj

Last Updated on Tuesday, 24 August 2010 12:35
 

Johnson & Associates Consulting is a St. Louis based consulting firm specializing in Hyperion Business Intelligence Solutions.   These solutions are comprised of Hyperion Essbase, Hyperion Planning, and Hyperion Financial Management (HFM).  I founded this company over 15 years ago with consulting solely in the Hyperion product suite.  I had no idea that the Hyperion slice of this market was going to continue to grow and I was willing to change technologies as the industry has evolved but this was not necessary.  During the last decade we have seen the original Arbor Essbase software go through 2 mergers / acquisitions.  In addition, many of the original olap competitors (50) have been left along the wayside and we are now down to less then 10.  My firm can handle anything from short notice infrastructure installs to complete project implementations.  While about 40% of our projects in the past decade has been from salvaging failed projects, we are constantly on the lookout to find new projects that we can run from requirements gathering to go live.  Feel free to contact us if you have any questions about Hyperion.  These could range from needing to find a critical resource to what components should be used for what purposes.

howard johnson (hj)