SSAS - Efficient way to process a multidimensional cube
Problem: I am building a multidimensional cube using SSAS, I created the partitions based on a date column, and defined a partition for each day. Source data size is bigger than 2 TB. While deploying and processing the the cube, if an error occurred all processed partitions are not save and their state still unprocessed. After searching for a while I found the following article mentioning that: Parallel (Processing option): Used for batch processing. This setting causes Analysis Services to fork off processing tasks to run in parallel inside a single transaction. If there is a failure, the result is a roll-back of all changes. After searching i found an alternative way to process partitions one-by-one from an SSIS package as mentioned in the following article: Create SQL Server Analysis Services Partitions using AMO But the processing time increased more than 400%. Is there is an efficient way to process partitions in parallel without losing all progress wh...