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

View Answer

Answer:

Explanation:

* 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