Content_Cut_Icon Twitter_Brands_Icon

Modernise Your TM1. Without Breaking What Already Works

Mode_Comment_Icon_white0
Alarm_Icon_1_white13 min

Here’s a scenario I see playing out across organisations right now. Finance teams have invested significantly in TM1 — IBM Planning Analytics — but somewhere along the way, the platform stopped feeling like a competitive advantage and started feeling like a liability. Excel is creeping back in. Enhancements are taking months. The system goes down at the worst possible moment. And in many cases, ...

down-arrow-blue
Book_Open_Solid_Icon

Here’s a scenario I see playing out across organisations right now. Finance teams have invested significantly in TM1 — IBM Planning Analytics — but somewhere along the way, the platform stopped feeling like a competitive advantage and started feeling like a liability.

Excel is creeping back in. Enhancements are taking months. The system goes down at the worst possible moment. And in many cases, the entire environment is held together by one or two people who are a single resignation away from becoming a crisis.

  

 

I’ve spent the last twenty years working with TM1 environments across every size and industry, and this pattern is remarkably consistent. The tool is rarely the problem. The way organisations run and support the tool — that’s where things break down.

In our recent webinar, I walked through the three pillars that we believe will modernise any TM1 environment — without starting over, without a costly eighteen-month project, and without breaking the things that already work.

Pillar 1: Infrastructure — Are You Running on the Right Foundation?

The first thing we audit with any new client is their infrastructure. And almost without exception, on-premise sites are running on versions that are three to five years out of date. That’s not a criticism — it’s the reality of how upgrade cycles work when there are competing priorities and limited IT resources.

The consequences are real: technical debt, security exposure, and a platform that’s increasingly hard to build upon. IBM ended support for versions 10.2 and below in April 2024. If you’re still on one of those versions, this conversation is urgent.

Today, there are three infrastructure options:

  • On-Premise: Full control, but the patching, security, and upgrades become your responsibility. In our experience, we have yet to encounter a single on-premise site running the latest version. Not one.

  • IBM Managed Hosting (IBM Cloud): IBM runs the platform for you. Upgrades are managed. The infrastructure burden shifts away from your team. This is a strong option if you want to focus budget on functionality rather than keeping the lights on.

  • AWS (PA on SaaS): The newest option, and in our view, the most compelling for organisations starting fresh or migrating today. Version 12, fully cloud-native, elastic RAM scaling in 16GB increments, and the lowest infrastructure overhead we’ve seen. Available in Australia and multiple other markets.

The economics matter here. On-premise can appear cheaper until you account for the IT time, upgrade projects, and security management it demands. Cloud pricing continues to decline. And migration itself is more straightforward than most teams expect — we have a dedicated team and a tested checklist that handles the move, including legacy Excel macros and TI processes that need extra care.

One important point: moving to the cloud is not modernisation on its own. If you move poor architecture onto better infrastructure, you still have poor architecture. Infrastructure is the foundation. Architecture is the next conversation.

Pillar 2: Architecture — Is Your Model Built to Last?

Legacy TM1 models accumulate debt in predictable ways. Different consultants come in over the years, each doing good work for the specific problem in front of them. But when you look at the model as a whole, the design may no longer reflect where the business is, or where it needs to go.

Some common symptoms we encounter:

  • Rules logic so layered over the years that no one can fully trace a number back to its source

  • Hard-coded dimension logic that makes even routine changes risky

  • Bloated, unused dimensions sitting in models and consuming memory

  • Critical processing knowledge living only in the head of one person

  • Metadata-driven design. Month rollovers, version changes, and business rule updates happen by changing a config cube — not by touching code.

  • Purpose-built, modular cubes. A separate staging layer, a core calculation layer, an input layer, and a reporting layer. It looks like over-engineering until you need to scale or change something.

  • Decoupled reporting. Reports connect to the relevant cubes and update automatically. Changes to the underlying model don’t cascade into manual reporting fixes.

  • Designed for change. The model is built for what the business will need, not just what was required at the time of build.

Modern TM1 architecture is built around a few core principles:

In some cases, we encounter, the accumulated technical debt is significant enough that a full rebuild is actually cheaper and faster than attempting to refactor what exists. We’ve seen organisations consider switching platforms entirely — not because TM1 couldn’t do what they needed, but because internal friction around a legacy model made change impossible. That’s a solvable problem, and it starts with an honest architecture assessment.

Pillar 3: Support — Moving from Reactive to Managed

This is the pillar that makes the most immediate difference, and the one most organisations have never properly addressed.

Traditional TM1 support looks like this: something breaks, someone raises a ticket, a consultant is engaged, investigation starts from scratch. The same issues recur every month. Knowledge lives in one person’s head. There are no SLAs, no health checks, no road map.

The data on this is stark. Around 60% of TM1 support spend goes into reactive work — fixing things that have already broken. Studies consistently show it costs three to five times more to fix production issues than to prevent them. And approximately 40% of finance teams report that Excel shadow models are running alongside TM1, filling the gaps where the platform is too slow or too broken to serve the business.

 

Modern managed support changes this. The key features:

  • Proactive health monitoring: Continuous environment monitoring rather than waiting for users to report problems

  • Finance calendar alignment: Support resources and capacity planned around budget cycles and month-end close, not allocated reactively

  • Defined SLAs: Users know what Priority 1 means, when the clock starts, and what happens next

  • Recurring issue elimination: Every resolved ticket is reviewed. Is this pattern recurring? If so, it goes into the backlog for a permanent fix

  • Knowledge transfer: No single-point-of-failure dependency. Multiple team members hold model knowledge, documented in a living knowledge base

The outcome, based on our work with clients across this model: a reduction of approximately 35% in total cost of ownership within the first several months and through optimised licensing, reduced reactive spend, and the compounding benefit of preventing issues rather than repeatedly fixing them.

The Practical Road Map: What to Expect and When

Modernisation does not need to be an eighteen-month programme. Here is what a practical timeline looks like:

Weeks 1–4: Assess and Plan

Audit the current architecture. Review support history — specifically, what tickets have recurred in the last six months and why. Assess infrastructure options and costs, including licensing implications. Align IT, security, and finance stakeholders on the direction.

Months 2–4: Execute

If migrating to the cloud, schedule and complete the migration. Begin architecture improvements, prioritised by business impact. Onboard managed support. Early benefits typically become visible around month four.

Ongoing: Optimise

Quarterly architecture reviews. Continuous performance tuning. Regular training as new features are released (IBM ships updates roughly every six weeks on the cloud). The knowledge base and road map stay live. Once this rhythm is established, improvements compound.

What Organisations That Have Done This Are Seeing

These are outcomes from actual client engagements, not projections:

  • Faster budgeting and month-end cycles: When the platform is stable and changes can be made quickly, the cycle compresses

  • Significant reduction in data errors: Proper architecture catches exceptions before they reach users

  • Zero outages during month-end: This is a bold statement, but it’s what the data shows when the foundational work is done properly

  • Finance teams spending more time on analysis than administration: The tool starts doing what it was bought to do

There is also a forward-looking consideration. If your organisation has any kind of AI strategy that involves TM1 data — and most do, or will — the data foundation has to be reliable. A platform that crashes at month-end is not a foundation you can build AI capability on. Modernisation is not the end goal. It is the prerequisite for everything that comes next.

Ready to Modernise Your TM1 Environment?

Octane Solutions is an IBM Gold Partner with over 100 TM1 projects delivered and the #1 IBM Partner award in the APAC region. We work with organisations globally — across Australia, New Zealand, the Pacific, India, the Middle East, and North America — on a flexible, no lock-in basis.

Our support tiers (Octane Green, Blue, and Black) are transparently priced on our website. If you’re not sure where to start, a complimentary health check will give you a clear picture of where your environment sits and what to prioritise.

Visit us: https://www.octanesolutions.com.au/tm1-support

Or reach out to Amendra directly on LinkedIn to discuss your environment.

If you’re on version 10.2 or below, or still running on-premise without a plan to move — this conversation is worth having today.

 

Leave a comment

Line

Why Your Power BI Reports Drift From TM1 (And How to Eliminate Flat-File Drift Forever)

Mode_Comment_Icon_black0
Alarm_Icon_117 min

