[Mifos-users] Pentaho Reports in Mifos

84 views
Skip to first unread message

Paweł Gesek

unread,
May 31, 2012, 10:50:04 AM5/31/12
to mifos...@lists.sourceforge.net, mifos-d...@lists.sourceforge.net
Hello everyone,

we have included over 20 Pentaho reports from Mifos-BI in the standard
Mifos distribution. These will be included in the next Mifos release,
but you can test them even now on the test servers:
http://ci.mifos.org:8085/mifos/ . It is also possible to upload your own
Pentaho reports, the same way as you upload Birt reports.

Regards
Paweł Gesek

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users

Thomas (Uganda)

unread,
May 31, 2012, 12:32:35 PM5/31/12
to mifos...@lists.sourceforge.net
This is exceptional work Pawel. Thanx

Hopefully it will be in time for the 2.4 release. Look forward 2
testing them out on a live deployment.

Best Regards


On May 31, 5:50 pm, Paweł Gesek <pge...@soldevelo.com> wrote:
> Hello everyone,
>
> we have included over 20 Pentaho reports from Mifos-BI in the standard
> Mifos distribution. These will be included in the next Mifos release,

> but you can test them even now on the test servers:http://ci.mifos.org:8085/mifos/. It is also possible to upload your own


> Pentaho reports, the same way as you upload Birt reports.
>
> Regards
> Paweł Gesek
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware

> threats.http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Mifos-users mailing list
> Mifos-us...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/mifos-users

Ed Cable

unread,
May 31, 2012, 9:47:39 PM5/31/12
to A good place to start for users or folks new to Mifos.
Echoing Thomas, job well done!

I updated the Master List of Reports with which run directly in Mifos and which only run in Mifos BI.


Do you know if the Outreach Summary by Branch report should be available in the embedded reports? I don't ever recall seeing this report but saw it in the master list.

Thomas - these are scheduled to be available for the 2.4 (Vinolia I release).  

Ramesh Nayak

unread,
Jun 1, 2012, 11:49:56 PM6/1/12
to Mifos software development, mifos...@lists.sourceforge.net
Hi Pawel,

I uploaded one pentaho report to test server(Report Title is Test and Report Category is Performance).

When I click on that report its giving the error message as "Access Denied You are not allowed to access this page".

Could you please give me detailed explanation of how to upload pentaho reports and how to access the uploaded reports.


Thanks and Regards,
Ramesh


On Thu, May 31, 2012 at 8:20 PM, Paweł Gesek <pge...@soldevelo.com> wrote:
Hello everyone,

we have included over 20 Pentaho reports from Mifos-BI in the standard
Mifos distribution. These will be included in the next Mifos release,
but you can test them even now on the test servers:
http://ci.mifos.org:8085/mifos/ . It is also possible to upload your own
Pentaho reports, the same way as you upload Birt reports.

Regards
Paweł Gesek

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats.
http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Mifos-developer mailing list
mifos-d...@lists.sourceforge.net
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer



--
Thanks and Regards,
Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :ramesh....@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Contact Number - Mob : +919739317276.
 

Vishwas Babu A J

unread,
Jun 2, 2012, 12:25:49 AM6/2/12
to Mifos software development, Ramesh Nayak, mifos...@lists.sourceforge.net
Hi Ramesh,

Upon enabling Admin access to your newly added report, I am able to access your newly added report on the test server.
Thanks and Regards,
Vishwas
Cell    : +91-9986077286
Skype Id: vishwasbabu

Thomas (Uganda)

