| 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] |
| |
| |
| |
|
| |
|