There’s a fair amount of TM1 knowledge on the web.

The best TM1 knowledge on the web is here at Cubewise’s Tech blog.

Upgrade from TM1 10.x to Planning Analytics

Migrating from TM1 10.2.2 to Planning Analytics is not complicated, but it is a process with multiple layers that requires sufficient planning.

With IBM’s decision to stop support for TM1 10.2.2 in September 2019, we compiled a decision tree to ensure you know which questions you need to answer to find the most suitable path for your environment to effectively plan your upgrade to Planning Analytics.


Read
Need to know essentials for Planning Analytics

Our colleagues from Cubewise CODE have done some great work producing not just 1 but 3, "cheat sheets". There's a separate sheet for End Users, Developers and Administrators respectively. The sheets are densely packed with information and hyperlinks to more detail when it can't possibly all fit on one page. Everything you need all on one super neat package!


Read
Enabling hierarchies, how does it affect your current model?

Welcome to this installment of our series on upgrading to Planning Analytics. If you’re here then you probably know about the new features that PA brings such as Workspace, hierarchies and multi-threaded feeders, but you’re hesitant about whether to implement the new features due to concerns about the impact on your current mature implementation. If this describes your situation then you are at the right place!


Read
Cubewise January 2019 Update

Yes, the first month of 2019 is already over and as things happened so fast, here is the summary of the Cubewise highlights in January.


Read
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.


Read
What exactly is cube optimization?

There are already many good resources on the internet explaining how to re-order dimensions, or in other words, how to "optimize" a cube. However, nowhere is it explained just exactly what is being optimized and why. This article addresses this gap and explains that there are multiple possible axis which can potentially be optimized and by extension that there is no "one best dimension order" as the optimal order is situational and depends on whether we should optimize for memory consumption or performance. As 64-bit computing has evolved memory has become cheaper, to the point of being a commodity. So is optimizing for memory consumption still relevant, or should we focus on performance? And if performance then is query performance or write-back performance more important?


Read
An unintended benefit of hierarchies

When an alternate hierarchy is added to a dimension in TM1 for the first time a Leaves hierarchy is also automatically created in the background. The Leaves hierarchy has some special properties which can result in benefits to your TM1 system which you may not have previously considered.


Read
Cubewise December 2018 Update

We took a few days off to celebrate and relax with family & friends, but that did not stop us ending the last month in 2018 with a firework of activities. If you just came back to work or want to bring yourself up to speed with the latest developments at Cubewise read the highlights below.


Read
How to work with hierarchies in rules

The power of what hierarchies allow us to do in terms of cube design are simply awesome, but this does some at a cost of additional complexity in terms of managing rules due to increased risk of ambiguous name conflicts. This article clarifies the syntax needed to address hierarchies with detailed examples, as well as discussing use cases and pitfalls.


Read
Changes to subsets control dimensions in PA 2.0.6

The most recent version of Planning Analytics 2.0.6 which incorporates TM1 server version 11.4 contains a number of fixes. One of these fixes introduces a potentially breaking change to custom code if your application has any processes or cubes already making use of the new }Subsets_ control dimensions. 


Read