Maximum number of tables 192 exceed error

[smtest]

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

[COGNOiSe administrator]

Holly Guacamolle! 192 tables in a single SQL? You need to look at your model design.

[Maple]

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)

[COGNOiSe administrator]

WITH works with DB2 as well.

[Maple]

ooh ...thanks...just mean to compare with SQL server 2000 ...

[COGNOiSe administrator]

No sweat. Just sharing.