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.
Just what is DTS? Again, per the DBAG:
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