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,
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.