Quick Summary: When Power BI board decks disagree with IBM Planning Analytics (TM1), batch CSV exports and scheduled ETL jobs are almost always the cause. Here is how modern finance teams eliminate data drift, protect payroll security, and connect TM1 directly to Power BI using live REST queries.

Target Readership: CFOs, Heads of FP&A, TM1 Architects, and Power BI Leads.

Every finance team recognizes the Friday afternoon reconciliation panic.

The CFO prepares to present the monthly forecast to the board. They open the executive dashboard in Microsoft Power BI. At the same time, the financial planning manager reviews the live consolidation model in IBM Planning Analytics (TM1).

The EBITDA numbers do not match.

The variance is small, but the damage is immediate. Executive trust evaporates. The finance team stops analyzing operational performance and spends the next four hours chasing spreadsheets across network drives.

This discrepancy is not a user error. It is an architectural failure known as data drift. Here is why traditional TM1 reporting pipelines drift, the security risks hiding in your flat files, and how to connect Power BI directly to TM1 without staging tables.

DataFusion Integration Architecture: IBM TM1 In-Memory Engine to Power BI Reporting Layer

Figure 1: End-to-end integration architecture: IBM TM1 multidimensional in-memory cubes streaming directly to Microsoft Power BI via the DataFusion OData v4 REST connector.

Failure Mode: Batch CSV Export Loop 12-24H Stale Latency

1. In-Memory TM1 Cube: Analysts update dynamic forecast assumptions →
2. TurboIntegrator Export: Overnight batch script runs ASCIIOutput to dump unencrypted CSVs to network drive →
3. Scheduled Power BI Refresh: Gateway reloads stale file snapshots. Late-day adjustments are missed.

Business Risk: Executive board decks disagree with live models. Unencrypted payroll and departmental margins exposed on shared drives.
Recommended: DataFusion Automated REST Link Scheduled & On-Demand Sync

1. TM1 v12 Cube: Single authoritative financial model in memory with cell security preserved →
2. DataFusion REST Connector: Lightweight (< 100 MB) local Flask bridge querying TM1 via OData v4 REST API →
3. Power BI Dataset: Queries TM1 on demand or on schedule with zero intermediate CSV staging and zero external data storage.

Business Outcome: Zero flat-file drift. One-click instant refresh with record counts displayed. Unlimited users, data, and servers.

1. The Anatomy of Reporting Drift

To understand why numbers drift, look at the path data takes from your TM1 cube to your Power BI visuals. In most organizations, this path relies on a batch export loop:

  1. The Live Plan: Business units enter revenue assumptions and labor headcounts into Planning Analytics Workspace (PAW). TM1 recalculates consolidated numbers in memory in real time.
  2. The Scheduled Export: Overnight, a TurboIntegrator (TI) process runs ASCIIOutput scripts to dump multidimensional cube slices into flat CSV files.
  3. The Shared Network Folder: These CSV files land on a local server or network drive.
  4. The Gateway Refresh: The Power BI on-premises data gateway triggers a scheduled import refresh early in the morning.
  5. The Executive View: Executives review the dashboard at 2:00 PM.

What happens if an analyst posts a late adjustment in TM1 at 10:00 AM?

The adjustment sits in TM1. Power BI will not reflect that number until the next overnight batch run. For an entire business day, your reporting layer shows stale figures. When organizations try to fix this by scheduling more frequent export scripts, they run directly into server locking issues, memory spikes, and fragile file dependencies.

2. The Three Hidden Risks of Staged Reporting

Batch exports create problems far beyond stale dashboard views. They introduce operational vulnerabilities that affect audit compliance, server stability, and data security.

Risk 1: Unencrypted Data Exposure

When you export TM1 data to CSV files, you strip away TM1 security. Unencrypted flat files containing sensitive payroll, executive compensation, and departmental margins often sit on network shares. Anyone with directory access can read these files. Staged reporting creates an unnecessary compliance risk for internal audit teams.

Risk 2: Brittle TurboIntegrator Maintenance

TurboIntegrator export scripts require hardcoded dimensions and element names. When your business adds a new entity, updates a cost center, or restructures a chart of accounts, those static TI scripts fail. Analysts must stop their planning work to debug broken scripts and adjust column mappings. If you want to review model health, read our TM1 Feeder Diagnostic Playbook.

Risk 3: Double Cloud Storage and Licensing Costs

Many IT teams try to solve flat-file drift by pushing TM1 data into an intermediate SQL database or Snowflake warehouse. This creates double data storage costs. You pay to store the data in TM1, and you pay again to host relational staging tables. Worse, you lose dynamic TM1 calculation rules. Every time rules change, engineers must rebuild ETL transformation pipelines.

3. Four Ways to Connect TM1 to Power BI: An Architectural Comparison

Finance organizations generally choose between four integration methods. Here is how they compare in production:

Integration Method Latency Cell Security Setup Complexity Server Load Impact
TI Flat-File CSV Export 12 to 24 Hours Stripped (Unencrypted) High Script Maintenance Moderate Disk I/O
Intermediate SQL Warehouse 4 to 12 Hours Rebuilt Manually Very High (Custom ETL) High Staging Overhead
Native Microsoft OData Feed Real Time Inherited Moderate (Power Query) High (JSON Memory Out)
DataFusion TM1 Connector Scheduled & On-Demand Inherited Automatically Low-Code (< 100 MB .exe) Low (OData v4 REST API)

While TurboIntegrator flat-file exports remain common, they treat an in-memory calculation engine like a static file dump. Similarly, Microsoft Power BI standard OData feeds struggle to parse complex multi-dimensional JSON views, frequently running out of memory during peak month-end refreshes.

The modern alternative is automated REST integration. DataFusion connects Power BI directly to the TM1 calculation engine using optimized OData v4 REST calls. It queries only the requested cube intersections, inherits cell security, and requires zero external data staging.

4. TM1 v12 and the Natural Shift to Direct REST Integration

Honoring TM1's Heritage: The Evolution of Manny Perez's Functional Database

For over forty years, TM1 has stood apart because of the functional database architecture Manny Perez pioneered in 1983: in-memory multi-dimensional calculations that traditional relational databases could never match. As TM1 evolves into TM1 v12, that core calculation power remains at the heart of the platform. The main evolution is how data flows around it. In containerized cloud environments without mapped Windows drives or local server file systems, integration naturally moves from batch text exports to direct, native REST APIs (like OData v4).

As organizations plan their upgrade path to TM1 v12, moving away from scheduled flat-file handoffs becomes a welcome simplification.

As detailed in our breakdown of IBM Planning Analytics Engine 12 Architecture, TM1 v12 runs on containerized microservices. In this modern setup:

  • TurboIntegrator processes run within isolated containers rather than relying on on-premises Windows batch scripts.
  • Ephemeral container storage makes external text file transfers unnecessary.
  • Reports in Power BI connect directly to the in-memory calculation engine through secure, governed REST interfaces.

DataFusion operates natively on REST protocols. It is designed to work with both traditional TM1 installations (10.2.2+) and containerized TM1 v12 environments without requiring architectural re-engineering.

5. Under the Hood: How DataFusion Works

According to the official DataFusion Technical Spec Sheet, the connector is engineered as a zero-overhead bridge designed specifically for finance and BI teams:

1. Prepackaged Standalone Executable (< 100 MB)

DataFusion runs as a standalone Windows application with zero external runtime dependencies, registry modifications, or complex client installs. It runs an embedded local Flask bridge on port 5000 (localhost:5000) to establish the direct communications link.

2. Direct OData v4 REST Connectivity

The software connects directly to the IBM Cognos TM1 REST API (default ports 5495 / 5498 SSL) using standard OData Version 4. It works seamlessly across IBM Cognos TM1 10.2.2 and above, Planning Analytics Local, and TM1 v12.

3. Selective Dataset & Metadata Link Generation

Users authenticate with their standard TM1 credentials, select the specific cube, dimensions, and views required for reporting, and click Get Link. DataFusion generates an encrypted, reusable link code for that specific dataset.

4. Universal BI Compatibility (Power BI, Tableau, Qlik)

Paste the link directly into Microsoft Power BI Desktop or Service. Power BI stores the link in its dataset library—once linked, it never needs re-linking. DataFusion also natively supports Tableau and Qlik.

5. Scheduled & On-Demand Sync with Record-Count Verification

