Exploring TM1

Great TM1 and Cognos content brought to you by Infocube

Discover More Here!

Create a TM1 Send Sheet in Excel

Excel based TM1 Send Sheets are a wonderful way of having data that is calculated in Excel loaded automatically into TM1 on demand. Here we show how to create a send sheet and automate it so that it only runs when required.

Weights in TM1 – What They Are and How to Use Them

Weights in TM1 can be confusing. Here we explain what they are and how to use them with some simple examples that will have your dimensions designed perfectly!

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 with screenshots to guide you along the way.

Persistent Feeders in TM1 – Explanation and Implementation

Persistent Feeders can dramatically decrease the time required to restart a TM1 model. Here is an explanation of what Persistent Feeders are and instructions on how to implement them in your TM1 model.

Days in Month – How to Easily Calculate in a TM1 Rule

Here we explain how to calculate the number of days in each month with a simple, but easy rule, using the DAYNO function and a Next Month attribute.

Choose Your Favourite ExploringTM1 T-Shirt

We are about to crack 100,000 visitors and half a million page views on ExploringTM1.com and to celebrate we are going to print a new, free t-shirt for the ExploringTM1.com community. Here are the final 8 tshirts and a link that will take you to the survey of possible designs.

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 dimension and all associated data from any cube the dimension is used in – so please be careful!

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 off transaction logging for a TI using the command CubeSetLogChanges.

CreateHierarchyByAttribute Function in TM1: Syntax and Use

Here is a great way to create virtual dimensions in TM1 based on attributes. These allow you to intersect multiple virtual dimensions from the same physical dimensions in a PAW or PAX report. Here we discuss the CreateHierarchyByAttribute function and give an example on how to use it.

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 since I looked at it last month? Well, if you have, here is the solution. And it is really easy!

/* THIS WAS THE CODE USED FOR EMBEDDING A SURVEYMONKEY POPUP */