I am trying to bring in a transaction time field from the erp system into cognos. It is setup as military time in the erp system. I have the field set up as a numeric data type in sql and as an attribute in fwm. The results I get when I add the field to a report is not the times I see in the erp system. When I preview the data in data manager it shows the data in time format there though. I changed the data type in sql to timestamp and then casted the field in fwm as a new calculation but it did not work, cast([dbo].[history].[time], timestamp). Any suggestions? Thanks in advance.
Check the SQL generated. Cognos has the nasty habit of adding min/max functions on objects defined as attributes in some cases.