Reports refresh automatically on your defined Power BI schedule or on demand. When users click Refresh manually in Power BI, an instant pop-up displays the exact count of records extracted from TM1 for transparent reconciliation.

Because DataFusion simply picks up and passes data discretely from TM1 to Power BI, customer financial data is never stored externally. The licensing model is straightforward: a 60-day free trial, setup in under 1 hour with Octane, and an unlimited subscription covering unlimited users, unlimited data, unlimited links, and unlimited servers (dev, test, prod).

6. Executive Action Plan: Eliminating Data Drift

To establish a single source of truth across your finance organization, follow these four steps:

  1. Audit Your Current Reporting Latency: Identify every report used by executive leadership. Measure the time delay between user input in TM1 and visibility in Power BI. If the delay exceeds 15 minutes, your pipeline suffers from data drift.
  2. Remove Flat Files from Shared Drives: Scan local network shares for exported CSV and Excel dumps. Replace unencrypted file paths with direct REST connections to protect confidential financial data.
  3. Align with Modern Support Models: Ensure your TM1 support team actively monitors REST integration performance rather than just fixing broken batch scripts. Review our guide on How to Evaluate IBM Planning Analytics Support Models to balance support capacity.
  4. Test Direct Query in a Pilot View: Select one high-frequency financial report, such as weekly cash flow or daily revenue tracking. Connect that cube directly to Power BI using Datafusion. Compare the refresh speed and data accuracy against your legacy batch export.

Eliminate the Friday Panic

Executive reporting should inspire strategic confidence, not spark data reconciliation debates.

When you connect Microsoft Power BI directly to the IBM Planning Analytics engine, you preserve the calculation power of TM1 while delivering instant, trusted visuals to leadership.

Ready to Modernise Your TM1 to Power BI Reporting?

Explore how the Datafusion TM1 Connector helps your finance team report like pros with zero TM1 development.

Explore Datafusion TM1 Managed Support
Line

Beyond the Monolith: Why IBM Planning Analytics Engine 12 Changes Everything for TM1 Architects

Mode_Comment_Icon_black0
Alarm_Icon_122 min

Quick Summary: IBM Planning Analytics Engine 12 (TM1 12) is the cloud-native re-engineering of the classic in-memory TM1 database engine. It replaces the 30-year-old monolithic server process (tm1s.exe) with containerized microservices on Red Hat OpenShift, enabling automated zero-downtime snapshots, elastic compute scaling, and secure REST-driven integrations.

Target Readership: TM1 Architects, FP&A Systems Leaders, and Finance Transformation Directors.

For three decades, IBM Planning Analytics (TM1) has powered the world's most demanding financial consolidation and operational forecasting models. Its in-memory calculation speed allowed finance teams to model complex multi-dimensional scenarios in seconds.

However, running enterprise TM1 on a monolithic architecture came with well-known operational friction:

  • 45-minute server reboot cycles during model maintenance.
  • Memory fragmentation requiring scheduled weekend reboots.
  • Heavy reliance on fragile operating system batch scripts via ExecuteCommand.
  • Client-side dependency on legacy 32-bit Windows utilities like TM1 Architect and Perspectives.

With IBM Planning Analytics Engine 12 (TM1 v12), IBM has rebuilt the infrastructure surrounding the TM1 calculation engine. Here is what TM1 architects, finance systems leaders, and FP&A directors need to know about TM1 v12, what changes under the hood, and how to prepare your models for the modern cloud-native era.

A Note to the Community: Keeping TM1 as TM1

In recent community discussions on LinkedIn, veteran architects and IBM Champions rightfully reminded us of an enduring truth: TM1 is TM1—the functional database pioneered by Manny Perez in 1983. While IBM marketing has cycled through product names over the decades (Applix TM1, Cognos TM1, Planning Analytics Local, PA Engine, and Engine 12), the soul of the technology remains Manny’s functional in-memory multidimensional engine. In this guide, whether we refer to it as TM1 v12 or IBM’s official packaging of Planning Analytics Engine 12, our focus is honoring that engine while dissecting the modern containerized infrastructure built around it.

1. The End of the 30-Year Monolith

In traditional TM1 (version 11 and earlier), every component of a TM1 database instance lived inside a single monolithic operating system process (tm1s.exe). When users logged in, queried views, ran TurboIntegrator (TI) processes, or saved data, everything competed for the same thread pool and memory space.

If an unoptimized feeder caused an out-of-memory error (as explored in our TM1 Feeder Diagnostic Playbook), the entire server instance could crash for all active users.

Lengthy Server Restarts

Loading dozens of gigabytes of cube data and recalculating feeders from disk on startup meant that any configuration change required taking the model offline for 20 to 60 minutes.

Fragile Operating System Dependencies

Many legacy TI processes relied on ExecuteCommand to trigger local PowerShell or Windows batch scripts to move files, create directories, or send notification emails. These scripts broke whenever underlying OS permissions or file paths shifted.

The 2026 Support Cutoff

Standard support for Planning Analytics 2.0.9 ended on October 31, 2025, and extended support concludes on October 31, 2026. Organizations still running legacy versions must modernize their architecture to maintain security compliance. If your team is reviewing support options, see our guide on How to Evaluate IBM Planning Analytics Support Models.

2. Inside Engine 12: Cloud-Native Microservices Architecture

Engine 12 fundamentally decouples the TM1 environment. Rather than running a single monolithic server, Planning Analytics 3.1 runs on a containerized, cloud-native architecture built on Red Hat OpenShift.

Figure 1: IBM Planning Analytics Engine 12 Cloud-Native Architecture Breakdown
RED HAT OPENSHIFT CONTAINER PLATFORM (ENGINE 12 CLUSTER) 1. Stateless Gateways SSO & OAuth 2.0 Auth Identity Token Routing REST API Gateway TM1 OData REST Endpoints PAW Web Session Router Zero-Lock Client Balancer [Scales on Demand] 2. TM1 Calculation Engine In-Memory Cube Pods Multi-Threaded Aggregations Rule Calculation Engine Feeder Evaluation & Stash Multi-Replica HA Dynamic Active Read Replicas [Isolated Memory Space] 3. Cloud Persistence Continuous Snapshots Zero-Downtime Backups Managed S3 Storage Cloud Object Repository Auto-Directory Gen Native AsciiOutput Paths [Decoupled Storage]
Architecture Component Legend & Technical Role:
1. Stateless Gateways (Left Block): Handles user authentication, SSO SAML/OIDC tokens, and OData REST API routing. Because it is completely stateless, user logins never compete with cube calculation threads.
2. TM1 Calculation Engine (Center Block): The high-performance in-memory OLAP core. Cubes, rules, and feeders run in isolated calculation pods. Organizations can scale multiple active read replicas to serve peak budget cycles without duplicating physical hardware.
3. Cloud Persistence Layer (Right Block): Decoupled cloud object storage executing continuous background snapshots. Reboots take seconds instead of 45-minute cold loads because memory states are restored instantly.

The core calculation engine remains an ultra-fast in-memory OLAP database, but the infrastructure surrounding it has been completely modernized into discrete services:

  • High Availability and Multi-Replica Databases: Engine 12 treats databases as managed cloud services. You can deploy active replicas that scale compute resources dynamically based on peak forecasting demands without duplicating physical hardware.
  • Automated Directory Creation and File Handling: Functions like TextOutput and AsciiOutput now create target directory structures automatically on cloud object storage. Developers no longer need to write manual OS directory creation routines.
  • REST-Native Automation with ExecuteHTTPRequest: Direct operating system command execution (ExecuteCommand) is retired in Engine 12 for enterprise security. In its place, TI processes use ExecuteHTTPRequest to communicate with external APIs, Azure Logic Apps, Power Automate, or serverless microservices. This eliminates the custom glue code friction we analyzed in Why Enterprise AI Projects Stall on API Glue Code.

3. The Retirement of Legacy 32-Bit Tooling

