[
http://mifosforge.jira.com/browse/MIFOSBI-203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=63841#action_63841
]
johnwoodlock commented on MIFOSBI-203:
--------------------------------------
Fees/Charges and Penalties PAID for loans and customers are already in DW.
Misc. Fees/Charges and Misc Penalties SCHEDULED for loans are already in DW.
Misc. Fees/Charges and Misc Penalties SCHEDULED for customers and any fees that
end up on loan_fee_schedule & customer_fee_schedule are not in the DW.
I think the work involved should drop dw_loan_schedules table and create
fact_loan_schedules, fact_loan_fees_and_charges_scheduled and
fact_customer_fees_and_charges_scheduled (column definitions to be defined but
done in dimension modelling format like the equivalent 'paid' tables).
Also I linked in the Jira issue to create timestamps that will be very useful
when extracting schedule info by the incremental DW job (the one that only
loads data additional to the last time the job was run).
This is generic DW work but (without running the impact analysis) I think the
Due vs Collected reports are the only ones affected.
Its a good chunk of work but fairly systematic as it should follow the pattern
used for 'paid' tables.
> Add Fees and Penalties columns to Due vs Collected reports
> ----------------------------------------------------------
>
> Key: MIFOSBI-203
> URL: http://mifosforge.jira.com/browse/MIFOSBI-203
> Project: mifos business intelligence
> Issue Type: Story
> Affects Versions: Mifos BI 1.0
> Reporter: Jakub Sławiński
> Assignee: Jakub Sławiński
> Fix For: Mifos BI 1.1 - Iteration 1, Mifos BI 1.1
>
>
> Add Fees and Penalties column - should be total of Loan and Client.
> The idea is you want to see what was due and collected and that should
> include fees or penalties that you have collected.
> Since these reports should only be run for the past (not the future), then it
> sounds like we should bring into the DW? Yes, we should bring the schedule
> and fee_schedule tables to the DW but in 'fact_' table style not 'dw_' style
> (which the loan_schedules are in currently)
--
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
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
