Skip to content

John

Virtual Dimensions in TM1 and Planning Analytics Explained

Posted on Nov 1, 2018 by John

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

Posted on Oct 15, 2018 by John

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

Posted on Oct 8, 2018 by John

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

Posted on Oct 5, 2018 by John

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

Posted on Sep 22, 2018 by John

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

Posted on Aug 25, 2018 by John

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

Posted on Jul 31, 2018 by John

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

Posted on Jun 25, 2018 by John

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

Posted on Jun 3, 2018 by John

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

Posted on May 28, 2018 by John

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!

pen