How to process multiple SSAS cube dimensions in SQL Management studio
This is a little issue that bugged me…. instead of going in the Visual Studio project and processing dimensions in there, I wanted to be able to multi-select my dimensions and reprocess them.
But, multi-select is not something that you can do in SQL Management studio.
So… here’s the (hidden trick)….
- Select the dimension
- Hit F7
- And then you have “Object Explorer Details” open, where you can do a multi-select.
You can also find “Object Explorer Details” in the “View” menu when you select the dimension.