[
http://mifosforge.jira.com/browse/MIFOSBI-222?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=64540#action_64540
]
johnwoodlock commented on MIFOSBI-222:
--------------------------------------
I was going to come up with a few options for this....
1) PDI ... good but still feel a big funny about needing to call the PDI layer
for each center
2) stored procedure... excellent! Works for reports and mifos :) but Van and
Adam F will have concerns...
Having read http://www.sherito.org/2010/12/santa-dropped-cda-datasources.html
it should be possible to put the query in CDA (pentaho lightweight data thing
we currently use for parameters and dashboards) so it can be re-used (and
augmented if necessary) by more than one report. This is probably a better
option than PDI. Havent tried it yet tho.
> 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
> 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.
-
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
------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