unread,
Jun 20, 2012, 3:06:55 AM6/20/12
to mifos...@lists.sourceforge.net
Hi Pawel, am currently using Tomcat 7 on mifos 2.4. However I cannot
generate the integrated reports. I get error below.
Is there any changes i need to make to Tomcat to view these reports.
Tx
************************************************************************************************************************************************
(org.mifos.core.MifosRuntimeException:
java.lang.NullPointerException:
Key data must not be null.
at
org.mifos.reports.pentaho.service.PentahoReportsServiceImpl.loadReport(PentahoReportsServiceImpl.java:
207)

Caused by: java.lang.NullPointerException: Key data must not be null.

*************************************************************************************************************************************************

On May 31, 5:50 pm, Paweł Gesek <pge...@soldevelo.com> wrote:

> Hello everyone,
>
> we have included over 20 Pentaho reports from Mifos-BI in the standard
> Mifos distribution. These will be included in the next Mifos release,

> but you can test them even now on the test servers:http://ci.mifos.org:8085/mifos/. It is also possible to upload your own


> Pentaho reports, the same way as you upload Birt reports.
>
> Regards
> Paweł Gesek
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware

> threats.http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Mifos-users mailing list
> Mifos-us...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/mifos-users

Lukasz Chudy

unread,
Jun 20, 2012, 6:58:08 AM6/20/12
to A good place to start for users or folks new to Mifos., Thomas (Uganda)
Hi Thomas,

I created Jira ticket for this issue
http://mifosforge.jira.com/browse/MIFOS-5682 and I will let you know
once this issue is resolved.

Regards,
Lukasz

Lukasz Chudy

unread,
Jun 22, 2012, 8:26:06 AM6/22/12
to A good place to start for users or folks new to Mifos., Thomas (Uganda)
Hi Thomas,

This issue occurs only when you are using mifos CF war. If you use normal Mifos 2.4.0 war and Tomcat 7, then reports should work properly, but you need to configure Tomcat:

Add the following JNDI items for a pentaho reports at <GlobalNamingResources> section in file server.xml located in TOMCAT/conf directory (remember to modify SourceDB and DestinationDB parameters accordingly to your databases configuration):

<Resource type="javax.sql.DataSource"
name="jdbc/SourceDB"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mifos"
username="mifos"
password="mifos"
initialSize="3"
maxActive="20"
maxIdle="15"
minIdle="3"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000"
logAbandoned="true"
suspectTimeout="60"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;ResetAbandonedTimer" />

<Resource type="javax.sql.DataSource"
name="jdbc/DestinationDB"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mifos_dw"
username="mifos"
password="mifos"
initialSize="3"
maxActive="20"
maxIdle="15"
minIdle="3"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000"
logAbandoned="true"
suspectTimeout="60"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;ResetAbandonedTimer" />

Also, you need to make sure that 'tomcat-jdbc.jar' file is in the TOMCAT/lib directory. If not, then you download it from here http://dev.mysql.com/downloads/connector/j/.

After completing above steps, restart Tomcat and Pentaho reports should be working properly.

Issue in Mifos 2.4.0-CF will be fixed in the maintenance release.

Regards,
Lukasz

Thomas (Uganda)

unread,
Jul 13, 2012, 4:09:22 AM7/13/12
to mifos...@lists.sourceforge.net
Hi Pawel,

I would like to ask for assistance in generating 3 major reports

1) Loans Disbursed (By Date range and Loan Product)
2) Loan Repayments Made (By Date Range and Loan Procduct)
3) Expected Loan Repayments (By Date Range and Loan Product)


All these could have columns i.e
Client Name | Loan Amount | Interest Rate | Disbursal Date | Repaid
Pricpl | Repaid Interest | Outsatnding Pripl | OutStanding Interest |
Loan Officer

Is there a way you could assist in designing these, or mayb show how i
could generate and upload them into Mifos List of Reports

Thanx, Best Regards

On May 31, 5:50 pm, Paweł Gesek <pge...@soldevelo.com> wrote:

> Hello everyone,
>
> we have included over 20 Pentaho reports from Mifos-BI in the standard
> Mifos distribution. These will be included in the next Mifos release,

> but you can test them even now on the test servers:http://ci.mifos.org:8085/mifos/. It is also possible to upload your own


> Pentaho reports, the same way as you upload Birt reports.
>
> Regards
> Paweł Gesek
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware

> threats.http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Mifos-users mailing list
> Mifos-us...@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/mifos-users

Reply all
Reply to author
Forward
0 new messages