Category Archives: SSAS

Deploying and processing SSAS cubes

In SSAS we build what’s known as a UDM, or Unified Dimensional Model, over the top of a database schema, usually a data warehouse. The UDM consists of several objects designed to aid analysis of the data. The UDM is … Continue reading

Posted in SSAS | 3 Comments

Restores in SQL Server Analysis Services

“You’re only as good as your last restore” I’ve no idea who originally said that – but it probably qualifies as DBA folklore. I blogged recently about backups in SSAS so to close the loop here are the basics of … Continue reading

Posted in Disaster Recovery, SSAS | 1 Comment

Backups in SQL Server Analysis Services

Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics. Using the GUI: Connect to the SSAS service in SQL Server management studio. Right click on the database and select backup. The … Continue reading

Posted in Disaster Recovery, SSAS | 2 Comments