If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Subquery issue in Cognos 8 BI (Report Studio)

Started by rohizzle, 22 Aug 2006 10:10:46 AM

Previous topic - Next topic

rohizzle

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Ã,  Ã, ???

Blue

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.
Robert Edis
Principal
Robert Edis Consulting
Rotorua, New Zealand

rohizzle

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???