Processing cubes in a transaction??? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Processing cubes in a transaction???

Hi All, right now i’m processing the cubes every night and if the process fails for some reason the cubes become unavailable for the end user. Is it possible to roll back to a previous successfull state of a cube in case of a failure? Something like a transaction? I am using a scheduled DTS package to process the cubes every night. A DTS package has a property to use transactions, which i am using but it doesn’t seem to roll back to a initial state when the process fails. Please help,
Thanks in advance
What storage mode are you using. Cube processing is a transaction when it fails to should roll everything back, that’s wierd. Raulie
I’m using MOLAP