Skip to main content
B
Brooks
March 14, 2025

Derived Values Consolidating

  • March 14, 2025
  • 1 reply
  • 1 view

I'm having an issue in which derived YTD values are consolidating in their period and it is throwing off our results.  In the example below which shows expenses by department for a site, there are no longer expenses for the Mfg_Selling dept in M2.  OneStream calculates the derived YTD values of -37905 (0 - the prior period expense of 37905).  This I understand.  What I don't understand is why that value is consolidating up the hierarchy when the view is set to periodic.  NOTE: I know how to hide the derived value in Mfg_Selling/M2, it is shown here for illustrative purposes.

 

1 reply

T
T_Kress
March 14, 2025

This is likely due to a combination of your scenario properties and settings.

This is a good post that should help you understand:  Making sense of the Scenario settings | OneStream Community

To help you solve this, we would need to answer several questions:

  • view of cube view above
  • all the various scenario property settings

 

 

B
BrooksAuthor
March 14, 2025

Thank you. I did read the blog post before submitting, but for a newbie like me, it still left me with some questions.  Is my problem the Retain Next Period setting?  I can also get screenshots of the CV settings, but that will take several replies.

Terms & ConditionsAccessibility statement