OneStream Community

NAS

Hi, I am loading periodic data and in some periods there are derived amounts (due to no periodic data for some periods). The YTD values appear as derived data. However, the parent entity isn't rolling up correctly because the parent is not including ...

NAS · 02-28-2023

Hi, AllWhat's the best way to ensure a specific tree within the account hierarchy has only one member within it. Would like to have a "count greater than one" alert or a report we can run, as inadvertent accounts affect data integrity.TIA!

NAS

Thanks so much, Marcus! In light of the need to create a lot of zeros, I am exploring either stage or possibly a BI Blend solution which (hopefully) will eliminate the need to store zeros. I appreciate your input.

NAS · 03-03-2023

Thanks! I would love the BR option, but I may be able to come up with that myself. I wanted to see if there were any other options before going down that road, but sounds like there's not too many other than what you described. I will give it a try w...

NAS · 03-01-2023

Hi, Nicholas! Yes, I do mean base member, not parents, although I wouldn't mind including them as well. For example, in a net income hierarchy, you would not want a rent expense base member to appear more than once or you would be double counting it....

OneStream Community

User Statistics

User Activity

Change derived data to stored

Hierarchy validation

Re: Change derived data to stored

Re: Hierarchy validation

Re: Hierarchy validation