You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customerdimension to evaluate the sum of values for the United
Kingdom and the United States. Which expression should you use?
(To answer, drag the appropriate expression to the answer area.)
A.
[Customer].[Customer Geography].[Country].&[United Kingdom] & [Customer].[Customer Geography].
[Country].&[United States]
B.
{[Customer].[Customer Geography].[Country].&[United Kingdom],[Customer].[Customer Geography].
[Country].&[United States]}
C.
[Customer].[Customer Geography].[Country].&[United Kingdom] UNION [Customer].[Customer Geography].
[Country].&[United States]
D.
SUM({[Customer].[Customer Geography].[Country].&[United Kingdom],[Customer].[Customer Geography].
[Country].&[United States]})
E.
SUM(([Customer].[Customer Geography].[Country].&[United Kingdom],[Customer].[Customer Geography].
[Country].&[United States]))