Category: CubewiseSource

  • How to use the Synchronize Function with RunProcess to Limit the Number of Threads

    What Is RunProcess? RunProcess is a TM1 TurboIntegrator function that allows you to run multiple processes in parallel, each using its own thread.  While this function is great as it allows for faster data processing and data loads there is currently no built-in logic or feature to limit the number of threads that can be…

  • Preparing your TM1 / Planning Analytics model for the TM1 Rest API

    You can find a lot of content on how to start using TM1’s REST API, for example here, here or here. However, to the best of our knowledge, until now there hasen’t been any guidance to be found anywhere on what changes you may need to make to an existing model to make it “REST API ready” or for that matter principles to…

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

  • Transitioning from Perspectives to IBM Planning Analytics for Excel (PAfE)

    Transitioning from Perspectives to IBM Planning Analytics for Excel (PAfE)

    Thinking about switching from Perspectives to Planning Analytics for Excel (PAfE)? This guide explains how the core reporting concepts remain the same—while introducing a modern interface, new report types, and ongoing updates. From Custom and Dynamic Reports to Quick and Universal Reports, see how PAfE makes the transition seamless.

  • Press Release: Apliqo UX and Cubewise Canvas for TM1 to be offered as a single product

    Apliqo UX and Cubewise Canvas for TM1 to be offered as a single product Apliqo UX and Canvas for TM1 have been combined to a single product which will be known as Apliqo UX.Future releases of Apliqo UX will contain all features and functionality of both products. Apliqo UX improves the adoption rate and user…

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

  • How to…Encryption at Rest

    Starting in Version 2.0.4, TM1 Server / Planning Analytics Local has had an ‘Encryption at Rest’ feature.  In this Cubewise blog post, we explain what EaR means, why you would want to enable it, and how you can set it up using the “tm1crypt” utility. What do we mean by Encryption at Rest? A TM1…

  • Cubewise March to May 2019 Update

    Time flies! This time we present a summary of three months full of events, software releases, and developments from Cubewise. Conferences The first half of our conference season is now over. A lot of clients joined us in Paris and Hongkong to learn all about the latest developments in the TM1 and Planning Analytics market,…

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

  • Filter strings in bedrock

    Understanding how the pFilter parameter encodes filter strings is central to understanding the bedrock library. Bedrock converts the contents of the pFilter string into views by splitting the string into dimension names and element names and creating the view on the fly. Let’s examine the components of the filter string using the process }bedrock.cube.view.create  – pCube = “Employee”  – pFilter = “Year…