ACG Business Analytics Blog

4 min read

Patient Volume Forecasting in Hospitals and Care Providers with IBM PA

Accurate forecasting of patient volumes is critical to help hospitals and care providers optimize allocation of resources. This Solution Brief outlines an application to support effective forecasting using IBM Planning Analytics (IBM PA). The... Read More

2 min read

Simplifying use of Custom Controls in IBM Cognos Analytics with AI

Custom Controls in IBM Cognos Analytics Over ten years ago, IBM introduced custom controls in Cognos Analytics 11.0.4. The concept was powerful and a framework that lets developers inject JavaScript and JSON configuration directly into a Cognos... Read More

4 min read

Using Claude with IBM Planning Analytics for Excel (PAfE)

Many finance teams already have two things sitting on the same desktop: a TM1 model they pull reports from through Planning Analytics for Microsoft Excel, and an AI assistant they are not quite sure what to do with. Connecting the two is more useful... Read More

2 min read

The Missed Opportunity in Using Copilot or Claude in Finance and FP&A

About a year into the AI journey, almost all companies and finance teams are using some form of AI capability. Most are using Copilot or Claude Desktop, given how easily they integrate with Excel. And while these are great tools and certainly... Read More

6 min read

Regular Backups of PAW Content with Lifecycle Manager

Below is an overview of the PAW backup process using Lifecycle Manager (LCM). For a full 27-page step-by-step guide with detailed screenshots, instructions and a customer communication template, download the ACG Solution Brief. 1. What Is PAW... Read More

4 min read

Data Quality AI Agent for IBM Planning Analytics

We have created an autonomous data quality agent designed to detect data anomalies, so that your team can spend less time tracking bad data, and more time making strategic decisions. Our custom agent solution combs through your TM1 model to elevate... Read More

3 min read

Native Job Scheduler for IBM Planning Analytics

The Challenge Every IBM Planning Analytics environment eventually outgrows simple chores. You start with a few scheduled TI processes. You add more. Soon, the processes become interdependent. Execution order begins to matter, failures must be... Read More

3 min read

Excel-Like Filtering in IBM Cognos Analytics

A JavaScript control evolved into a coordinated data filter that meets real business needs. The Business Problem Our team was tasked with delivering an IBM Cognos Analytics report that would serve as a daily dashboard tool for business users. The... Read More

2 min read

PAW Asset Backup with Lifecycle Manager

Planning Analytics Workspace content— books, views, dashboards, and applications— requires regular backups just like any other critical business asset. IBM Planning Analytics includes a built-in tool called Lifecycle Manager that handles this task. Read More