Moving to Engine 12 marks the official end of legacy client applications that have supported TM1 developers for decades:

  • Retired Tools: TM1 Architect, TM1 Perspectives (Excel Add-in), Performance Modeler, and TM1 Applications Web.
  • Planning Analytics Workspace (PAW): The central web-based interface for all modeling, cube authoring, rule editing, process configuration, and dashboard design. To get the most from PAW modeling, see our deep-dives on Mastering MDX in Planning Analytics Workspace and Selector Tiles in PAW.
  • Planning Analytics for Microsoft Excel (PAfE): The high-performance, modern 64-bit Excel add-in utilizing REST API endpoints for dynamic exploration and reporting.
  • Enterprise BI Integration: For teams connecting live TM1 cubes directly to executive dashboards, solutions like Datafusion for Real-Time Power BI Integration provide direct, high-speed reporting pipelines without manual data exports.
Figure 2: Planning Analytics Workspace (PAW) Unified Modeling & Reporting Interface
Cube Analysis & MDX View Builder Rows: Entity / Cost Center Columns: Period / Actual Live In-Memory Write-Back Grid Real-time dynamic rule calculation & sandbox modeling Executive Financial Dashboards Actuals vs. Forecast Visualizations • Instant consolidated variance reporting • Direct TM1 cube connection (Zero ETL latency) • Multi-chart synchronized drill-down FINANCIAL WORKFLOW & GOVERNANCE STATUS PIPELINE 1. Data Collection [Done] 2. FP&A Review [Active] 3. CFO Approval [Pending] 4. Month-End Lock [Pending]
Workspace UI Component Legend & Technical Role:
• Cube Analysis Grid (Left Section): Web-based cube view designer allowing FP&A analysts to slice multi-dimensional models, create sandboxes, and perform instant write-back without installing desktop client software.
• Financial Dashboards (Right Section): Real-time executive visualizations pulling consolidated actuals vs. budget variances directly from TM1 rules in milliseconds.
• Workflow & Governance Pipeline (Bottom Section): Replaces legacy TM1 Applications Web with end-to-end task assignment, multi-tier approvals, and audit trail locking across cost centers.

By centralizing development in PAW, teams eliminate client-side installation overhead and ensure every modeler accesses the exact same governance rules.

Traditional TM1 (V11) vs. Planning Analytics Engine 12 (V12)

Architectural Dimension Traditional TM1 (Version 11) Engine 12 (Planning Analytics 3.1)
Deployment Model Monolithic on-premises / IaaS VM Cloud-Native containerized microservices
Server Startup Full memory reload (20 to 60 minutes) Fast container spin-up with managed persistence
High Availability Manual standby clustering or cold backup Automated multi-replica service failover
External Automation Local ExecuteCommand (batch / PowerShell) Secure ExecuteHTTPRequest REST endpoints
Client Modeling TM1 Architect & Perspectives (32-bit) Planning Analytics Workspace (PAW) & PAfE
File Management Requires manual server-side file directories Automatic directory generation in cloud storage
Support Status PA 2.0.9 standard support ended Oct 2025 Modern platform with continuous release stream

4. The 2026 TM1 Modernization Playbook

Upgrading to Engine 12 is not just a version bump; it is an infrastructure upgrade that streamlines ongoing administration. Here is how enterprise planning teams are executing their transition:

1
Audit TI Scripts for ExecuteCommand

Catalog all TurboIntegrator processes that call external operating system batch files. Convert file movements and email alerts to REST endpoints using ExecuteHTTPRequest and modern webhooks.

2
Transition Modelers to PAW and PAfE

Phase out TM1 Architect and Perspectives immediately. Ensure your finance and modeling teams are comfortable building dimensions, rules, and reports directly in Planning Analytics Workspace and Excel.

3
Review MDX Queries and Rules

Engine 12 uses a modernized, standards-compliant MDX calculation parser. Validate custom MDX queries to ensure compatibility and take advantage of new memory management guardrails.

4
Establish Cloud or Container Migration Path

Determine whether your organization will deploy via IBM Planning Analytics as a Service (SaaS) or IBM Cloud Pak for Data on OpenShift before the October 2026 extended support cutoff.

Frequently Asked Questions

What is the deadline to upgrade from IBM Planning Analytics 2.0.9?

Standard support for IBM Planning Analytics 2.0.9 ended on October 31, 2025. Extended support runs until October 31, 2026. Organizations should migrate to Planning Analytics 2.1 or Planning Analytics 3.1 (Engine 12) before this date to ensure ongoing vendor patches and security compliance.

Can I run TurboIntegrator processes with ExecuteCommand in Engine 12?

No. ExecuteCommand is disabled in Engine 12 for cloud security. All external automations must be migrated to ExecuteHTTPRequest to call REST endpoints, serverless functions, or cloud integration platforms.

How does Engine 12 improve database recovery and server restarts?

Engine 12 decouples compute from storage and uses cloud-native object snapshotting. Database instances spin up in seconds rather than requiring 45-minute disk loads and feeder calculations.

The Leadership Takeaway

IBM Planning Analytics Engine 12 preserves what made TM1 world-class—its calculation speed and multi-dimensional modeling flexibility—while replacing the operational headaches of a 30-year-old server monolith.

By adopting cloud-native microservices, automated file handling, and REST-based integration, finance organizations can build scalable planning applications that require less maintenance and deliver faster insights.

Planning Your TM1 Modernization to Engine 12?

Octane Solutions helps enterprise FP&A and finance technology teams audit legacy TI processes, re-architect feeders, and execute zero-downtime migrations.

Schedule an Architectural Assessment
Line

The AI Bill Shock Coming for Every CFO

Mode_Comment_Icon_black0
Alarm_Icon_18 min

The AI Bill Shock Coming for Every CFO

Token costs, uncontrolled AI spend, and the governance gap that will cost your organisation — if you don't act now.

Every CFO I've spoken to in the last 12 months has signed off on at least one AI initiative. Most have signed off on several. Claude, Microsoft Copilot. ChatGPT Enterprise. AI features bundled into your ERP, your FP&A platform, your HR system. It's everywhere, it's accelerating, and for most organisations the cost of it is currently invisible.

newsletter cover (33)

 

That invisibility is about to end.

I'm not writing this to slow down your AI adoption. I'm writing it because the CFOs I respect most are the ones who price risk honestly — and right now, AI token cost is an unpriced risk sitting inside almost every finance function.

What Is a Token, and Why Should a CFO Care?

Let me give you the CFO version, not the technical one.

Every interaction with an AI system — every question answered, every document summarised, every forecast commentary generated, every journal entry proposed — consumes a unit of compute called a token. Tokens are the currency of AI. And like any currency, someone is paying for them.

Right now, for most organisations, that cost is bundled. It's absorbed into a Microsoft 365 licence fee, or included in a per-seat SaaS price. It feels free because it's not yet a separate line item. But the economics underneath it are not free. The hyperscalers — Microsoft, Google, Amazon, OpenAI — have collectively spent hundreds of billions of dollars building the infrastructure that runs these models. That capital has to be recovered. And as AI usage scales, the pricing models will adjust to reflect actual consumption.

The shift is already underway

What happens when 'included in licence' becomes metered usage

Microsoft Copilot, Azure OpenAI and others are already offering consumption-based pricing tiers — the bundled era is ending

 The Scenario I'm Warning CFOs About 

Picture this: it's 2027. Your organisation has deployed AI across finance, HR, procurement, and customer service. Every workflow touches AI. Your agentic finance stack is processing thousands of transactions per day — reconciliations, journal proposals, variance commentary, consolidation runs, audit checks.

Each of those interactions consumes tokens. Each of those tokens costs money. And the bill arrives — not as a budget line you planned for, but as a usage overage on a platform contract nobody reviewed carefully.

This is not speculation. It's the natural trajectory of a market where AI infrastructure costs are currently being subsidised to drive adoption. The subsidies don't last. They never do.

Before we know it, all those co-pilots and ChatGPTs running around the organisation will start quoting you every time someone asks something. It is going to cost you. The question is whether you see it coming.

The Three Ways Organisations Are Burning Tokens Right Now

In my experience working across finance transformations in Australia, New Zealand, and the Pacific, I see three patterns of token waste that are already costing organisations money they're not tracking:

1. Conversational AI without governance

When AI tools are deployed without usage policies, employees use them for everything — including tasks that don't require AI at all. Long, rambling prompts. Repeated questions because the first answer wasn't quite right. Document uploads of files that are thousands of tokens long when a summary would have served the purpose. Every one of those interactions has a cost.

2. Poorly designed agentic workflows

