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

…

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

…

A Free Form Planning aka Essbase SaaS Journey — part 2, loading from LCM

Whoopsie

In my last exciting post, I stated:

Whoopsie, that’s not right. Bugger. Why? ‘Cos my Younger Taller Smarter and Definitely Better Looking Brother From Totally Different Parents noted:

Whoopsie. That’s usage of that word three times (so far). Surely some kind of record in a technical blog?

It’s up to you decide which is the bigger whoopsie: me getting it wrong or Celvin reading LinkedIn on vacation. Celvin, buddy, if you’re commenting on my many technical (and otherwise, frankly) mistakes, errors, and own goals, surely that can wait for your return to the grindstone?

My mea culpas aside, let’s see what happens when I load Sample.Basic from an LCM file. I’m not going to do this step by step as you’ve already hopefully read that bit.

Let’s look at that LCM file again

Data

A screenshot of a computer

Description automatically generated

Ooooh, in addition the outline file, there’s something called Data. Let’s open that up:

A screenshot of a cell phone

Description automatically generated

Oooh, again. That’s all of the data. See the fourth row from the bottom and the “100”? That’s a product total. LCM doesn’t export the PAG/IND files (apparently at one time it did per Celvin and I sort of remember that) but instead text, I believe because it can be

…

A Free Form Planning aka Essbase SaaS — part 1, creating an app

Essbase as διαχείριση επιδόσεων των επιχειρήσεων or Essbase as τη βάση δεδομένων?

Free Form Planning as a product name? Really? Yeah. No. Free Form Planning is really Essbase SaaS. I don’t think Oracle’s EPM product management team cast themselves as Greeks seeking to enter the city state of Troy through subterfuge, but make no mistake: Free Form Planning is Essbase, it is Software as a Service, and it is an application option within the Enterprise EPM product sku that you really, really, really ought to look at.

Most definitely not the Oracle EPM product management and development teams. Maybe.

Don’t believe me? This post is but the first of a multipart series on Free Form Planning as I make my case for FFP (I am so over writing the full name, cf. my well-known laziness and also remember this is really Essbase).

Before I document this first pass at creating an Essbase SaaS aka FFP application, I should note that the below is not the only way to create an application and it has twists and turns. As noted, this will be a series of posts on how this works.

With that, let’s create the app.

You’ve Got Possibilities

…

My take on OGB Appreciation Day: An Essbase Hacker’s POV

“Smart boy, doesn’t follow instructions, must try harder”

Pretty much every teacher I ~~tortured with my intransigence and folly~~ gladly received tutelage from as a wee lad noted that while I had a certain level of base intelligence, (note that I didn’t use words like, “overmuch”, “gratifyingly high”, or even just, “barely adequate for the purpose at hand”) I really, really, really wasn’t terribly good at following instructions. It’s a skill that alas seems to be forever beyond my reach. And still is, as you’ll soon see.

Tim Hall, aka OracleBase, (Oracle-Base? Dunno.) organizes OGB (Oracle Groundbreakers) Appreciation Day as a way to thank all of the people in the Oracle community that have helped others. In my (OMG, surely it isn’t possible if you follow the corporate ownership path of Essbase) 25 years in the Oracle space I have: helped some, been helped by many, and confounded and confused just about everyone I’ve crossed paths with.

Tim has suggested the following potential topics:

My favourite feature of {the Oracle-related tech you work on}.
What is the next thing on your list to learn.
Horror stories. My biggest screw up, and how I fixed it.
How the

…

Oracle OpenWorld 2019 presentations, free as in beer

Introduction

You, Gentle Reader, are one of three sorts when it comes to reading this blog:

You didn’t get to go to OpenWorld for a variety of reasons, but sure wish you had.
You did go to OpenWorld but didn’t attend every session you wanted to go to/you did attend each and every session you wanted to but were too sleepy/hungover/overwhelmed to remember. I might have fallen into the latter category.
You really meant to learn all about cars at www.thetruthaboutcars.com and unintentionally typed in “cpm” instead of “cars”. A sort-of understandable mistake. I fully expect you to stop reading although of course you’re welcome to carry on.

Whatever your reason (unless you’re in the third group and don’t have a sense of curiosity), this post is for you. And for once it’s short and sweet.

NB – Actually, no, there’s a fourth that ended up here but pretty much wished it was anywhere else in the world wide web. Fie to you, I say!

And heeeeeereeeee they are!

Here’s the link to the publicly available OOW 2019 EPM presentations.

https://events.rainfocus.com/widget/oracle/oow19/catalogow19?search=epm

Roadmaps, emerging technology, customer success stories, everything — it’s all there. It isn’t quite like being there

…

OpenWorld 2019, day 4, but in fact not even then

Why do I even bother?

At the beginning of conferences I am filled with fresh will and enthusiasm, sure that this time I really and truly will keep you, Gentle Reader, as informed as informed can be when it comes to this conference; any conference really. And I don’t. Ah, a man’s reach must exceed his grasp else what’s a heaven for?

Having firmly established the fact that I am either a fool (almost certainly), unreliable (the evidence speaks for itself), or simply unduly optimistic in my estimation of how hard I’m really going to try to do this (this is what I choose to believe although I think there’s something about the road to Hell and pavement in the form of good intentions), and before I get to the main plate of delicious geeky information, allow me to give you some impressions of what OpenWorld was like this year. And oh yeah, day four of the conference finds me on an aeroplane on the way back to the Right Coast, so all of the cool EPM stuff that Oracle cruelly scheduled for Thursday – missed the whole thing. Argh. Disirregardless of my poor timing (next year I’ll stay through

…

Oracle OpenWorld 2019, live blog, part two

OpenWorld is an interesting place

I tweeted this one out it bears repeating.

There is an eyeglasses vendor.

At OpenWorld.

In the Expo Hall.

And they’re doing a smashing business.

What can I say?

Hah! I can say something: for a limited time, there’s a 20% discount.

So much for vendor relations.

I swear there’ll be real content Real Soon Now.

Be seeing you.

…