Applied Dimensionality

Recent posts

Apr 20, 2017
Coursera: Big Data Analysis with Scala and Spark
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 pursuit.
Dec 31, 2016
2016
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.
Dec 16, 2016
Most useful Planning Analytics feature for me so far: StatsByRule
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).
Oct 18, 2016
TM1 SSL Certificates Expiry Update 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 for the updates, there’s nothing else to wait for :) We ran a webinar regarding the steps to do the updates, here’s a slide pack for your information.
Aug 31, 2016
Your TM1 SSL certificates will expire in November
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.
Aug 25, 2016
TM1 Dimension Order
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.
Jun 13, 2016
Some statistical functions in TM1FinanceLib: VAR, Median, DevSQ and more
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.
May 23, 2016
Just found TM1 10.3 most important feature Forget all your Cloud, Planning Analytics and CAFE. It’s finally here!
May 8, 2016
Java TM1 Extensions: TM1FinanceLib for calculating IRR, NPV and more
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.
Feb 13, 2016
TM1 Input in Calculated Cells or Break Back
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.