Universe Turns Bex Date fields to Character
We are noticing that the universes that we creat are turning all date fields from the bex query to charachter fields. When we try to change the field back to a date in the universe it fails saying that the "driver is not capable". This is usually tied to bad data in the columns or a date format issue. Has anyone seen this and come up with a workaround?
Nisha Makhija replied
We also had the same issue, if you have underlying infoset at BI side, then the date fields will appear as Characters in universe.
I raised this issue in oSS, they confirmed that this is a Produxct fix, and will be released in 1st quarter of 2010.
Please have a look at this thread:
hope this helps.