I have a WebI report data provider as BI query, where Date format in BI query is as character, but when i put a filter on that to restrict dates between as a prompt in query filters in query panal and refresh the query, It is selecting the dates between the characters but not dates.
Ex: If i choose Dates between Jan2011 to Jun2011, it is sorting all Jan and Jun months in the query and showing results for even 2007 year.
When i tried to change the type in Universe-> obj definition, it is getting parsed, but when i run webi report it is failed.
how to change this to date type in BO/Universe, even i need to filter this in dashboards.
Help would be greatly appreciated.