[
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