• Version: 2.0.104 (Planning Analytics 2.0) / 2.1.11 (Planning Analytics 2.1)
• Released: May 29, 2025

Add a spacer row or column within a Universal Report to improve the layout or insert an Excel formula, making content areas easier to interpret and present visually.

Cell indicators in Universal Reports can visually provide quick context on cells that are held or have values that haven’t been committed.

You can now hold and release cells directly in Universal Reports, just like in cube views. This makes it easier to manage value changes while protecting key numbers during data input or planning scenarios.

• 0:13 Add spacer rows and columns to Universal Reports
• 0:42 Cell indicators for Universal Reports
• 1:08 Universal Reports support cell holds
• 1:33 Enhancement to cube viewer interaction

IBM Planning Analytics for Excel (PAfE) version 2.0.104 (20104), also known as 2.1.11 (2111), was released on May 29, 2025. This release includes three updates for Universal Reports.

Easily add a spacer row or column in a Universal Report, giving you more control over layouts and presentation. With this feature, you can create cleaner, more stylized reports by visually separating sections. Or you can use Excel formulas in spacer areas to enable extended calculations or custom logic to add a new user defined row or column. Make sure you apply the formula to the calculation by clicking on Apply Formula to Calculation.

Cell indicators have been added to the Universal Report that make it easy to spot cell holds and edited cells that have not been committed. The style can be edited in the styles_CAFE.xlsx file that is located here. Please note from the style sheets, Universal Reports only uses the font color set from the styles Edit – IBM Cognos and Hold Values – IBM Cognos.

Cell hold is supported in Universal Reports, giving you more control over data entry and planning adjustments. With this feature, you can hold specific cell values in place during data spreading. This means held cells remain fixed while surrounding values adjust proportionally, improving flexibility in planning scenarios, especially when you need to protect key figures while adjusting others.

Navigating between the Cube Viewer and your Excel workbook will be more seamless when the Cube Viewer is in focus and you want to use Excel, the Cube Viewer will automatically minimize if you click any cell in the workbook behind it. It’s a simple but effective improvement that streamlines navigation and helps you stay focused while working across views.

And that’s the last feature for this version.