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.

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.

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?

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.

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.

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.

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. 

PAL Installation Guide

Once you have gone through the PA decision tree and technical implications articles and decided to upgrade to Planning Analytics, the next important question you must ask yourself is “how do I technically do it?”. Many people are afraid of the upgrade, because of the general perception that this is a very complicated process, more time consuming than ever before. This is however not true. Of course, it requires some preparation and execution time, but generally not more than when you upgraded from 9.x to 10.x.

The following list contains information about requirements and the installation steps for Planning Analytics.

Converting Perspectives Reports to PAx

Moving to an upgrade where an update is required on workbooks can easily be addressed by making use of the additional functionality provided within the Planning Analytics software.

Making use of Snap Commands in Planning Analytics Workspace

With the release of IBM Planning Analytics Workspace (hereinafter referred to as PAW) came a new interface, new ways of interacting with data, and the addition of Snap Commands.

PAW’s Snap Commands are simple commands that can be used to accelerate common tasks. They allow the use of natural language to find, create, and interact with visualizations. Snap Commands can be used for finding specific views or cubes, as well as creating and modifying views and visualizations.