IsEmpty (MDX)

Return true if the tuple is evaluated to an empty cell.

Parameters

Name	Type	Cardinality	Default value
	tuple-expression	one

Return

boolean

Description

The function returns true if the tuple is evaluated to an empty cell.

a) Null entities will return true, as they are considered empty.
b) Sets of members and tuple will return false independently of their size.

Note that even empty sets return false.

Examples

isEmpty(tuple)

Returns true if the tuple is evaluated to an empty cell (i.e., without value).

In our example, for operating year 2010, we return all cities with sale activity. Note how missing values for hierarchies are filled with current values.

Query

WITH
    SET [Cities] AS Filter( [Geography].[Geo].[City].Members, NOT IsEmpty( ([Time].[Calendar].[2010],[Measures].[Amount]) ) )
SELECT
    [Cities] ON 0,
    [Measures].[Amount] ON 1
FROM
    [Sales]

Result

	New York	Paris	Barcelona	Madrid	Geneva	Lausanne	Zurich
Amount	768	4	2	1	128	56	64

Assertion : Cell Equals

SELECT
    NonEmpty([Geography].[Geo].[City].Members) ON 0,
    [Measures].[Amount] ON 1
FROM
    [Sales]
WHERE
    [Time].[Calendar].[2010]

Assertion : Cell Equals

WITH
    SET [Cities] AS Filter( [Geography].[Geo].[City].Members, NOT IsEmpty( [Measures].[Amount] ) )
SELECT
    [Cities] ON 0,
    [Measures].[Amount] ON 1
FROM
    [Sales]
WHERE
    [Time].[Calendar].[2010]

Special Examples (errors, null, ...)

isEmpty(NULL)

Empty
true

isEmpty(emptySet)

Empty
false

isEmpty(level)

Empty
false

isEmpty(memberSet)

Empty
false

isEmpty(tupleSet)

Empty
false

isEmpty(string)

Empty
false

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.