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.
Use ROLAP storage for all partitions.
B.
Use the Distinct Count and Sum measure aggregation functions.
C.
Use the Define Semiadditive Behavior page to enable semi-additive behavior.
D.
Use the Define Semiadditive Behavior page to disable semi-additive behavior.
E.
Create a single measure group containing all measures
F.
Place the distinct count measures in separate measure groups.