Cannot do subquery in Cognos 8

[samjose]

Hi

I am trying to do a subquery in Cognos 8, as C8 does not have tabular model, I am using the filter in query1 to include query2 items and when I validate the subquery it gives me a cross join error,so I have changed the properties of both the queries to allow cross joins and now it is giving a "QE-DEF-0459 CCLException RQP-DEF-0120 Database connection is dropped" error. Any suggestions are welcome

Thanks

 

[mfgf]

Your subquery needs to be defined as a second query in your report, then joined to the main query with a query join. You can do all of this from the query explorer.

Tabular models no longer exist in Cognos 8 - the structures have been simplified a lot so that you now just have queries. What you would have done in Tabular Models in ReportNet you now do in Queries in Cognos 8, and instead of having to mess around with filters to join them, there are new Query Join objects in the toolbox.

Regards,

MF.