There’s a fair amount of TM1 knowledge on the web.

The best TM1 knowledge on the web is here at Cubewise’s Tech blog.

Tag: TM1

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.


Read
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. However, Planning Analytics offers other features such as alternate hierarchies, new clients (PAX, PAW), improved clients (TM1 Web), performance boosts following new configuration parameters, or the option to move to a cloud-based system. Most of these features can but don’t have to be used, which leaves TM1 customers with some decisions to make.


Read
We oldschoolers need to revisit the language we use to talk about dimension structures

TM1 oldschoolers have long been used to being sloppy in our use of language to describe dimensions, hierarchies and rollups. Now that Planning Analytics supports named hierarchies the term "hierarchy" has a specific meaning which we need to respect. Clear and unambiguous communication is important. It may be difficult at first, but if you catch yourself saying “hierarchy” when you really mean “rollup” stop and correct yourself. It doesn’t take long to change the habit and the sooner we all do we can stop second guessing each other.


Read
What is the Cubewise EDU TM1 and Planning Analytics Developer Credential?

People might not generally be aware that in Planning Analytics (TM1 server v11) virtually all server configuration parameters are now dynamic, meaning they can be changed with immediate effect while the server is in session. This includes IntegratedSecurityMode which affects how users are able to log in.

This presents an easy way to prevent users establishing new sessions and interfering with batch load processes. Just change the IntegratedSecurityMode parameter and users won’t be able to log in. No need to for a TI to remove client/group associations or change all passwords which then need to be put back again.


Read
Let’s talk about element and attribute naming

Naming conventions are necessary both for end users and developers to make any system understandable and navigable. Deciding on a naming convention is a critical step and there are many opinions on what the "best" convention may (or may not) be. The rules and content of any naming convention actually matter far less than whether the conventions are consistently and universally applied within a given system.

Although naming conventions may be open for debate what isn't is that all naming conventions must avoid illegal characters and reserved words. This is a founding principal of any naming convention. To find out more about what this means in the context of Planning Analytics (TM1) read the article in full.


Read
Moving from TM1 to Planning Analytics is NOT complicated

First of all, Planning Analytics is just a new name for TM1.

Over the last few months, a number of customers have started planning the upgrade to Planning Analytics Local. There seems to be the perception that this process is more complicated than any other upgrade done before with TM1. In this article, I try to bust some myths and provide the information for your upgrade.


Read
Surveying Excel Hell – a New Approach to Manage Spreadsheet Proliferation

The nearly unlimited flexibility of Excel is powerful, but also one of the biggest cause of concern. How can you trust that a workbook shows the latest information, is built on trusted source data and does not containing any modelling errors? Any attempt to manage these risks is hampered by the fact that sheets can be added to a workbook, formulas can be changed and copies of the workbook can be easily created.


Read
Freedom under the Law and the Functional Database Model

Despite how obvious the benefits of the functional database seemed to me when I invented TM1 over 30 years ago, I have learned that these benefits are not immediately obvious to most people.


Read