one query results should be joined with another table in FM

[neelimakoppu]

Hi,

I have to generate 4 reports BI, BQC, BPrice & BPrint using 5 different tables. Here one query results should be joined with a new table. To implement the same in cognos i've followed as below.

BQC is resultant of BI leftouterjoin with JFDVAI00 table. For this I've joined tables as in 1. It worked fine.

Where as BPrice is resultant of BQC inner join with JFDV0600 table. I've created joins as in 2, which is throwing trace back error.

Tried another way of joining as in 3, which is also giving time out error.

Can anyone tell me, am I doing joins correct or please tell me how to model in such cases. Thanks.