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

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *