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.
