Gautam Narula, Author at Exploring TM1

Excel Reports

Discover a clever method to dynamically update period selectors to the current month in Planning Analytics Workspace and Excel.

4-June-2024 No Comments

Reporting

IBM does not provide a native function to calculate SUMIF in TM1. How do I calculate SUMIF in TM1 and

29-August-2023 No Comments

Admin Best Practices

Do you have slow reports with large subsets using MDX? Here’s a best practice guide with screenshots to fix poor performing MDX based subsets.

11-August-2023 No Comments

Dimensions

There are times user face issues trying to navigate in the dimension (subset editor) with thousands of elements, and accidentally

26-June-2023 No Comments

About Me