Applied Dimensionality

Recent posts

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. I find this presentation to be a better navigation to Planning Analytics accelerators than the website itself ;)

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. Here’s some of my ramblings about it.

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.e. promoting via copying the object files to a folder and carrying it over and it’s sometimes easier to start from doing the same thing with a new tool :)

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. I hope to post more on this later.

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.x releases), but I’m still not sure what’s the best way to replace it. The lack of built-in support for all financial calculations in TM1 never ceases to puzzle me and essentially we’ve got 3 options for their replacement:

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. In this post, I’ll look into adding ‘push’em to the cloud to query’ step :)

Jul 16, 2019
Another reason for TM1 10.2.2 to PA memory growth: Preloading Public views and ALL subsets

Do you have a red circle around 30th of September in your calendars as TM1 10.2.2 end of support? As we’re going through the upgrades for our customers, it’s mostly smooth sailing (if you ignore PaW) and we mostly see 3 main types of ‘issues’:

May 8, 2019
Java TIs are not out of support in Planning Analytics

If you’re like me and have done anything with ExecuteJavaN(S) TI calls, you were probably saddened by the news that IBM was planning to phase out Java support in TM1. Current PA (2.0.6) release was supposed to be the last one to support it. You can still see the google cached documentation mentioning it. depcr_note.png