Agentic AI — where AI systems take sequences of actions to complete a task — is significantly more token-intensive than a simple question-and-answer interaction. An agent that loops back to reconsider, that makes unnecessary tool calls, that passes large context windows repeatedly through the model — this is expensive compute. Well-designed orchestrated workflows minimise token consumption by design. Poorly designed ones burn through compute at a rate that will surprise you when it's metered.

3. Shadow AI

Your teams are using AI tools you haven't sanctioned. ChatGPT personal accounts. Free-tier tools. Unofficial browser extensions. Some of this is genuinely benign. Some of it involves your financial data being processed by models you haven't vetted, under data agreements you haven't reviewed, with no audit trail of what was sent or what came back.

The token cost isn't the biggest risk here. The data governance risk is. But both are real.

What Governs Your AI Spend Right Now?

Ask yourself honestly: does your organisation have a framework for AI cost governance? Not a policy document that says 'AI should be used responsibly' — an actual framework that tracks consumption, attributes cost to business units, establishes usage thresholds, and reviews AI-generated outputs before they become business decisions?

If the answer is no — or 'sort of' — you are in the same position as organisations that deployed cloud infrastructure in 2012 without tagging resources or setting spend alerts. The AWS bill shock of that era is now a well-documented corporate cautionary tale. The AI bill shock of the late 2020s is still preventable.

Most of organisations have no formal AI cost governance framework

The AI equivalent of untagged cloud spend — invisible until it isn't

The Finance-Specific Governance Risk

For those of us in finance, there's an additional layer of risk that goes beyond cost.

When an AI system generates a journal entry, proposes an accrual, or produces variance commentary — and that output is posted or published without human review — you have a governance failure. The question the auditor will ask is not 'did AI do this?' The question is 'who approved it, and is there a record of that approval?'

Ungoverned AI in a finance context isn't just a cost risk. It's an audit risk, a compliance risk, and in some jurisdictions, a regulatory risk. The framework for AI governance in finance needs to address not just spend, but accountability for every decision the AI makes.

This is why in everything we build at Octane, the principle is non-negotiable: the agent proposes, the human approves. Every journal, every cost-centre assignment, every period lock is presented to a named controller before it posts. Nothing happens without a human decision. And every decision — approval, rejection, revision — is logged with a timestamp.

That isn't a constraint on AI effectiveness. It's what makes AI trustworthy in a finance context.

What to Do in the Next 90 Days

  • Audit your AI tool landscape. Get a complete picture of every AI tool your organisation is using — sanctioned and unsanctioned. Understand what data is flowing through each one and on what contractual basis.

  • Understand your current token cost exposure. Work with your IT and procurement teams to identify where AI usage is currently bundled versus metered. Get a baseline consumption number, even if approximate.

  • Build token cost into your AI business cases. Going forward, every AI initiative should include a consumption cost model alongside the efficiency benefits. The ROI calculation isn't complete without it.

  • Design governance into agentic workflows from the start. If you're evaluating or deploying agentic AI in finance, make human-in-the-loop approval a design requirement, not an afterthought. The audit trail this creates is not just good governance — it's the evidence your auditors will want.

The AI bill shock is preventable. But only if you see it coming and act before consumption scales.

The next blog in this series covers the one I get asked about most: governance. Specifically, how do you build an AI-powered finance function that your auditors will actually respect?

Amendra Pratap is the Founder and Managing Director of Octane Solutions, an IBM Gold Partner specialising in AI-powered finance transformation across Australia, New Zealand, and the Pacific.

Line

TM1 is never the Problem. Support is.

Mode_Comment_Icon_black0
Alarm_Icon_110 min

Why most TM1 environments underperform — and the four-step blueprint to fix it. 

Support

When a finance team tells me their TM1 environment "doesn't work", I've learned to listen carefully — because the platform is rarely the real issue. 

What they actually mean is one of four things: Excel is creeping back in. Enhancements are taking months instead of days. The system goes down at the worst possible moment — mid-budget cycle or during month-end close. Or, most dangerously, the entire environment is held together by one or two people, and a single resignation away from a crisis. 

The root cause of all four problems is the same: the operating model is reactive, knowledge is trapped, and improvements never get prioritised. In short, TM1 is not the problem. Support is.

The Four Support Models and Where Each One Breaks

Most organisations fall into one of four support models. The first step to improving your environment is recognising which one you are.

Model 1: The In-House Specialist 

You have one or two TM1 experts who own the environment. It works well when things are stable, and they're content. The breaking point arrives when they leave, or when the backlog grows faster than one person can manage. This is what the IT industry calls the "bus factor", what happens when the key person gets hit by a bus? It is not a strategy.

Model 2: Finance as the Admin

Finance has taken on the pseudo-admin role either because it was cheaper, more convenient, or gave them greater control. This works reasonably well in small deployments. It breaks when FP&A spends more time maintaining TM1 than using it for insights. The tool that was supposed to free finance ends up creating a new administrative burden, and Excel creeps quietly back in. 

Model 3: Ad Hoc Consulting

You call a vendor or consultant when things break. This is common — especially after a difficult implementation. The problem is structural: you pay to fix the same issues repeatedly, there is no knowledge transfer, no improvement, and you are essentially funding someone else's consulting pipeline by never resolving the root cause.

Model 4: Hybrid or Managed Support (Where You Should Be Heading) 

A model built for modernisation: clear governance, defined SLAs, mixed-maturity handling, peak-load capability, and measurable KPIs. This is the model that transforms support from a cost centre into a genuine business enabler.

 

What Modern TM1 Support Actually Looks Like

Not the brochure version. The operational reality.

Modern support is built around five pillars:

  • Coverage and Response. Defined SLA targets — not best effort. You know what Priority 1 means, when the clock starts, and what happens next. Communication is transparent.

  • Single Intake Funnel. No artificial split between support, development, and training. If it helps the business, it goes into one queue. No out-of-scope conversations.

  • Prevention Over Firefighting. The goal isn't faster ticket closure — it's eliminating the ticket in the first place. Every resolved issue is reviewed: Is  this recurring? If so, it goes into a problem backlog and gets a permanent fix.

  • Reporting and Accountability. Monthly KPI reports, backlog trends, and SLA compliance data. You can see what's happening and hold your support partner accountable.

  • A Live Road Map. Structured improvement with capacity built into every engagement. Not a list of hopes an actual plan with milestones.

The key mindset shift: modern support is not about faster ticket closure. It is about predictable cost, reduced risk, and continuous improvement — a model that prevents recurring pain rather than profits from it.

The Prevention Imperative

This is where most support models genuinely fail. In a reactive model, organisations pay to fix the same problem every month. In a prevention-led model, you invest once in understanding the root cause — and then it's gone. 

Based on our experience across client sites, more than 50% of ongoing support spend is going into repeatable issues that could be fixed once and automated. Think about that: half your support budget is fixing things that shouldn't be happening. 

Effective prevention involves three things:

  • Recurring ticket elimination: Identify the patterns and close them permanently.

  • Proactive health checks: Log hygiene, performance baselines, and chore execution validation — run fortnightly or monthly before problems surface, not after.

  • Automation of manual issues: Every repeatable manual task is flagged for automation. As the environment stabilises, ticket volumes drop, and human intervention decreases. 

Three Real Clients. Three Consistent Outcomes

The following outcomes come from actual client engagements — three different environments, three different sizes and industries, but strikingly consistent results.

Case Study 1: Large Media Group 35% Cost Reduction

A complex multi-entity TM1 environment with a heavy reporting load, mid-way through a cloud migration. By moving from a reactive break-fix model to a governed, predictable support structure with defined SLAs, this client eliminated their top five recurring issues within 90 days, reduced ticket volume by 40%, and completed their cloud migration with zero disruption to BAU operations including through a live budget cycle. 

The lesson: The 35% cost saving is the headline. The mechanism predictable cost, removal of key-person risk, and proactive maintenance are what actually drove it.

Case Study 2: Large Financial Services Group: 10-Week Budget Cycle Reduction 

Close to a thousand users, 50 rolling forecasts, and heavy allocation and scenario modelling workloads. The budget cycle was cut by ten weeks. Scenario modelling extended to a 60-month horizon. Finance shifted from process-heavy administration to genuine analysis. 

