Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

IsEmpty (MDX)

Updated: 17 July 2006

Returns whether the evaluated expression is the empty cell value.


IsEmpty(Value_Expression) 

Value_Expression

A valid Multidimensional Expressions (MDX) expression that typically returns the cell coordinates of a member or a tuple.

The IsEmpty function returns true if the evaluated expression is an empty cell value. Otherwise, this function returns false.

ms145507.note(en-US,SQL.90).gifNote:
The default property for a member is the value of the member.

The IsEmpty function is the only way to reliably test for an empty cell because the empty cell value has special meaning in Microsoft SQL Server 2005 Analysis Services (SSAS).

ms145507.note(en-US,SQL.90).gifImportant:
If the evaluation of the value expression returns an error, the function will return false. A value expression can return an error, for example, if a properties reference refers to an invalid or non-existent property.

For more information about empty cells, see the OLE DB documentation.

Example

The following example returns TRUE if Measures.CurrentMember is an empty cell:

IsEmpty(Measures.CurrentMember)

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft