[ 
http://mifosforge.jira.com/browse/MIFOSBI-301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67044#comment-67044
 ] 

johnwoodlock commented on MIFOSBI-301:
--------------------------------------

Binny, 

a) Jaipur Area Office has 8 branches under it. But the report shows zero.

The figures in the Outreach section are for new items 'created' during the 
month, not accumulated by the end of the month.  So, the "% change" doesn't 
show the increase/decrease comparison of 2 months, it shows the 
increase/decrease in the 'rate of change'.

So if no new branches were created in a selected month then the figure is zero. 
And so on for all the other Outreach figures.  Pity! It would have been easier 
(code wise) to just show the 'accumulated' figure.

b,c and d) Same reason as a) above.

e)The calculation of 'Number of Active Loans' is exactly that... the no. of 
active loans on the last day of the month selected. The 'Disbursement Amount' 
figures are for the amount disbursed during the month.  I did a query on keef 
mifos data (15th April) and it matches the report i.e. there no disbursals for 
DCL-Pragati, all for DCL-KRANTI.

f) I looked at the DW for 2011-03-31 (the report takes the arrears figure for 
last day of month selected).  There were 28 loans in arrears.  I have data from 
15th April and it showed up correctly in it when I ran the latest version of 
the report locally.  As you said, it doesnt in yours.  Are you running on 
current Digamber data or a test backup from march? If you had say only up to 
20th March there wouldn't be data for arrears cos it looks for last day of 
month.  Also, its possible its a bug that has been fixed... or that the ETL 
didn't complete fully (though I'm sure we would have heard about that).  



> MFI Progress Report shows incorrect values
> ------------------------------------------
>
>                 Key: MIFOSBI-301
>                 URL: http://mifosforge.jira.com/browse/MIFOSBI-301
>             Project: mifos business intelligence
>          Issue Type: Story
>            Reporter: Binny Gopinath Sreevas
>            Assignee: johnwoodlock
>            Priority: Critical
>              Labels: Digamber
>             Fix For: Mifos BI 1.2, Mifos BI 1.2 - Iteration 6
>
>         Attachments: DigamberReports.zip
>
>
> I took the MFI progress report for 2 branches: (reports attached)
> Jaipur Area Office - 
> Digamber_MFI_ProgressReport_ForMar2010ToMar2011_JaipurAreaOffice.pdf
> Jaipur Branch Office - 
> Digamber_MFI_ProgressReport_ForMar2010ToMar2011_JaipurBranch.pdf
> Many of the values displayed on this report is incorrect:
> a) Jaipur Area Office has 8 branches under it. But the report shows zero.
> b) Centers - As of today, there are 338 centers under Jaipur Area Office and 
> 105 centers under Jaipur Branch (based on my queries on the DB). The report 
> shows 7 and 5 as of March 2011.
> c) Groups - report shows 22 and 14 - for Jaipur Area office and Branch
> d) Clients - report shows 110 and 70 - for Jaipur Area office and Branch
> e) Product - DCL-Pragati shows 261 active loans. but disbursement amount is 
> zero.
> f) There are about 52 accounts which are "active in bad standing" i.e. 
> Account_State_ID = 9. But the report does not show any in arrears.
> Overall, the report does not seem to give accurate data.
> I just see too many issues to be listed exhaustively here.
> Note: Since these reports have production data, I have password protected the 
> zip file.
> Please contact me if you need to password.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to