Exclude few dates in a month in mdx query

Question

Below is my query. My requirement here is I want to exclude a few dates sales in a particular month while I am looking for month wise data.

For example: I don't want to include Aug 15, 2008 date sales for the month of August, 2008 when I am looking 2008 year for the month of August, 2008 data for accessories product.

select
[Measures].[Internet Sales Amount] on 0,([Product].[Category].&[4], 
[Date].[Calendar].[Month]
)on 1
from [Adventure Works]
where [Date].[Calendar Year].&[2008].

I would appropriate, if you could help in this regard.

Danylo Korostil Danylo Korostil · Accepted Answer · 2017-03-15T13:21:40

You have to exclude the member within the Where clause:

select 
[Measures].[Internet Sales Amount] on 0,
([Product].[Category].&[4],[Date].[Calendar].[Month]) on 1
from [Adventure Works] 
where ([Date].[Calendar Year].&[2008],{[Date].[Day].[Day].Members - [Date].[Day].&[20080815]})

Exclude few dates in a month in mdx query

1 Answers