COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: sepusa on 15 Sep 2022 11:44:08 AM

Title: Is crosstab reports not working in Cognos analytics?
Post by: sepusa on 15 Sep 2022 11:44:08 AM
I have a question regarding crosstab reports in Cognos 11.1, we have crosstab that did worked absolutely fine in Cognos 10, but they started failing after we id migrated to C11. Does anyone here came across this kind of situation, please suggest your thoughts.
Title: Re: Is crosstab reports not working in Cognos analytics?
Post by: MFGF on 15 Sep 2022 11:50:36 AM
Quote from: sepusa on 15 Sep 2022 11:44:08 AM
I have a question regarding crosstab reports in Cognos 11.1, we have crosstab that did worked absolutely fine in Cognos 10, but they started failing after we id migrated to C11. Does anyone here came across this kind of situation, please suggest your thoughts.

Hi,

IBM had/has an imperative for "no report gets left behind" when migrating from Cognos 10. If the environments are set up in the same way, your report should work as it did. Have any other changes been made, for example migrating from using Compatible Query to Dynamic Query? What issues/errors are you seeing?

Cheers!

MF.
Title: Re: Is crosstab reports not working in Cognos analytics?
Post by: dougp on 15 Sep 2022 12:15:03 PM
Quotemigrated to C11

Migrated?  Not upgraded?

MFGF is correct in assuming you changed more than just the version.  For example, if this was a migration to IBM's "Cognos in the Cloud" offering, CQM is no longer available.

Providing specific error messages would be helpful.
Title: Re: Is crosstab reports not working in Cognos analytics?
Post by: sepusa on 11 Oct 2022 02:16:34 PM
It is not creating any specific error message, but the report runs forever and gets timed out. The same report used to work fine in C10.