Re: AUTOMERGENovember 25 2016 at 8:45 AM
No score for this post
from IP address 220.127.116.11
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.
- PBCS - Pete on Jan 9, 2017, 7:20 PM