Want to know The Truth About CPM?

30 August 2010

11.1.2 zombies ate my brain, and how I got it back, part 1

I am an installation drama queen

Corvus brachyrhynchos is a delicious meal, especially when garnished with a rosemary sprig.  Why would I eat crow?  Cast your eyes to this triumphant post.

 

Yes, 11.1.2 installed just fine, and without (mostly) incident, and it even ran.

 

There was one small problem – it consumed:

1)    All of the memory in a 32 bit Windows Server 2003 VM (4 gigabytes)

2)    All of the memory in a 64 bit Windows Server 2008 VM (6 gigabytes)

3)    All of the memory in a 64 bit Windows Server 2008 dual booted laptop (8 gigabytes)

 

Are you noticing a trend?

 

And when I mean consumed, I mean *all* of the usable memory.  Oh, 11.1.2 might start out with 20 or 30 megabytes of free memory, but any activity dropped the available memory to just about zero – the hard drive light stayed a nice solid blue as Windows continuously paged to disk.  I wouldn’t call 11.1.2 the undead, but it certainly ate my laptop’s brain. 

 

NB – 11.1.2 does run in this use-all-the-memory mode, but it is excruciatingly slow and just isn’t going to be viable for testing, learning (okay, maybe that), prototyping, proof of concepting, etc.  I do those tasks all the time with 11.1.1.3 running on a 4 GB 32 bit VM.  Sigh.

 

Along the way, an epic Network54 thread ensued, as did a less painful one on OTN .  I also hijacked a thread on LinkedIn.  I am pleased (?) to write that everyone’s consultant/tire kicking/Wot’ll she do, Mister? install of 11.1.2 is the same – it runs, but oh my goodness, does 11.1.2 use a lot of memory. 

 

Yes, it has occurred to me that perhaps Oracle didn’t architect 11.1.2 with a single laptop install in mind.  Having acknowledged that, the issue remains – I make my daily bread off this technology, 11.1.2 has lots of cool features, and I need access to it.

What to do?

Based on my discussions (I thank you all for your calmness in the face of my blind panic), the consensus is eight gigabytes isn’t enough memory for an 11.1.2 installation that uses:  Shared Services, Workspace, EPMA, Calc Manager, Planning, HPS, EAS, and Essbase.  I’d also like:  FDM, Financial Reports, and Dodcea

 

So then the question becomes – how much memory is enough?  I have heard approximately ten to tweleve gigabytes, depending on who you talk to.  Alas, my nifty (and nearly new) Latitude 6500 maxes out at eight gigabytes. 

Another laptop?

There are laptops that address more than eight gigabytes.  Tim Tow pointed out that Dell now makes a laptop that can take 32 gigs of RAM.  Er, not at $14,000 for this particular consultant.

 

Dell also makes a Precision 4500 laptop.  With 16 gigabytes of RAM, it’s a mere snip at $6,700.

 

Jake Turrell noted that Lenovo sells the same basic laptop as the 4500 but it costs “only” $3,000.

 

Why Dell’s offering costs so much more (yes, I did go through and custom configure both laptops to the same chipset, drive, screen, blah, blah, blah and the Lenovo still came with more features) than Lenovo’s I couldn’t say. 

 

A couple of thoughts about laptops:

1)    Another $3,000?  I just bought this laptop three months ago for $3,000.  Eeek.  Yes, welcome to technology in the 21st century, but it still hurts.

2)    How do I know that my even more super-duper laptop will make it to 11.1.3 or 11.2 or 12.1 or whatever the next release of Oracle’s EPM stack will be called?  I don’t mind buying new equipment more frequently than I’d like, but this is getting ridiculous.

3)    Even if I have a 16 GB laptop, will it be powerful enough to handle the 11.1.2 EPM stack when I do real work on it?

4)    Dell (I’ve owned Dell servers, workstations, and laptops since the mid 1990s), your pricing is way out of line and you’re going to lose sales with at least this geek.

Go to the Cloud

