How to process a partitioned cube in multiple threads
Our company is in the retail business, thus, the window for processing cubes is very small during Christmas season (only 4 hours each day).
To speed things up, we have partitioned our cube at monthly level so, potentially, 12 threads can be run simultantsly. However, when I looked at DTS, I am not so sure whether or how it can accomplish that task. Has anyone tried this before or is aware of another third party tool can do the trick?
thx in adcance,
Carl.
multi-threading a DTS package
hi, Bill
Thanks for the reply.
Yes, I am refering to multi-threading in DTS package. I have attempted to set up all 12 partition in a package in parallel (at least it appears so), when executed, it seems each partion is still executed serially. As you suggested, I will post the question to a DTS forum.
Since I got you here, I'd like to ask you a seperate question if I may. I have followed your instruction in a previous artical on integrating Cognos and MS olap. Overall, it was a very smooth operation. However, I wasn't able to find any information on how to tune these two products to achive the optimal result. ie, is there any way to adjsut PTS cache size on PPES server, can it be done through PPES server, how to capture MDX sent from cognos to MS. I hope there is a way to do these things, but just don't know where I could obtain the information. Can you shed some lights on this?
cheers,
carl.