OneStream Community

MarcR · 06-18-2024

Hi Guys, I'm at a project where we use Data Cell Detail, we have created classifications and added 2 lines of test data. I can find the data via a data adapter Method query: But now i want to add it via a BRApi, i've found a post here but what ever I...

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 · 06-19-2024

Thanks @FredLucas, that was exactly what i needed. I hadn't figured out the DataCellDisplayOptions. Have a great day!

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

OneStream Community

User Statistics

User Activity

Report on Data Cell Detail using UD8 dynamic calc (DataCellDetail)

Obsolete functions

Data Audit

CubeView - Switch IC and Entity

A Review of Selected Admin Solutions in OneStream

Re: Report on Data Cell Detail using UD8 dynamic calc (DataCellDetail)

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