Get news from our subject-matter experts

arrow

The Ultimate IBM Planning Analytics (TM1) Training Roadmap for Beginners

Comment_Icon_black0
Alarm_Icon_16 min

IBM Planning Analytics (TM1) is a powerful enterprise planning and analytics platform used for budgeting, forecasting, and reporting. This premium roadmap is designed to take you from beginner to job-ready TM1 developer with practical skills, real-world use cases, and interview preparation. Phase 1: Fundamentals (Week 1–2) Understand OLAP concepts (Dimensions, Cubes, Measures) Explore TM1 Architecture (Server, PAW, TM1 Web) Install and navigate Planning Analytics Workspace (PAW) Understand basic cube and dimension structures Phase 2: Core TM1 Development (Week 3–5) Create Dimensions, ...

Line_2015

Mastering TM1DISTINCT: The Smart Way to Clean Up Your MDX Subsets

Comment_Icon_black0
Alarm_Icon_18 min

IBM TM1 models can get messy fast, especially when you use alternate hierarchies and elements show up in multiple places. That's where the TM1DISTINCT MDX function quietly saves the day. Instead of blindly stripping out anything that "looks" duplicated, it understands TM1's hierarchies and only removes true duplicates – the exact same member in the exact same context The Problem: Why Regular DISTINCT Isn't Enough Imagine you're building a dynamic subset of Products. You pull all products under All Products, then union it with a special "Focus Products" consolidation. Now some products appear ...

Line_2015

Smarter Cube Views in IBM Planning Analytics Workspace 3.1.3

Comment_Icon_black0
Alarm_Icon_19 min

Introduction IBM Planning Analytics Workspace 3.1.3 has made a noticeable difference to how I work with cube views every day. Instead of dragging views around and hoping I do not overwrite something important, I now use the built-in view selector to switch between different saved views in seconds. With Undo and Redo available directly in the cube view, it feels safe to try new layouts, pivots, and filters because I can always step back if the result is not what I expected. Together, these changes reduce friction in my analysis, keep my report layouts intact, and help me move much faster from ...

Line_2015

IBM Planning Analytics: Debugging and database explorer updates

Comment_Icon_black0
Alarm_Icon_12 min

IBM Planning Analytics has introduced new features that make development and administration tasks much easier. Two of the most impactful improvements are the ability to see variable values while debugging TI processes and the enhanced Database Explorer. 1. Hover to See Variable Values in TurboIntegrator Debugger Debugging TI processes used to mean adding log statements and rerunning processes just to see variable values. With the new hover help, simply move your mouse over a variable in the debugger, and its value is displayed (e.g., sCube = 'Asset_Input'). ✅ Benefit: Makes debugging much ...

Line_2015