So it’s always exciting being very cloud focused – every month you have new toys, bug fixes, changes to read. However even for 2019 (which has had some big releases already) June 19 is a pretty big one! I’m writing this as part of a blog hop (organised by the… Continue Reading PBCS & EPBCS What is Old is New Again!

G’day All, So – I spent 7 hours working through a fancy REST API script, reading optimisation notes on Powershell queries, and re-working and re-writing the code to be simple and clean to finally post up a detailed ‘warts and all’ article. And then I actually tried to use it!… Continue Reading Extracting Metadata from PBCS using the REST API – Updated!

G’day All, As is seemingly often the case – most of my REST API work is simply trailing on the coat-tails of greatness, aka: John Goodwin. Specifically a question came up in the OTN Planning forums Identifying Level 0 in metadata export Obviously there are a number of manual ways… Continue Reading Extracting Metadata from PBCS using the REST API

G’day All, Two posts in two weeks! So, this is really a continuation of the previous one. Just as a recap: the REST API is awesome It lets us do all of the same functions as EPMAutomate, but with significantly better error handling and logging abilities It also has a… Continue Reading RESTing around with PBCS 2 – Still RESTless

KScope Recap G’day All, So a lightning quick recap of KScope17. Cameron celebrated VE day Celvin met a deer Opal had a sugar high Gary drove a train Ludovic ate some tacos Natalie experienced Puppy Love Jason went to the danger zone Rodrigo grew a moustache Ricardo held an axe… Continue Reading RESTing Around with PBCS

G’day All, So Cameron Lackpour suckered engaged another extremely talented EPM specialist – Chris Rothermel – to write a guest post. It walks through a simple yet elegant code set to perform Automated Daily Timestamped Backups on PBCS. Given the consolidation Oracle Cloud products this process could be easily extended… Continue Reading EPMAutomate, PBCS, Backups and You!

G’day All, So I’ll skip the shenanigans of Gaullic invasions and move straight to the good stuff – but this is basically a copy of a post I guest wrote for Cameron after being horrified that VBA was his go-to for dealing with MDX. The agony and the ecstasy Upon… Continue Reading MDXExport and Hybrid Allocations

Summary A multi-page rant about time, leap seconds, the amount of acid the Unix developers took in the 70’s and Essbase vs planning time. Note: As per the previous blog post – to my American audience – in this post I will not be using the arbitrary retarded roller coaster … Continue Reading A History of Dates, Essbase and Why Unix time sucks

Intro As it is with most things, you start writing a blog post about something, and two weeks, 4 environments and 16 test cases later it’s morphed into 3 blog posts. So as follows: In this post, a useful tip about combining variables, dynamic calcs and scripts to deal with… Continue Reading Time and Dynamic Date Factors