Data Loads

New Contributor


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?


Valued Contributor

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.

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?

New Contributor III

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.