TI Process To Copy Data Within Cube

[zodiacviv]

Guys,

Please help me on this:
If a TI Process which is used to copy data within same cube (source and target is same cube) from Vesion 1 to Version 2, since this TI Process is taking too much time to execute, is there any way to modify TI Process so that execution time can be reduced??? I found somewhere that using a text file in TI Process as an intermediate for copying data from Version 1 and then again using same text file as a source for other TI Process to copy to Version 2 and then call these two Process from 3rd TI Process will reduce time as compared to directly coping within cube. Can i go with this method?? Also using textOutput or AsciiOutput function to create intermediate file allows only 8000 bytes max so if this is method to be used how can i use it for Process copying Data more than 8000 bytes???

[jim wood]

Are you excluding the likes of rule calculated and consolidated elements in your data source?

[Duncan P]

If you are copying rule calculated values then using BatchUpdateStart will help by queuing all the updates to be entered at the end, thus avoiding blowing away the calculation cache between cell reads.

[paulsimon]

In you think about it, Cube to Cube is in-memory and therefore it should be faster than cube to file to cube. If it isn't then you are probably doing something wrong.

Ensure that your view excludes zeroes, consolidations and calculated values, then it will work quickly.

If you need to land the results of calculations in the version then set up the view so that it only has base level elements in each dimension, and ensure that you skip zeroes.

Regards

Paul Simon