Automate And Accelerate SSAS Tabular Cube Partition Maintenance Using PowerShell
The Blog is prepared to automate and accelerate SSAS tabular cube Partition creation and maintenance activities required for the most of the MSBI analytics projects. There are definitely better way of doing it and probably easy to do but this is how I tackled it.
Also, I would like to focus on simplifying the automation core concept with basic cube details stored in SQL master partition control table and generating required partition details in Partition Control detail table, can be used effectively for creating cube partitions using PowerShell script.
Tags: management, script, powershell, tabular