Analytics Software

Hi All,
Though when ever I posted my question in forums never got an answer. Trying again if some one takes interest in answering it. Situation is as under:

I am stuck in joins for Master Detail tables of AP schema. Consider We have master table AP_INVOICES_ALL having its detail in AP_INVOICE_LINES_ALL further its child is AP_INVOICE_DISTRIBUTIONS_ALL.
Specified the joins in Physical Layer which are mandatory to link them all.

What happens to my data is when ever I pick up (Sum)INVOICE_AMOUNT and Sum(DISTRIBUTIONS_AMOUNT)
results are mulitplied according to distributions rows or line rows.

Please help if I am missing something else like master detail relationships or anyother parameter which should be applied to avoid cartesians.

Please Help!

Regards,
Waqas