Drag and Drop Question 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 memb

The complete MDX statement is as follows: `` CASE WHEN ([Customer].[Region].&[East].MEMBERS, [Measures].[Sales Amount]) = [Measures].[Sales Amount] * 1.10; END ``

Build an analysis services database

Question

Drag and Drop Question 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.)

Explanation

The complete MDX statement is as follows:

CASE
WHEN ([Customer].[Region].&[East].MEMBERS,
[Measures].[Sales Amount])
= [Measures].[Sales Amount] * 1.10;
END

Topics

#MDX calculations#SCOPE statement#member value assignment#cube calculations

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice