I saw many related posts on this,but no satisfactory answer , hence writing it down here.I'm trying to create reports based on OLAP cubes,and am facing the following issues :
1. Date fields of the cube automatically change to char data type,and hence I dont see a calender pick in date filter
2. If I change the data type to date,and pull the field in the report,I get no data in the report,and no error message
3. I already tried creating universe level filters also,but it also doesn't give any data
4. In addition to that,as soon as I pull a measure in the universe,I again get no data,even if the date filter is a char.
In short, date field doesn't work in the filters well.
The version I'm using is Business Objects Platform 4.0 SP4 ( 14.0.4.738 )
Please help if anyone has any workaround for this,or if this issue is addressed in any patch.
Any help would be appreciated.
Thanks in advance...