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.
0
0
i think Nic is right.
0
0
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image0149.jpg
0
0
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.
0
0
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
0
0
1 select dimension
2. open designer (by double click the selected dimension)
3. select processing group by table
0
0
“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
0
0