Applied Dimensionality

Recent posts

Oct 26, 2019
Using AWS Athena for TM1 transaction log analysis
We all love tm1s.log files, our lifeline and an invaluable tool in the ‘why the number is X’ scenarios. They tend to get quite big though and you usually do some sort of ‘zip’em / move’em / delete’em after Y days’ automation.
Jul 16, 2019
Another reason for TM1 10.2.2 to PA memory growth: Preloading Public views and ALL subsets
Do you have a red circle around 30th of September in your calendars as TM1 10.2.2 end of support? As we’re going through the upgrades for our customers, it’s mostly smooth sailing (if you ignore PaW) and we mostly see 3 main types of ‘issues’:
May 8, 2019
Java TIs are not out of support in Planning Analytics
If you’re like me and have done anything with ExecuteJavaN(S) TI calls, you were probably saddened by the news that IBM was planning to phase out Java support in TM1. Current PA (2.
Jan 24, 2019
Adjusting flat.css file for TM1Web A quick note here as well as on TM1Forums here’s what I generally change in flat.css style (located in tm1_64\webapps\tm1web\scripts\tm1web\themes\flat ) to make TM1Web in Planning Analytics easier on the eyes.
Oct 26, 2018
IBM published Planning Analytics TM1Web Tuning Guide And here it is. Very useful content. Overall I must say I’m really impressed with this new WLP backed TM1Web, it’s a lot faster and more stable than Tomcat in 10.
Sep 13, 2018
TM1p ini file equivalent for Planning Analytics for Excel Is called CommManagerSettings.xml and is located in C:\Users\<yourUserNameHere>\AppData\Local\Cognos\Office Connection\. It contains the data source settings (tm1 app server, tm1 server name), nice to ‘preset’ those in PaX silent installations across a wide user community, you don’t everyone to know how to configure URLs.
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.