-
CellPutProportionalSpread function for IBM Planning Analytics (TM1)
CellPutProportionalSpread function for IBM Planning Analytics (TM1) CellPutProportionalSpread proportionally spreads a value to the children of a consolidation. In this video, CellPutProportionalSpread is used to show how data is spread to a cell with no underlying and no data. Where can the CellPutProportionalSpread function be used? TurboIntegrator Which TM1 Server version is the CellPutProportionalSpread function…
-
What’s new in v2.0.92 for PAfE, PAW and TM1 Web
Released on 11th of December 2023
-
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…
-
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…
-
List and Wildcard Functionality in bedrock
The bedrock library has always included support for lists and wildcards in strings passed to parameters. In previous versions of the library, the implementation of list and wildcard support was inconsistent with some bedrock v3 processes allowing users to input a list of objects separated by a delimiter and some included wildcard functionality. However, other…
-
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…