Hello,
I am using MDX query Below is an example.
SELECT NON EMPTY { [Measures].[Qty] } ON COLUMNS, NON EMPTY { ([Sell-In].[ItemId].[ItemId].[125421] * [Sell-In].[WeekEnd].[WeekEnd].ALLMEMBERS * [Sell-In].[GBPStore].[GBPStore].[WME01] * [Sell-In].[CalendarYear].[CalendarYear].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( [Sell-In].[WeekEnd].&[ceu]&[2013-03-08T00:00:00] : [Sell-In].[WeekEnd].&[ceu]&[2013-05-16T00:00:00] ) ON COLUMNS FROM [Last year Cube]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
And WeekEnd is like
1/1/2011
1/5/2011
1/14/2011
1/20/2011
2/1/2011
In a MDX query we require to filter the data based on the date range.E.g date range 01/01/2011 to 01/31/2011
Here when the FromDate and ToDate parameters are passed as 01/01/2011 and 01/20/2011, the items 1 to 4 with their respective qty’s are retrieved correctly. But when the FromDate and ToDate are passed as 01/01/2011 and 01/31/2011 (or) 01/01/2011 and 01/19/2011, it returns even the value of Item5 which is wrong. i.e., only when the exact dates available in the table are passed as parameters, it returns the correct result. But when dates that are not available in the table is passed, the entire dataset is returned. Any solution then please suggest answer.
Thanking you
hardik