OneStream Community

PFugereCSO · 11-04-2022

Have you ever wondered how the Calculate if No Data setting works? (I did, and Keith Berry helped me out)“Calculate if No Data = False” prevents the execution of rules on “OK,NA” (no data) entity. However, the Calc Status gets changed from “OK,NA” to...

PFugereCSO · 05-18-2022

I was asked today, 'Am I correct to think that Databuffers do not return Null/Blank cells and therefore you don't need to check whether the cellstatus is Not NoData?' The full data unit is in memory and Time is part of that. The system needs it in me...

PFugereCSO · 02-25-2022

General FormattingOne of the most important things you can do to make you rules readable and helpful is to make sure they are properly formatted. There are some simple rules you should always, without exception follow. The rules of good formatting ar...

PFugereCSO · 02-16-2022

Equity Accounting And Methods A consolidation method is just a way to treat an entity during consolidation based on how much of it you own or control. It makes sense, if you only own 10% of an entity, and another entity has an asset recorded for the ...

PFugereCSO · 02-16-2022

Equity pickup (EPU) is a method of reevaluating the investments owned by a holding company allowing the parent to realize changes in equity. This results in the holding company’s balance sheet showing the current value of the corresponding share in t...

PFugereCSO · 09-07-2022

I believe you would need to customize the report to do it, but it can be done.

PFugereCSO · 03-21-2022

One option people do when creating a people planning application is to not put names/titles and salary data all together. Meaning they might just use employee id, or some other information. When that isn't an option, you can create an application tha...

PFugereCSO · 03-08-2022

My first thought is if you used the member filter in the formula you could call all base accounts under IncomeStatement. As an example -api.Data.Calculate(formula, accountFilter, flowFilter, originFilter, icFilter, ud1Filter, ud2Filter, ud3Filter, ud...

PFugereCSO · 03-03-2022

You can add Force Translations in the workflow, as part of the Run Calculate step. And I like this option much better than having the system try and guess based on where data is. The reason is that there are times when no one will enter data and you ...

PFugereCSO · 02-28-2022

The short answer is YES. You can do this with rules, pretty easily. In fact, you don't need to do the whole elimination calculation, you just need to tell the rules where to you want to see the elimination in the hierarchy. Then add this line in your...

OneStream Community

User Statistics

User Activity

Calculate if No Data

NoData in a Data Buffer

Rules Formatting - Please Format Your Rules!!

What is a Consolidation Method?

Equity Pick in OneStream

Re: Journal report for multiple workflows

Re: People planning security

Re: Filter a Dynamic Calculation

Re: Calculation Sequence of a Single Data Unit:

Re: Intercompany Eliminations - not at First Common Parent