-
An introduction to creating subsets with Bedrock
This post is a quick tutorial covering creating subsets with the bedrock 4 library. To get a copy of the library you can download it from GitHub. Let’s examine bedrock’s workhorse process of subset creation, }bedrock.hier.sub.create. This process basically remains the same as in previous versions of the bedrock library. The process will create a static subset…
-
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…
-
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…
-
Cubewise February 2019 Update
Given that the month only had 28 days, the Cubewise team still pushed out a lot of content and updates. It is worth highlighting, that all these posts, videos, and tools are coming on top of the global teams working on building good TM1 and Planning Analytics solutions for our clients. THINK 2019 IBM hosted…
-
Need to know essentials for Planning Analytics
Our colleagues from Cubewise CODE have done some great work producing not just 1 but 3, “cheat sheets” which are super densely packed with knowledge. Each sheet is separately targeted at End Users, Developers or Administrators. The sheets have some handy colour-coding so you can easily distinguish what should be basic knowledge, advanced knowledge, or “extra reading”…
-
Enabling hierarchies, how does it affect your current model?
Welcome to this instalment of our series on upgrading to Planning Analytics. If you’re here then you probably know about the new features that PA brings such as Workspace, hierarchies and multi-threaded feeders, but you’re hesitant about whether to implement the new features due to concerns about the impact on your current mature implementation. If this describes…
-
Cubewise January 2019 Update
Yes, the first month of 2019 is already over and as things happened so fast, here is the summary of the Cubewise highlights in January. Cubewise CODE and other tools TM1Py 1.2.0 Marius did some major development around TM1Py and released a new version early December. After some internal testing, it is now ready for…
-
How to reference intersections of hierarchies in rules
This is a follow on from the previous article on working with hierarchies in rules. It will deal with how to address the intersection of two (or more) hierarchies in the right-hand side of a rule statement and the left-hand side of a feeder statement. Note this is accurate as at version 2.0.6.71 Intersections of hierarchies…
-
What exactly is cube optimization?
There are already many excellent sources available on the web explaining how to re-order dimensions or “optimize” a TM1 cube. Basically, this method can be summarized ordering dimensions “small to large, then sparse to dense.” However, I’m yet to find any reference explaining what is being optimized. This paper is aimed at addressing exactly this question:…