Clear the data from 40 cubes using single TI process?
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Clear the data from 40 cubes using single TI process?
I'm guessing CellPutProportionalSpread, sending zero. Bit surprised that it would be faster than ViewZeroOut.
Re: Clear the data from 40 cubes using single TI process?
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!
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!