Analysis Services
IsEmpty
Returns TRUE if the evaluated expression is the empty cell value, FALSE otherwise.
Syntax
IsEmpty(«Value Expression»)
Remarks
The IsEmpty function is the only way to reliably test for an empty cell, because the empty cell value has special meaning to Microsoft® SQL Server™ 2000 Analysis Services. 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)