[
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