Applied Dimensionality

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 happier that I managed to achieve the usual 5x performance improvements :)
• A fair bit of TM1 another 10+ countries in Sanofi rollouts and some really interesting ongoing projects, looking forward to seeing them in production in 2017
• Cut down on travel, only a month away from home this year (and a couple trips to europe, lucky me)

Thank you all for reading and the very best for you and your families in 2017!

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

• 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 here. I’ll post am update once we try them out, but it’s really good news.

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.

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 next free moment )

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 ‘finance’ functions like IRR, NPV and some more. And there’ll be freebies, I’ll give you an extension library for some of the functions so you don’t have to write it yourself.

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 is kind of missing.  Not entirely, I’ll show how to achieve similar behaviour in TM1 (although in a much more restricted manner). I think it’s isn’t actually documented anywhere, so I’ll put it out here.

Judging by the amount of feedback I still get about the Java stress testing tool, load testing is really something everyone starts looking at once they’re facing any decent number of users in the system. This post will describe how to use JMeter to do a broader scope of testing, emulating the full user interaction with TM1 Contributor.