-
Improving rules performance with }StatsByRule – Part I
The Cubewise Code division wrote a great article recently “7 tips to writing faster IBM TM1 and Planning Analytics rules”. They show different techniques of how you can write rules to improve their performance. I presented the same topic on the European Cubewise Conference in Paris this year and think that it deserves a bit…
-
How to…Encryption at Rest
Starting in Version 2.0.4, TM1 Server / Planning Analytics Local has had an ‘Encryption at Rest’ feature. In this Cubewise blog post, we explain what EaR means, why you would want to enable it, and how you can set it up using the “tm1crypt” utility. What do we mean by Encryption at Rest? A TM1…
-
Cubewise Opens First Branch In Germany
Cubewise opened a branch in Munich this month, consolidating its role as IBM Germany’s leading Platinum Partner. Markus Fynmore also joins Cubewise Germany as Practice Manager at the new Branch in Munich. Cubewise, winner of the IBM Solutions Bestseller Award 2018, opened its first German branch in Munich this month. (From left to right: Marco…
-
How to reference intersections of hierarchies in rules
This is a follow on from the previous article on working with hierarchies in rules. It will deal with how to address the intersection of two (or more) hierarchies in the right-hand side of a rule statement and the left-hand side of a feeder statement. Note this is accurate as at version 2.0.6.71 Intersections of hierarchies…
-
What exactly is cube optimization?
There are already many excellent sources available on the web explaining how to re-order dimensions or “optimize” a TM1 cube. Basically, this method can be summarized ordering dimensions “small to large, then sparse to dense.” However, I’m yet to find any reference explaining what is being optimized. This paper is aimed at addressing exactly this question:…
-
Technical implications when moving to PAL: A TM1 upgrade checklist
With just under one year left of IBM supporting TM1 version 10.2.2, it can be assumed that most TM1 customers have at least started preparations for an upgrade to Planning Analytics (PA). The support aspect appears to be an underlying driver for the version upgrade, particularly if corporate policy prohibits the use of unsupported software.…
-
We old-schoolers need to revisit the language we use to talk about dimension structures
Back Then … In the TM1 world, many people have for many years been used to saying “hierarchies” when referring to hierarchical dimension structures e.g. Ancestor > direct children (consolidated) > intermediate consolidations > ultimate leaf descendants When TM1 was just TM1 and dimensions didn’t have named hierarchies this was OK as it was still…
-
What is the Cubewise EDU TM1 and Planning Analytics Developer Credential?
With growing interest, I keep getting asked: “what exactly is the ‘Cubewise EDU TM1 and Planning Analytics Developer Credential’”? The Credential was developed in partnership with DeakinCo. and is another initiative in Cubewise’s ongoing contribution to the ideals of #DoGoodTM1. At Cubewise, we had a growing list of TM1 and Planning Analytics customers that were…
-
Let’s talk about element and attribute naming
This article isn’t about naming conventions. My opinion on naming conventions is that they are necessary both for end-users and developers to assist in making a system understandable and navigable. But I don’t have an opinion on what the best naming convention is other than it doesn’t exist. Whether a naming convention uses spaces, underscores,…
-
Moving from TM1 to Planning Analytics is NOT complicated
First of all, Planning Analytics is just a new name for TM1. Over the last few months, a number of customers have started planning the upgrade to Planning Analytics Local. There seems to be the perception that this process is more complicated than any other upgrade done before with TM1. In this article, I try to…