SSAS: restore last good cube on failed processing
Posted on 2013-02-05
I have a cube that I process every day. I do this daily because transaction data is added and reference data is changed (new/modified products etc.).
First question - it IS right to process the dimensions and the cube daily isn't?
Sometimes, users enter bad data (we are still working on better validation) which causes the processing to fail rendering the cube useless to the regular users.
Main question - is there a method to and a backup for rollback if the processing fails? Data 48hrs is better than no data.