Applied Dimensionality

Recent posts

Jan 29, 2018
How to implement a work queue in TM1
TM1 / Planning Analytics team is doing an impressive amount of work to make TIs run in parallel, however, the ‘grunt’ part of TurboIntegrator processes is still (as of 10.2.2 / PA 2) limited by one core.
Nov 17, 2017
Now I’m a certified AWS Solutions Architect Associate
Now that we can be sure that cloud computing is a real thing I’ve finally got around to ticking AWS cert of the ‘would be good to do’ list. I’ve been using EC2 for a fairly long time, but AWS is many (and many doesn’t even start to cover how many) things more and certification was a good chance to make sure that I’m across a few of them.
Sep 1, 2017
Rewrote Application Maintenance scripts for SSO
I’ve recently updated the script that runs application maintenance utility for TM1 when you got CAM Security with Single SignOn enabled on Cognos BI. See this post for the description of the issue, I’m publishing a better take on a solution.
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.