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.

Tag: Planning Analytics

An introduction to creating subsets with bedrock

This is a quick tutorial in how to create subsets with the bedrock 4 library. It covers ...
- including descendants of a consolidation
- filtering elements by level
- filtering elements via attribute value
- excluding elements via list or wildcard
- modifying an existing subset

List and Wildcard Functionality in bedrock

The latest version of the bedrock library consistently includes support for lists and wildcard string matches whenever defining objects or elements. This article explains step-by-step how lists and wildcards work and how to put them to use.

Changes in functions of rules and TIs from TM1 10.2 to PA  

IBM support on TM1 version 10.2.2 will be discontinued from 30th September 2019. Awareness around the decisions for the interface, additional available functionality and what to consider for the installation and configuration have already been covered. The decisions can be found in the decision tree in the blog post Upgrade TM1 to Planning Analytics.  

With the move from TM1 10.2.2 to PA 2.0.6 (TM1 Server 11.4) there are a few functions used in rules that will not be available in the upgraded software.

A Detailed Look at Planning Analytics Workspace

IBM Planning Analytics Workspace (PAW) is a web-based interface for IBM Cognos TM1. It brings new exciting possibilities in terms of visualization of your TM1 data. IBM succeeded in expanding the TM1 interface options with a user-friendly and attractive experience aimed at a wide user community.

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.

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.