Work has been quite intense and very high-level recently, so I was missing the state of flow and the builders high that accompany coding. And I thought it’s a good time to learn something new and since I’ve been reading heaps of good things about Apache Spark, a course on it sounded like a worthwhile…
was the year when: – This blog turned 10 years old – I moved from PMsquare to Cornerstone – Opened up my own company – Got roughly the same amount of IM and TM1 work, very happy about that – Got a chance to work with 10Tb+ dwh, not many of these down under. Even…
It’s Xmas time again and we get the big bag of presents this time: Planning Analytics on Premise is finally here. There’s a ton of new things to like in new Planning Analytics (and all those need to be throughly tested, so I wouldn’t be upgrading just right now). I just wanted to highlight a…
There’s been a flurry of news on SSL certs topic in past 2 weeks. Main ones are: Automated updaters are released (yay!) for all client versions and not all server versions (nay, but not a big deal) There’s a manual way to update certificates if you can’t do it automatically So all is now ready…
Update 02/10/2016: Fix pack / updater from IBM still not released, but a manual update instructions + a set of new certificates are published at http://www-01.ibm.com/support/docview.wss?uid=swg21990588 . I’ll post am update once we try them out, but it’s really good news. Update 07/09/201t6: Corrected the post to reflect the fact that TM1 will not ‘crash’,…
A quick note on the decades-old topic of dimension order. In a nutshell: don’t really trust System Order, it ignores changing the last dimension and it’s always the most impactful one. Ignore the rest of the post and move on, carry on if you’re interested in my ramblings on it. There’s a metric ton of…
Just a quick note that I’ve updated tm1financelib with a few statistical functions (again, nothing more than pointing to them in POI): DEVSQ AVEDEV MEDIAN VAR VARP I’ve added function descriptions in the original post. Come to think of it, maybe I should post the whole stuff on something like github. Whenever I’ll have a…
Forget all your Cloud, Planning Analytics and CAFE. It’s finally here!
Well, I’m a bit late to the party, so you all know by now that after TM1 10.2.2 you can use something called Java Extensions to execute your own Java code and call it as a Turbo Integrator function. What I’ll show in this post is how to use this approach to calculate the usual…
Break-back was one of the famous features in Cognos Enterprise Planning, it allowed data input in a calculated cell and system would adjust all the participating elements to match the new result. Combined with ‘holds’ it was a really awesome feature. TM1 allows input in consolidated cells, but not in calculated ones, so this functionality…