OneStream Community

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

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 · 11-10-2021

The items below detail the specific list of tasks that are executed for each data unit during the calculation process.Data Unit Calculation Sequence (DUCS)Clear previously calculated data If Using Hybrid Scenarios - the copy will run hereRun Scenario...

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

PFugereCSO · 02-25-2022

Hi Christy, As for zeros source, I would be just taking an educated guess. But you are right to want to explore that. Some people find the No-Data for zero settings create a situation where they feel they have to load zeros. Ive been guilty of this t...

OneStream Community

User Statistics

User Activity

NoData in a Data Buffer

Rules Formatting - Please Format Your Rules!!

What is a Consolidation Method?

Equity Pick in OneStream

Calculation Sequence of a Single Data Unit:

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

Re: Does the "In Use" tag impact Data Unit Size?