John
Virtual Dimensions in TM1 and Planning Analytics Explained
What are Virtual Dimensions? Virtual dimensions in TM1/Planning Analytics are an excellent way of adding new analysis capability to a TM1 cube without changing the underlying structure of the cube,…
Create a TM1 Send Sheet in Excel
Sometimes we have data that is created in Excel and we need to load it into TM1 directly from the Excel sheet. This blog post details how to create a…
Weights in TM1 – What They Are and How to Use Them
What are Weights in TM1? Weights in TM1 are used to change the way an element in a dimension is added up into a parent element. For example, if you…
Connecting Planning Analytics for Excel (PAX) to TM1
Here we detail how to create a new connection in Planning Analytics for Excel (PAX) to a TM1 model or server. What is Planning Analytics for Excel (PAX)? Planning Analytics…
Persistent Feeders in TM1 – Explanation and Implementation
Do you have a large TM1 model that takes forever to load when it is restarted? Do you have complex feeders or large feeder files in your model? If you…
Days in Month – How to Easily Calculate in a TM1 Rule
Calculating the number of days in a month is used for a number of financial calculations, such as inventory days and debtor days. Have you ever wondered though how to…
Choose Your Favourite ExploringTM1 T-Shirt
To celebrate almost 100,000 visitors to ExploringTM1.com and almost half a million page views, we have decided to create an ExploringTM1.com t-shirt to give away to the ExploringTM1 community and…
DimensionElementDelete Function TM1: Syntax and Use
Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the TM1 dimension and all associated data from any…
CubeSetLogChanges TM1 function: Syntax and Example
When we run a Turbo Integrator process in TM1, the Transaction Log will normally have a record written for each data change. To speed up the TI, we can turn…
Who Changed that TM1 Data? Using the TM1 Transaction Log
Have you ever had an inexplicable change to TM1 data? you know, when a user comes to you and says, John (in my case), the data in TM1 has changed…
Keen to chat? Book a discovery call!