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
Dimensions in TM1
Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and then cubes to hold data. What are…
Recent Posts
All the latest from ExploringTM1.
Universal Reports Prerequisites
A Universal Report is a new type of dynamic report that is hierarchy aware. It utilises TM1SET formulas and named ranges to achieve this. The…
How Users Add their IBM IDs for IBM Planning Analytics Cloud
As part of establishing IBM Planning Analytics on Cloud, users need to be invited into Planning Analytics, then accept the invitation and, if they don’t…
How to Add Users to IBM Planning Analytics on Cloud
As part of the administration of IBM Planning Analytics on Cloud, the TM1 administrator needs to set up users. In this post we will run…
Filter MDX Function in Planning Analytics
Definition The TM1 MDX function FILTER in IBM Planning Analytics is utilised to selectively retrieve data from multidimensional cubes based on specified criteria. In conjunction…
How to Calculate SUMIF in TM1
IBM does not provide a native function to calculate SUMIF in TM1. How do I calculate SUMIF in TM1 and perform a sum of values…
How to use DefineCalc to Create a User Defined Calculation
One of the most useful features of TM1 is the ability for users to create custom rollups, by way of User Defined Consolidation (UDC). Unfortunately,…
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.