<div>
How about backing cube before you reprocess it? Then in event of process failure perform a cube restore.
</div>


How about backing cube before you reprocess it? Then in event of process failure perform a cube restore.

<div>
It appears that in most cases that the cube does indeed rollback. I am unable to recreate the errors that led to the issue. It is something I will have to moniter. Should it occur again I will post a new question. Thanks for your help.
</div>


It appears that in most cases that the cube does indeed rollback. I am unable to recreate the errors that led to the issue. It is something I will have to moniter. Should it occur again I will post a new question. Thanks for your help.

<div>
dear user,<br />
Let us know the solution you found for your issue.<br />
regards,<br />
pedro
</div>


dear user,
Let us know the solution you found for your issue.
regards,
pedro

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am using a SSIS package to repoluate my data warehouse &amp;&nbsp;then re-process a cube. If a problem with the data causes the processing to fail then users who access the cube via Panarama views are left with nothing. I want to be able to rollback the cube so they can still view the old data. Any help would be great.<br />
<br />
Regards
</div>
</div>


Hello,

I am using a SSIS package to repoluate my data warehouse & then re-process a cube. If a problem with the data causes the processing to fail then users who access the cube via Panarama views are left with nothing. I want to be able to rollback the cube so they can still view the old data. Any help would be great.

Regards

Cube failure rollback

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.