This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Re: AUTOMERGE

November 25 2016 at 8:45 AM
No score for this post
DrFosterman 
from IP address 159.53.174.143


Response to Re: AUTOMERGE

What we have seen is, when a cube is aggregated (in our case 10gb +) and has incremental slices with incremental aggregated cells, a send of 300K-500K cells can take betwen 10-20 mins as the automerge kicks in for every line of the send. The way the send is formatted also seems to make a difference as the more columns you have the more data is being sent and automerged (it appears to go line by line)


In testing we found that when we merge all slices into the base and then load the same file through the Excel Add-in, it takes a matter of minutes.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. PBCS - Pete on Jan 9, 2017, 7:20 PM
  2.  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.