[
http://mifosforge.jira.com/browse/MIFOS-3979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yogesh N - Gray Matter updated MIFOS-3979:
------------------------------------------
A few queries on Loan Officer Performance Summary Report
For the following columns:-
1. Total Amount Savings Deposit
2. Total Amount Savings Withdrawals
3. Total Amount of Loans Repaid
4. Total New Savings Account
We intend to use the following query logic:-
1. Sum of deposit_amount from fact_savings_transactions as Total Amount Savings
Deposit.
2. Sum of withdrawal_amount from fact_savings_transactions as Total Amount
Savings Withdrawals.
3. Sum of principal_amount from fact_loan_repayments as Total Amount of Loans
Repaid.
4. Count of savings_account_key from dim_savings where 'start date' <
valid_from as Total New Savings Account.
Some one pls validate.
> Update Loan Officer Performance Summary Reports - queries and parameterization
> ------------------------------------------------------------------------------
>
> Key: MIFOS-3979
> URL: http://mifosforge.jira.com/browse/MIFOS-3979
> Project: mifos
> Issue Type: Story
> Reporter: Usha D - Gray Matter
> Assignee: Usha D - Gray Matter
> Fix For: Release E - Iteration 11
>
>
> The report has around 24 data columns which roughly translates to 24 queries,
> therefore the estimate of 2 days or 1pt.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Achieve Improved Network Security with IP and DNS Reputation.
Defend against bad network traffic, including botnets, malware,
phishing sites, and compromised hosts - saving your company time,
money, and embarrassment. Learn More!
http://p.sf.net/sfu/hpdev2dev-nov
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
