NonEmpty (MDX)

Returns all set members that are non empty, facts wise, from the tuple set.

In our example, this is equivalent to NON EMPTY

Query

SELECT
    [Measures].[Amount] ON 0,
    NonEmpty([Geography].[Geo].[America].children) ON 1
FROM
    [Sales]

Result

Assertion : Cell Equals

SELECT
    [Measures].[Amount] ON 0,
    NON EMPTY [Geography].[Geo].[America].children ON 1
FROM
    [Sales]

Returns all set members that are non empty, facts wise, from the tuple set when evaluated using the specified measure.

In our example, this is equivalent to a Filter( ..., NOT isEmpty() ) statement.

Query

SELECT
    NonEmpty([Geography].[Geo].[America].children, [Measures].[Amount] ) ON 0
FROM
    [Sales]

Result

Assertion : Cell Equals

SELECT
    Filter( [Geography].[Geo].[America].children, NOT isEmpty( [Measures].[Amount] ) ) ON 0
FROM
    [Sales]

Returns the first two set members that are non empty, facts wise, from the tuple set when evaluated using the specified measure.

In our example, this is equivalent to a Filter( ..., NOT isEmpty() ).head(2) statement.

Query

SELECT
    NonEmpty([Geography].[Geo].[America].children, [Measures].[Amount],2 ) ON 0
FROM
    [Sales]

Result

Assertion : Cell Equals

SELECT
    Filter( [Geography].[Geo].[America].children, NOT isEmpty( [Measures].[Amount] ) ).head(2) ON 0
FROM
    [Sales]

Returns all members of the first set that are non empty, facts wise, for at least one combination with the members of the second set.

In our example, the query returns the total [Amount] for all countries which have a partnership product.

Query

SELECT
    [Measures].[Amount] ON 0,
    NonEmpty([Geography].[Geo].[City].members,[Product].[Partnership])  ON 1
FROM
    [Sales]

Result

Assertion : Cell Equals

SELECT
    [Measures].[Amount] ON 0,
    Filter([Geography].[Geo].[City].members as s,not isEmpty(s.currentMember* [Product].[Partnership]))  ON 1
FROM
    [Sales]