Processing Cubes After a Data Refresh: Batching Processing Using AMO
Recently I needed to update some cubes in a test environment after the underlying data warehouse had been refreshed. Typically I'd sync the cubes from prod, but as sync causes locking, and I needed to get this done during the day, I needed to reprocess all of the cubes in the test environment, and there were a lot of them, all ranging in sizes from hundreds of gb to a few mb. The simplest way to update the cubes was to run a process default on the dimensions and then run a process default on the measure groups. Some of the measure groups were partitioned, so I could've got clever and just processed fully any unprocessed partitions, but I felt a default would do most of the hard work for me.