• Version: 2.0.103 (Planning Analytics 2.0) / 2.1.10 (Planning Analytics 2.1)
• Released: April 16, 2025

This release is focused and measured. The updates bring meaningful improvements that help streamline daily use, particularly for users working with Universal Reports and environment management.

Here’s a closer look at what’s included:

Universal Reports now support cell pick lists, enabling users to select values from a dropdown list during data entry.
This feature enhances the speed and accuracy of input by minimising manual typing and reducing the risk of invalid entries.

Why it matters:
By standardising choices through pick lists, users can maintain better data quality while making the data entry experience faster and more intuitive.

Universal Reports introduce a Commit Changes dialog box that displays pending edits before they are submitted back to the TM1 server.
Users are given the opportunity to review, confirm, or cancel submissions, ensuring greater visibility into the changes being applied.

Why it matters:
The additional confirmation step improves data governance and reduces the likelihood of accidental or incomplete submissions — critical for environments where data integrity is a top priority.

An option called Disconnect and Clear WebView2 Profile Settings provides users with the ability to fully disconnect from data sources and reset WebView2 profile settings within Excel.
This feature is especially valuable for troubleshooting login problems, display issues, or session-related errors without requiring a full reinstallation or profile deletion.

Why it matters:
By providing users with a simple, self-service troubleshooting tool, downtime is reduced, support calls are minimised, and environment stability can be maintained more efficiently.

A known issue has been identified where large Universal Reports that require more than two minutes of query execution time may time out and fail to return data.
This affects users working on IBM Planning Analytics as a Service environments.

Best practice recommendation:
To minimise disruption, IBM recommends using Planning Analytics for Excel 2.0.103 together with Planning Analytics Workspace 2.0.103.

0:13 Cell Pick Lists Available in Universal Reports
0:26 Commit Data in Universal Reports
0:43 New option to disconnect from data sources and clear Webview2 settings
1:09 Known Issue: Universal Reports Timeout When Workloads Exceed Two Minutes of Query Execution

IBM Planning Analytics for Excel version 2.0.103 (20103), also known as 2.1.10 (2110), was released on April 16, 2025. Let’s walk through the updates introduced in this release and a known issue.

Universal Reports supports cell pick lists that allow users to select values from a drop down list when entering data, promoting faster, more consistent and error free input across reports.

Another enhancement for Universal Reports includes a Commit Change dialogue box to submit data back to the TM1 server.

This dialogue provides an opportunity to review pending changes before committing, reducing the risk of errors during the data submission process. An option called disconnect and clear WebView2 profile settings is available to fully disconnect from all data sources and resets WebView to profile settings. This option helps restore a clean environment when troubleshooting login issues, display problems or corrupted sessions without needing a full restart or reinstall. It provides a simple way to refresh the connection and improve overall stability in PAfE.

In this version, large Universal Reports that require more than two minutes of query execution time may experience a timeout and fail to return data. This issue affects users on IBM Planning Analytics as a Service. There is no current workaround, so for the best experience it’s recommended to use IBM Planning Analytics for Excel 2.0.103 together with IBM Planning Analytics Workspace 2.0.103. That’s the last feature for this version.