September 2025 Release Notes
  • 11 Minutes to read
  • Dark
    Light
  • PDF

September 2025 Release Notes

  • Dark
    Light
  • PDF

Article summary

Latest Product Release - September 2025 (v25.9)

Explore what’s new in Planful’s September 2025 release! This update brings significant enhancements across key features:

  • Dynamic Planning: Introduced scalable management of structured, non-numeric data directly in Spotlight web for easier model maintenance with Enhanced External Source Model.

  • Dynamic Planning: Introduced support for multiple independent cascade blocks within a single SpotlightXL report for flexible, multi-model reporting with Multi-Block Cascade.

  • Dynamic Planning: Added support for commentary on non-numeric measures, enabling teams to provide context-rich collaboration directly within planning models.

  • Integrations: Added support for exporting hierarchies in Tree, Parent-Child, and Level-Based formats to CSV, JSON, and Excel for the Export Attribute Hierarchy REST API.

  • Planful AI Analyst: Threshold-Based Filtering – Introduced automatic filtering based on user-defined thresholds to spotlight material variances and key insights.

  • Predict: Introduced AI-powered forecasting with as few as two months of history, accelerating adoption for new accounts.

  • Predict: Introduced single-year and multi-year trend visualization with zoom and year-specific grid updates in Dynamic Report.

  • Predict: Algorithm Mode in Templates – Introduced a mode to compare forecast accuracy, toggle projections, and upload custom models for tailored planning.

  • Workforce Planning: Employee Type Mapping for Compensation – Streamlined compensation management by enabling direct mapping or unmapping of items to Employee Types.

  • Workforce Pro: New Agg() Function – Added a flexible aggregation function for rolling commissions, bonuses, and forecasts across customizable time windows.

Stay informed with the latest product release details and optimize your Planful experience with these enhancements.

Explore these latest release notes to make the most of the new features and enhancements!

Dynamic Planning: Enhanced External Source Model for Streamlined Management of Structured, Non-Numeric Data

Enhanced the flexibility of Dynamic Planning with powerful enhancements to External Source Models (ESM). These updates bring richer management of structured, non-numeric data directly into the Spotlight web experience, making planning models more scalable and easier to maintain.

Note:

This is an opt-in feature. Contact Planful Support to enable the DP 2.0 flag for you.

Read More…

With this release, we have significantly enhanced External Source Models (ESM) in Dynamic Planning. Users already use ESM to manage structured, non-numeric datasets, and these capabilities are now extended to the Spotlight web experience with a range of usability improvements.

ESM provides a flexible, spreadsheet-like interface to organize and maintain business-critical reference data such as employee rosters, project lists, cost center attributes, and other operational datasets. By separating structured lists from cube logic, ESM simplifies planning models, improves scalability, and maintains high data integrity.

Key Enhancements:

ESM Creation and Configuration

  • Create customizable tables quickly with an intuitive interface.

  • Add columns with configurable data types: Text, Number, Date, and Boolean.

  • Define validation properties such as required fields, uniqueness constraints, and default values.

Edit and Manage Published ESM

  • Modify structure and data of published tables without rebuilding.

  • Restore previous versions to revert to a prior data state.

  • Rename columns or update data types post-publish.

  • Add formula columns to calculate dynamic values.

  • Apply or update column formatting for improved readability.

Row-Level Data Management

  • Add or edit rows directly in published tables.

  • Support incremental updates for agile and accurate planning.

Automatic Sync with SpotlightXL

  • All published table changes automatically sync with linked ESMs in SpotlightXL, ensuring consistency across platforms.

Key Benefits:

  • Centralized Data Management – Keep critical reference data structured within your planning models.

  • Streamlined Planning Models – Reduce reliance on complex cube structures for cleaner, scalable planning.

  • Data Integrity – Enforce validations and rules to minimize errors.

  • Agility and Control – Make real-time updates without disrupting ongoing planning.

How to Create an ESM

  1. Navigate to Dynamic Planning > ESM in Spotlight Web.

  2. Click Create ESM.

  3. Upload a structured dataset or build it manually.

  4. Define column names, data types, and validation properties.

  5. Use the + icon to add more columns.

  6. Click Publish or Save as Draft to make it available.


Dynamic Planning: Multi-Block Cascade Support in SpotlightXL

With this release, we have enhanced Multi-Block Cascade support in SpotlightXL reports, a powerful enhancement that significantly boosts report-building flexibility. This update allows users to define and execute multiple independent cascade blocks within a single SpotlightXL report using the same or different models, enabling more dynamic and complex reporting scenarios.

Note:

This is an opt-in feature. Contact Planful Support to enable the Multi-Block Cascade flag for you.

Key Capabilities:

  • Multi-Block Cascade Per Report: Users can now define several independent cascade blocks in the same SpotlightXL report layout.

  • Flexible Layout Options: Support for stacked, side-by-side, and offset block placements to fit diverse reporting needs.

  • Multi-Model Compatibility: Each cascade block can link to the same or different Dynamic Planning models, with validations performed individually.

  • Excel Formula Compatibility: Excel formulas placed outside named cascade blocks are preserved. The system automatically adjusts relative references to maintain formula accuracy during cascade expansions.

