COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: pravin.cognos on 02 May 2012 03:27:04 AM

Title: Issues after migrating to Cognos 10.1 from 8.3
Post by: pravin.cognos on 02 May 2012 03:27:04 AM
Dear Gurus

We have migrated from 8.3 to Cognos 10.1 successfully. When I run the reports in, I see the below issues which were not there in 8.3

1. Data item label name is not shown in report. This was fine with 8.3. For few dataitems, I have used Coalesce() function and their label name is correct. For the other ones, it is showing the physical name of the label (ex: FIN_BENEFITS_ACCURED). If I use the function here, then its showing the correct label name. I have few attribute dataitems for which I cant use any function..Any reason what is causing this??

2. For few rows, I see a difference of 1 in the values. (ex: In 8.3, it was 1000, in 10.1 it is showing as either 999 or 1001). Any hint why is this happening.

Please let me know how these issues can be addressed..

Thanks
Pravin
Title: Re: Issues after migrating to Cognos 10.1 from 8.3
Post by: pravin.cognos on 02 May 2012 10:50:19 AM
Dear All

I found out the reason for issue # 2. It was due to wrong placement of Isnull() function in the calculated dataitems. Now they are showing the correct values.

Any help on Issue #1 please ??

Thanks
Pravin