PrepAway - Latest Free Exam Questions & Answers

Which expression should you use?

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.)

PrepAway - Latest Free Exam Questions & Answers

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]))


Leave a Reply