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

TM1 Best Practices

A selection of the "Best Practice" articles from ExploringTM1

How to Dynamically Assign Information based on Data Entry

How to create a planning model where users can enter or select variables in one location and TM1 then assigns the data dynamically to all required dimensions. For example, in a budgeting model to plan labour centrally and assign people to cost centres dynamically.

Recent Posts

All the latest from ExploringTM1.

Planning Analytics for Excel (PAX) Ribbon Not Visible

The Planning Analytics for Excel ribbon is somewhat unreliable. Here we explain what drives the PAX toolbar, the add-ins and how and what to activate and a registry change that might be required.

Planning Analytics Version Management

Here we explain what versions of Planning Analytics (TM1) server, Planning Analytics for Excel (PAX) and Planning Analytics Workspace (PAW) work together to ensure your TM1 environment keeps on working nicely.

How to Display Traffic Lights using TM1

Traffic Lights in an Excel based TM1 report are dead simple. Here is a fully worked exercise to follow to create them and a series of ideas for their use.

Display TM1 Attributes in Cognos Analytics Crosstab

Here is how to create a Cognos Analytics Crosstab and use the contents of a TM1 Attribute for the rows, rather than the element IDs from TM1.

Rounding in TM1 – The Complete Guide!

ROUND and ROUNDP are often confused and users expect them to behave the same as the Excel function. They are very similar but are different to the Excel treatment. Here is a complete explanation of both functions, a comparison to Excel ROUND and screenshots of the usage of both functions.

SUBNM Excel TM1 Function: Syntax, Use and Example

SUBNM allows you to use a subset from a TM1 dimension for drop-down selection in an Excel, PAX, TM1Web or PAW report or form and open the subset editor to select elements.

Get started with our complete TM1 courses

Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement