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

 

This entry was posted in Programming and tagged , , . Bookmark the permalink.

One Response to How to Process Multiple Dimensions via BIDS and SSMS

  1. Hi there Jens,

    Actually i didn’t know any of these ways to process all dimensions, I always created an XMLA script that i fired in SSMS.

    Thx for these tips.

    /Kenneth

Leave a Reply