The lesson: None of this came from a new module or feature. It came from platform stability. When the system isn't crashing, when changes don't take weeks, the team can actually start using it. That is what stable support contributes to planning transformation.

Case Study 3: Global Retailer Zero Spreadsheets, 120 Hours Saved Monthly

A finance team managing reporting across 15 to 20 offline spreadsheets. Reports that previously took weeks now take five minutes. 120 hours saved per month — roughly equivalent to one full-time finance analyst returned to the business for actual analysis. And zero offline spreadsheets remaining. 

The lesson: For the CFO, eliminating spreadsheets was the most significant outcome not the time saving. Every uncontrolled spreadsheet is a version-control risk and an audit exposure. Stable TM1 support is not just an efficiency gain; it's a governance improvement.

The Support Maturity Curve: Where Are You?

  

Most organisations, if honest, sit at Level 1 or Level 2. Here is the full picture:

  • Level 1 — Reactive: Fix things when they break. Knowledge lives in people's heads. No road map. 

     

  • Level 2 — Stable: The environment is reliable. A support model exists, even if imperfect. Recurring issues are managed but not eliminated. 

     

  • Level 3 — Optimised: Prevention is active. Telemetry is live. Ticket volumes are declining. Finance is spending more time on analysis than administration. 

     

  • Level 4 — Innovation Ready: The platform is a genuine competitive advantage. Planning is automated. AI tools are actively in use. Finance is leading the organisation forward as a true business partner. 

The opportunity is not moving from Level 1 to Level 4 overnight. It is taking the next step. Levels 2 to 3 are where organisations see the biggest returns. 

The 6–12 Month Road Map

Months 1–3: Stabilise

Audit the environment. Fix the top five recurring issues. Stand up a single intake queue. Get telemetry and reporting live within 48 hours. Most organisations attempt to modernise before they have stabilised — that is backwards. Worse still, many implement another tool because the current one feels broken. Changing the tool will not solve a support model problem. 

Months 4–6: Optimise

Telemetry is fully deployed. Minor requests are automated. SLA reporting live. The knowledge base is built out. Around this period, support ticket volumes will begin to decline noticeably.

Months 7–12: Modernise

If you are still on-premises, cloud migration should be a key consideration here (IBM Cloud or AWS, depending on your scale and environment). Legacy models decommissioned. Finance has shifted from process work to analysis. If you are on an older version, anything 10.2 or below, IBM ended support for those versions in April 2024. You are running unsupported software. This conversation is urgent.

The True Cost of Poor Support

  

Most organisations measure support costs as consultant invoices. The real cost is much broader: 

  • Finance time wasted managing the tool instead of using it

  • Audit risk from uncontrolled spreadsheet use

  • Delayed forecasting and planning cycles

  • A platform too unstable to build upon

  • AI projects that cannot move forward because the data foundation is unreliable

That last point is increasingly critical. If your organisation has an AI strategy that involves TM1 data, and TM1 is crashing every month, you will have no confidence, nor will the AI team or the board in using those cubes as a foundation. Stable support is not the end goal. It is the prerequisite for everything else. 

Where to Start 

Ask yourself ten questions about your current support model:

  • During peak periods, is the system fast and reliable or slow and crashing?

  • How many recurring bugs or tickets do you handle every month?

  • What happens to unused support hours? Are they lost, or rolled forward?

  • Can your support model handle development work without a separate commercial fight?

  • How long does it take to deliver a critical finance report days, hours, or instantly?

  • Do you have performance monitoring on stats control cubes to spot regressions early?

  • Are your TM1 logs monitored so that accumulation doesn't silently pressure the server?

  • Who controls the ticket priority: finance, IT, or whoever shouts loudest?

  • Is there a knowledge base or runbook being actively maintained and shared?

  • Do you have an active road map aligned to IBM's support lifecycle?

Score one point for each yes. If your total is under seven, your support model is introducing meaningful risk into your finance function. 

The good news: this is entirely fixable. The road map is clear, the outcomes are proven, and the first step is simply understanding where you are. 

Ready to assess your TM1 support model?

Contact the Octane Solutions team for a complimentary five-question health check assessment, or reach out to Amendra directly on LinkedIn. We work with organisations globally from Australia, New Zealand, and the Pacific through to India, the Middle East, and North America on a flexible, no lock-in basis.

Learn more and get started: www.octanesolutions.com.au/tm1-support

Line

Modernising TM1: Why Cloud Migration Alone Doesn’t Solve the Problem

Mode_Comment_Icon_black0
Alarm_Icon_17 min

IBM Planning Analytics (TM1) remains one of the most powerful planning and modelling engines used by Finance teams worldwide. Yet many organisations eventually experience frustration with their TM1 environments — slow performance, painful upgrades, rising support costs, and the quiet return of Excel.

Contrary to popular belief, these challenges are rarely caused by TM1 itself.

They are symptoms of a modernisation gap.

The Hidden Drift Problem in TM1 Environments

TM1 models often start clean, efficient, and purpose-built. Over time, however, incremental changes accumulate:

  • New dimensions added without structural discipline

  • Rules layered onto legacy logic

  • TI processes expanded beyond their original design

  • Reporting logic intertwined with source data

  • Upgrade cycles deferred

  • Risk and compliance requirements

  • Upgrade tolerance

  • Internal IT capabilities

  • Cost predictability objectives

  • Metadata-driven logic instead of hard-coded processes

  • Modular cube design separating input, calculation, and reporting

  • Decoupled reporting layers

  • Performance-first feeder strategies

  • Cloud-aware security models

  • Structured change management practices

  • Issues detected late

  • Knowledge concentrated with individuals

  • Upgrades treated as disruptive events

  • Costs becoming unpredictable

What emerges is not a broken system — but a fragile one.

Performance declines. Change cycles slow. Complexity rises.

The Common (But Incomplete) Response: “Move to Cloud”

When issues surface, organisations frequently default to infrastructure decisions:

Move from on-premise to cloud
Adopt SaaS
Change hosting providers

While these shifts reduce infrastructure management overhead, they do not automatically modernise the model.

A poorly structured TM1 architecture behaves the same way regardless of where it is hosted.

Better infrastructure cannot compensate for design inefficiencies.

True TM1 Modernisation Requires Three Pillars

Sustainable TM1 environments align three interdependent areas.

1. Infrastructure Modernisation

Infrastructure choices should reflect:

Cloud platforms reduce maintenance effort — but they are only the foundation.

2. Architecture Modernisation (The Critical Lever)

Architecture modernisation is where the largest gains are realised.

Modern TM1 models typically prioritise:

Without architectural evolution, cloud migration simply relocates existing constraints.

3. Support Model Modernisation

Traditional break-fix support models introduce systemic risk:

Modern support approaches focus on:

Proactive monitoring
SLA-driven response models
Continuous optimisation
Upgrade lifecycle management
Knowledge transfer

This operating philosophy underpins Octane Blue, our proactive TM1 managed services model.

Why This Matters for Finance Leaders

Modernised TM1 environments typically deliver:

Faster budgeting and forecasting cycles
Lower data errors
Safer upgrade paths
Reduced operational friction
More predictable support costs

Most importantly, Finance teams regain time, stability, and confidence.

Final Perspective

Cloud migration is valuable — but it is not modernisation by itself.

Real TM1 modernisation redesigns how the model scales, performs, and evolves with the business.

📘 Download the TM1 Modernisation Roadmap (PDF) 
📊 Request a Free Upgrade & Risk Estimate 

 

Line

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

Mode_Comment_Icon_black0
Alarm_Icon_13 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. 

TM1 newsletter

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 Analytics model.

2. Leverage the Power of TM1 Cubes

TM1 cubes are powerful data structures that enable complex multi-dimensional analysis. Properly designing your cubes is crucial for efficient data retrieval and reporting. Ensure your cubes are optimized for performance by avoiding unnecessary dimensions and carefully planning your cube structure to support your analysis needs.

3. Automate Data Integration

Automating data integration processes can save time and reduce errors. Use ETL (Extract, Transform, Load) tools to automate the extraction of data from various sources, its transformation into the required format, and its loading into TM1. This ensures that your data is always up-to-date and accurate.

4. Implement Robust Security Measures

Data security is paramount, especially when dealing with financial and performance data. Implement robust security measures within your Planning Analytics environment. Use TM1’s security features to control access to data and ensure that only authorized users can view or modify sensitive information.

