OneStream Community

PFugereCSO · 12-07-2022

Part 3 of 3 - In this series of blogs we discuss the Consolidation and dimensions that drive the power of the cube in OneStream. I first used an Origin dimension with another product, but it was completely custom. OneStream smartly has this prebuilt ...

PFugereCSO · 11-15-2022

Part 2 of 3 - In this series of blogs we discuss the Consolidation and Dimensions that drive the power of the Cube in OneStream. Hey! Where is my data?!?! You explained during the POC. Then it was covered during the ABA training. As you discussed eli...

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

PFugereCSO · 11-02-2022

Part 1 of 3 - In this series of blogs we discuss the Consolidation and dimensions that drive the power of the cube in OneStream I was in a meeting with a large group of consultants years ago. Some were Budget and Forecast guys, others were Consolidat...

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 · 01-09-2023

I don't think so. If they have the rights to enter data, they have rights to remove or clear data values too. This is only a way to clear all cells for a period they are entering.

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

OneStream Community

User Statistics

User Activity

The Origin Dimension

The Consolidation Dimension

Calculate if No Data

Consolidation Vs Aggregation

NoData in a Data Buffer

Re: Clear All Import/Forms Data from Cube

Re: Journal report for multiple workflows

Re: People planning security

Re: Filter a Dynamic Calculation

Re: Calculation Sequence of a Single Data Unit: