Skip to content

The Truth About CPM

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

  • Home
  • About

Month: August 2020

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

RSS The bright shiny new episode of EPM Conversations

  • EPM Conversation Episode 17 — A Culture Clash Conversation or Are The Simpsons Really How Latin America sees us with David Blanco and Belen Ortiz 14 April, 2023 Cameron Lackpour
  • EPM Conversations Episode 16 — A Culture Clash Conversation or 50 Million Frenchmen Can’t be Wrong with Ludovic De Paz and Pascal De Schryver 10 February, 2023 Cameron Lackpour
  • EPM Conversations — Episode 15. A Conversation with Cameron Lackpour and Celvin Kattookaran, a OneStream conference and a OneStream book 14 December, 2022 Cameron Lackpour
  • 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

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 56 other subscribers

Search

Latest posts

  • EPM Conversations Episode 16 — A Culture Clash Conversation or 50 Million Frenchmen Can’t be Wrong with Ludovic De Paz and Pascal De Schryver 10 February, 2023
  • 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

Blog Archive

  • February 2023 (1)
  • 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

  • EPM Lab – IPM Insights – Machine Learning in Planning The EPM Lab, 22 May, 2023 Jun
  • ODI in the hybrid database world – Azure SQL Database – BCP Utility DEV EPM, 8 May, 2023 Rodrigo Radtke de Souza
  • OCI Lab – SSO Configuration The EPM Lab, 1 May, 2023 Jun
  • ODI in the hybrid database world – Oracle ADW – OCI/CLI + DBMS_CLOUD DEV EPM, 14 April, 2023 Rodrigo Radtke de Souza
  • Snowflake loader using ODI DEV EPM, 13 April, 2023 Rodrigo Radtke de Souza
  • Building dynamic ODI code using Java variables – Table to File example DEV EPM, 23 March, 2023 Rodrigo Radtke de Souza
  • Mac Smart View Function Builder – HsGetValue, HsSetValue and HsAlias The EPM Lab, 13 March, 2023 Jun
  • How the Essbase CLI Login Works Cube Coder, 9 March, 2023 TimG
  • EPM Lab – OCI Migration The EPM Lab, 27 December, 2022 Jun
  • Quick tip - Finding out your EPM Cloud Infrastructure Datacentre EPM Simplified, 8 December, 2022 Omar Shubeilat
  • EPCM - A workaround for deleting scheduled jobs EPM Simplified, 9 September, 2022 Omar Shubeilat
  • EPCM BUG - Error deleting scheduled jobs EPM Simplified, 3 September, 2022 Omar Shubeilat
  • Lightning Lessons in2Hyperion, 8 August, 2022 Kyle Goodfriend
  • Quick tip - Groovy rule validates successfully but fails to run EPM Simplified, 3 August, 2022 Omar Shubeilat
  • Improve the Planner Experience with Groovy (ODTUG) in2Hyperion, 3 November, 2021 Kyle Goodfriend
Proudly powered by WordPress | Theme: Independent Publisher 2 by Raam Dev.