PrepAway - Latest Free Exam Questions & Answers

Which statement fragments should you use?

You are making changes to a cube named Sales.
You must increase the value of the measure named Sales Amount by 10%. The increase must be
applied only to the children of the member named East in the dimension named Customer.
You need to complete the Multidimensional Expressions (MDX) statement in the calculations
section of the Sales cube.

Which statement fragments should you use? (To answer, drag the appropriate statement
component to the correct location or locations in the answer area. Use only components that
apply.)
Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:

Note:
SCOPE THIS END SCOPE
* SCOPE Statement (MDX)
Limits the scope of specified Multidimensional Expressions (MDX) statements to a specified
subcube.
* Example:
cope
(
[Date].[Fiscal Year].&[2002],
[Date].[Fiscal].[Month].Members
) ;
This = [Date].[Fiscal].CurrentMember.Parent / 3 ;
End Scope;


Leave a Reply