Amount multipled after join

[clingst]

i have two table

Application table with column applicationNO, loanAmount, product
Collateral table with column applicationNo, propertyType, collateralValue

i did a join at Database view level for this two table then published as a package in a single query as following:
<p>applicationNo, loanAmount, productm propertyType, collateralValue </p>

as a result, my loanAmount will be multiplied IF there is multiple property for the application.

please advice how should i handles this in Framework Manager so that the value will comes correctly in cube and reports.

[bus_pass_man]

Have you ruled out it being a bride table situation?