Angie Wilcox made a really good suggestion (it’s there in the Network54 thread) that I take a look at cloud computing instead of endlessly beating myself to death over trying to make the gallon of 11.1.2 fit in the pint of eight gigabytes of RAM.  And, as I truly suck at installations (okay, that’s my interpretation, Angie didn’t write that), why not a company that has already done all of the hard work?

There’s interest out there

I have received emails about my Network54 thread asking me to blog about my cloud computing experience.  No one has ever written to me before, urging more exploration/stumbling about/desperate grasping at straws about a question I posed on any board.

What this blog is not about

Remember, I’m not coming at cloud computing from the perspective of hosting production applications – I’m strictly here for a 11.1.2 sandbox as I am but a humble Oracle EPM implementation consultant. 

Other views

But even if you work for MegaCorp GmbH, NSULC, N.V., S.A., S.p.A., LTD, Ltd., Ltd (Pty), p.l.c., (Pty) Ltd, or Inc., my journey should help you figure out if cloud computing is of value to you and your company.

A training teaser

One last thing I’m not going to write about in this post (but likely will in future) – the opportunities cloud computing offers for training are immense. 

 

I have taught classes at clients where the install was woefully inadequate for a whole variety of reasons – this didn’t exactly make the class easy for me or all that valuable for the students.  Yes, everyone marching up to the front of the class to get five minutes at a tool and then switching places is an interesting approach in resource sharing but is not exactly good value for money. 

 

That won’t happen to me (nor should it happen to you) in the future – I’ll rustle up as many of these sandboxes as required and go from there.  As you’ll read, an EPM stack in the cloud is powerful medicine.

Who are the players?

There are many players in the cloud computing world, but only two that specialize in commercial Sandbox offerings for the Oracle EPM world:  EPMCloud and Full360.

 

Interestingly, both companies use Amazon’s EC2 platform to provide a fully installed Windows Oracle EPM 11.1.2 single server stack that is *exactly* what I need.

 

Could I contact Amazon directly, create/buy a Windows image, and roll my own?  I could, but I’ve already wasted more than a month of my free time trying to get 11.1.2 up and running.  My agony is your good news, but no more, please.

 

With the avoidance of further pain in mind, I emailed EPMCloud and Full360 to see what their offerings are; EPMCloud reached me first, so they get written up first.  I fully expect/hope/pray that I’ll be writing another post about Full360 in the near future.

EPMCloud

EPMCloud is an EPM cloud installation (hence the name) offering from a company called HyNote

 

HyNote have an interesting business model.  I’ll quote directly from their web site:

Who we are


Conductor
Founded in 2006 by software industry veterans, HyNote introduced an innovative approach to community-based solution delivery with the launch of it's Orchestra Partner Network; a global network of independent IT services and consulting firms with the ability to operate as one virtual company.  HyNote helps mid-sized and large enterprises implement and support Enterprise Performance Management and Business Intelligence applications.

 

EPMCloud is a cloud-based application delivery platform used by HyNote and our partners to take cost, complexity and risk out of enterprise application deployment and operation for our customers.

 

Well, I’ve got a bellyful of cost, complexity, and risk.  Can EPMCloud end my 11.1.2 indigestion?

The EPMCloud experience

I contacted EPMCloud, spoke with Tommy James, and before I knew it, was at the wheel of a 15 gigabyte quad virtual core sandbox.  That is exactly what I need, don’t have, and can’t get on my laptop. 

What is it?

It’s a virtual server.  It can be persistent, or not, between sessions.  You can run it for a long time, or not, although cost does enter into that as I’ll discuss in a little while.

 

On this virtual server, you are a Windows administrator and you can pretty much do whatever a Windows admin might do, including installing software.  For instance, I am a Dodeca fan and that’s one of the first things I would likely install on this box.  I also am a big advocate of ODI – onto that box just as quick as I can manage. 

 

One thing that’s kind of neat – when you download software onto that server it’s happening at the throughput of the virtual box, not your local connection.  I have a slow DSL connection (although it was more than adequate for using the EPMCloud server) but saw this kind of download speed when I was kicking the ASO Procedural Calc tires in the latest issue of Oracle Magazine.

