Skip to main content
J
JakeBrown
Newcomer
October 26, 2022

Data Loads

  • October 26, 2022
  • 2 replies
  • 0 views

Hi 

We are getting the following error message on a new data source load

' Detail Cache summarization did not produce any Summary Data Rows.'

Can anyone share any light on what this might indicate?

2 replies

E
OneStream Employee
EricOsmanskiOneStream Employee
OneStream Employee
October 26, 2022

This is a new message beginning in 7.1. It results when all of the source records are mapped to Bypass because the system is no longer generating summary rows for those mapped to Bypass. The workaround is to set the Is Optional Data Load workflow setting to True which allows the user to complete their workflow when the import fails, without needing to complete the Import-Validate-Load steps. Another workaround would be to change your transformation rules to map the data to a dummy member you could create outside of your reporting hierarchies.

    K
    kenostrovsky
    Newcomer
    January 4, 2023

    Thank you for the explanation. This really helped. Would it be possible to attach your explanation to the error message that pops up in OneStream?

    O
    OneStream Employee
    OSEmployee1007OneStream Employee
    OneStream Employee
    December 21, 2022

    Hello, I encountered the same message. Thanks for the answer, the second workaround worked, it disappeared after I mapped the members in the One to One mapping. I am unsure that changing the property Is Optional Data Load to True helped much in my case. I realized afterward that I had a Bypass rule bypassing all the rows of the set of data. 

    Terms & ConditionsAccessibility statement