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