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?

A screenshot of a social media post Description automatically generated

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?

A close up of a sign Description automatically generated

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

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


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

  1. You didn’t get to go to OpenWorld for a variety of reasons, but sure wish you had.
  2. 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.
  3. You really meant to learn all about cars at 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.

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

OpenWorld 2019, live blog, part the zeroeth and first

Zero? One?

Every good(ish) geek knows the difference between zero and one based numbering systems. Said geek also knows that Powers That Be flip between them, seemingly arbitrarily. When I want to fool mathheads/real programmers, I use a zero-based convention. When I interact with normies, I use one.

Said geek also knows that different conversations and contexts seem to drive usage in a seemingly arbitrary way. I flip between the two contextually:  when I want to fool mathheads/real programmers into thinking I have a brain, I use a zero-based convention. When I interact with normies, I use one as my starting point.

In this case, I’m using both. Unpossible! In fact all of this falderal means is that I’m combining yesterday’s pretty-much-arrive-in-San-Francisco-at-OpenWorld and EPM partner meeting with an ongoing live stream today and, with luck, every day.

I can’t tell you much (actually, nothing) about yesterday’s partner meeting, but I can share with you this list of sessions Oracle recommended to us. Also, as a bonus you get the top of someone’s head. Lucky whoever that may be.

Many of these sessions are already full, but if not and you’re at OOW, check them out.

I’ve got to go