SSAS Operations Templates (Free)

Written by Rob Kerr. Posted in SSAS Scripts

SSAS Operations Templates includes SSIS packages, scripts and code samples for automating maintenance of SSAS in a production environment. Includes operations such as backing up current state of cube designs, scripting paritition creation, etc.

"I read that I should script Analysis Servcies partition creation rather than creating years of partitions in advance, but how do I do that?"

"I don't want to backup my cubes completely, but I need to have a complete backup of the designs as they are in production in case I need to restore them for any reason. Is there an easy way to do that?"

If you're asking questions like these, this project may help you! This project was created to consolidate various templates and scripts that help productionize your SSAS solutions. These templates aren't necessarily perfect! But they are a good starting point for solving these kinds of issues in your solution and will help save you time recreating the wheel.