Solved

SSAS: restore last good cube on failed processing

Posted on 2013-02-05
1
991 Views
Last Modified: 2016-02-18
Hi all,

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.

Thanks,

Warren
0
Comment
Question by:PharmAll
1 Comment
 
LVL 6

Accepted Solution

by:
liija earned 500 total points
ID: 38858258
Hi,

If your data comes daily - it is natural to process both your dimensions and cubes daily. Yes.

Most of my own cubes are on top of data warehouses. ETL takes care of data quality - each fact row has corresponding row in the dimension. Depending on the fact the 'bad' row has value 0 (missing) or is neglected totally and written to the error table during ETL.

Cube backup and restore you'll find in SQL Management studio when you connect to SSAS. Right click your SSAS database - if you want to do it manually.

Backups can also be automated. See:
http://blogs.msdn.com/b/as_emea/archive/2012/02/14/ssas-2008-automating-analysis-services-backup.aspx
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now