Hi,
i use XamDataChart with OLAP data (AdomdDataSource). I have a date dimension.I need to get all data except those who have a date < Today - 2.How i can set a such filter?
Generaly how i can set a 'not in',' lower than' and 'grater than' filters?
I put this filter in the AdomdDataSource's Filters property:
ado.Filters = DataSourceBase.GenerateInitialItems("[Date].[Year]{[Date].[Year].&[2014]}, [Date].[Day] < '2014-04-07'");
it doesn't work, it only filter on the year.
Any help would be appreciated.
Thx.
Hello,
I am just checking if you have any questions on the matter.
I have been looking into your description and I believe that this issue is similar to the one that was answered in the following forum thread regarding complex filtering of the AdomdDataSource: http://ko.infragistics.com/community/forums/p/88291/438445.aspx.
Please feel free to let me know if you have any questions.