Applied Dimensionality

Thought I’d describe how we installed / upgraded Planning Analytics and Cognos Analytics on 100+ servers. TLDR: pretty much like in the picture above :)

We had a couple of iterations in this environment over the years, first for a 10.2 -> Planning Analytics upgrade and then for migration from on-prem to cloud, so we know the approach does work well. I won’t be divulging any trade secrets, it’s all bog-standard infrastructure as code with a slight PA twist. All this installation and configuration will all be magicked away with version 12 of Planning Analytics, this post will be a bit of nostalgia to come back to in a few years time.

This is post is updated on 2022/12/20 to correct a couple statements below based on the Linkedin discussion we had and add an example of commit timing.

I remember reading

Quick write-up on how to display time in different timezones in Planning Analytics while we’re waiting for a timezone aware format to be added.

We end up using a cube to display messages to end users in every project, something as simple as:

Going through a security set up for a project now with Planning Analytics Workspace as front-end and thought I’d share how we set up PaW & PA security in hte last few ’largish’ deployments, i.e. with

Thought it’d be interesting to write out the things that stop me from using TM1 Git integration so far. There’s been a few discussions on tm1forums that highlight some of them:

We’ve spent a bit of time trying to figure it out recently, so putting it out there for future Google search :)

GCP network is using a 10 minute connection tracking and drops the connection deemed ‘idle’ once they exceed this limit. In human terms it means that if you’re sending an Oracle query that exceeds this limit, the open connection will be closed. This, in conjuction with a restrictive enough firewall configuration, would lead to the following situation:

This post is an outline of the presentation I did at our internal knowledge share session recently. There’s no new or ground-breaking stuff here, just a review of well-known ideas and some of my takes on them.

Decided to make some of my GCP forrays official (I did use it on a few projects) during a bit -gardening- upskilling XMas break and passed the entry level GCP cert.

There’s a very innocent-looking code snippet that gives me chills whenever I encounter it (especially in a largish TIs) that goes like this:

If (something something);
	Itemskip;
Endif;

nothing really complicated, nothing to wrack your brain about, nobody’s doing their best go at IRR calcs or any other fancy things, so why the dread?

And in case you’re using the tm1logins log file as per the previous post, here’s a TI that builds a very simple analysis cube that shows you the user logins per hour. Add it to your server and schedule a chore to update it, it should take seconds to run on a 10mb logins file. I’m using it for very simple activity analysis, answering the ‘who is using the system at all’ and ‘what is the login distribution within the day’ to identify when you can do maintenance.