Andrew Walker
TM1 Cell Security: How To Do It and Best Practices
TM1’s security can be as simple or as complex as you need. We tend to start with the broadest possible definition of security and then refine it down to the…
TM1 RoundUp Function: Method, Syntax and Use
The RoundUp function doesn’t exist in TM1 like it does in Excel. However, here is a really simple method to achieve exactly the same outcome. TM1 RoundUp Method The method…
Calculating “As At” Values in a TM1 Rule
Have you ever needed to calculate the value “as at” a point in time? For example, you have an inventory cube and want to show the volume of stock at…
DimensionElementInsertDirect Function: Syntax & Use
DimensionElementInsertDirect in TM1 works exactly the same way as DimensionElementInsert except that it inserts the element immediately into the target dimension, rather than batching up all the new elements and…
Use Architect or Perspectives 10.2.x to Planning Analytics
“TM1 Architect cannot connect to server.” You might get this error when you try to connect an old version of Architect or Perspectives to a Planning Analytics server. One of…
TM1 Excel Reporting Best Practices – Control Tab
Excel is still the tool of choice for TM1 users to create reports and forms. They can be opened directly in Perspectives or Planning Analytics for Excel or via the…
PAX Connection Greyed Out – Troubleshooting
I once had a call from a client where the connection to Planning Analytics for Excel (PAX) was greyed out. We did a bit of troubleshooting and it turned out…
What is the URL for TM1Web?
I had a memory fade yesterday and could not remember the TM1Web URL for a default installation of TM1. FYI, TM1Web is a browser based interface for accessing forms and…
Over Feeding in TM1 – What is it and How to Avoid it
Do you have a large TM1 model that is consuming excess memory? Is performance suffering because of the size of the model? If so, you might have a situation where…
Keen to chat? Book a discovery call!