CUBE WRITE BACK in SQL SERVER 2008 R2
Did anybody get the SSAS write back functionality to work against a decent sized datawarehouse? I'm not asking about a little demo but a significant sized footprint e.g. 14M Rows measures, 6-8 wired Dimensions with 8-10 attributes each.
I setup a test server using a Dell XEON ( 2x4core) with 48 GB RAM hardware and the latest Sql Server 2008 R2 release. I used the What-If scenario in Excel 2010 and modified a higher level, hoping SSAS would push the values down.
After about 15 minutes and after having used 48 GB memory (on average 5% CPU) Excel throw an error - short on memory - and stopped the action.
I found the same behavior in Sql server 2005 and 2008 and was hoping this would work now but apparently not so.
Here are my questions:
Is anybody using this at all? how can one calculated (roughtly) how much memory is requiered? is there any paper that describes best practise?
Thanks for any help in advance,
View Complete Post