Posts

How to perform workflow clear in OneStream ?

Recently we wanted to run a  "clear Import Data" from the WF, but it was clearing the data of the same entity from other WFs that was loaded . One of the things we tried was to  "CLEAR" the workflow, and it clears the data that is in the stage tables. If you want to clear the data in the cube, first clear the workflow and then click retransform, then validate and load.   This will Load nothing into the cube but clear the data that is in the cube.

OneStream V8+ upgrade and things to know about .NET

  .NET is the development platform used by OneStream to build the Platform.  Prior to Platform v8.0, OneStream used versions of .NET referred to as   .NET Framework   versions.  The v7.x Platform release used .NET 4.8.   The development of Platform v8.0 used .NET6, referred to as a . NET Core  version.  The .NET Core versions leverage modern development paradigms and are  much faster!   OneStream customers upgrading to Platform v8+ are observing performance improvements in memory intensive operations such as Consolidation processing, and several data loading / copying processes.   The modern paradigms of .NET Core had an impact on OneStream Business Rule compilation - older syntax and library references that were not .NET Core compatible failed compilation.  This required some minor updates to MP Solutions and customer created Business Rules.  No sweat - a one time adjustment with your pre-v8 to v8+ Platform upgrade. OneStream plans to follow Microsoft's Long Term Support (LTS) rel

OneStream performance load testing tool for Desktop/Cloud application

Marketplace solution called load test suite and  System Diagnostics helps to monitor the health of the system.  The load test tool can help to generate multiple user activity on the One Stream cloud application.  The OSD (OS System Diagnostics) provide all the statistics about your application & infrastructure. Especially on DUCS and provide few recommendations on Member formula.  

OneStream migrating from on-premise to cloud - Recommendations

Depending on your application configuration and how much data are you trying to validate for historical purpose. The below are some steps required before the post migration to cloud: 1. If you are using Direct Connect then SIC should be configured. 2. Upgrade OS Marketplace solutions if any 3. Update to latest .NET Version. 4. Update to latest Excel Add-in 

OneStream and Excel addin reading an XFGetCell parameter values

Image
If you have a large Excel report built on XFGetCells, and trying to understand the dimensions that each XFGetCell is grabbing, it can take a long time to parse through an XFGetCell manually and make notes of each relevant dimension.  Open your Excel Addin. Go to  your XFGetCell, see below pic. By clicking on the fx, we can identify which dimension each member is related to. It will bring up this interface.  

OneStream Excel Addin and Formulas

How to keep Excel formulas intact, when refreshing Quick view with new PoV ? In the Quick View settings, at the top are two settings:  "Insert or Delete Rows (Columns) When Resizing Cube View content" Try turning both to "False"

Exporting data automatically to other systems, outside of OneStream

Image
Trying to automate a data extract process to send data from OneStream to another system eg ERP, Trintech, Anaplan etc.  Setup a data management job to export the data to a CSV on the file share.  Move that CSV file from the file share to my desktop for example (or any other file storage place).  You can use OneStream Business rule such as the Fdx functions within BRAPI, they are creating a data table object and they are retrieving the data very fast, they are all starting with BRApi.Import.Data.Fdx<Something> Screen shot below.