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