IBM TM1, Agentic AI & Finance Transformation Insights

Mastering MDX in IBM Planning Analytics Workspace

Comment_Icon_black0
Alarm_Icon_110 min

Part 1: Essential Functions Every TM1 Developer Should Kno MultiDimensional Expressions (MDX) is one of the most powerful features available in IBM Planning Analytics Workspace (PAW). While many TM1 developers rely on static subsets, mastering MDX opens the door to dynamic reports, intelligent dashboards, and significantly reduced maintenance In this first article of the series, we'll explore three fundamental MDX functions that every TM1 developer should understand: TopCount() Filter() Descendants() These functions form the building blocks of many real-world PAW applications. Why Learn MDX? ...

Line_2015

IBM Planning Analytics Migration: The Power BI & Datafusion Blueprint

Comment_Icon_black0
Alarm_Icon_14 min

You have made the decision to migrate to IBM Planning Analytics (TM1) in the Cloud. You have mapped the architecture, and you are ready to leave your legacy spreadsheet grids behind. But for both IT and the CFO, the most critical bottleneck in a 2026 migration isn't getting the data into the cloud—it's getting it back out. How do you connect a multi-dimensional TM1 cube directly to a modern visualization tool like Microsoft Power BI, without breaking the reporting layer or relying on brittle, overnight batch scripts? Here is how the fastest-moving FP&A teams are solving the reporting ...

Line_2015

What is IBM Planning Analytics? Ending the "Month-End" Friction in 2026

Comment_Icon_black0
Alarm_Icon_14 min

If you are a CFO or an IT Director managing an on-premise financial reporting system in 2026, you already know the pain. IT is spending a disproportionate amount of the week maintaining local servers and dealing with version control conflicts in legacy Excel add-ins. Meanwhile, Finance is battling the exhausting "double-close risk," manually reconciling data across disparate systems and praying a massive VLOOKUP macro doesn't break on day three of month-end. When leadership asks "what is IBM Planning Analytics?", they are usually looking for a better spreadsheet. But the reality is different: ...

Line_2015

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

Comment_Icon_black0
Alarm_Icon_19 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

What's new in Cognos Analytics 12.1.x

Comment_Icon_black0
Alarm_Icon_118 min

Dashboards: Distinction between Display and Use value in dashboards: You can now define Display and Use values in data modules. The Display values are the values that you can see in a dashboard UI; the Use values are primarily for filtering logic. Previously, defining the Display and Use values was possible only in FM packages. This feature brings the same capability to data modules and enhances consistency across dashboards and reporting. You can interact with readable values while filters apply precise underlying identifiers. For example, you can select a Customer ID value in the dashboard ...

Line_2015

Octane’s AI Contract Analyser & Ask Procurement Portal: Transforming Contract Review for Modern Enterprises

Comment_Icon_black0
Alarm_Icon_114 min

Procurement teams today are under pressure to move faster, reduce risk, and operate with greater transparency. Yet contract review — one of the most critical procurement responsibilities — remains slow, manual, and highly inconsistent across most organisations. A major enterprise client came to Octane facing exactly this challenge. Their procurement function was overwhelmed: contracts were buried in inboxes, reviews took hours, and comparing updated versions created delays and negotiation blind spots. Octane delivered a powerful, AI-enabled solution using IBM WatsonX Orchestrate — combining a ...

Line_2015

Transform Enterprise Performance with IBM Analytics and AI Solutions

Comment_Icon_black0
Alarm_Icon_18 min

In today’s volatile business landscape, agility is no longer a competitive advantage—it’s a necessity. True agility means moving beyond fast response to actively anticipating market shifts and seamlessly aligning people, processes, and technology to act decisively. Enterprises possess vast troves of data, yet the ultimate differentiator is the ability to transform that data into actionable insights and automated, intelligent decisions. At Octane Analytics, we are driving this transformation across industries by evolving disconnected reporting tools into a unified, intelligent ecosystem ...

Line_2015

Integrating transactions logs to web services for PA on AWS using REST API

Comment_Icon_black0
Alarm_Icon_15 min

In this blog post, we will showcase the process of exposing the transaction logging on Planning Analytics (PA) V12 on AWS to the users. Currently, in Planning Analytics there is no user interface (UI) option to access transaction logs directly from Planning Analytics Workspace. However, there is a workaround to expose transactions to a host server and access the logs. By following these steps, you can successfully access transaction logged in Planning Analytics V12 on AWS using REST API. Step 1: Creating an API Key in Planning Analytics Workspace The first step in this process is to create an ...

Line_2015

Tips on how to manage your Planning Analytics (TM1) effectively

Comment_Icon_black0
Alarm_Icon_14 min

Effective management of Planning Analytics (TM1), particularly with tools like IBM’s TM1, can significantly enhance your organization’s financial planning and performance management. Here are some essential tips to help you optimize your Planning Analytics (TM1) processes: 1. Understand Your Business Needs Before diving into the technicalities, ensure you have a clear understanding of your business requirements. Identify key performance indicators (KPIs) and metrics that are critical to your organization. This understanding will guide the configuration and customization of your Planning ...

Line_2015

Saying Goodbye to Cognos TM1 10.2.x: Changes in support effective April 30, 2024

Comment_Icon_black0
Alarm_Icon_12 min

In a recent announcement, IBM unveiled changes to the Continuing Support program for Cognos TM1, impacting users of version 10.2.x. Effective April 30, 2024, Continuing Support for this version will cease to be provided. Let's delve into the details. What is Continuing Support? Continuing Support is a lifeline for users of older software versions, offering non-defect support for known issues even after the End of Support (EOS) date. It's akin to an extended warranty, ensuring users can navigate any hiccups they encounter post-EOS. However, for Cognos TM1 version 10.2.x, this safety net will ...

Line_2015

Top 12 Planning Analytics features that you should be using in 2023

Comment_Icon_black0
Alarm_Icon_18 min

Amin Mohammad, the IBM Planning Analytics Practice Lead at Octane Solutions, is taking you through his top 12 capabilities of Planning Analytics, in 2023. These are his personal favorites and there could be more than what he is covering. He has decided to divide his list into PAFe and PAW, as they have their own unique capabilities, and to highlight them separately. Planning Analytics for Excel (PAfE) 1. Support for alternate hierarchies in TM1 Web and PAfE Starting with TM1 Set function, which has finally opened the option to use alternate hierarchies in TM1 web. it contains nine arguments ...

Line_2015

Planning Analytics Audit log – Little known pitfall

Comment_Icon_black0
Alarm_Icon_12 min

The blogs brief about the challenge faced post enabling the Audit log in one of our client's environment. Once the audit log was turned on to capture the metadata changes, the Data Directory backup scheduled process started to fail. After some investigation, I found the cause was the temp file (i.e., tm1rawstore. ) generated by the audit log by default and placed in the data directory. The Temp file is used by audit log to record the events before moving it to a permanent file (i.e., tm1auditstore). Sometimes, you may even notice dimension related files (i.e., DimensionName.dim.), and these ...

Line_2015