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

johnwoodlock commented on MIFOSBI-115:
--------------------------------------

additional notes for any digamber data discussion:

There were 3186 transactions related to 316 accounts that were previous to the 
account creation date: Migration?  Mainly a problem when getting stats for 
accounts in a particular status e.g active accounts on a certain day (quite a 
few of the standard reports are like that so it might throw figures off a bit)
- 405 disbursals happened prior to loan statuses of ApplicationApproved or 
DisbursedToLo.  That's nearly 10% of Digamber disbursals. 
about 1000 fee/charge repayments

also loan accounts (200) and customer accounts (36) had schedules created prior 
to account create date.

> Data Quality Check for Digamber data prior to setting up DW schedule
> --------------------------------------------------------------------
>
>                 Key: MIFOSBI-115
>                 URL: http://mifosforge.jira.com/browse/MIFOSBI-115
>             Project: mifos business intelligence
>          Issue Type: Story
>          Components: Data Warehouse
>    Affects Versions: Mifos BI 1.0 BETA - Iteration 12, Mifos BI 1.0 BETA
>            Reporter: johnwoodlock
>            Assignee: johnwoodlock
>             Fix For: Mifos BI 1.0 BETA - Iteration 12, Mifos BI 1.0 BETA
>
>         Attachments: ETLDigamberNotesOnInitialLoad.txt
>
>   Original Estimate: 3 hours
>  Remaining Estimate: 3 hours
>
> Run Digamber data through the ETL process to see if anything needs to be done 
> prior to creating a data warehouse and scheduling the ETL.

-- 
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

        

------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to