Gautam Narula

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?…

Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1

Posted on Aug 11, 2023 by Gautam Narula

Having MDX based dynamic subsets in TM1 is a fantastic way to ensure that reports, forms and processes that use those subsets contain all required elements. But there is an…

Stop Architect Hanging when Clicking Consolidated Element

Posted on Jun 26, 2023 by Gautam Narula

There are times user face issues trying to navigate in the dimension (subset editor) with thousands of elements, and accidentally click on the consolidated element. TM1 Architect hangs and the…

Keen to chat? Book a discovery call!