[ 
http://mifosforge.jira.com/browse/MIFOSBI-316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Lukasz Chudy updated MIFOSBI-316:
---------------------------------

    Status: Ready for Showcase  (was: Ready for Testing / Resolved)

Verified on 13.07.2011
When there are duplicated Loan Officer names then ETL is not stopping and as 
John wrote in dim_customer table in loan_officer_key and 
formed_by_loan_officer_key columns there are "0" for the Loan Officers with 
duplicated names.

> ETL Stops if Staff Names have Duplicates
> ----------------------------------------
>
>                 Key: MIFOSBI-316
>                 URL: http://mifosforge.jira.com/browse/MIFOSBI-316
>             Project: mifos business intelligence
>          Issue Type: Improvement
>    Affects Versions: Mifos BI 1.2
>            Reporter: johnwoodlock
>            Assignee: johnwoodlock
>             Fix For: Mifos BI 1.3
>
>
> Currently, the ETL will stop near its start if there are duplicate Personnel 
> display_names (and takes name changes into account to).  Mifos allows 
> duplicate display_names but the ETL doesn't because the audit tables use the 
> display_name rather then the personnel_id to record loan officer 
> reassignments... so a duplicate display_name mean ambiguity.
> Proposal is to identify when this problem occurs for loan officer 
> reassignment and Warn instead of stop and allocate for the time being to 
> personnel '-1' which is a bucket to identify the extent of this problem.

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

        

------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric 
Ries, the creator of the Lean Startup Methodology on "Lean Startup 
Secrets Revealed." This video shows you how to validate your ideas, 
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to