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

…

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

…

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 n00b’s OneStream Journey No. 8 — Why Two Is Not Better Than One

Apologies and yet without apology

Apologies up front as the subject of this blog post is both n00bie-ish as well as somewhat advanced and awfully, awfully, awfully important. It’s super-duper important that you understand what follows because a common design requirement and an equally common design solution won’t and doesn’t take into account OneStream’s core storage model. I’ll be making references to Data Management jobs, Finance business rules, as well as Data Buffer processing which is all rather a lot for a n00b post. But all of that is exposition – the key thing for we n00bs is to understand that a design approach we all take for granted in other tools is a Bad Idea in OneStream. Happily, the solution is straightforward.

The 42 people who regularly read this blog probably know a fair bit – although logic demands that I ask why you lucky 42 read it if you already know it. Perhaps you enjoy irrelevant links to popular culture from a year that predates your time on this planet by at least 50 years. Ask your parents or better yet your grandparents to help with that sort of confusion; hopefully the balance of the post will make

…

A n00b’s OneStream Journey No. 3 — OneStream XF Relational Blending 101, part 1

Introduction

This post is proof that my quite meager salesmanship skills are sometimes successful in convincing others to do my work. This time round, that means that my colleague Mike Gialanella agreed to write a guest post on XF’s relational blending. Thanks, Mike, for giving me the week off. And oh yeah, Gentle Reader, you too should thank Mike for writing about a really exciting and unique tool bit of functionality.

And with that, heeeeeerrrreeee’s Mike.

XF Relational Blending 101

When Cameron Lackpour asks you to write a guest blog post, the answer is yes. It is one of those things that you just can’t say no to. If Santa Claus asked you to deliver Christmas presents to kids-in-need, you would need an incredibly good reason to decline such a request.

XF networking event Nov 2017. Me on the right, Santa on the left.

So, for all you technical and finance experts that are attracted to ~~Cameron’s wit and wisdom~~ this blog, here’s my best-most-humble effort to deliver, by request of ~~the man~~ Cameron himself…. here you go:

OneStream XF is a unified SmartCPM^TM platform solution, it is not a siloed set of solutions that are fused together.

…