Skip to content

The Truth About CPM

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

  • Home
  • About

Category: Calculations

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

…
cameronl Calculations, Data, Essbase, Oracle, Planning Leave a comment 23 January, 2020 3 Minutes

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

…
cameronl Calculations, Data, Metadata, OneStream, Planning Leave a comment 3 September, 2019 7 Minutes

A n00b’s OneStream Journey No.6 — Instant Gratification

Instant

Everyone likes fast except when it comes to slow cooking or taking a nap or when pursuing a hobby or simply enjoying oneself. Of course, instant is even better than fast. No, not instant coffee (I can only drink it while camping – I think I somehow enjoy straining out bits of dirt from the tin mug), nor instant pot noodles (a staple of my university life, never to be repeated), but instead instant aggregations. I’m a busy geek; you are too. And I want it all. Now. Instantly.

Generally, in OneStream that’s not an issue as most dimensions are dynamically aggregated with the exception – till now – of Entity. By that I mean: input data at an Account, Time, Custom Dimension (and the other required dimensions – see my previous post for an overview of them in all of their glory) intersection and a single Entity and the numbers at an aggregate level are instantly available across all of those dimensions. That’s lovely in the non-ironic sense. However, that Entity dimension, the spine of every OneStream app, is a stored dimension, i.e. the upper level members must have materialized aggregate views. To get those aggregated –

…
cameronl Calculations, Data, Metadata, Planning Leave a comment 14 September, 2018 7 Minutes

RSS The bright shiny new episode of EPM Conversations

  • EPM Conversations – Episode 5, A Conversation (no, a rap!) With Chris Turner 5 January, 2021 Cameron Lackpour
  • EPM Conversations – Episode No. 4, a conversation with John Booth 8 December, 2020 Cameron Lackpour
  • EPM Conversation – A Conversation With Abhi Nerurkar, Co-Founder of EPMware 17 November, 2020 Cameron Lackpour
  • EPM Conversation – Episode No. 2, Part 2, A Conversation With Essbase Lady, Natalie Delemar 29 October, 2020 Cameron Lackpour
  • EPM Conversation – Episode No. 2, Part 1, A Conversation With Essbase Lady, Natalie Delemar 20 October, 2020 Cameron Lackpour
  • Blogs by hosts 29 September, 2020 Celvin Kattookaran
  • Episode No. 1: Introduction with Tim German, Celvin Kattookaran, and Cameron Lackpour 18 September, 2020 Cameron Lackpour

About This Site

I’m going to cover C/EPM in all of its glory.  And pain.  And fun.  I hope.  Join me, won’t you?

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 40 other subscribers

Search

Latest posts

  • EPM Conversations — Episode 5, A Conversation (no, a rap!) With Chris Turner 5 January, 2021
  • EPM Conversations – Episode No. 4, a conversation with John Booth 8 December, 2020
  • EPM Conversations – Episode No. 3, a conversation with Abhi Nerurkar, co-founder of EPMware 17 November, 2020
  • EPM Conversations – Episode No. 2, Part 1 & 2, a conversation with Essbase Lady, Natalie Delemar 29 October, 2020
  • EPM Conversations – TWTWTW 14 October, 2020

Blog Archive

  • January 2021 (1)
  • December 2020 (1)
  • November 2020 (1)
  • October 2020 (2)
  • September 2020 (1)
  • August 2020 (1)
  • May 2020 (3)
  • April 2020 (1)
  • March 2020 (2)
  • February 2020 (2)
  • January 2020 (2)
  • December 2019 (2)
  • November 2019 (1)
  • October 2019 (3)
  • September 2019 (4)
  • July 2019 (3)
  • June 2019 (6)
  • September 2018 (1)
  • June 2018 (1)
  • April 2018 (1)
  • December 2017 (1)
  • November 2017 (4)
  • October 2017 (2)

Tags

AppliedOLAP (2) AVBS (1) Changes (4) Cloud (3) CPM (7) Data (4) Dimensions (12) Dodeca (1) EPM (20) EPM Conversations (3) Essbase (15) Excel (2) Groovy (1) Infrastructure (4) Kscope (7) Marketplace (2) Metadata (8) n00b (3) OAC (3) OneStream (7) Planning (15) Security (1) Stupid Tricks (1) Upgrade (3)

Categories

Other Sites You Should Read

  • Is my ODI version certified for that technology? DEV EPM, 14 January, 2021 radk00
  • Introducing CPMInsights YouTube channel CPM Insights, 12 January, 2021 ckattookaran
  • EPM Lab – Dashboard 2.0 The EPM Lab, 8 December, 2020 Jun
  • MindStream toolbox CPM Insights, 17 November, 2020 ckattookaran
  • Generate JSON objects with ODI in a very easy way DEV EPM, 9 November, 2020 radk00
  • Conversations with the Essbase lady CPM Insights, 29 October, 2020 ckattookaran
  • Oracle SQL for EPM Tips and Tricks S01EP14 DEV EPM, 15 October, 2020 RZGiampaoli
  • Collate and Try catch in Groovy rules to speed up Smart Pushes CPM Insights, 12 October, 2020 ckattookaran
  • A New Platform – EPM Conversations Cube Coder, 29 September, 2020 TimG
  • EDM Lab – Control User Access The EPM Lab, 28 September, 2020 Jun
  • Dashboards 2.0 - Geomaps EPM Simplified, 26 September, 2020 Omar Shubeilat
  • Essbase Lab – Exceed the limit of Potential Blocks?! The EPM Lab, 21 September, 2020 Jun
  • Oracle Analytics Summit 2020 Keynote: Data for Good, a Global Analytics Movement Data Restless Millennials, 11 August, 2020 Data Restless
  • Celebrating One Year Of Training in2Hyperion, 1 August, 2020 Kyle Goodfriend
  • Adventures in Groovy – Part 52: And You Thought Essbase Only Stored Numbers in2Hyperion, 23 July, 2020 Kyle Goodfriend
Proudly powered by WordPress | Theme: Independent Publisher 2 by Raam Dev.