Select and Process Multiple
Dimensions at Once in SQL Server Management Studio
What if you want to process multiple dimensions on an SSAS
db but you don’t want to go through the process of scripting out XMLA and a job
to do it? Only recently I stumbled on to
an option to multi-select dimensions within one db in Management Studio and
process them all.
Within Object Explorer, you can usually only select 1
dimension at a time to Right-Click and Process.
But if you select a dimension, then go to View > Object
Explorer Details (or press F7), you are presented with a new window for Object
Explorer Details.
From here you can CTRL + Click or SHIFT + Click to select
multiple dimensions, then right click and select Process.
This works (at least) in SQL Server 2008 +.
Labels: Dimensions, SSAS, SSMS