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 Cleaner OneStream 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 man...

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 · 05-26-2023

Hi Lisa, unfortunately I don’t. If you have a local installation it is the account running the OneStream services that needs access but with a cloud installation (which most of us have) there must be some kind of direct connection. I’m not an it guy ...

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 ...

OneStream Community

User Statistics

User Activity

Obsolete functions

Data Audit

CubeView - Switch IC and Entity

A Review of Selected Admin Solutions in OneStream

Reducing size of the XFGetCell function

Re: How to set up Parcel Services - Batch reporting

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?