Reporting Case Studies

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

How to Calculate SUMIF in TM1

Posted on Aug 30, 2023 by Gautam Narula

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 based on a user input?…

How to Create a User Defined Consolidation in TM1 Architect & Perspectives

Posted on Aug 18, 2023 by John

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. We can either go back…

What to Consider to Upgrade from Perspectives to Planning Analytics for Excel (PAX/PAfE)

Posted on Jul 8, 2022 by John

We are about to upgrade one of the largest TM1 sites in the world from using Perspectives to Planning Analysis for Excel (PAX/PAfE). This is a guide to what you…

How to Display Traffic Lights using TM1

Posted on Dec 20, 2019 by John

Have you ever needed to create a TM1 report that uses Traffic Lights? You know, those little Red, Green or Orange (Amber) indicators that everything is good in your world,…

General Ledger Analysis with TM1

Posted on Nov 12, 2018 by John

The other day we were reviewing a General Ledger cube for a new client. They had a concern because they wanted to start using Planning Analytics Workspace, rather than just…

Create a TM1 Send Sheet in Excel

Posted on Oct 15, 2018 by John

Sometimes data created in Excel needs to be loaded into TM1 directly from the Excel sheet. Here I am going to show you the details in how to create a…

Need help with TM1?
We're here for you



Popular Articles

Keen to chat? Book a discovery call!