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

solve this problem please

Started by cognoshelp@ymail.com, 30 Jul 2008 02:25:43 PM

Previous topic - Next topic

cognoshelp@ymail.com

I have  two tables joined as 1..1,1..n
but data is not getting what I am expecting....Please throw some of your exp.

Please read complete description then reply
NOTE: I CHANGED THE JOINS TO 1..n, 1..1 and 1..1,1..n so for all this I am getting different values(more or less) compared to DB(Oracle)

Two tables : A_HDR & B_DTL

Joined by using column - 123 Now what is my problem is
from A_HDR table I am selecting a Date column and from B_DTL table I am selecting a number(value) column.

In report I am able to  see these values but when I go and check with the DB(oracle) I am seeing more values.

Please let me know what I need to do....


blom0344

You need to check the SQL generated by Cognos and compare this with the SQL that you aim directly against Oracle. There is a pretty good chance that these statements are not directly comparable.

Other than that , your problem description is way too vague to answer properly..

wyconian

You need to provide more details on the problem but from what you've said it sounds like you may need to have an outer join between the tables or set up a dummy value so that you can get all rows coming back with out the outer join.

Check the cardinality of the tables in your source.