5. Regularly Review and Optimize Models

Regularly reviewing and optimizing your Planning Analytics models is essential to maintain performance and relevance. Analyze the performance of your TM1 models and identify any bottlenecks or inefficiencies. Periodically update your models to reflect changes in business processes and requirements.

6. Utilize Advanced Analytics and AI

Incorporate advanced analytics and AI capabilities to gain deeper insights from your data. Use predictive analytics to forecast future trends and identify potential risks and opportunities. TM1’s integration with other IBM tools, such as Watson, can enhance your analytics capabilities.

7. Provide Comprehensive Training

Ensure that your team is well-trained in using Planning Analytics and TM1. Comprehensive training will enable users to effectively navigate the system, create accurate reports, and perform sophisticated analyses. Consider regular training sessions to keep the team updated on new features and best practices.

8. Foster Collaboration

Encourage collaboration among different departments within your organization. Planning Analytics can serve as a central platform where various teams can share insights, discuss strategies, and make data-driven decisions. This collaborative approach can lead to more cohesive and effective planning.

9. Monitor and Maintain System Health

Regularly monitor the health of your Planning Analytics environment. Keep an eye on system performance, data accuracy, and user activity. Proactive maintenance can prevent issues before they escalate, ensuring a smooth and uninterrupted operation.

10. Seek Expert Support

Sometimes, managing Planning Analytics and TM1 can be complex and may require expert assistance. Engaging with specialized support services can provide you with the expertise needed to address specific challenges and optimize your system’s performance.

By following these tips, you can effectively manage your Planning Analytics environment and leverage the full potential of TM1 to drive better business outcomes. Remember, continuous improvement and adaptation are key to staying ahead in the ever-evolving landscape of financial planning and analytics.

For specialized TM1 support and expert guidance, consider consulting with professional service providers like Octane Software Solutions. Their expertise can help you navigate the complexities of Planning Analytics, ensuring your system is optimized for peak performance. Book me a meeting

Line

Exploring the Power of Automation with IBM Robotic Process Automation (RPA)

Mode_Comment_Icon_black0
Alarm_Icon_14 min

In an era defined by digital transformation and efficiency, businesses are increasingly turning to automation to streamline their operations. One such powerful tool in the realm of automation is IBM Robotic Process Automation (RPA). In this blog post, we'll delve into the world of IBM RPA, exploring its key features, benefits, and how it is shaping the future of business processes.

fiji blog (2)

 

Understanding IBM RPA:

Quick Answer: The top 6 benefits of intelligent process automation are: reduced operational costs, faster processing times, improved accuracy, enhanced compliance, better employee satisfaction, and scalable operations — all achievable with IBM RPA.

Robotic Process Automation, or RPA, refers to the use of software robots or "bots" to automate repetitive, rule-based tasks within business processes. IBM RPA is a comprehensive solution designed to enhance operational efficiency by automating mundane and time-consuming tasks, freeing up human resources for more strategic and creative endeavors.

Key Features of IBM RPA:

  1. User-Friendly Design: IBM RPA comes with an intuitive and user-friendly design that enables users to create automation workflows with ease. Its drag-and-drop functionality allows even those without extensive programming knowledge to design and implement automation processes.

  2. Cognitive Capabilities: Leveraging advanced technologies like artificial intelligence (AI) and machine learning (ML), IBM RPA goes beyond basic rule-based automation. The solution can adapt to changing scenarios, learn from patterns, and make decisions based on real-time data.

  3. Integration with Existing Systems: IBM RPA is designed to seamlessly integrate with a variety of existing systems and applications. This ensures a smooth transition to automation without the need for a complete overhaul of existing infrastructure.

  4. Scalability: Whether you are a small business or a large enterprise, IBM RPA is scalable to meet your automation needs. It can grow with your organization, adapting to increasing workloads and expanding automation requirements.

Benefits of IBM RPA:

  1. Increased Efficiency: By automating repetitive tasks, IBM RPA allows organizations to complete processes faster and with fewer errors. This not only increases efficiency but also enhances the overall quality of work.

  2. Cost Savings: Automation reduces the need for manual intervention in routine tasks, leading to significant cost savings in terms of time and resources. IBM RPA allows organizations to allocate human resources to more value-added activities.

  3. Improved Accuracy: Bots deployed through IBM RPA are programmed to follow predefined rules with precision. This reduces the likelihood of errors that can result from manual data entry or repetitive tasks.

  4. Enhanced Compliance: In industries with strict regulatory requirements, IBM RPA ensures that processes are executed consistently and in compliance with regulations. This reduces the risk of human error and associated compliance issues.

  5. Quick ROI: Organizations adopting IBM RPA often experience a rapid return on investment (ROI) due to increased productivity and cost savings. The time saved by automating repetitive tasks allows teams to focus on strategic initiatives that drive business growth.

IBM Robotic Process Automation is a game-changer in the automation landscape, providing organizations with the tools they need to enhance efficiency, reduce costs, and stay competitive in an ever-evolving business environment. As businesses continue to embrace digital transformation, IBM RPA stands out as a powerful solution that empowers organizations to automate intelligently, driving innovation and growth.

Want to learn more about RPA? Book us!

 

Line

Holly, jolly, and hassle-free: Let us handle your TM1 Support during the festive season 🎉

Mode_Comment_Icon_black0
Alarm_Icon_15 min

With the holiday season just around the corner, the air is buzzing with excitement as individuals eagerly anticipate spending quality time with their loved ones. As companies prepare for the annual shutdown, employees are gearing up for some much-needed rest and relaxation. However, amidst the festivities, it's essential to ensure that business operations continue to run smoothly, especially for those facing month-end reporting obligations.

IBM (4)

 

Maintaining Business Continuity:

The holiday season is a time to unwind, reflect, and connect with family and friends. However, in finance, the show must go on. As your key personnel take time off the forecasting and reporting must continue. This is where you can lean on us to ensure that your models and users are supported throughout this period. There is always an errant data load or a report that does not work the way it is meant to. Our Octane Blue TM1 team are an expert consultant and would be able to track issues and fix them. And yes we are available 24/7.

Eliminate Key Person Risk

Key man risk is the phenomenon of placing knowledge, skills, and important relationships in the hands of one or a few staff members. If this key man is to leave the business, they take their knowledge with them, leaving the business open for risk. This is a position that even most key persons hate as it limits their ability to progress within the organisation or get a promotion. This key person also wants to take a longer break and holidays. When this key person decides to move on from the role there is a mad scramble to do knowledge transfer. We walk into this scenario all the time to pick up the pieces and take over support. And in all the cases the model documentation is non-existent. 

Scale Up or Scale down

Your TM1 requirements are not static - You have busy months, unplanned outages, and a business that keeps evolving requiring your tools to keep up to pace. However, most of our support models are stuck in the past in a static mode. You can scale up or down based on what activities are happening in your application. During peak periods your users would appreciate having someone that can fix any data load and reconciliation issues that could suck up valuable hours waiting around. A lot of our clients also like having active monitoring during peak periods. On the same token, you can always scale down your usage of Octane Blue when there are no active support requirements or enhancements pipeline. Being a Pay as you go support you only pay for what you use.

No Contracts

We have a 100% client retention rate. There is no need for us to bind you to a 12-month contract or any other mechanism to keep you as a client. We believe our service and expertise are enough. Therefore we have removed the need to sign a 12-month contract. You can use us as a once-off or ongoing. We will take the burden of ensuring you are happy with the service and keep using us. We also don't ask you to break up with your existing vendor. 

How does it work?

Octane Blue is a 40-hour unit of octane services. We do not differentiate between Support and development. You can buy however units you need per month. No need to stress if you don't end up using the hours as we will roll it over for another month. You can utilize these hours for any support tickets, enhancements, or mini-projects. For larger projects, we recommend Octane Projects as that gives you a higher level of governance. 

We also open up our training portal for your users so they get access to unlimited free TM1 training. As you and us both know a trained user means a reduced number of tickets. 

What do our clients say?

Large Australian Steel company

