How to Process Multiple Dimensions via BIDS and SSMS

This is one of those tips I need to write down, before I forget…
Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually turned to Visual Studio Business Intelligence Development Studio [BIDS] or SQL Server Data Tools [SSDT], which allows you to select more than one dimension at a time, and fire up the processing. See figures below:

Via BIDS

Open a connection to a “live” database

Open Connection
Open Connection

Choose which server/database to connect to:

Choose Server/Database
Choose Server/Database

Select all dimensions and right-click:

Select dimensions
Select dimensions and right-click

Finally, choose processing mode:

Processing Mode
Processing Mode

Via SSMS

Until today, I didn’t know you could actually do the same action through SQL Server Management Studio [SSMS]. You do as following:

Connect to the server:

Connect to Server
Connect to Server

Expand till you get to the Dimensions folder:

Find the Dimensions folder
Find the Dimensions folder

Hit F7 to open the Object Explorer Details:

Select All and Right-click
Select All and Right-click

Select Processing Mode:

Select Processing Mode
Select Processing Mode

 

Loading

One thought on “How to Process Multiple Dimensions via BIDS and SSMS

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.