Re: Clear the data from 40 cubes using single TI process?
Posted: Fri Jul 31, 2009 10:24 am
I'm guessing CellPutProportionalSpread, sending zero. Bit surprised that it would be faster than ViewZeroOut.
Here is a sample of what I did. I used the same view when using ViewZeroOut.
CellPutProportionalSpread(0,'Profit_and_loss_company','Total Group','Net Profit After Interest and Tax','Budget','Total Year','All Companies','2008','
Local Currency');
All it did was spread 0 across the highest consolidator of all the dimensions. I used this code in the Standard demo so if you want to try it first and see what happens go try it. Create a view consisting of the above dimensions in the Profit_and_loss_company cube and paste the code in the Metadata tab in a TI process.
Cheers!