Which statement fragments should you use?

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

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

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 3

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