CPM Express IFRS Release PV9.3.0 SV2.0.0

The theme for this Major release is an IFRS compliant application for consolidation, planning, and reporting - delivered through a productized approach that accelerates time-to-value and ensures predictable, scalable outcomes.

Highlights

  • This latest release makes the Cash Flow IFRS 18 compliant and standardizes how foreign-currency overrides and historical data are handled, with new override flows, a historical data load, and a dedicated CTH flow. It also brings the Equity Control Center and the consolidation dashboard into the Workflow and Genesis. Rationalization of workspaces, cube views, and business rules makes the application easier to maintain.

New Features

  • Standardized FX Overrides: Adds a consistent approach for overriding translated balances with a new CTH flow (Translation adjustment - Historical), end-balance override flows grouped under an "Overrides" parent, and an Override cube view and form template for manual entry. (SN8-2553, SN8-2556)

  • Historical Data Load: New data sources, transformation rules, and a dedicated Workflow Profile step in StatutoryReporting_ACT for loading historical data. Formula pass orders are adjusted to support the new flow. (SN8-2555, SN8=2554, SN8-2558, SN8-2569)

  • IFRS 18 Ready Cash Flow: Cash Flow metadata in UD6 and the cash flow mappings now follow IFRS 18, with a new parent member for the Net Result check and Net Result cube views added to the CFS report dashboard. (SN8-2392, SN8-2393, SN8-2866, SN8-2874)

  • New Cash Flow Report in Guided Reporting: A new report that can show both the new and the previous version of Cash Flow. (SN8-2435)

  • Equity Control Center (ECC): Central Engine enhancements, support for batch calculation across multiple entity scopes, and additional calculation cases. (SN8-1316, SN8-1320, SN8-2179)

  • Ownership Import Step: New import step in the Admin Workflow Profile to import ownership data directly from a flat file. (SN8-2394)

  • Consolidation Logger Without Global Flag: Consolidation logging no longer relies on a global flag. A Data Management sequence starts the consolidation and passes parameters instead, removing the risk of a literal parameter staying edited after a failed consolidation. (SN8-1969, SN8-2286)

  • Planning Framework Sample Setup: New Entity and UD1 dimensions using flipped dimension usage, additional FinPlan cubes and planning Workflow Profiles aligned with CPM Express GAAP, giving partners a sample to build from. (SN8-2033, SN8-2516, SN8-2518, SN8-2519)

Enhancements

  • Consolidation Dashboard in Workflow and Genesis: The consolidation dashboard is now available from Workflow and from Genesis. (SN8-1591)

  • Data Movement Tool: Business-rule-based copy aligned with the IFRS consolidation logic. (SN8-2030)

  • Report Formatting: Different formats can now be applied to totals when D_ formatting is used on a "(tree) descendants" member extender, and the formatting parameters of reporting cube views are cleaned up. (SN8-1152, SN8-1153)

  • Forms Manager: Previous-year columns are now blocked for input in Forms Manager cube views, and Calc on Save also runs after the quick Intercompany input is saved. (SN8-2403, SN8-2485)

  • Non-controlling Interest Label: "Minorities" is replaced by "Non-controlling Interest" in English account descriptions. (SN8-1810)

  • Data Access Rule on 261EQUI: Input is now prevented by default on 261EQUI, as the account is generated by the system during consolidation. (SN8-1974)

  • Central Member Formulas: The scenario Actual member formula was moved to the central CXI_memberformula, and member formulas were migrated from members to standard business rules. (SN8-247, SN8-1521)

  • Workflow Review: The main financial statement container is now inside the Workflow Review workspace. Legacy business rules were migrated into it, and the remaining Confirmation Rule dashboard was renamed to reflect that it is now a manager. (SN8-2512, SN8-2769, SN8-2805, SN8-2806)

  • Closing Flow Drill Down: The drill down for Flow member F#CLO now includes only F#OPE and F#TMVT. (SN8-2571)

  • Genesis Links: The Solution Exchange and Community pages in Genesis point to the new addresses. (SN8-2515)

  • Setup Page: The setup page was updated for the latest version of Cloud Administration Tools. (SN8-2665)

Fixed Issues

  • MVT Flow Not Generated by Consolidation Hub: Fixed the MVT flow not being generated when a scenario created in the Consolidation Hub was copied and consolidated. (SN8-2186)

  • Confirmation Thresholds Rounding: Thresholds are now handled as decimals instead of integers, resolving rounding issues in confirmation rules. (SN8-2321)

  • Old Dashboard References in Workflow Profile Templates: The Corporate Actuals and Location Actuals templates now point to the current dashboards. (SN8-2529)

  • Incorrect Workspace and Dashboard References: Corrected workspace and dashboard references in existing Workflow Profiles and Workflow Profile templates. (SN8-2513)

  • Empty Cube View Profile: Resolved a cube view profile for Reports_Import_WF that was empty but was attached to several Workflow Profiles and templates. (SN8-2732)

  • Import Workflow Drill-Down POV: The cube view in the last step of the Import workflow no longer takes the F# members from the Cube POV. (SN8-2484)

  • Compile Errors in Drill Down Formulas: Fixed two compile errors in the drill down member formulas for OCI2210 and K_CTR. (SN8-2740)

  • Intercompany Matching Report Currency Symbol: Removed the $ symbol shown in the BI Viewer based Intercompany Matching report. (SN8-2482)

  • Form_Flash Cube View: Corrected the CF Form_Flash cube view. (SN8-2853)

  • File Explorer Manager Logout: Opening the File Explorer Manager workspace no longer logs you out of the platform. The dashboard type of 0_Frame_FEM_OnePlace is now Embedded Top Level. (SN8-2847)

Deprecation

  • Text1 property removed from the Entity dimension, and its mentions removed from the Admin Guide. (SN8-2175)

  • Unused business rules, workspaces, Workflow Profile templates, cube views, and Data Management jobs removed after two review rounds. (SN8-2318, SN8-2528)

  • Duplicate Confirmation Rule dashboard under Default removed. (SN8-1769)

  • Cash Flow cube views removed from the Default section. The workspace versions remain. (SN8-2045, SN8-2865)

  • Legacy business rules WCR_HelperQueries, WCR_SolutionHelper, and WFR_ParamHelper replaced by the Workflow Review workspace. (SN8-2769, SN8-2805)

Compatibility

  • The OneStream Software platform version 9.3.0 or later is required.

Documentation

  • Updated:

    • CPM Express IFRS Configuration Guide (cube view formatting, UD5 and UD8 corrections, OCI content)

    • CPM Express IFRS Admin Guide (Text1 property removal)

    • Consolidation Helper (CHP) Logger documentation

  • Created:

    • Cube View Formatting documentation

    • Genesis: Tips & Tricks and Color-Coding Edit Guide

    • Documentation of the override additions

    • Documentation of the planning changes (cubes, dimensions, and Workflow Profiles)

Known Issues

Browser and Genesis Behavior

  • Consolidation Hub: In the browser, the Copy menu does not close after the Data Management job completes. This also happens in the Copy Ownership and Data Seeding tabs. (SN8-3261)

  • CPM Express Setup: In the browser, the Execute menu does not close after the Data Management job completes when the setup is run from Genesis. (SN8-3271)

  • Workflow Review: The Refresh Confirmation Rule button image is not displayed in the browser. (SN8-3259)

  • Genesis:

    • The Spreadsheet links do not work in the browser. (SN8-3262)

    • The landing page can show an error the first time it is opened. The error does not recur after selecting the Home button. (SN8-960)

Workflow Review and Confirmation Rule Manager

  • Data Entry Analysis: ICP is not captured in the WFR report, in either the browser or the Windows application. (SN8-3260)

Consolidation and Cash Flow

  • Cash Flow: The Cash Flow solution returns an error on a weekly scenario. (SN8-1043)

Consolidation

  • The Proportional method does not work as expected. The previous-year consolidation percentage is not taken into account when an entity was not consolidation, but is tagged as a partner. (SN8-1308)

Consolidation Hub

  • Not all journal data are copied. Journals posted on a different consolidation member than C#local do not get copied. This is linked to a known issue linked to hybrid scenario. (PF-38724)

Contact Support

Contact OneStream Support by registering at:

Support - OneStream Software

CPM Express IFRS Release PV9.3.0 SV1.0.1

The theme for this Hotfix release is an IFRS compliant application for consolidation, planning, and reporting - delivered through a productized approach that accelerates time-to-value and ensures predictable, scalable outcomes.

Highlights

This latest release delivers greater transparency and control for finance teams, introducing the Consolidation Helper for clear audit trails into elimination and consolidation entries, a detailed documentation around the consolidation engine, an enhanced Consolidation Hub to handle proforma and what-if, Intercompany Matching at the transaction currency level, along with reporting, performance, and usability enhancements.

New Features

  • Consolidation Helper: Provides a debit/credit log of consolidation entries, increasing transparency and auditability.

  • Consolidation Hub: Enhanced user experience for ownership copy, proforma, and constant currency scenarios. Enables flexible management of ownership structures and scenario creation.

  • Confirmation Rule Manager: No/low code builder for confirmation rules, with new rule types and extended edit capabilities.

  • Intercompany Matching at Transaction Currency: Allows matching at the transaction currency level, improving reconciliation and FX impact analysis.

  • Data Movement Tool (DMT) Solution: Solution intended to pivot and facilitate data movement between cubes either through Data Management Export Sequences or Dynamic Scenarios populated through a Business Rule.

  • Periodic Translation: CPM Express IFRS’s consolidation engine now natively supports periodic translation.

