Forum Discussion

tkrekeler's avatar
tkrekeler
New Contributor III
2 years ago

Consolidation slow when after copying from scenario to another

Hello, 

We are currently seeing slow consolidation times after we copy data from one scenario to another. If we run a force consolidation in the source scenario the full year takes around an hour or so. When running the consolidation in the target scenario it is taking 4+ hours to complete. Both scenarios are using the same scenario type.

Anyone have ideas on what could be causing this issue? Seems odd that the same data set would have such huge deviations in run times. This is the second quarter we have seen the issue. 

 

Thanks for your help!

 

Tim

Consolidation
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    Could be a Member Formula on the target Scenario, could be the Hybrid Scenario configuration (if you're using that), could be formulas that are actually Scenario-specific in some way, could be table indexes that need attention...

    You could try working on individual Entity branches, to isolate where the problem might be.

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

      Thanks for the response it doesn't seem to be any of the above as the scenario will force consolidate in about a 1/4 of the time. Its only on that first run following the copy. It's almost like OneStream is performing extra consolidation steps on the initial consolidation. Maybe building out data units records?

      • PeterFu's avatar
        PeterFu
        Contributor II
        2 years ago

        Hi Tim,

         

        If I understand you correctly, you are doing Force Consolidate on the source scenario, but you do a normal Consolidate the first time on the destionation scenario. If that is the case, then I think I make sense that the the normal consolidation takes more time. The difference between the Force Consolidate and Consolidate is that when you do a Force Consolidate, the system will not check the status since it will consolidate everything from the first period, while a Consolidate will check the status of each entity and period. That is why the Force Consolidate will be quicker (given that you actually are consolidating the exact same data in 2 different scenarios). I think this is also describe in the Design and reference Guide. That means how you choose to consolidate your data will have an effect on the consolidation time. I hope this clarifies it.

         

        Peter

  • chul's avatar
    chul
    Contributor III
    2 years ago

    Also ensure that you don't have a member formula on the target scenario as it will run first upon calculation/consolidation.