Hi
I am trying to do a subquery in Cognos 8, as C8 does not have tabular model, I am using a filter in query1 to include query2 items and when I validate the subquery it gives me a cross join error, so I 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Ã, Ã, ???
You can create multiple queries and join them. This is done like CRN1.1 but at the query layer rather than module layer.
Master-detail queries are quite useful. After creating the queries use the Master Detail Relationships feature under the Data option on the toolbar menu.
Master Detail is not the issue, that works just fine. I'm having trouble with a "tabular reference" issue in C8. You should be able to pull item from query 2 into query 1 if you enable the joins conditions. But for some reason I keep getting this DB conn dropped error, I think its something to do at the model level but I'm not sure what. The fact that it works in 1.1 and not in the ported over version in c8 can only mean that something is wrong at the model level, but since i didnt develop the model, I don't know what could be the possible cause. Anyone have any suggestions if not a solution???