Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: smtest on 13 Apr 2007 02:04:48 PM

Title: Maximum number of tables 192 exceed error
Post by: smtest on 13 Apr 2007 02:04:48 PM
I have migrated the reports from MR1 to MR2. I am getting maximum number of tables exceed error. I know, it happens generally because of the number of sub queries or joins. But this report was running fine in MR1. Do i need to change something in MR2 to make it work.
pls advice
Title: Re: Maximum number of tables 192 exceed error
Post by: COGNOiSe administrator on 15 Apr 2007 09:52:13 AM
Holly Guacamolle! 192 tables in a single SQL? You need to look at your model design.
Title: Re: Maximum number of tables 192 exceed error
Post by: Maple on 15 May 2007 03:44:43 PM
bug in cognos...They can't resolve it...

I also got this message in my complicated reports...It can't be resolve...Use other tech to create your reprt

-What you can try...

-Consolidate the underlying tables into a database view

- OR -

Turn on the 'use WITH clause' ( only works for SQL server 2005)




Title: Re: Maximum number of tables 192 exceed error
Post by: COGNOiSe administrator on 17 May 2007 02:56:36 AM
WITH works with DB2 as well.
Title: Re: Maximum number of tables 192 exceed error
Post by: Maple on 17 May 2007 10:09:44 AM
ooh ...thanks...just mean to compare with SQL server 2000 ...
Title: Re: Maximum number of tables 192 exceed error
Post by: COGNOiSe administrator on 17 May 2007 02:57:57 PM
No sweat. Just sharing.
Text only | Text with Images