EPM Conversations — Episode 14, A Conversation with Sree Menon, The Calc Man

Sree Menon, The Calc Man

Many years ago (just over 10!), Yr. Obt. Svt. wrote a blog post on why he Hated and Loved Calculation Manager. I even did it twice. I am – oft times, still, it continues unabated – a complete smartass who pays little heed to what he says and writes and this was most definitely one of those times. These posts were a continuation of not altogether terrifically awesome judgement as they were an expansion of a similarly-snarky two parter on Hyperion Business Rules. 2009? 2012? My, but the time does fly.

So that’s four snide technical blog posts on two closely related Oracle products. As is typical and as has been noted, I performed zero thought on any potential consequences that might arise from click-bait (was that even a term in 2009?) titles: Oracle could have gotten annoyed and come down on my head with a bag of hammers or they could have ignored it and hoped that no one read my posts or they could have read it, realized that (somehow) there was a little value in it and reached out to me so that in future my posts on this

…

EPM Conversations — Episode 12, A Conversation With Kumar Ramaiyer, Workday Adaptive Planning Business Unit Vice President

As Everyone Knows, But Hardly Anyone Actually Does

One of my fondest recollections of Kscope (umm, one year or another, they all blend together after a while) is sitting in on Kumar’s introduction of Exalytics (remember that Wave Of The Future?). As Kumar dived deeper and deeper into the hardware behind Essbase-on-Exalytics, he prefaced each increasingly (exponentially?) complex computer engineering concept and detail with, “As everyone knows…”. If only. I sure didn’t.

Key to Kumar’s personality is this liberality of intellectual comradeship: he thinks that surely whatever a given insanely complex topic might be is easily understood by the average geek. This (possibly insanely optimistic) generosity of intellectual spirit informs this podcast as Kumar takes us (and you, Gentle Listener) through his journey from theoretician to developer to advocate to Vice President of Engineering while working at Informix, Oracle, and now Workday.

Cubes, Cubes, Cubes

Beyond the interesting personal history (and you have to catch Kumar’s glory days in the NCAA and yes, really; we in the performance management space are polymaths), he gives one of the most passionate, cogent, and comprehensive arguments of the cube as the ideal for planning and budgeting. I’ve worked with non-cube forecasting tools and

…

EPM Conversations — Episode 10, A Conversation with Jodi Hill, Pattern Recognizer and Outlier

We’re all wired to see patterns

We live in patterns: seasonal, political, historical, and even atomic. Many live a life blithely unaware of them, which is to their disadvantage, for understanding those patterns is key to what makes us human, drives culture and society, and informs economics. We happy few in the performance management world figuratively live and die by the patterns in data. If careful observation of clients, customers, and conferences is an accurate guide, we are largely cut from the same professional and educational cloth. This is not always true. Those of us who come from outside that pattern have different perspectives, values, and insights. Jodi Hill is one such outlier.

Her path to a job in business strategy is atypical and is driven by its unconventionality: from Army translator to accountant to consultant to strategist is surely out of our norm. So too is an educational journey from the Defense Language Institute to a BS in accounting to multiple Masters in predictive analytics, public policy, and health economics. No matter how diverse this may seem at first glance, it is held together by the thread of transforming data into information by seeing, interpreting, and understanding patterns. I’ve

…

A Free Form Planning aka Essbase SaaS Journey — part 7, I didn’t know what (DTS) time it was

I didn’t know what (DTS) time it was, Then I met you

What is Dynamic Time Series (DTS)? I am ever so glad you asked ‘cos if you didn’t, there wouldn’t be much to this post, would there? To quote (and illustrate) from the Essbase Database Administrator’s Guide (oooooh, the very latest 19c one out in the cloud). Note that it is not entirely accurate.

A screenshot of a cell phone Description automatically generated

Just what is DTS? Again, per the DBAG:

A screenshot of a cell phone Description automatically generated

What this means is that you can calculate all sorts of period-to-date members in BSO without having to write code or do math in Excel or a standard report. Lovely.

Oh, what a (non)lovely time it was, How (un)sublime it was too

I’m here to tell you a (small) secret. This functionality wasn’t always there in Essbase SaaS. In the very early days of this supercalifragilisticexpialidocious product, It Wasn’t There. Ugh. But that is the past.

I didn’t know what day it was, You held my hand, Warm like the month of May it was, And I’ll say it was grand

The present is rather different – DTS is fully supported and it’s super easy to set up just as it is in the on-premises Essbase

…

The ODTUG Learn From Home Series, Free Form Planning aka Essbase SaaS, The Changing Landscape of EPM, and Yr. Obt. Svt.

A plague is upon us. Shall we make a virtue out of necessity?

Snark is, next to laziness and general incompetence, my stock in trade, cf. this blog (and the previous one) in post after post after post. But there’s not really all that much to mock or deprecate or even gently poke fun at in the face of a global pandemic and the unknown economic cost to come.

Better then to celebrate grit and determination and optimism in the face of adversity, which is exactly what ODTUG has done with a brilliant concept: the ODTUG Learn From Home Series. If the world+dog cannot come to Kscope20, then Kscope20 will come to you. For free. Really.

