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.

Cloud versus On-Premise Deployment

Reviewing your Software environment can result in many questions. Which is the best option? How do I choose between cloud and on-premise? How would it change the way we manage our systems? Can the cloud environment be managed by internal IT team?

Both environments have benefits, therefore the best question to find an answer to is “Which solution suits us best?”.


Read
Attributes in TM1. More things to be aware of

TM1 has supported MDX for a long time, but TM1’s own “dialect” of MDX can be a little quirky. Compared to standard MDX TM1 can be very concise, but it is also ambiguous which can be a problem as using TM1's "shorthand MDX notation" it is only possible to tell by context whether a member, a member property, or a subset is being referred to.

Of course, TM1 doesn’t just speak its own dialect of MDX, it also understands standard MDX and using standard MDX solves solves the problem of ambiguity. However, there is still a potential for typing and name conflicts between TM1 attributes and built-in intrinsic MDX member properties. This article makes Planning Analytics developers aware of these conflicts and how to deal with them.


Read
Using hierarchies for PickLists

The colon delimiter used between dimension name and hierarchy name presents a problem when defining PickLists as the same string delimiter is used. But we can overcome this issue by escaping the additional colon character.


Read
The (increased) importance of attributes in Planning Analytics

Attributes have always been very useful when developing a TM1 model but until now have never been an essential component of development. With Planning Analytics this changes. This is a forgotten or little known point that all TM1 developers should be aware of and is especially relevant for anyone with an existing TM1 model considering upgrading to Planning Analytics. To find out why this is read the article.


Read
Upgrade from TM1 10.x to Planning Analytics

Migrating from TM1 10.2.2 to Planning Analytics is not complicated, but it is a process with multiple layers that requires sufficient planning.

With IBM’s decision to stop support for TM1 10.2.2 in September 2019, we compiled a decision tree to ensure you know which questions you need to answer to find the most suitable path for your environment to effectively plan your upgrade to Planning Analytics.


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
An easier way to manage overnight batch runs

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