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.
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,…
How to Create a User Defined Consolidation in TM1 Architect & Perspectives
Sometimes we want to create a rollup of elements from a dimension that does not exist in the dimension structure itself. We have a choice….
TM1USER TM1 Excel Syntax and Use
TM1User function, when used in Planning Analytics for Excel, returns the user logged in the current server. TM1USER SYNTAX The syntax is as following: Where:…
DBSW TM1 Excel Syntax and Use
The DBSW function in TM1 sends a numeric value to a TM1 cube. Syntax The syntax for using DBSW function is: Where: The arguments e1…
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.
