COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: mycognos on 29 Oct 2008 08:20:53 AM

Title: Cognos Migration from 8.2 to 8.3
Post by: mycognos on 29 Oct 2008 08:20:53 AM
I am in the process of migrating cognos8.2 reports to 8.3. I have almost done that, but when i try to run the reports some of them(2 Crosstab reports) are not giving any data. If i run the query from oracle it is fetching data from the database, i dont know why it is not coming in the output. Can anyone pls help me?
Title: Re: Cognos Migration from 8.2 to 8.3
Post by: Suraj on 29 Oct 2008 09:55:36 AM
try re-doing the migration.
sometimes if you miss a step or sometimes just for nothing the deployment archive gets corrupted.
Some reports may have to be re-created...
Title: Re: Cognos Migration from 8.2 to 8.3
Post by: blom0344 on 29 Oct 2008 01:18:50 PM
Quote from: mycognos on 29 Oct 2008 08:20:53 AM
I am in the process of migrating cognos8.2 reports to 8.3. I have almost done that, but when i try to run the reports some of them(2 Crosstab reports) are not giving any data. If i run the query from oracle it is fetching data from the database, i dont know why it is not coming in the output. Can anyone pls help me?

Cognos seems to be trying to be  too clever with version 8.3. We had some reports where the totals were way to high (after migration). Adding the object that was supposed to be used in the filter brought back the correct results in a tabular query. However, the only way to correct the report was to add the object to the crosstab and then 'hide' it.
Bloody annoying !!
Be prepared to go over every report and check thoroughly