Latest Posts

DIY Hyperion Planning – Ingredient List

Some Context . . .

This is the second post in a multi-part blog educating readers on how to build a personal “sandbox” environment for Hyperion Planning. Click here to see all nine posts in the series. Please note that the contents of this post are not appropriate for building production environments. Please be sure to engage a qualified EPM Infrastructure consultant for any “real” environments.

Also, note that this post does not cover Oracle’s “Rapid Deployment” option for Hyperion Planning. Because the Rapid Deployment option excludes certain products and does not really teach the reader about Hyperion Planning’s infrastructure, this topic will not be addressed.

Decisions . . . Decisions . . .

Before building your very own Hyperion Planning environment, some upfront planning is required. The following key decisions will need to be made. Think of these as the main ingredients in your Hyperion Planning recipe:

  • What kind of hardware will be used?
  • What kind of virtualization software will be used?
  • What operating system will be used?
  • What relational database will be used?

There are many, many options regarding the questions above. Let’s explore these a bit.

Hardware

Because I run demos at client sites and conferences, I prefer to host my Hyperion Planning environment on my laptop. But not just any old laptop will do . . . you’ll want something that’s “workstation” quality. The two best options currently available are Lenovo’s “W” and Dell’s “Precision” lines of laptops. The following features are critical:

  • Quad-Core Processor
  • 16GB of RAM (at least . . . I prefer 32GB)
  • 500GB SSD

Could you run Hyperion Planning on something less? Maybe, but it will take a very long time to start, and it will perform poorly once it’s running. Could you use a desktop computer? Absolutely – the same hardware requirements apply, but it’s not portable. Could you use cloud infrastructure like Amazon Web Services? Yes – you’ll just be paying by the hour, and will be limited by your current location’s available bandwidth. In summary, make sure you have beefy enough hardware. Installing Hyperion Planning takes a while, and you don’t want to find out at the very end of the process that your installation was successful, but you underestimated your hardware requirements.

For this post, I’ll be using a somewhat old Lenovo W520 with a Core i7 processor, 32GB of RAM and a 1TB Samsung 840 Evo SSD.

Virtualization Software

There are a handful of virtualization options from which to choose. Pick the one you’re most comfortable with. For the purposes of this post, we will be using VMware Workstation 11. Microsoft Hyper-V and Oracle VM VirtualBox will also get the job done.

Operating System

For Hyperion Planning 11.1.2.4, most users will either install Microsoft Windows Server 2012 R2 or some flavor of Linux. Just remember that several products are still not supported on Linux, including DRM, parts of EPMA and Strategic Finance. HFM is not currently supported on Linux unless you have an Exalytics box. For this post, we’ll be using Windows Server 2012 R2.

Database

I have to admit, I really like SQL Server. It’s so easy.  But because many people reading this won’t have access to the software, we will use Oracle Database 12c.

Downloading Oracle Database

The Oracle Database files can be downloaded from e-delivery here. After signing in and accepting the terms, select “Oracle Database” and “Microsoft Windows x64 (64-bit)”. Select “Oracle Database 12c Release 1 (12.1.0.1.0) Media Pack for Microsoft Windows x64 (64-bit)”. The following files are required:

File Contents
V38893-01 Oracle Database 12c Release 1 Client (12.1.0.1.0) for Microsoft Windows x64 (64-bit)
V38894-01 Part 1 of 2 Oracle Database 12c Release 1 (12.1.0.1.0) for Microsoft Windows x64 (64-bit) (Part 1 of 2)
V38894-01 Part 2 of 2 Oracle Database 12c Release 1 (12.1.0.1.0) for Microsoft Windows x64 (64-bit) (Part 2 of 2)

Downloading Hyperion Planning

Within e-delivery, select the menu options “Oracle Enterprise Performance Management System” and “Microsoft Windows x64 (64-bit)”. The following files are required:

File Contents
V74007-01 EPM System Release 11.1.2.4.0 Installation Documents and Readmes
V74025-01 EPM System Release 11.1.2.4.0 for Microsoft Windows (64-bit) Part 1
V74031-01 EPM System Release 11.1.2.4.0 for Microsoft Windows (64-bit) Part 2
V74011-01 EPM System Release 11.1.2.4.0 Part 3
V74037-01 EPM System Release 11.1.2.4.0 for Microsoft Windows (64-bit) Part 4
V74044-01 EPM System Release 11.1.2.4.0 for Microsoft Windows (64-bit) Part 5
V74050-01 EPM System Release 11.1.2.4.0 for Microsoft Windows (64-bit) Part 6
V74056-01 EPM System Release 11.1.2.4.0 for Microsoft Windows (64-bit) Part 7
V74016-01 EPM System Release 11.1.2.4.0 Client Installers for Microsoft Windows
V29856-01 Oracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence
V74019-01 EPM System Release 11.1.2.4.0 for Microsoft Windows (64-bit) Oracle HTTP Server

Ready . . . Set . . . Go!

At this point, you have all of your ingredients. You have:

  • Hardware
  • Virtualization Software
  • Operating System
  • Relational Database
  • Oracle Hyperion Software

In the Next Post

With all of the hardware and software ingredients lined up, it’s time to start building. We will begin by installing VMware Workstation 11 on your host. Next, we will create a virtual server and install our operating system and relational database.  Click here for the next post in the series.

DIY Hyperion Planning – Introduction

Starting a blog is a new experience for me.  I implement Hyperion Planning and Essbase solutions for a living, and as part of that process I write a lot of user guides and admin guides.  I’m used to writing formal, structured documents where I don’t have to worry too much about being interesting.  Blogs are different, and finding a good starting point has been a challenge.  So let’s see if we can start with something useful . . .

The Most Effective Thing I’ve Ever Done to Advance My Career

I’m going to illustrate, step-by-step, how to build your own personal Hyperion Planning sandbox environment (version 11.1.2.4).  This is no simple task, so why go to the trouble if you have an environment at work?  Well, it can be risky to “experiment” at work.  Perhaps you want to try something that just might bring down the whole environment?  Work might not be the best place for that sort of thing.  Maybe you need an environment on a specific version or patch?  Do you build demos for clients or present at conferences?  These are all situations where it can be advantageous to have your very own, personal Hyperion Planning environment.

There are three basic options for getting started:

  1. Leverage a pre-built cloud environment
  2. Build your own cloud environment
  3. Build your own environment on your own hardware

Option #1 is fast and cheap.  Option #2 is slow and cheap.  Option #3 is slow and somewhat pricey.  (Because you will need a Windows Server 2012 license.)  But it’s definitely my favorite option.  By building something yourself, you learn more.  And in the end, you will have an environment that you know well, and that you control completely.

If you’re looking for Option #1, head to Metavero and check out John Booth’s excellent AMI’s (Amazon Machine Images).  If you’re looking for Option #2, the information I’m going to present will still be useful.  You’ll just be using hardware in the cloud.  If you are like me and are interested in Option #3, . . . click here.