-
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…
-
A Deep Dive into SANDBOXES
A Deep Dive into SANDBOXES (aka What-if scenario capability) WHAT ARE SANDBOXES? There is often a need to plan multiple scenarios before feeling comfortable with the numbers you are submitting. The Sandbox feature allows you to create your own personal workspace where you can plan different scenarios (changes to the base data) before making those changes public to other…
-
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…
-
Changes in functions of rules and TIs from TM1 10.2 to PA
Overview of changes in functions when upgrading 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…
-
A Detailed Look at Planning Analytics Workspace
What is Planning Analytics Workspace (PAW)? 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. It is a…
-
An unintended benefit of hierarchies
The Leaves hierarchy 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 as it contains only leaf elements (inserting consolidations is not possible). The maintenance task of inserting new elements into the…
-
How to work with hierarchies in rules
This article is a little longer than normal, but we do go into quite a bit of detail with some examples of how the hierarchy syntax works in various situations. It’s step-by-step so should be not problem for anyone with an understanding of TM1 rules to follow. All code examples have extra spacing added for…
-
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 listed in the release notes. 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. The fix is listed as:[PI99205]…
-
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…
-
Converting Perspectives Reports to PAx
Conversion steps 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. The Planning Analytics for Excel add-in has an option to Upgrade Action Buttons. Follow these steps to convert your Perspective workbooks to be…