Notes:

  • Your Named Ranges are not supported in SpotlightXL when publishing Multi-Block Cascade templates.

  • Ctrl+X and Ctrl+V are not supported on the cascade blocks to cut and paste it in the other sheet.

  • Cascade Block names are system-defined and cannot be renamed.


Dynamic Planning: Commentary now compatible with Non-Numeric Measures

With this release, we have expanded support for non-numeric measures to allow comments directly on data values within planning models. You can now annotate values while leveraging non-numeric fields improving context, collaboration, and clarity in reviews and forecasts.


Integrations: Enhanced Export Attribute Hierarchy REST API

The enhanced Attribute Hierarchy Export API now supports Tree, Parent-Child, and Level-Based formats, with export options available in CSV, JSON, or Excel.

Read More…

We have enhanced the Attribute Hierarchy Export API to support multiple export formats Tree, Parent-Child, and Level-Based providing greater flexibility and control when exporting Attribute hierarchy data. You can also choose the desired response format in CSV, JSON, or Excel formats, making it easier to suit different integration and reporting needs.

Previously, only Level-Based exports were supported. With this enhancement, users can now export attribute hierarchies in Tree and Parent-Child formats as well.

New ExportType Parameter: A new ExportType parameter has been introduced in the API request body, allowing you to define the hierarchy structure format. The supported values are:

  • Tree - Exports a list of hierarchy members with each member’s Id (IDX), Name, and Type (Rollup or Leaf).

  • ParentChild - Exports data in a parent–child structure including Name, Description, and Leaf status.

  • LevelBased - Dynamically reflects the number of levels configured in the hierarchy. Each level includes Name and Description.

Default Behavior: If ExportType is not provided, the API returns the Tree format.

Sample Request Body

{
  "AttributeHierarchy": "Text_Attribute_hierarchy",
  "Dimension": "Account",
  "ExportType" :"LevelBased"
}

Download Format Options: Choose the response file format via the Accept header (or download action):

  • CSV - Set the header: Accept: text/csv

  • JSON - Set the header: Accept: text/json

  • Excel - Use Send and Download in your API tool (e.g., Postman) to save the response as an .xlsx file.

To learn more about Export Attribute Hierarchy parameters and examples, click here.


Planful AI Analyst: Threshold-Based Filtering

With this release, users can automatically filter data based on user-defined thresholds (for example, variances greater than 10%). This enhancement enables users to focus their analysis on material changes and outliers, while ignoring less significant data points.

By streamline reviews and highlight only what is most impactful, threshold-based filtering streamlines reviews and supports faster, more informed decision-making.

Sample Natural Language Queries:

  • Which expenses are more than 500K?

  • Which departments spent more than 10% above the budget?

  • Which product's revenues increased by more than 15% compared to last quarter?

Note:

Supported Query Categories:

  • Get Data

  • Scenario Variance

  • Time Variance


Predict: Forecasting with Limited Historical Data

With this release, we have supported forecasting with as few as 2 months of historical data, reduced from the previous minimum of 24 months (2 years).

This enhancement is especially valuable for newly created GLs or business segments with limited data history, enabling teams to start leveraging AI-powered forecasts earlier in the data lifecycle.

  • Minimum Requirement: 2 historical data points (2 months).

  • Admin Control: Admins can toggle this option in General Settings.

  • Accuracy Warning: A notification will display when configuring predictions with less than three years of history, advising that forecast accuracy may be lower.


Predict: New Multi-Year Graph View for signals and Trend Analysis in Dynamic Report

With this release, we have introduced a multi-year graph drop-down for signals and Trend Analysis in Dynamic Report that allows users to visualize historical and forecasted data over multiple years, greatly expanding on the previously available single-year view. It provides a holistic perspective on trends and seasonality across years, enabling data-driven decision-making at both the GL and category levels.

Users can switch between views from the new Graph View dropdown

  • View Options:

    • Single Year View: Displays one year (12 months) at a time.

    • Multi-Year View: Displays full history and projections over multiple years.

  • Zoom Capabilities: Users can zoom into specific periods in the multi-year view

Applicable To:

  • Trend Analysis

  • Signal Context

  • Signals Overview

Notes:

  • This feature is already available for Projection Templates.

  • The data grid now updates based on the selected year in both Single-Year and Multi-Year views. The Multi-Year graph remains fixed, while the grid reflects the chosen year. In Single-Year View, users must switch years to update both graph and grid.


Predict: Introduced Algorithm Mode in Templates

Explore the new Algorithm Mode in Predict to compare accuracy metrics, toggle projections, and even upload custom models for tailored planning.

Read More…

With this release, we have introduced an Algorithm Mode to enhance AI-generated projection capabilities in planning templates. Users can select from a list of algorithms, each accompanied by accuracy metrics, allowing them to pick the most suitable algorithm for their needs. They can also compare the outputs of different algorithms graphically by toggling them on or off.