This client is the leading steel supplier and manufacturer for the building and construction industry in Australia. They have been using TM1 for over 10 years. They started using Octane Blue for their support and enhancements in one of their divisions. 12 months on Octane has transitioned into supporting all divisions. In their quarterly TM1 User Forum, the team reflected on the benefits Octane Blue has delivered for them:

  • Mitigate Key people Risks and get an external view of best practice processes
  • More frequent review of the Planning process and system health
  • Cost-effective way to scale up
  • Create Additional Capacity to allow the internal team to work on higher-value critical work

Australia's Largest Commodity Organisation

This organisation is a unique mix of agribusiness and processing operations across multiple countries. They are the largest grains and oilseeds storage, handling, and processing assets in eastern Australia. They offer a global end-to-end supply chain. They have been using TM1 across the organization for their financial reporting and Budgeting. Due to M&A activity, their in-house team was at capacity and they started using Octane Blue. Initially, it was for End User support but has morphed into Development, Enhancement, and support streams.

What they love is :

  • 24/7 Support available to their global business
  • Support and development are handled in a more professional manner
  • Allow their in-house resources to focus on high-value work
  • Reduced Cost of Ownership for TM1
  • They can scale up Octane Blue to do Projects when required

All our clients are happy to provide a reference so we can facilitate a call with them. 

How do you start?


We ensure that onboarding you as a client is a seamless and easy exercise. We have our onboarding checklist that the team will use to ensure we have the correct level of access and work with your IT teams to get this organised. Post that we will go through model understanding and set up ticketing systems. All our services are SLA based so you have full transparency on tasks and status. 

You can start assigning us support and/or enhancement tickets. We recommend you get us to do a Flight check with you so we can gather a full understanding of the model very quickly as well as identify bottlenecks and complications built into it over the years. 

See here for more details. Octane Blue

 

Line

How does Octane TM1 Support services work and why is it so popular?

Mode_Comment_Icon_black0
Alarm_Icon_13 min

One of the interesting things about Octane Red and Blue is that there is no onboarding you can start to ticket on the first day of your subscription. Over time, we are studying tickets that the user creates and anticipate that the user will have the same ticket for the next month so we will create it in advance so that users will no longer make one, that is what we call recurring tickets.

desola-lanre-ologun-IgUR1iX0mqM-unsplash (1)
 

 There is a lot of automation that we can introduce, and this will no longer require any human intervention needed during the process, and tasks that are ticketed will be automated.

Preventative maintenance is where we take a lot of responsibility in TM1 to make sure that it is running lean, running clean, and running smart. If you don’t have a ticketing system within their organization, don’t worry because we will introduce you to a ticketing engine instead of sending emails, we will set up a ticketing app and the users can use this. This will help us track the ticketing hours we have every month and track the number of tickets made every month and if the volume of tickets reduces over the months passed.

In one of our client’s scenarios when they started with us, they were able to have 200 tickets, and then over time, we were able to reduce the tickets by 20% every 3 months. They just started with 3 units of Octane Blue and by the time with 6 months of engagement with the clients, we were able to reduce it to 1 ½. One of our KPIs with this product is the number of tickets, we want the volume of tickets to drop every month.

This ticketing application we use will help us read that to see how well we are on track. Once, the ticketing app is set up we are going to give the finance officer a chance to become the ticketing board leader, with this he gets to decide the priority tickets. The users then begin the ticketing on the board and the finance officer will be the one to decide what ticket to prioritize.

The process that happens between the finance office and the users is important because this is where preventive maintenance takes place. This is where we will take responsibility for how well your TM1 is running.

Let’s say you have opted in for the 40 hours of Octane blue, and you are already at the end of the month and there are 10 hours left. An octane (that is one of us) will ticket to themselves – “Preventive maintenance”, which means that they discovered something in the system like a bug or an issue that if eradicated will give ROI to make running TM1 easier in the consecutive months.

A finance person will have an opportunity to do two things, it is to roll the remaining 10 hours forward for the next month or have the 10 hours remaining to do preventive maintenance. Either way, we will take the responsibility to drive down the tickets that have been generated from month to month.

The limitation

Before subscribing to Octane Red or Blue, you need these three factors ready;

  • Project management
  • Costing
  • Timeline

Without those 3, it will cost you more dollars and we don’t want that to happen. Spending 16 hours on development only is not recommended because you will need to add more hours to keep your TM1 running.


 

Line

Smarter way to manage your TM1 Support and Development

Mode_Comment_Icon_black0
Alarm_Icon_16 min

If you are a TM1 user then you would have surely come across times when you required assistance in support or Development (DevOps) for your implementation. Thousands of companies use TM1 globally for financial and business performance reporting, calculation and presentation of KPIs, allocation, and apportionment, and as a tool for data collection. While having all that factors, a company may also experience pain points like costly consultants for TM1 Development and the struggle to hire a TM1 developer. We have released Octane Blue and Red which allows you access to TM1 developer and support resources on demand. 


rear-view-programmer-working-all-night-long (2)
 

3 instances Octane Blue can help you with your TM1 support and development

  • Your resident TM1 developer is getting bogged down in BAU tasks and unable to focus on Projects. This is a very typical scenario for mid-size TM1 shops. Your prized TM1 developer who understands business is not being utilized for Projects. This person also is responsible for keeping the lights on in the TM1 Planning Analytics and doing tasks like investigating data load issues, mapping mismatch, adding users, and answering small queries. Is this the best use of their time? Does this create a risk of the developer moving to another company where he can better utilize his skills and feel more valued?  This is where Octane Blue would be ideal where all the support tasks can be ticketed to the Octane team. This creates capacity in your TM1 capability to allow your internal teams to focus on bigger ticket items. Octane Blue is a cost-effective and professional approach to supporting your team. Octane Blue would provide you with seasoned DevOps staff who would be able to take on support and enhancements. Find out more here  Octane Blue

  • With the current turbulence in the skilled market, we have seen many instances where companies have had their TM1 resource leave and there is great difficulty in hiring another resource. The cost of resources has gone up significantly which means the budget has to be increased or compromises have to be made on the skill level. There have been times when Finance staff have been pulled into TM1 admin roles and expected to manage development and support. This is usually not sustainable, and you end up eventually losing your finance staff!  Octane can step in into this situation and take over the TM1 Support and development while you source your TM1 resource. The beauty of the Octane Blue service is that there are lock-in contracts. Use it for as long (or short) as you need us. 

  • You don’t need a full-time TM1 resource. Many sites don’t require a full-time TM1 resource. You may only need a TM1 expert when there is an issue or when you need some enhancements or development. This makes Octane Blue ideal as you only call upon our team when you need us – and we only charge for hours you consume! We also have a lite version which is Octane Red. It's quite comforting to know that you have experts on hand  – it could be just using the service during peak periods around month end and budgeting period. All our services are backed with SLA and response times.  

What you will love about Octane red and blue

  • No separation between the developer and support team – you will no longer have separate and different prices for development and support and talk to different people. You will no longer care whether you have co-development support because all you wanted at the end of the day is to have your cube built and want your reporting ready and done. But, with Octane red and blue you will no longer experience this problem from month to month on your plans because the price will be constant over the period of those months.

  • Rolling forward of the unused hour – some months are not so busy and you don’t really wanna pay for the months that don’t have much work that happened. With Octane red and blue you can roll forward those hours that you have not used up to one month. If you have used more hours that month you simply start working fewer hours the next month achieving the same equilibrium in your pricing. 

  • You will have a dedicated account Manager who will be the escalation point and would also be managing your services and communication between you and our team.  

How to get started with us

We have removed any friction from engaging our services. It’s simple to engage and there is no lock-in contract so you can stop the services easily as well. We have an onboarding checklist and we go through the documentation to get us the right level of access. We have security protocols around data access and access review. We take the privacy of your data seriously.   

Our team is all IBM-certified TM1 developers. You can start ticketing issues and support tasks from Day 1. It may take us a bit longer in the early days to resolve some of the tickets but as we build our understanding of your environment these times will reduce. We hold monthly meetings with you to go through the tickets and any outstanding issues. We also take this opportunity to suggest changes that may help eliminate issues. 

There are no limits to what you can ticket – it can be a development task, support task, or monitoring task. However, we may steer you to use our Projects mechanism for larger projects to ensure an appropriate level of governance is applied. You can also get more details on Octane blue here TM1 Developers

Fill out the form below and I will send you an information pack. 

 

 

Got a question? Shoot!

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Get more articles like this delivered to your inbox