Applied Dimensionality

Recent posts

Feb 19, 2022
Configuring keepalive for Oracle connections in Google Compute Cloud
We’ve spent a bit of time trying to figure it out recently, so putting it out there for future Google search :) GCP network is using a 10 minute connection tracking and drops the connection deemed ‘idle’ once they exceed this limit.
Mar 22, 2021
What do I think about when I think about TM1 TI performance
This post is an outline of the presentation I did at our internal knowledge share session recently. There’s no new or ground-breaking stuff here, just a review of well-known ideas and some of my takes on them.
Feb 23, 2021
Got a GCP associate cert as well
Decided to make some of my GCP forrays official (I did use it on a few projects) during a bit -gardening- upskilling XMas break and passed the entry level GCP cert.
Feb 12, 2021
Why I don't like 'silent' Itemskips
There’s a very innocent-looking code snippet that gives me chills whenever I encounter it (especially in a largish TIs) that goes like this: If (something something); Itemskip; Endif; nothing really complicated, nothing to wrack your brain about, nobody’s doing their best go at IRR calcs or any other fancy things, so why the dread?
Dec 11, 2020
tm1login cube
And in case you’re using the tm1logins log file as per the previous post, here’s a TI that builds a very simple analysis cube that shows you the user logins per hour.
Sep 11, 2020
my default tm1s-log.properties file
Thought I’d share the ‘standard’ tm1s-log.properties file I regularly use. tm1s-log.properties controls how and where tm1 logs things and the config file below generates you 4 files: tm1server.log – I’m adding the Debug level for locks to see the name of the objects locked at that point in time.
Jul 31, 2020
Another PA Performance tip "Don't read from and write to the same cube in TIs" or "The cunning of CellIncrement"
Some of the largest performance gains I saw on a recent project came from ‘breaking up the circles’ in TI processes, so I thought that I’d do quick write-up on it.
Jul 5, 2020
Planning Analytics 2.0.9 is out I usually don’t do ‘release’ posts, but I think this one is significant for a couple of reasons. 2.9 is an official long-term support release, which means that IBM will provide only fixes to this 2.
Jun 1, 2020
IBM Data and AI Accelerators
IBM have released a real treasure-trove of content in IBM Data and AI Accelerators! Most definitely have a look if you haven’t already. I only skimmed the Planning Analytics part of it (or as I call it, “Andreas Kugelmeier’s mind palace”) and it’s a very worthwhile read.
Jun 1, 2020
Price Volume Mix analysis in TM1
I was just reading through Price Volume Mix analysis IBM Accelerator template and it would have been be so useful for me about 5 years back when I had to create our own template for a pharmaceutical model.