What should you do?

You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.

The sales department requires the following set of metrics:

• Unique count of customers

• Unique count of products sold

• Sum of sales

You need to ensure that the cube meets the requirements while optimizing query response time.

What should you do? (Each answer presents a complete solution. Choose all that apply.)
A . Place the measures in a single measure group.
B . Place the distinct count measures in separate measure groups.
C . Use the additive measure group functions.
D . Use the semiadditive measure group functions.
E . Use the Count and Sum measure aggregation functions.
F . Use the Distinct Count and Sum measure aggregation functions.

View Answer

Answer: B, F