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:
Open a connection to a “live” database
Choose which server/database to connect to:
Select all dimensions and right-click:
Finally, choose processing mode:
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:
Expand till you get to the Dimensions folder:
Hit F7 to open the Object Explorer Details:
Select Processing Mode:
One thought on “How to Process Multiple Dimensions via BIDS and SSMS”
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.