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.