What it isn’t?

EPMCloud’s sandbox is not for production use.  Testing, learning, prototyping – these are all Good Things.  HyNote consult on offering true production hosting.  Why not contact them and ask them all about it?

How big is the sandbox?

 

What’s installed?

 

Is there something missing?  Remember, this is a Windows server image – you can install anything you like. 

 

And you get utilities as well:

 

Logging on

The dramatic side of me wants to tell you that getting onto the server was a kind of Herculean task that took hundreds of years and cost millions of lives.  Nope, all I did was run Remote Desktop Connection, put in the IP address given to me by Tommy, and away I went.

 

The anticlimactic is climatic

By Jove, here’s something more powerful than most laptops:

 

NB – I was erroneously given their Extra Large server with 15 GB of RAM.  The normal EPM sandbox is a 17.1 GB box with two virtual cores instead of four.  No matter, CPU speed for this kind of stuff isn’t the issue, it’s the amount of memory.

Remember, we’re in Windows

Familiar, isn’t it?  I was practically bouncing up and down in my chair at this point.  Can you tell this is what I’m looking for?

The Start menu

 

It’s so normal I could cry.  Well, not really, but it is really nice to see that, and have had nothing to do with its creation.  I leave that to the EPM installers of this world, bless ‘em all.

Client connections

EPMCloud’s 11.1.2 instance does not include Microsoft Office.  However, I happen to have a Windows XP VM just waiting for 11.1.2 client software.  You can download the Classic add-in and/or SmartView from Oracle directly or through EPMCloud. 

 

I chose to download the good old add-in from EPMCloud:

 

And then ran an install:

 

Yes, the 11.1.2 add-in install first has you run a binary to install, and then when you start Excel there is a second step.  Weird, but there it is.

 

Magic, isn’t it?

 

Performance

I ran out of time to really performance test this thing but I can certainly provide some subjective findings:

1)    Is this faster than a laptop?  Unless you’re talking about one of those ~$15,000 laptops I mentioned above, you bet.  It is significantly faster than my poor eight gigabyte laptop.  Everything I did was practically instantaneous instead of the click, pause, pause, pause, display, click, pause, display, click, etc experienceThat was the whole point of this exercise, so a definite win.

2)    Is it as fast as a fully architected multiple server installation running on SSDs, Fibre Channel connected servers (not so likely, eh?), etc., etc., etc.?  Nope, but that’s hardly the point of the Sandbox product. 

Price

Yes, this is the $64 (oh, the punning, 64 bits, and dollars, and I get to work in an old radio show) question. 

 

Is this price effective?  My usage model will likely be:

1)    An hour or two before work and at night (yes, I am sad)

2)    A few hours every weekend

 

The above pattern will be amplified when I need to learn something new for a project/client, and then usage will die off as I get involved in something else/have finally learnt the particular technology/try to have a life.  I could easily see touching my persistent EPM sandobox seven days a week, maybe even twice a day.

 

Alternatively, as I build prototypes and/or proof-of-concept systems, I’m likely to use the sandbox eight or ten (yes, that sad bit, again) hours per day, for maybe five days in a row.

So how does much does EPMCloud cost?

These prices are subject to change.  The prices below reflect the pricing model as of the writing of this post but this blog is not the price sheet.   For that, go right here.  I have been informed that the pricing you see below is not on the EPMCloud website but will show up soon.

 

Having stated that disclaimer, here’s what I know now:

1)    There is a $25 fee each time EPMCloud starts up a new sandbox from one of their base images (you know, the one you didn’t spend any time installing, testing, whining about how you can’t get it to work, etc.).  This startup includes the first four hours of sandbox time.

2)    Remember, you can stop a sandbox at any time.  Restarting that sandbox will cost you $5.  No hours go along with that restart.

3)    Once you go past the first four hours on new sandbox startup in #1, or any time you use on the restart as in #2, the regular hourly rates apply. 

Those hourly rates

The hourly rate for what EPMCloud calls a HM Extra Large sandbox, with 17.1 GB of RAM, 6.5 ECUs, and two virtual cores is $1.15.

 

