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?
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
