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.
Answer: B, F