NB – An ECU is an Amazon’s EC2 Compute Unit.  A single ECU is equal to a 1.0 to 1.2 GHz 2007 Operton or 2007 Xeon processor.

 

So let’s look at a use case of CL, a typical (?) consultant who has no large infrastructure group to hand him that great big 11.1.2 VM.  A side note here – I have spoken with multiple consultants about their company’s 11.1.2 sandbox as surely they must have it, be kicking the tires on it, learning more than I so they can kick my derriere when it comes to engagements, etc.  And do you know what?  Not a single blessed one has it.  Oh, they will, sooner or later, but yr. obdnt. srvnt. believes in taking his training and prototyping destiny into his own hands.  You must either be hammer or anvil.  You choose.

 

Now that I’ve scared/shamed you into further reading, let’s see what we have.

Cameron the consultant’s use case

Given the $25 startup cost the new start costs, and the $5 restart, and the $1.15 per hour charge, here’s what doing some tire kicking/prototyping might look like in a typical month.  As always, your usage may differ, and this could cost less or more.  I encourage you to contact EPMCloud and fully discuss your requirements. 

 

Date


Startup

Hours

Cost

Why?

1-Sep


 

 

 

 

2-Sep


 

 

 

 

3-Sep


 

 

 

 

4-Sep


$25.00

0

$25.00

Tire kicking

5-Sep


 

 

 

 

6-Sep


$5.00

2

$7.30

Training

7-Sep


 

 

 

 

8-Sep


$5.00

1

$6.15

Training

9-Sep


$5.00

8

$14.20

Prototype

10-Sep


$5.00

8

$14.20

Prototype

11-Sep


$5.00

4

$9.60

Prototype

12-Sep


 

 

 

 

13-Sep


$5.00

8

$14.20

Demo to client

14-Sep


$5.00

8

$14.20

Tweak prototype

15-Sep


$5.00

2

$7.30

Demo to client

16-Sep


 

 

 

 

17-Sep


 

 

 

 

18-Sep


$5.00

3

$8.45

Blog writing

19-Sep


 

 

 

 

20-Sep


 

 

 

 

21-Sep


 

 

 

 

22-Sep


 

 

 

 

23-Sep


 

 

 

 

24-Sep


 

 

 

 

25-Sep


 

 

 

 

26-Sep


 

 

 

 

27-Sep


$5.00

8

$14.20

Prototype

28-Sep


$5.00

8

$14.20

Prototype

29-Sep


 

 

 

 

30-Sep


 

 

 

 

Montly total


$ 80.00

$60.00

$149.00

 

 


 

 

 

 

 


 

Total cost:

$229.00

 

 

Is $229 a lot of money for a month’s worth of 11.1.2?  Well, if your name is Rich Uncle Pennybags, maybe not.  Not even if you’re a humble consultant as you won that job and are going to bill 200 hours on the project.  You’ve made your money over again and again and again.

 

I won’t bore you (Now he writes this?  Too late.) with how much time I wasted trying to get a usable 11.1.2 environment going – time I could have spent learning more about this release and doing work that will lead to billable hours.  Playing around with stack settings in the Windows registry is amusing, but not actually helpful.

 

For those of you lucky enough to eat and sleep in your own house every night, throw out billable hours and substitute project done on time and the big promotion that results. 

Conclusion

So there you have it, a complete 11.1.2 installation, running correctly (and quickly), a mere network connection away.

 

The amazing thing is there is nothing amazing about the EPMCloud Oracle EPM experience.  It just works. 

 

Should you give serious consideration to EPMCloud’s Sandbox?  Absolutely.  I am.

People I’d like to thank

My journey to a usable 11.1.2 install isn’t over yet, but I’m a lot further along than I thought I would be.

 

I bugged so many people out there, and so often, for help with my 11.1.2 installation woes that it’s impossible to work most of you into the narrative of this blog.  The best I can do is to list your names alphabetically; if I’ve missed anyone, let me know and I’ll add you to the Roll of Honor.  Thank you all for your patience and forbearance:

Jay Aleck

