The query below returns True or False for the Date members of the Calendar hierarchy where the Sales Amount for the current Date member is empty.
|
|
WITH MEMBER [Measures].[AmIEmpty] AS ISEMPTY(([Date].[Calendar].CurrentMember, [Measures].[Sales Amount]))
SELECT {[Measures].[AmIEmpty]} ON COLUMNS,
{[Date].[Calendar].[Date].Members} ON ROWS
FROM [Adventure Works] |
|
|
|
|
|
|
The following query uses the IsEmpty function in a filter clause to restrict the returned set to Date members that have empty values for the Sales Amount measure.
|
|
SELECT {[Measures].[Sales Amount]} ON COLUMNS,
FILTER([Date].[Calendar].[Date].Members, ISEMPTY([Measures].[Sales Amount])) ON ROWS
FROM [Adventure Works]
|
|
|
|
|
|
|