A few years ago the very very talented Mike Henderson gave a Kscope presentation entitled Power Tools: Using VAR + LOOP for If-Then Procedure Logic and ARRAY for Speed (the presentation can be found here.) First and foremost the presentation has the easiest to understand and most detailed description of… Continue Reading Conditional FIX statements

G’day All, I’ve been a bit lax with regard to posts – apologies – but Cameron harassed me to post this up after he’d not heard of it. To be honest, this is one of those ‘been in my back-pocket for so long I just assumed everyone knew’ kinda features… Continue Reading Sub Variables, and a Glorious Dataform Hack

KScope Wrap! G’day All, So Kscope16 is over, done and dusted, and I’m back home. A quick thankyou to everyone who I met – was amazing to be able to put a face and a voice to the names/blogs/twitter accounts I’ve followed over the years! For everyone else – you’ll… Continue Reading PBCS and Fun New Features

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

G’day All, As promised – my final post on time\date factors\arbitrary rants about date systems. This time, we delve under the covers to have a look at some of the new HSP functions – which massively simplify any work that you need to do with dates in Hyperion! Quick Recap… Continue Reading HSP Date Functions in 11.1.2.4

G’day All, The subtitle for this post could be “How to make sure the guy after you doesn’t hate you – making code legible” As the newest Ace Associate and java-junky-Jason-Jones points out – code is read significantly more often than it is written He then also used the term… Continue Reading IPMT and PPMT in Essbase

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

G’day All, A very quick and very essbase hacky one today (since we’re all essbase hackers at heart!) From 11.1.2.2 onwards you can no longer take an copy of a Planning BSO Application through EAS. You can still copy ASO apps and Essbase only BSO apps, but can no longer… Continue Reading EAS copy of a BSO Planning Cube post 11.1.2.2