An homage to “Who moved my cheese?”
One of my colleagues had a client request to turn on data auditing in Hyperion Planning 220.127.116.11.
Seems they have multiple people forecasting the same cost centers which was causing some confusion.
The “my data is gone” is always an interesting conversation; the last client conundrum of missing data I recall where planning data went “missing” was a defense contractor client — that root cause was someone changed substitution variables and voilà! presto chango no data show on the forms; always a fun conversation when your manager goes so this data is gone and the client isn’t real happy. My first reaction is data doesn’t go missing; then the next reaction is I wish we had Essbase ssaudit on and we would know who cleared it, who changed it, or where it was before.
The interesting thing with the audit features of planning is it logs this information to a relational table within the given planning application database (schema on Oracle) however there is no query mechanism.
There are also no tools which come with planning other than Web Analysis which can query and put it into a nice presentable format.
So I mess around with Web Analysis for a bit, creating a relational data source and then in the wizard get stuck at the area you define dimensions and measures. I phone a friend (or two as it turns out) one Mr. Collins and one Mr. Nader. Dave quickly relates this technology isn’t recommended and Oracle (and Hyperion) hasn’t touched it since Brio wrote it. He relates you probably want the SQL Spreadsheet vs trying to do it another way; turns out it’s very easy with this widget.
So how does it work?
Next save it to a handy area in your worskpace structure.
NOTE: One caveat; if this app were used for salary planning you may want to restrict who can see these reports.
P.S. Web Analysis is going away.
P.P.S One would expect Oracle would need a way for Planning and Budget Cloud Services to see the audit information.
We’re working with a client on an upgrade where Essbase and Essbase Studio are on a Red Hat 5.6 Linux box. Funnily enough a rival consulting firm said you shouldn’t use Linux for Hyperion due to memory leaks (I called BS on that fast).
So on to the issue: the installer hangs at 0% and logs reflect disk space issue. All the disk space looks great — we even increased /tmp and swap to 10GB per a recommendation from an Oracle support friend.
First level Oracle Support for hard (read unique) issues is as useful as one would expect — I do have a great respect for how the Knowledge Base has grown. The first tier guys aren’t as good as the Financial Data Quality Management support team has been (and rumor has it most of them are no longer with Oracle) when you get lucky or have a system down issue you generally get the better service.
So after a few hours of sleuthing it turns out the /tmp file system is mounted with the noexec flag.
Well this is interesting as we had set the four variables (TMP, TEMP, TEMPDIR, TMPDIR) that should have been using /u01/tmp.
Syntax for this presuming you create a folder in u01 called tmp is:
$ export TMPDIR=/u01/tmp
$ export TEMPDIR=/u01/tmp
$ export TMP=/u01/tmp
$ export TEM=/u01/tmp
So a few complaints here:
1) The EPM installTool.sh is hard-coded in places to use /tmp vs adhering to over-rides — I’ve communicated this to Oracle at some pretty high levels today. If you run into this issue hack the installTool.sh and use the directory you set above variables to see below for an example of this.
2) InstallShield has really bad error reporting for something that crashes and burns — they received a Twitter note which was promptly favorited from a fellow in France to my enjoyment. Maybe @InstallShield will put a note in their KB.
3) Irritated when security things kill product functionality; at least there is a work around (shown above).
4) GoogleFu saved me — an IBM web page had a vague comment (not related to Oracle, Hyperion, or InstallShield) that made me check /tmp settings in the /etc/fstab
Hello all, it’s been quite some time since my last post. I’m going to share some recent things and also talk about Kscope14. This post is a bit different than my typical keep it technical. We’ll see if I get into trouble from anyone or everyone ;).
What’s been going on with me? At the end of this month it will have been 9 months at Huron – it’s been very busy since joining. We usually see a slow-down in CY Q4 for EPM work where we can catch up. For whatever reason: recovering economy, growing practice, great people we’ve not had the luxury to catch our breath.
We have an Exalytics X3-4 implementation we’ve been working on with another partner, Oracle, and HP on – going live soon.
At another client it’s a bigger deployment using the Exalytics T5-8’s – you need all your fingers to count their environments from dev, test, stage, train, reg, and prod to red, yellow, blue, and green. On an Oracle call we mentioned we had 10 environments and they said, “you have 10 servers”. No we have about 60 servers which host the 10 environments….was an amusing conversation.
What’s the future hold for the blog:
- EPM Test Drive III (a bit late)
- EPM Test Drive IV (hopefully right on time – II was out within 24 hours of 2.2)
- Performance Testing with JMeter (Essbase MDX to begin with)
- Playing with WebLogic Enterprise Manager plugins
On to Kscope14. The title Falling in Seattle is true. Monday night of the conference a sidewalk decided to disagree with me and I received a minor sprain from the spat. This happened to be the same leg I broke a few years ago so it was a bit concerning. Mike Nader joined me for a 3 hour tour of a local hospital interrupting our crashing of an Oracle client event (Mike I very much appreciated the company – Debb says I should get you a fruit basket or something).
Shout outs to those helping during my time of mobile impairment:
Susan of our marketing team, Jesus one of our planning leads (funny story one of my clients referred to him as a higher power during an email exchange I had while doing the work thing during the conference thing), Reg and Tim of Qubix, Venkat from Canada (thanks for the assist leaving the conference), Cameron who I shamelessly asked for assistance a few mornings and last but not least Natalie for her moral support (she would have been at the hospital however Mike had my back there).
So what about Kscope14 John? You get all chatty, go off the normal topic, enough on to this Hyperion mastery thing!
Some very cool things coming down the pipe (or pike?). I tend to think of it as pipe personally vs. a fish or water device.
18.104.22.168 or PS4 as the Oracle folks refer to it is coming in Winter. Makes you wonder if they are watching Game of Thrones….(the books are decent up through #3 by the way). My guess is December 15th, 2014.
BI on the Cloud
BI on the cloud looks very intriguing – they’ve build some nice training content that leads you through configuration and setup. You’ll get 5 GB of DB space (gmail gives me 15 GB of free email by the way and my iPhone is rocking with more flash than that) and it sounds like you will be able to license Oracle DB on the cloud for additional space. I’m positive on the product and am looking to convince my practice we should sign up for this guy.
Essbase (and Essbase on EXA)
Some very compelling statistics were shown for Essbase 22.214.171.124.500 both on commodity and Exalytics.
Commodity 126.96.36.199.500 was shown to be faster than Exalytics on 000 (realize commodity in this context is the exact Oracle Hardware)
On Exalytics with .500 we are now seeing linear increases as the number of threads (cores) are increased for applicable calculations. We now have the analytic power we were promised – it’s very encouraging how the platform has been steadily improved at a rapid pace.
We also heard mention of a new X designated Exalytics. Had some conversations on X vs T – my take on that is pick the OS your IT team is most comfortable with Linux for X or Solaris for T. Both systems perform exceptionally well on 188.8.131.52.500.
We are going to see EPMA ported to the Unix platforms at some future time – my guess is it doesn’t hit the cloud though (although I could be wrong). Datasync is going away from EPMA (see FDM EE)
I called this one a few years ago – FDM EE is going to be all things data/metadata for the EPM Suite. Source adaptors for EPM products will be coming and this will replace the Datasync feature being obsoleted in EPMA. As an aside — one of my colleagues Leo Bichon has implemented metadata and data on FDM EE from an EBS system and it’s pretty slick. I also finished up a deployment of FDM EE on SAP late last year. I’m becoming quite the fan of Jython as a scripting language too.
Hyperion Financial Management
It’s coming to Unix specifically the Exalytics platform first. We’ve heard this for a while and they really sound confident it will come out in 184.108.40.206 Word is this thing will be pretty fast. It will be nice to be able to have a full unix stack when this and EPMA hits.
Oracle Data Integrator
One of the few unhappy things I heard about (I was happy about Datasync going away – go Classic) was it appears the Planning and HFM Knowledge Modules are going to no longer be produced staring with ODI 12c. Apparently not enough companies use these for it to make sense to continue them. Flat files using either the HFM API or Planning Outline loader.
Some very cool stuff coming to planning. My hat is off to the Planning Product teams (Management and Development) for invigorating the platform.
The Essbase Hybrid engine along with an updated ADF control for grid entry turbocharges Planning. With the new web grid control the web blows Smart View performance away. Several grids were demonstrated going up to and over 100,000 cells which rendered in less than 10 seconds without bring the client machine to it’s knees.
A note about Hybrid – this will require one of the following licenses to make use of:
Planning Plus + Essbase Full Use
Planning Plus + BI Foundation Suite
Enterprise Planning Suite (I think since it allows limited use ASO it should also confer the limited use Hybrid) – the Suite license also give you a ton of other products from Planning Modules to HSF to FDM EE.
We also see some cool new web/tablet interfaces (coming in 220.127.116.11.600 and PS4 rumor says) as well as valid combinations ala PeopleSoft.
Infrastructure Deep Dive
This year Thursday was changed up a bit – I had an early (delayed) flight out so didn’t stick around for the closing ceremony however our (Rob Donahue, Eric Helmer, and myself) 9:00 – 11:00 session was well attended even with it being last day and America and Germany squaring off at the World Cup.
Download the presentation EPM Infrastrucure Deep Dive.
Well that’s all for now and hopefully this makes up for my lack of content over the last year.
I had the opportunity today to get my hands on the upcoming release. It’s looking very good. My guess on release date this year is April 22nd.
The quick take away’s from in installations point of view are:
- You may configure all databases at once. This means a much quicker installation.
- The services have been renamed for the most part (see below).
- Less Microsoft specifics when we talk about FDM EE (no ASP.NET requirement)
If you have a travel budget or are in the Asia Pacific area, then mark March 21st and 22nd off on your calendar.
My good friend Cameron Lackpour is presenting at the BI/EPM Seriously Practical conference in Melbourne, Australia. Richard Philipson from New Zealand who I also consider a friend will be there as well. They both tend to have compelling and entertaining presentations–so pack your bags and check it out! For those of you in the area this is a not to be missed event.
I would love to visit Australia again — with my recent job move I have too many things going on to contemplate and the budget may not be there just yet.
Happy New Year!
I wish everyone a great 2013, today I give you a walk through of my new test server build on YouTube. I discuss the individual pieces of a server and build it in real-time in a 90 minute video.
After the build was completed I installed Windows Server 2012 as well as Oracle Enterprise Linux 6 Update 3. I then installed Essbase 18.104.22.168 on both systems. Although Essbase is not technically supported on Server 2012 it was a fairly painless process — NOTE: I did attempt to put a full EPM Suite on and there was some unhappiness with the WebLogic portions so I went ahead and only put Essbase on using my other test machine for the Web portion.
I have just finished ordering the parts for my new test server at home. It consists of: an Intel Server Chassis supporting dual six core Xeon processors, 128 GB of Ram, and four Corsair Force GS 180 GB solid state drives.
Presuming shipping goes as expected and it arrives by 12/27 I will begin a build before the weekend which I will capture and upload to YouTube.
I’m excited to do this build and hope it is indeed compatible with the LSI 9271-8iCC controller which has been giving me headaches in my ASUS server.
The old server was aggregating a test Essbase database to 86 page files in less than 30 minutes using solid state disks as the data store; the new server and LSI card should beat that handily.