Click on the below graphic that I shamelessly stole from ODTUG’s website to begin your registration:

A screenshot of a cell phone

Description automatically generated

I can’t write this better than ODTUG (cf. laziness).

We are excited to announce the Free ODTUG Learn from Home Series taking place May 19 – May 22. Get ready for four days packed with over 90 sessions plus mini Oracle symposiums—all covering a range of Oracle-related topics to keep you on the cutting edge of the latest technology.

The ODTUG Learn from Home Series

…

A Free Form Planning aka Essbase SaaS Journey — part 6, the Mac Smart View Revolution

A point fully stretched to the breaking point

Essbase on Macintosh has always been a poor relation. But it was not always thus. There was a time when ~~Apple~~ Power Computing really was Thinking Different and that difference was revolutionary. I was a (small) part of it. The emotions invoked were strong, to wit:

This is (I think) Bill Gates being tortured by Mean Girls; you can substitute Essbase on Mac for Mr. Bill. Ouch. Was Yr. Obt., Lyl., Fthfyl., & Hmbl. Svt. ever treated thus at a birthday party? If so, he cannot remember, but probably.

The last time I used Essbase and a Macintosh that wasn’t also running a VM, was in – gasp! – something like 1994, just about when I started with Essbase. Yes, there really was an Essbase add-in for Mac and I used it on my Macintosh IIfx.

Given that Macs now run Intel, this poster isn’t totally accurate but is too cool to not include:

Supposedly there’s a version around with Sluggo Smith punching Mr. I-used-to-be-the-richest-man-in-the-world-but-I’m-not-doing-too-badly-thanks-for-asking in the face but I’ve never actually seen it. This is good enough.

Evangelizing Macintosh aka being a Mac fanboi

Why, when Windows

…

A Free Form Planning aka Essbase SaaS Journey — part 4, Gonna Build An Outline

Gonna build an outline, from a little file

I’ve shown how easy it is to build an Essbase SaaS database from an existing outline .otl file. Read about my glorious experiences doing just that (and using LCM as well) here.

That’s all well and good but what if I want to do something other than migrating an outline? I thought at first that I’d have to create the smallest Essbase outline in the world ever and then import that, adding dimensions as required. Ugh. Regardless of the ugh, the ick, and the yuck, I wrote about just that approach.

I should have been more patient, because now Essbase SaaS (Have you noted that I call this product what it is – Essbase as a Service? You should.) can load from dimension files. Patience is a virtue but he who hesitates (or wants to write about something most ricky tick) is lost. I suppose that means that I am without virtue because I don’t hesitate to act before knowledge mysteriously comes my way. It was ever thus with Yr. Obt. Svt. But no matter, onwards.

Gonna build an outline, at least I hope I will

I have a

…

Stupid Programming Tricks No. 31 — Have you ever created a Unicode Planning application?

Don’t. Don’t do it.

Or at least don’t if you work in a Latin character country like the Good Ol’ U-S-of-A. And it ain’t Unicode, not really, but instead it’s UTF-8. Yr. Obt. Svt. is not going to try to even attempt to explain what UTF-8 is and instead suggests that you enjoy Joel On Software’s explanation. I encourage you to Read The Whole Thing.™ as any blog post that goes into high- and low-endian byte orders has to be good. At least I think so but perhaps I need to get a life. Don’t be intimidated (or bored beyond description) – he really did write an excellent article and I think I almost understand it. Almost.

A note: Planning cloud applications are all Unicode but this is an on-premises tale, even in 2020.

Safely ensconced in the on-premises world (which isn’t going away any time soon I might note), why shouldn’t you create a (not-really) Unicode application? Because this when one tries to import Essbase data (this is on-premises) from a not-really Unicode application to a plain old “normal” one. Bugger. But why?

Test was created in Unicode, Development and Production were not. Of course. So when it

…

Kscope20 presentations come in threes

Good things come in threes?

Just what are the brilliant creations of Hergé doing in an EPM/CPM blog about ODTUG’s Kscope20?

While you are all, I trust, ardent fans of Captain Haddock, Tintin, and Snowy just as I am, I am not suggesting that Kscope20 has become a place to meet, discuss, and learn all about what are surely the greatest fictional Belgians outside of Hercule Poirot. Wait. That would actually be awesome. Beyond awesome. But alas, no. Tintinology is not within the scope of what is after all surely The Greatest of All Oracle Conferences. Perhaps it should be in future? But I digress.

Why the triumvirate? Does putting this sketch in his blog mean that Yr. Obt. & Hmbl. Svt. finally has a chance to get that Masters in literary criticism he really ought to get via Hergé’s oeuvre? No. Thankfully. Probably. Most especially for me. Instead, the above reflects friendship. Tintin and his chums travel the world, getting into one scrape after another, fighting evil, righting wrongs, and generally doing Great Things including fighting Bolshevism, breaking international opium rings, restoring rightful governments in the face of fascist usurpers (this one is my favorite, probably

…