Skip to content

The Truth About CPM

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

  • Home
  • About

Month: January 2020

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 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

RSS The bright shiny new episode of EPM Conversations

  • EPM Conversations — Episode 14, A Conversation with Sree Menon, The Calc Man 7 June, 2022 Cameron Lackpour
  • EPM Conversations — Episode 13, A Conversation with Elizabeth Ferrell, Accountant (ex), Advocate (of so many things), and Aviatrix 19 April, 2022 Cameron Lackpour
  • EPM Conversations — Episode 12, A Conversation With Kumar Ramaiyer, Workday Adaptive Planning Business Unit Vice President 14 December, 2021 Cameron Lackpour
  • EPM Conversations — Episode 11, A Conversation With Peter Fugere, OneStream Software’s Chief Strategic Services Officer 2 November, 2021 Cameron Lackpour
  • EPM Conversations — Episode 10, A Conversation with Jodi Hill, Pattern Recognizer and Outlier 21 September, 2021 Cameron Lackpour
  • EPM Conversations — Episode 9, A Conversation with Matthias Heilos, CEO of Finance Technology Innovations 4 May, 2021 Cameron Lackpour
  • EPM Conversations — Episode No. 8, A Conversation with Tom Shea, CEO of OneStream Software 6 April, 2021 Cameron Lackpour
  • EPM Conversations – Episode No. 7, A Conversation With Kevin Lawrence, Marketing Analytics, Corporate to Guerilla 16 March, 2021 Cameron Lackpour
  • EPM Conversations — Episode No. 6, A Conversation With Mike Nader, EPM’s Very Own Data Analytics Polymath 4 February, 2021 Cameron Lackpour
  • EPM Conversations – Episode 5, A Conversation (no, a rap!) With Chris Turner 5 January, 2021 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 52 other subscribers

Search

Latest posts

  • EPM Conversations — Episode 14, A Conversation with Sree Menon, The Calc Man 7 June, 2022
  • EPM Conversations — Episode 13, A Conversation with Elizabeth Ferrell, Accountant (ex), Advocate (of so many things), and Aviatrix 19 April, 2022
  • EPM Conversations — Episode 12, A Conversation With Kumar Ramaiyer, Workday Adaptive Planning Business Unit Vice President 14 December, 2021
  • EPM Conversations — Episode 11, A Conversation With Peter Fugere, OneStream Software’s Chief Strategic Services Officer 2 November, 2021
  • EPM Conversations — Episode 10, A Conversation with Jodi Hill, Pattern Recognizer and Outlier 21 September, 2021

Blog Archive

  • June 2022 (1)
  • April 2022 (1)
  • December 2021 (1)
  • November 2021 (1)
  • September 2021 (1)
  • May 2021 (1)
  • April 2021 (1)
  • March 2021 (1)
  • February 2021 (1)
  • 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 (5) Cloud (5) CPM (9) Data (5) Dimensions (12) Dodeca (1) EPM (22) EPM Conversations (6) Essbase (18) Excel (2) Groovy (1) Infrastructure (4) Kscope (7) Marketplace (2) Metadata (10) n00b (3) OAC (3) OneStream (9) Oracle (1) Planning (18) Security (1) Stupid Tricks (1) Upgrade (3)

Categories

Other Sites You Should Read

  • Planning Lab – Task Manager Overview The EPM Lab, 13 June, 2022 Jun
  • Planning Lab – Autosave The EPM Lab, 8 June, 2022 Jun
  • EPM Lab – The New Enterprise PCM (EPCM) The EPM Lab, 31 May, 2022 Jun
  • Groovy Lab – Print Calculation Information in Job Log The EPM Lab, 5 May, 2022 Jun
  • ODI in the hybrid database world – Files/Stages and SnowSQL DEV EPM, 14 April, 2022 radk00
  • ODI in the hybrid database world – Snowflake JDBC DEV EPM, 13 April, 2022 radk00
  • ODI in the hybrid database world – Oracle Autonomous Database DEV EPM, 13 April, 2022 radk00
  • Groovy and Essbase Cloud APIs - Part 3 EPM Simplified, 11 April, 2022 Omar Shubeilat
  • Groovy and Essbase Cloud APIs - Part 2 EPM Simplified, 11 April, 2022 Omar Shubeilat
  • Groovy and Essbase Cloud APIs - Part 1 EPM Simplified, 11 April, 2022 Omar Shubeilat
  • Improve the Planner Experience with Groovy (ODTUG) in2Hyperion, 3 November, 2021 Kyle Goodfriend
  • Efficiently Handling Creating Blocks in2Hyperion, 25 October, 2021 Kyle Goodfriend
  • Announcing the Essbase Ribbon, Part 2 – Power Adhoc Ribbon in2Hyperion, 4 October, 2021 Kyle Goodfriend
  • The Case for Serverless Backups using Oracle Functions EPM Simplified, 13 September, 2021 Omar Shubeilat
  • Excel Ribbon Part Duex – I got a second wind! in2Hyperion, 19 August, 2021 Kyle Goodfriend
Proudly powered by WordPress | Theme: Independent Publisher 2 by Raam Dev.