[
http://mifosforge.jira.com/browse/MIFOSBI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau updated MIFOSBI-222:
-----------------------------
Fix Version/s: (was: Mifos BI 1.3)
> getting Collection Sheet is data hard... consolidate it
> -------------------------------------------------------
>
> Key: MIFOSBI-222
> URL: http://mifosforge.jira.com/browse/MIFOSBI-222
> Project: mifos business intelligence
> Issue Type: Improvement
> Reporter: johnwoodlock
> Assignee: johnwoodlock
> Priority: Major
>
> Technical Debt around collection sheet data and collection sheet reporting.
> Not expecting to address in current mifos or mifosbi release but its too
> complicated an area to allow too much duplication of data access rules.
> The proposal is to:
> use the retrieveCollectionSheet service to get all collection sheet data. If
> the report needs additional data or decoration then it should do that (via a
> custom higher level api/java work or an integration tool like Pentaho PDI)
> ----------- come about because...
> The query for the African collection sheet report is about 350 lines (maybe
> 300 without comment and spacing lines). This is way too much complexity for
> a single query. It's not a single query. What appears as a single query in
> the Pentaho report
> 1) gets the data that the retrieveCollectionSheet api does (already
> considered a complicated area of code)
> 2) get details of loan repayments that have been collected since the last
> meeting
> 3) does a lot of 'decoration' to allow the results to fit nicely into the
> report format
> ----- col sheet reporting not generic
> It's quite common for MFI's to have their own idea of a collection sheet
> report. Often, MFI's only use some of the capability of the collection
> sheet. Keef is the first one I've seen to want collections since last
> meeting (due to MPesa payment I believe).
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