Indra Bangsawan

John Booth

Charl Du Toit

Tommy James

Tim German

John Goodwin

Jeff McAhren

Dan Pressman

Glenn Schwartzberg

Minash Shah

Tim Tow

Jake Turrell

Ben White

Angie Wilcox


8 comments:

Christian said...

Cameron,

This post has a catchy title and very well composed content. Well done!

I always new some team would start build a business model managing EPM in the cloud and I agree with your conclusions that ultimately the cost is definitely worth the value of knowledge gained, time saved fumbling with an install and memory lag issues, and off loading responsibility on hardware.

11.1.2 is a beast and loading up the entire Fusion Middleware Suite for Oracle EPM a single workstation or laptop is definitely not advisable. I like that you did however explore some high-end, high-cost laptops showing that a few ridiculous options to exist there.

Thanks for this post that gives your fellow consultants an additional set of options to think about when ramping-up on the new Oracle stacks.

Institut Francais des Réflexologues said...

Hello,

What is the name of the Linkedin Group please ?

Thanks a lot for your post.

Cameron Lackpour said...

Pierre,

The group is called "Oracle Essbase".

Here's the thread (you will need to log into LinkedIn first):
http://tinyurl.com/25skz67

Regards,

Cameron Lackpour

Anonymous said...

Cameron - this might just be one of the best, most useful blogs of ALL time - ever. Did I mention it is just great? WOW. I guess I am going to have to put you on my lunchtime reading list!
--Angie

Cameron Lackpour said...

Angie,

Touche. :)

Nevertheless, I'm still going to thank/tease you in the next cloud computing post. HAHAHAHA, it's my blog and I can be just as big of an idiot as I want to be. You are *not* allowed to nod your head knowingly when you read that last sentence.

Regards,

Cameron Lackpour

Daniel Poon said...

I put the same EPM Install i.e. Essbase, Planning, EPMA, Foundation, HPCM, HPS, RA (WA, Reports, IR) on my 8Gb Macbook Pro laptop (but really only running on a 4Gb Fusion VM) and it works perfect. Takes only 3.6Gb memory. And then I run another VM on Win 7 using 2Gb to do Excel (Addin + Smartview). I am also running OSX.

So not sure why I'd want to pay $1 per hour on the cloud. And my laptop certainly did not cost me $15000.

Cameron Lackpour said...

Daniel,

How much memory is free when you run all of that in 4 gigabytes? I found the multiple WebLogic instances to eat all of the memory and there didn't seem to be any way to tune it.

I don't know if you read John Goodwin's blog, but he just posted about 11.1.2.1's compact deployment: http://john-goodwin.blogspot.com/2011/05/epm-11121-compact-deployment.html

That approach might make it usable but was not available in 11.1.2.

Remember, I could get it all to install and even run -- it was just completely unusable. I have (time marches on -- it was pretty hot stuff as of last year) a fairly hefty 64 bit Windows laptop, and yes, I tried installing Windows 2008 directly onto an alternate drive and still didn't get performance I could live with.

You're the first person to say that it all works great in 4 gigs. Or even 8.

As to why else you'd bother with the cloud -- how about: much faster performance, the ability to spin up as many instances as you need (come to KScope11 and take a lab -- you'll be in the cloud), the ability to quickly snapshot and share your installation, the ability to treat the cloud instance like a real server instead of a one-man box, etc. I happen to be giving a presentation on the cloud -- come to it and perhaps I can convince you. :) For all of the mild pain it's caused me, it has been worthwhile.

Also, if you're coming to KScope11, I'd love to see your laptop in action. Was there a simple switch that made it all work? I am an installation idiot, so it's entirely possible but you're the only person I've heard thus far who has been able to make it work.

Regards,

Cameron Lackpour

P.S. I take that back -- Jake Turrell said he had success doing it in 8 gigs (I think) but he used SSD drives and so the insane paging to disk was somewhat alleviated by faster drive performance.

Daniel Poon said...

Just installed my home server since ram is so cheap on an i5-2500k (total cost $600) but it's slower than a 8gb MacBook with SSD still but no.