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 Franceand
Germany.
Which expression should you use? (To answer, drag the appropriate expression to the answer area.)
A.
[Customer].[Customer Geography].[Country].&[France] & [Customer].[Customer Geography].[Country].&
[Germany]
B.
{[Customer].[Customer Geography].[Country].&[France],[Customer].[Customer Geography].[Country].&
[Germany]}
C.
[Customer].[Customer Geography].[Country].&[France] UNION [Customer].[Customer Geography].
[Country].&[Germany]
D.
SUM({[Customer].[Customer Geography].[Country].&[France],[Customer].[Customer Geography].
[Country].&[Germany]})
E.
SUM(([Customer].[Customer Geography].[Country].&[France],[Customer].[Customer Geography].
[Country].&[Germany]))