Which four MDX segments should you insert in sequence before a SELECT statement?

DRAG DROP
You are developing reports based on the SQL Server Analysis Services (SSAS) cube
named ProcessedOrders.
A Multidimensional Expressions (MDX) query must include a query-scoped calculated
member, which computes average sales per order item. The query must also return the set
of three states in a query-scoped named set named East Coast Customers.
You need to define the calculations in an MDX query to meet the requirements.
Which four MDX segments should you insert in sequence before a SELECT statement? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange
them in the correct order.)

Answer: See the explanation.

Explanation:

Box 1:

Box 2:

Box 3:
MEMBER [Average Sales Per Processed Order Item ] AS
Box 4:

Note:
* Example #1:
WITH
MEMBER [Measures].[Special Discount] AS
[Measures].[Discount Amount] * 1.5
SELECT
[Measures].[Special Discount] on COLUMNS,
NON EMPTY [Product].[Product].MEMBERS ON Rows
FROM [Adventure Works]
WHERE [Product].[Category].[Bikes]
* Example 2:
WITH SET [ChardonnayChablis] AS
{[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Good].[Good Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Pearl].[Pearl
Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Portsmouth].[Portsmouth Chardonnay],

[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Top
Measure].[Top Measure Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Walrus].[Walrus Chardonnay],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Good].[Good
Chablis Wine],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Pearl].[Pearl
Chablis Wine],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Portsmouth].[Portsmouth Chablis Wine],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Wine].[Top
Measure].[Top Measure Chablis Wine],
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Walrus].[Walrus Chablis Wine]}
SELECT
[ChardonnayChablis] ON COLUMNS,
{Measures.[Unit Sales]} ON ROWS
FROM Sales
Reference:
http://technet.microsoft.com/en-us/library/ms146017.aspx
http://technet.microsoft.com/en-us/library/ms145487.aspx