OneStream Adapter & Business Rules Change Log

This page contains a change log of CXO’s OneStream Adapter and Business Rules as a curated, chronologically ordered list of notable changes for each version. The format is based on Keep a Changelog.

Note: While following numbering syntax, the release versioning does not adhere to Semantic Versioning rules.

OneStream Business Rules 25.1.0

Date: April 7, 2025

Added

• Implement Fast Data Extract

• Documentation Data export using FDX

OneStream Adapter 24.4.0

Date: February 24, 2025

Added

• Possibility of doing custom transformation of data before cube processing

  • Requires minimum version of CXO 24.4.1

OneStream Adapter 24.3.0

Date: November 28, 2024

Added

• Updated to .net 8 (pre-requisite for OneStream Adapter installation ) and updated the installer

OneStream Adapter 23.4.0

Date: March 25, 2024

Added

• Resolved incremental metadata load issue when two or more leaf members with different parents are added in the same dimension.

OneStream Adapter 23.3.1.33523

Date: 29-11-2023

Added

• Increased OS adapter max request size

OneStream Adapter 23.3.0.32587

Date: 13-10-2023

Fixed

• Standalone metadata refresh removing existing loaded data

OneStream Adapter 23.2.23195.02

Date: 18-07-2023

Added

• Standalone metadata refresh for update members and Scheduled Extractions

OneStream Adapter 23.2.23186.1

Date: 05-07-2023

Added

• Standalone metadata refresh for add and delete members

OneStream Adapter 22.4.23003.1

Date: 17-01-2023

Changed

• Update application to .NET 6

Install steps

• Open CXO Server Configuration - Maintenance

  • Stop CXO OneStream IIS application pool

  • Stop OneStream Adapter Processing Service

• Open Add or Remove Programs

  • Uninstall .Net Core 2.0 hosting bundle

  • Important: Do this before installing the .NET 6 hosting bundle

• Download the .NET 6 hosting bundle and install it on the server

  • Download .NET 6.0 (Linux, macOS, and Windows)

• Execute the CXO.Adapter.OneStream.msi installer

• For test servers that do not have an SSL certificate set up to communicate with the database

• All connection strings need to have encryption manually disabled now

• Note: This was set to false by default in previous versions so it is the situation before the upgrade. It is now set to true by default Introduction to Microsoft.Data.SqlClient namespace - ADO.NET Provider for SQL Server

• Add the following at the end of the connection string: ;Encrypt=False

• Connection strings can be found in the following files

  • <Path to Adapter>\Web API\appsettings.json

  • <Path to Adapter>\Processing Service\appsettings.json

• In the database the changes need to be done in the following tables

  • In dbo.application_variables table, av_value for av_name = ‘OneStream Adapter: Configuration Connection String’

  • In dbo.applications for all entries in connection_string column

• Start the services again in CXO Server Configuration

• Verify install

  • Open IIS and click browse to the Onestream website

    • Browser should show 404 but not a 500 error

    • If log level is set to information in appsettings.json then the logs will show “Checking if there are any pending database migrations“ (can be temporarily set to information to check this)

• Open Windows Services

  • Check that CXO OneStream Adapter Processing Service is running

  • Logs can also be set to info to see a message saying “Checking for pending tasks started” every minute

Note: Using versions prior to ASP.NET | Open-source web framework for .NET Core Runtime 6.0, can cause problems with the processing service.