SQL Server Performance

Processing cubes in a transaction???

Discussion in 'Analysis Services/Data Warehousing' started by jrusnac, Mar 18, 2005.

  1. jrusnac New Member

    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
  2. Raulie New Member

    What storage mode are you using. Cube processing is a transaction when it fails to should roll everything back, that's wierd.

    Raulie
    hp

  3. jrusnac New Member

    I'm using MOLAP

Share This Page