OneStream Community

MarcR · 05-17-2022

Hi All, in OneStream 6.x some functions in Business Rules became Obsolete. One of them is the BRApi.Database.GetCustomDataTable where the initial script required a string as CriteriaExpression but now it requires a list of dbWheres. That part I fixed...

MarcR · 03-29-2022

Hi All, In OneStream there are many audit tables containing specific sections that can be audited. I'm looking for a detailed overall data audit showing which user changed which number at what time. Preferably combining loads with (Excel) input. Does...

MarcR · 03-09-2022

Hi all, In a CubeView we want to see selling and buying members in one row. So for Column 1 is sales where the Entity is the selling entity and IC is the retrieving entity. in the same CubeView Column 2 is stock where the Entity is the Buying Entity ...

MarcR · 03-03-2022

1. Log CleanerOneStream provides sophisticated and detailed audit trail capabilities using various types of logging. The logging functionality is distributed over the system and the Log Cleaner MarketPlace solution provides a single interface to mana...

MarcR · 03-02-2022

The XFGetCell function has 20 arguments, when you have a large sheet (e.g. for data validation) there can be many of these functions increasing the size of the excel file. In SmartView it was possible to create 1 cell with commonly used arguments and...

MarcR · 01-03-2023

@mitrad i have never done that but this information must be stored in the tables used with this marketplace solution. Using a data adapter you can easily create a query showing this information. You could start scrolling through the OPS tables and se...

MarcR · 11-07-2022

Hi Marcello, in the SetDataBuffer statement there is an additional option (just enter a , at the end) where you can choose to append the current value. Pretty straight forward once you know where it is 

MarcR · 10-11-2022

Hi Kelley, we just did actually.It is important that the workflow steps are in different workflows (different workflow steps in 1 workflow don’t run in parallel). You also need to make the load ID (the first item of your load file) dynamic.OneStream ...

MarcR · 09-20-2022

Hi Chaka, unfortunately i'm not. If you select the row you can see it in the dashboard so it must be stored. I assume you need to find it in the custom data tables that are created for this solution which you can find in System - Database. So if you ...

MarcR · 09-08-2022

No problem at all.. I don't know exactly how, it might need some customization. But you could try to use the substitution variables for the Global POV: if that doesn't work you need to create your own parameter e.g. via an XFBR rule.

OneStream Community

User Statistics

User Activity

Obsolete functions

Data Audit

CubeView - Switch IC and Entity

OneStream admin solutions

Reducing size of the XFGetCell function

Re: How to set up Parcel Services - Batch reporting

Re: api.Data.SetDataBuffer in increment mode

Re: Direct Connect Loads into OneStream

Re: How to set up Predictive Analytics?

Re: How to set up Parcel Services - Batch reporting