Forum Discussion

JakeBrown's avatar
JakeBrown
New Contributor
3 years ago

Data Loads

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?

Data Sources
Import
  • EricOsmanski's avatar
    EricOsmanski
    Valued Contributor
    3 years ago

    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.

    • kenostrovsky's avatar
      kenostrovsky
      New Contributor III
      2 years ago

      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?

  • OSEmployee1007's avatar
    OSEmployee1007
    New Contributor III
    3 years ago

    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.