Skip to Content
0
Former Member
Nov 16, 2012 at 08:36 PM

Issues with Date Fields in OLAP Cube Based Universe

16 Views

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...