Enhancements

  • Genesis Improvements: Upgraded Genesis blocks for better integration and usability.

  • Enhanced Reports: Improved statement of change in equity, OCI reports, and other analytics.

  • Constant Currency "Fixed Period" type: Added support for fixed-period constant currency rates, giving users more flexibility when configuring translation rate overrides.

  • Tax Confirmation Rules converted to Confirmation Rule Manager: Migrated tax confirmation rules to the Confirmation rule Manager, consolidating all confirmation logic into a single unified rule.

  • Narrative Reporting added as optional solution: Narrative Reporting is now available as an optional solution on the CPM Express Setup Page.

  • Planning: Updated the Planning Framework solution UI and enhanced modeling capabilities.

  • Summary Flows Form Template Enhanced: Form template for Summary Flows now shows Opening + total movements + FX impacts + Closing balance + Check flow(SN8-2287).

Fixed Issues

  • Cash Flow Yearly Scenario Error: Resolved an error that occurred when running the cash flow solution on a yearly scenario.

  • Ownership Rollup Using Incorrect Dimension: Fixed the Sub AcctParameter to use the FinRPT Dimension PK instead of api.pov.DimPK when rolling up ownership information (% Own, % Con, Method).

  • Parent Parameter Showing Limited Entities: Corrected the parent parameter to display all parent entities across cubes rather than only POV cube-specific parents.

  • Missing Confirmation Rule: Added the missing G00_001_ClosingBalanceImport confirmation rule for balance sheet closing balance validation to the Confirmation Rule Manager.

  • Consolidation Failure at Varying Subconsolidation Depths: Fixed consolidation not working in specific cases involving subconsolidations with different levels of depth.

  • DOPE/ROPE DFIN/RFIN Flow’s Descriptions Update: Updated descriptions on DOPE/ROPE DFIN/RFIN members to reflect broader usage beyond depreciation (e.g., increase in provisions).

  • WFR Data Entry Performance: Improved performance and resolved hanging issues in WFR (Workflow Review) Data Entry by optimizing the SQL query for audit cell retrieval.

  • OwnerPostAdj Not included on ResEx Accounts: Fixed OwnerPostAdj not being taken into account by the flow appropriation on ResEx accounts.

  • Constant Currency Calculation: Fixed issues with the constant currency calculation logic.

  • Scope IN/OUT Specific Rates Not Applied: Fixed scope-specific rates not being applied during translation due to api.pov.parent not being passed, and corrected the CubeView to pull UD2 currency based on the selected parent.

  • Cons Parameter Issue: Resolved an issue with the consolidation parameter selection.

  • Data Access Security Misalignment Between Cubes: Aligned Data Access / Sliced Security categories between StatutoryDetail and StatutoryReporting cubes, standardizing category names and removing redundant entries.

  • Corrected Hybrid Scenario Copy Functionality: Consolidation Hub – Issue with data copy in the balance sheet - Flows F#ERR and F#MVT now excluded from the "DataBinding Member Filters To Exclude” to ensure correct data copy. (SN8-2221)

  • Multiple Cube Consolidations Required: When updating the ownership information from the central setting cubes, consolidation needs to be run twice to populate data at parent level. The issue was linked to a wrong configuration on the CentralSettings Cube (SN8-2358)

Deprecation

  • Task Manager removed from Genesis Landing Page.

  • Legacy Cash Flow members removed from UD5.

Compatibility

  • The OneStream Software platform version 9.3.0 or later is required.

Documentation

  • Updated:

    • CPM Express IFRS Template Design Guide

    • CPM Express IFRS Template Admin Guide

    • CPM Express IFRS Configuration Guide

    • In-App Documentation

  • Created:

    • Consolidation Helper (CHP) Documentation

    • Consolidation Hub User Guide

    • Consolidation Engine Guide

    • Intercompany Matching at Transaction Currency (ICT) Guide

Known Issue

  • Consolidation Hub: Not all journal data are copied; journals posted on a different consolidation member than C#local do not get copied. This is linked to a known issue linked to hybrid scenario. (PF-38724)

  • Confirmation Rules: Translated threshold below 0.5 gets rounded to 0. (SN8-2321)

  • Platform 9.4 compatibility: For users on OneStream Platform Version 9.4, review the following notes and perform the steps below:

    • Customers must update the cube StorageType in the AppZip: Metadata.xml:

      • Before: <property name="StorageType" value="DataRecordAndBinaryData" />

      • After: <property name="StorageType" value="VariableLengthWidthDataRecord" />

    • Perform the steps below to upgrade OFC to be compatible with CPM Express IFRS and Platform v9.4

      • After importing the solution package, delete the workspace OneStream Financial Close.

      • If the solution is required for the implementation, import the latest version of OneStream Financial Close from the Solution Exchange and run the setup page from the Financial Close Setup Dashboard, rather than the CPM Express Setup Dashboard.

    • Perform the steps below to fix the File Explorer Manager to be compatible with CPM Express IFRS and Platform v9.4.

      • Issue: File Explorer Manager dashboard frame is incompatible with the platform version.

      • Fix: As a workaround, set the Dashboard Type of the 0_Frame_FEM_OnePlace dashboard to "Embedded Top Level."

    • Please note, Intercompany Matching at Transaction Currency is not supported on Platform v9.4 of CPM Express IFRS.