70-466 cbt
Microsoft SQL Server 2012 70-466 : Implementing Data Models and Reports with Microsoft SQL Server

70-466 Latest Exam Braindumps

Question 10: DRAG DROP
You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services (SSAS)
cube.
You need to compute the aggregate value of the 10 most-ordered produces in the Product Categories
hierarchy. The Product level is the lowest in the hierarchy.
Which functions should you use to complete the MDX query? (To answer, drag the appropriate
functions from the list of functions to the correct locations in the answer area.)
Correct Answer:
Explanation:
Note:
* Example (order of TopCount and Aggregate):
WITH
SET
[Top25Customers] as
TopCount([Customers].[All Customers].Children, 25.0, [Measures].[Sales]) MEMBER [Customers].[All
Customers].[Rest of Customers] as Aggregate(Except([Customers].[All
Customers].Children,[Top25Customers])) SELECT NON EMPTY {CROSSJOIN([Markets].[All
Markets].Children,{[Measures].Sales})} ON COLUMNS, Union([Top25Customers],{[Customers].[All
Customers].[Rest of Customers]}) ON ROWS from [SteelWheelsSales]
* TopCount: Sorts a set in descending order and returns the specified number of elements with the
highest values.
*Aggregate:
Returns a number that is calculated by aggregating over the cells returned by the set expression. If a
numeric expression is not provided, this function aggregates each measure within the current query
context by using the default aggregation operator that is specified for each measure. If a numeric
expression is provided, this function first evaluates, and then sums, the numeric expression for each
cell in the specified set.
* Example:
One can extract the leaf members of a parent child hierarchy by asking the descendants of the root
member with the following expression: Descendants([Organization].[Organizations].&[1], , LEAVES)
* Incorrect:
/ Not TopSUM: Returns, in order of decreasing rank, the top-most rows of a table whose cumulative
total is at least a specified value.