|
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’: |
Recent posts
Another reason for TM1 10.2.2 to PA memory growth: Preloading Public views and ALL subsets
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.0.6) release was supposed to be the last one to support it. You can still see the google cached documentation mentioning it.
|
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.
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.2.2 was.
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. This info is relatively tricky to find, it’s still only in CAFE documentation as far as I can see.
Simple tricks for improving Cognos BI & Analytics user interfice
I find myself in a ‘can you make this report or dashboard look better’ type of a dialogue every now and then and thought I’d list a few simple tips that I apply almost everywhere.
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. Even if you have a beefy server with multiple cores, they would only be utilised in ‘preparing source view with MTQ’ stage and all Metadata / Data will be single threaded. A common way to speed things up is to split the work into independent chunks and run those in parallel via tm1runti. Sometimes you can get close to the linear increase in performance improvement and it can be worth a try. |
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. |
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. |
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. With that in mind, I enrolled in Big Data Analysis with Scala and Spark and thoroughly enjoyed the experience. |