Applied Dimensionality

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