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
Featured Articles
TM1 Best Practices
A selection of the "Best Practice" articles from ExploringTM1
How to Convert a Text Date-time to a Numeric Element
Do you know how to convert a text date-time into a numeric (or full serial datetime) element in TM1? For example, if you have an…
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.
Playlists
Choose on of our playlists and read all our material on that subject in a curated list.