The main reason on why we get this error is due to the fact that the data source is not able to convert THE data item into appropriate data type (conversion issue) that is needed for the calculation. Here is a link related to IBM
The attached image in this section shows an example where I faced this issue. Once I removed the casting on the date data item used in the filter, the issue got fixed. But let me tell you why this casting was required in the first place :). This particular report was built using a SQL query and not from metadata. Since SQL Server saves both date and time in a date column we had to cast it; later when a different user ran it on MySQL it threw an error. :)
2 comments:
Thanks for Information COGNOS Online Training brings the most current standard IBM Business Analytics Education course material for you to deliver to your employees. We provide interactive and prescriptive training that lets student’s work at their own pace. The course is designed with a blend of multimedia and interactive labs to ensure faster user adoption. You can deliver the material in either a standard or customized format.
I'm too geting the same error while trying to validate the following code:
select e.patientid,h.encounterid,
min(case when st.name = 'Event Site' then h.value end) as 'Event Site',
min(case when st.name = 'Event Zip code' then h.value end) as 'Event Zip code'
from
enc e join structhpi h on e.encounterid = h.encounterid join
structdatadetail st on h.itemid = st.itemid where st.id in (6031,6032)
I'm trying to use the data present in 'h.value' as the column.
How shall I proceed in this case ?
Post a Comment