Notes:

  • A minimum of 4 years of historical data is required to view the Algorithm Mode.

  • The types of algorithms supported in Algorithm Mode are:

    • ETS (Auto) : Automatically selects the best exponential smoothing model to capture trends and seasonality in time series data.

    • XGBoost: A gradient-boosted decision tree algorithm optimized for speed and accuracy, handling complex nonlinear relationships.

    • RandomForest: An ensemble of decision trees that averages multiple predictions to reduce overfitting and improve accuracy.

    • Seasonal Naive: Predicts future values by repeating the last observed seasonal pattern without adjustments.

    • Theta: A statistical method that combines simple extrapolation and smoothing for robust, accurate forecasts.

    • Regression: Uses lagged values of the historical data as predictors to estimate future points.

How to Configure an Algorithm Mode

  1. Navigate to Maintenance > Configuration Tasks > Planful: Predict.

  2. From the Projections Configuration section, toggle on Enable Algorithm Mode.

How to View the Algorithm Mode

  1. Navigate to Structured Planning.

  2. Select the desired Budget Entity and Template.

  3. Right-click on a cell and select Predict Projections > Algorithm Mode.

    Algorithm Mode can also be accessed via Predict > Algorithm Mode from the top toolbar.

    The Algorithms screen displays.

You can access the following actions:

  • Algorithm Mode with Accuracy Scores: A selection of algorithms each accompanied by accuracy metrics will be available, allowing users to pick and choose the most suitable model for their data.

  • Graphical Output Comparison: Users can compare outputs visually by toggling multiple algorithms on and off within the template, making it easy to evaluate and validate results.

  1. Select the desired algorithm and click Update Template to apply the algorithm.


Workforce Planning: Introduced the Ability to Map or Unmap Employee Types when Managing Compensation Items

With this release, users can now map or unmap compensation items to Employee Types directly when adding or editing the Compensation Items, without needing to navigate to the Employee Type tab. This improvement streamlines the process of assigning compensation, making it faster and more intuitive. To learn more about the Employee Type tab, click here.

When creating or editing a compensation item, users will now see an Employee Type dropdown that allows selection of one or more Employee Types. To learn more about creating or editing a compensation item, click here.

Note:

The Employee Type dropdown is optional, and users can still save the compensation without selecting a type.

Additionally, mappings made in the Add/Edit Compensation Item screens are automatically synced with the Employee Type screen and vice versa. This ensures both views remain up to date without additional manual effort.
This enhancement improves efficiency and reduces friction when managing compensation configurations in Workforce Planning.

Other Important Notes

  • When copying a compensation item, Employee Type mappings from the original compensation item are not retained. These mappings must be selected manually for the new compensation item if needed. All other compensation details will be copied as-is without changes.

  • When adding or editing the compensation items, only one wage-type compensation can be mapped to an Employee Type at a time. Also, you cannot remove an Employee Type from a wage-type compensation item if that removal would leave the Employee Type with no wage-type compensation mapped.

  • When a scenario is locked, or an entity/template is forwarded, or the user has no access to the Entity, users can still map new or updated compensation items from the Compensation screen. However, associated employees will be marked as Unprocessed, and changes will not reflect until the scenario is unlocked or access is restored. This allows partial setup flexibility, but no data push or processing will occur under these restricted conditions.

  • When a new compensation item is created with Employee Type selection, it will be automatically added to all existing employees belonging to that Employee Type — including those with a status of Terminated, Promoted, or Transfer-Out.

    So these employees will be marked as Unprocessed, and must be manually reviewed or reprocessed if needed.


Workforce Pro: New Agg() Function for Rolling Commission Calculations in Custom Compensation

With this release, a new function Agg(Input, TrailingMonths, OffsetMonths) has been added to the Custom Compensation feature to support dynamic rolling aggregations across monthly windows. To learn more about Custom Compensation, click here.

This function enables users to calculate trailing or forecasted values such as commissions, bonuses, or quota achievements using flexible, scalable syntax. It operates at the employee level and supports aggregation across fiscal years and offset periods.

Key Features

  • Accepts Compensation Items (e.g., Comp[Commission]) and Integer-based By Period Attributes (e.g., Attr[Target]).

  • Supports trailing month windows and offsetting (forward or backward) from the current period.

  • Handles missing months by defaulting values to 0—no errors are thrown.

  • Enables cross-fiscal year aggregation logic.

Function Syntax

Agg(Input, TrailingMonths, OffsetMonths)

Argument

Description

Input

A numeric source such as a Compensation Item or By Period Attribute.

TrailingMonths

Number of months to aggregate backward. Must be an integer ≥ 1.

OffsetMonths

Shifts the end of the aggregation window forward or backward relative to the current period. Must be a valid integer - can be negative, zero, or positive.

Examples

Function

Current Month

Aggregation Period

Agg(Commission, 6, 0)

Jun 2025

Jan–Jun 2025

Agg(Commission, 6, -1)

Jun 2025

Dec 2024–May 2025

Agg(Commission, 12, -6)

Jun 2025

Jan–Dec 2024

Agg(ForecastedBookings, 6, 12)

Jun 2025

Jan–Jun 2026

Use Cases:

  • Trailing 6-month commissions

  • Prior-year quota achievements

  • Future-dated forecast aggregations


Was this article helpful?