Applied Dimensionality

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 ;)

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.

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.

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 :)

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.

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.

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:

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 :)

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’:

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.