NonEmpty (MDX)

Artykuł
02/16/2015

Returns the set of tuples that are not empty from a specified set, based on the cross product of the specified set with a second set.

Składnia

NONEMPTY(set_expression1 [,set_expression2])

Arguments

set_expression1
A valid Multidimensional Expressions (MDX) expression that returns a set.
set_expression2
A valid Multidimensional Expressions (MDX) expression that returns a set.

Uwagi

This function returns the tuples in the first specified set that are non-empty when evaluated across the tuples in the second set. The NonEmpty function takes into account calculations and preserves duplicate tuples. If a second set is not provided, the expression is evaluated in the context of the current coordinates of the members of the attribute hierarchies and the measures in the cube.

[!UWAGA]

Use this function rather than the deprecated NonEmptyCrossjoin (MDX) function.

Ważne:
Non-empty is a characteristic of the cells references by the tuples, not the tuples themselves.

Examples

The following query shows a simple example of NonEmpty, returning all the Customers who had a non-null value for Internet Sales Amount on July 1st 2001:

SELECT [Measures].[Internet Sales Amount] ON 0,

NONEMPTY(

[Customer].[Customer].[Customer].MEMBERS

, {([Date].[Calendar].[Date].&[20010701], [Measures].[Internet Sales Amount])}

)

ON 1

FROM [Adventure Works]

The following example returns the set of tuples containing customers and purchase dates, using the Filter function and the NonEmpty functions to find the last date that each customer made a purchase:

WITH SET MYROWS AS FILTER

(NONEMPTY

([Customer].[Customer Geography].[Customer].MEMBERS

* [Date].[Date].[Date].MEMBERS

, [Measures].[Internet Sales Amount]

) AS MYSET

, NOT(MYSET.CURRENT.ITEM(0)

IS MYSET.ITEM(RANK(MYSET.CURRENT, MYSET)).ITEM(0))

)

SELECT [Measures].[Internet Sales Amount] ON 0,

MYROWS ON 1

FROM [Adventure Works]