Great TM1 content brought to you by Infocube

Discover the potential and power of TM1 (Planning Analytics) and how you can sculpt and mould it to meet almost any business need.

Already have an account? Log In

Recent Posts

All the latest from ExploringTM1.

How to Write a Great Blog Post

This post explains how to write a blog post on ExploringTM1.com. It covers writing the post, making sure it is well structured from an SEO…

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…

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….

INT in TM1: Finding the Largest Integer Less Than or Equal To a Specified Value

The INT function allows you to return the nearest integer less than or equal to a specified value. Syntax of INT The syntax of the…

How to find the Largest of Two Values in TM1: MAX Function: Syntax and Use

The Max function will deliver to you the largest of two numbers. For example, if you have 50 and 100, using the MAX function will…

N Level-MDX for Leaf Level Elements from an Ancestor in TM1

Use MDX to return JUST the children of a parent element in TM1. Simple explanation with worked example. THis MDX can then be used to export just those elements.

Join the TM1 Explorers

Gain free access to all ExploringTM1 content and receive a regular email with great ideas and best practices for managing your TM1 environment.