missing join and data mismatch

[shrini]

Hello Guru's


I have a requirement, i got a sql from the DB team, to model as per the joins in FM. But when i do as that i get more records than the records which i get when the sql is ran in database. Then i came to know that cognos missing one join, may be of the loop formed between them.

Steps done to rectify it:-

1. I created a shortcut.. still no change,i get 3 joins only
2. I created an alias-- Now i get 4 joins but the data is not matching with DB output.

Can someone guide me in this.

Below is the sample joins with 4 tables and 4 joins.


Select Column1, Column2.... from
A,B,C,D
where
A.ASSET_KEY_CCID = B.CODE_COMBINATION_ID
and C.ASSET_KEY = B.SEGMENT1
and D.ASSET_ID = A.ASSET_ID
And D.BOOK_TYPE_CODE = C.BOOK_TYPE_CODE

Thanks in advance.


Regards,

[AnalyticsWithJay]

shrini,

We'll need more information to help. I would start by identifying what the correct joins are between the tables, what the alias is for, and what you're trying to achieve with it.

I would also select all four query subjects in FM, launch context explorer, and post a screen capture of the joins so we could see it. Too little information unfortunately.