Category: CubewiseSource

  • 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…

  • 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…

  • 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…

  • 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.…

  • Adjusting server configuration for Planning Analytics

    What this article is about Planning Analytics or TM1 server v11 comes with a host of new features. In order to get best performance and control behaviour of the TM1 server if you are upgrading or considering upgrading to PAL then you should make sure that as a minimum you optimize your server configuration file…

  • Planning Analytics Workspace Installation guide

    What do I need to start the installation of Workspace? The installation would seem daunting at first as the installation of Planning Analytics Workspace is not as straight forward as the usual TM1 installations. To continue with the Workspace installation, confirm the current version of planning Analytics Local as at least version 2.0.0 or greater…