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

Merging Query Subjects

Started by dsg1, 29 Jan 2008 02:27:00 AM

Previous topic - Next topic

dsg1

Hi,
Can anybody tell me what is the criteria when merging 2 query subjects into one. Will it be possible if I merge two query subjects which have no direct relationship between them. How data is fetched. Will the duplicate values be fetched

ComplexQry

Joining two tables without a relationship is a Cartesian Join.  A Cartesian join is when you join every row of one table to every row of another table.  You rarely want to do this...  The better solution would be to get your database remodeled so there is a relationship, if possible.  I have done this before to take a fact at a yearly grain and explode it to a monthly grain.  Hope this helps.