DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
You identify that a dimension, which has a large number of attributes, is issuing a separate
(SELECT DISTINCT) query for each attribute even though they all come from a single
database table. The table does not have a large number of rows.
You need to configure the processing of the dimension to issue only a single SQL query to
the underlying database, and processing must continue if any errors are encountered.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: 
Answer:
1.- Open dimension designer.
2.- Select dimension.
3.- In the properties windows, set the ProcessingGroup property to ByTable and then change the KeyDuplicate property to IgnoreError.
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image0149.jpg
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00215.jpg
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00416.jpg
1.- Select dimension.
2.- Open dimension designer.
3.- In the properties windows, set the ProcessingGroup property to ByTable and then change the KeyDuplicate property to IgnoreError.
1 open dimension designer
2 here right click on dimension node (so select dimension)
3 select processing group by table
http://www.ssas-info.com/analysis-services-articles/66-mgmt/2542-dimension-processing-group–bytable-or-byattribute
When development has been finished, we no more have access to the project. What we have i a deployed model to SSAS. We need to connect to it using SSMS that generally would allow you to define all administrative settings, including processing.
Presented answer by Carlos is OK.
1 select dimension
2. open designer (by double click the selected dimension)
3. select processing group by table
“Select Dimension -> Open Dimension Designer” should be to correct sequence.
So:
1 select dimension
2. open designer (by double click the selected dimension)
3. select processing group by table