Skip to content

The Truth About CPM

A treatise on solving problems, getting answers, and hacking Corporate and Enterprise Performance Management

  • Home
  • About

Category: Metadata

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

…
cameronl Data, Essbase, Metadata, Planning, Podcast, Uncategorized Leave a comment 21 September, 2021 1 Minute

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

…
cameronl Essbase SaaS aka Free Form Planning, Metadata, Oracle, Planning, Smart View 2 Comments 3 August, 2020 2 Minutes

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.

A close up of a horse Description automatically generated

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

…
cameronl Essbase, Metadata, Oracle, Planning 3 Comments 13 January, 2020 7 Minutes

OneStream Security Remover or how I learnt to love MarketPlace

Will no one rid me of this turbulent security?

No Archbishop of Canterbury will be put to sword in this blog post but what will be expunged is security that no one wants (heh, sort of like the TSA).

I recently imported an application into my local copy of OneStream and…