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 · 01-16-2024

Hi LeAnn, this is unfortunately a quite unspecific error that can happen at many places. I would advise to raise a ticket with support so they can have a look with you. Sorry i haven't had this one before so don't have any quick tips.

MarcR · 12-13-2023

Hi Adam, Officially it is not possible. but... If you open the dashboard in Design mode You can see that the combobox is connected to this component: The Combobox is linked to this parameter: And that is linking to a businessrule: Unfortunately that ...

MarcR · 12-13-2023

Never tried before but you could try: Account IN ('123', '456', '789') Or you could try Account = '123' OR Account = '456' OR Account = '789'

MarcR · 12-13-2023

Yes, in the filter option (the Nothing before the 8 parallel count) you can use 'SQL type filters' e.g. Account <> 'COGS_USENG' So not A#xxx.tree but it should get you there. However, if you set a filter that returns no values it will return all. It ...

MarcR · 12-12-2023

Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, "Corporate", "E#Frankfurt", "Local", ScenarioDimHelper.GetIdFromName(si, "Actual"), "S#Actual", "T#2018.base, T#2017.base", "YTD", False, False, Nothing, 8, True) 'Dim dt As Data...

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 Predictive Analytics?

Re: Get multiple time period in FDX

Re: Get multiple time period in FDX

Re: Get multiple time period in FDX