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 the United
Kingdom and the United States. 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].&[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]))


Leave a Reply