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

To resolve the issue and meet the requirements: 1. Open the dimension designer. 2. Select the dimension. 3. In the Properties window, set the ProcessingGroup property to ByTable and then change the KeyDuplicate property to IgnoreError.

Configure and maintain an analysis services database

Question

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.)

Exhibits

Explanation

To resolve the issue and meet the requirements:

Open the dimension designer.
Select the dimension.
In the Properties window, set the ProcessingGroup property to ByTable and then change the KeyDuplicate property to IgnoreError.

Topics

#dimension processing#GroupByAttribute#error configuration#SSAS query optimization

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice