Applied Dimensionality

Recent posts

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.
Apr 3, 2020
TM1 Cell Security
Had a few ‘let’s improve performance’ cases recently that were all related to CellSecurity, so here’s a couple of notes on it. You’ve heard all of this before, just putting it together.
Mar 17, 2020
GIT integration for TM1, part 2
Continuing the TM1 Git story, I’ll describe how to do a simple promotion of a few objects from one server to another. This might be slightly different from overall Git-enabled philosophy of development, but it’s a direct replacement of how TM1 promotions work in most places I see now, i.
Feb 21, 2020
TM1 at scale
I recently had a chance to work on a very large TM1 system and one of my colleagues asked ‘so what can we learn from it?’ This question got me thinking a bit past the usual ‘just don’t do this’ banter and lead to this post.
Dec 5, 2019
GIT integration for TM1, part 1
I finally had a couple of days to play with Git integration for TM1, something I was very curious about ever since it was released in PA 2.0.7. This post describes what I’ve found so far plus the instructions on setting it up in VSCode.
Nov 25, 2019
TM1FinanceLib is available on GitHub
Just realised that I’ve put tm1financelib on GitHub and didn’t tell anyone about it ;) Here it is. I know nobody should be using Java Extension TIs as this functionality is no longer actively developed (but still supported for all PA 2.
Oct 26, 2019
Using AWS Athena for TM1 transaction log analysis
We all love tm1s.log files, our lifeline and an invaluable tool in the ‘why the number is X’ scenarios. They tend to get quite big though and you usually do some sort of ‘zip’em / move’em / delete’em after Y days’ automation.