Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Salvo(z) SQL

Adam and Jennifer Salvo are IT professionals with over 10 years of diverse experience. Jennifer is a Business Intelligence developer focusing on the Microsoft BI stack (SSIS, SSAS and SSRS). Her prior work experience includes software development, systems analysis, end-user support, training, and SharePoint administration. Adam is a .NET technical lead with a current emphasis on Dev Ops and Windows Azure. His prior work experience includes .NET development, SQL Server administration, and BizTalk development. They also maintain a personal blog at salvoz.com.

SSAS: Processing Cube Dimensions and Measures in SSMS

My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the GUI interface in SQL Server Management Studio (SSMS).

To process all dimensions:

1.  Connect to an SSAS instance in SSMS.

2. Expand the appropriate node / cube.

image

3. Select ‘Dimensions’ and in the SSMS menu at the top select ‘View’ > ‘Object Explorer Details’.

image

4.  You will then see the following window with a list of the dimensions.

SNAGHTML659e975

5. Select all dimensions by first clicking on the top dimension in the list, hold down the ‘Shift’ key and then click the last dimension.  You should now have all the dimensions selected as shown below.

image

6.  Right click anywhere on the dimensions and then click ‘Process’.

image

7.  You should now see a ‘Process Object (s)’ window.  Update the ‘Process Option’ for each dimension if needed and then click ‘OK’.

SNAGHTML661a093

8.  A dimension ‘Processing Progress’ window is displayed. If the processing completes successfully, you should see a ‘Process succeeded’ message.    When finished, close the window.

image

The steps to process all the measures are almost identical:

1.  Connect to an SSAS instance in SSMS.

2. Expand the appropriate node / cube.

image

3. Expand the Cubes node to the ‘Measure Groups’ level.

image

4.  Select ‘Measure Groups’ and in the SSMS menu at the top select ‘View’ > ‘Object Explorer Details’.

image

5.  You will then see the following window with a list of the measure groups.

SNAGHTML68fd866

6.  Select all dimensions by first clicking on the top measure in the list, hold down the ‘Shift’ key and then click the last measure.  You should now have all the measures selected.

7.  Right click anywhere on the measures and then click ‘Process’.

image

8.  You should now see a ‘Process Object (s)’ window.  Update the ‘Process Option’ for each measure if needed and then click ‘OK’.

SNAGHTML6949cbd

9.  A measure ‘Processing Progress’ window is displayed. If the processing completes successfully, you should see a ‘Process succeeded’ message.    When finished, close the window.

image

Comments

Leave a comment on the original post [salvoz.com, opens in a new window]

Loading comments...