You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Bharath Gowda <bg...@mifos.org> on 2020/06/30 07:21:52 UTC
Fineract Dev Pentaho Reports Issue Discussion
Hello Everyone,
Initiating this thread to understand and discuss a solution for the Pentaho
reporting issues which has surfaced recently.
1. From which version, Fineract has stopped supporting Pentaho due to
Licencing issues?
2. When we run a Pentaho report on Develop version, we get an sql
injection error like below, Will it be appropriate to raise an issue to
handle the pentaho errors (if it is due to the licence support issue) which
will help the users to understand better?
{"developerMessage":"The request was invalid. This typically will happen
due to validation errors which are
provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
Commands
found","userMessageGlobalisationCode":"error.msg.found.sql.injection
3. Should we discuss an alternate solution for this? Our stretchy reports
have limitations, many value added reports (with design and calculations)
will not work with stretchy reports.
From an organization users perspective, this might become a bottleneck for
their End/Beginning of the Day/Month/Year Business Reconciliations.
Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019636073
http://mifos.org <http://facebook.com/mifos>
<http://www.twitter.com/mifos>
On Tue, Jun 30, 2020 at 12:02 AM Saransh Sharma <sa...@muellners.org>
wrote:
> Currently fineract does not support Pentaho reports due to Licensing
> issues.
>
> You can use or integrate some oss version of reporting engine if you want.
>
> Thanks
>
> Though Inbuilt Sql based reporting is also quite usable and powerful.
>
> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent, <vi...@gmail.com>
> wrote:
>
>> Hello Dev
>>
>> I have an instance running locally from the latest fineract repository
>> and also have accessed dev.mifos.io
>>
>> In both cases the Pentaho Reports show blank white screen. Am asking for
>> guidance on how to utilize Pentaho Reports on fineract
>> https://github.com/apache/fineract
>>
>> Kind Regards.
>>
> Mifos-developer mailing list
> mifos-developer@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
Re: Fineract Dev Pentaho Reports Issue Discussion
Posted by Avik Ganguly <av...@fynarfin.io>.
Hi all,
Interesting topic. I think older Pentaho versions were GNU Lesser General
Public License and now it's Pentaho Reporting Enterprise Edition license.
Functionality-wise, we are primarily exploring Redash (other than
visualization what report designing capabilities it has) for going
forward. Redash has BSD 2-Clause "Simplified" License.
Superset is also on our radar in terms of familiarity and Apache license.
With best regards,
Avik.
ᐧ
On Tue, Jun 30, 2020 at 7:40 PM Luis Alberto Alegría de los Santos
<lu...@innovar.app> wrote:
> Hi all
>
> Ed, is it possible for an IF to compile fineract with pentaho support by
> themselves, without infringing licenses?
>
> If this is possible I could do a guide, I have done some tests to support
> pentaho to fineract 1.2 and I was able to compile the code with class
> "PentahoReportingProcessServiceImpl.java". I am not done yet, I need to
> debug the code and do more tests, at this moment it still does not work,
> however with the help of the most experienced developers I think it is
> possible.
>
> I think that being able to access the reports from the MIFOS X itself is
> something that gives added value and makes the operation easier for end
> users. And if there are no problems with the licenses, it is worth it to be
> able to use the 95 pentaho reports that exist, as well as the ones that the
> FIs could have created.
>
> Best regards
>
> El mar., 30 jun. 2020 a las 2:38, Ankit Muellner (<an...@muellners.org>)
> escribió:
>
>> Hey Bharat, Thanks for putting together this thread.
>> As Saransh pointed out, not only integration of Pentaho with latest
>> versions started extinguishing, I have noticed that this Pentaho
>> integration misses out a lot more requirements.
>>
>> *3.* Clearly, a new external open solution needs to be integrated
>> because of the following scenarios:
>> a.) No ability for generating an external feed of reporting which many
>> FIs wish to use to report to their different Information Systems. I am
>> talking about file interchange format feeds. (CSV, excel is a limited
>> function.)
>> b.) Reports are not highly configurable as we promise with Pentaho. Of
>> Course, those with SQL knowhow can customize them. But somehow we have
>> missed out the aspect of this for non technical functional experts
>> routinely managing the system configuration of Fineract via community app.
>> Pentaho does not help in this direction.
>> c.) There is no user level encryption of the reports getting fired and up
>> for download, also at API level.(which of course can be extended & executed)
>> d.) The direct end points of granular level reporting(e.g accounting
>> reports in pentaho) are again missing which is increasingly becoming a
>> standard point of Financial reporting. e.g if an FI wishes to push their
>> portfolio reporting for an external securitization or better if Risk
>> reporting solutions need to be embedded, Pentaho does not support this to
>> the extent of 2020 level reporting.
>>
>> I would be happy to point a functional specification on a Jira Issue.
>> Prior to that, I am looking for a technical conversation of feasibility on
>> this thread.
>>
>> On Tue, Jun 30, 2020 at 9:22 AM Bharath Gowda <bg...@mifos.org> wrote:
>>
>>> Hello Everyone,
>>>
>>> Initiating this thread to understand and discuss a solution for the
>>> Pentaho reporting issues which has surfaced recently.
>>>
>>> 1. From which version, Fineract has stopped supporting Pentaho due to
>>> Licencing issues?
>>> 2. When we run a Pentaho report on Develop version, we get an sql
>>> injection error like below, Will it be appropriate to raise an issue to
>>> handle the pentaho errors (if it is due to the licence support issue) which
>>> will help the users to understand better?
>>>
>>> {"developerMessage":"The request was invalid. This typically will happen
>>> due to validation errors which are
>>> provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
>>> Commands
>>> found","userMessageGlobalisationCode":"error.msg.found.sql.injection
>>>
>>> 3. Should we discuss an alternate solution for this? Our stretchy
>>> reports have limitations, many value added reports (with design and
>>> calculations) will not work with stretchy reports.
>>>
>>> From an organization users perspective, this might become a bottleneck
>>> for their End/Beginning of the Day/Month/Year Business Reconciliations.
>>>
>>>
>>>
>>> Regards,
>>> Bharath
>>> Lead Implementation Analyst | Mifos Initiative
>>> Skype: live:cbharath4| Mobile: +91.7019636073
>>> http://mifos.org <http://facebook.com/mifos>
>>> <http://www.twitter.com/mifos>
>>>
>>>
>>> On Tue, Jun 30, 2020 at 12:02 AM Saransh Sharma <sa...@muellners.org>
>>> wrote:
>>>
>>>> Currently fineract does not support Pentaho reports due to Licensing
>>>> issues.
>>>>
>>>> You can use or integrate some oss version of reporting engine if you
>>>> want.
>>>>
>>>> Thanks
>>>>
>>>> Though Inbuilt Sql based reporting is also quite usable and powerful.
>>>>
>>>> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent, <
>>>> vincentkalanzi211@gmail.com> wrote:
>>>>
>>>>> Hello Dev
>>>>>
>>>>> I have an instance running locally from the latest fineract repository
>>>>> and also have accessed dev.mifos.io
>>>>>
>>>>> In both cases the Pentaho Reports show blank white screen. Am asking
>>>>> for guidance on how to utilize Pentaho Reports on fineract
>>>>> https://github.com/apache/fineract
>>>>>
>>>>> Kind Regards.
>>>>>
>>>> Mifos-developer mailing list
>>>> mifos-developer@lists.sourceforge.net
>>>> Unsubscribe or change settings at:
>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>>
>>>
>>
>> --
>> Ankit Müllner
>> Muellners Europe
>> +4581929792
>>
>> This mail is governed by Muellners® IT policy.
>> The information contained in this e-mail and any accompanying documents
>> may contain information that is confidential or otherwise protected from
>> disclosure. If you are not the intended recipient of this message, or if
>> this message has been addressed to you in error, please immediately alert
>> the sender by reply e-mail and then delete this message, including any
>> attachments. Any dissemination, distribution or other use of the contents
>> of this message by anyone other than the intended recipient is strictly
>> prohibited. All messages sent to and from this e-mail address may be
>> monitored as permitted by applicable law and regulations to ensure
>> compliance with our internal policies and to protect our business. E-mails
>> are not secure and cannot be guaranteed to be error free as they can be
>> intercepted, amended, lost or destroyed, or contain viruses. You are deemed
>> to have accepted these risks if you communicate with us by e-mail.
>>
>
>
> --
> LSC. Luis Alegría
> INNOVARAPP
>
> *La información contenida en este correo electrónico y anexos es
> confidencial. Ésta dirigida únicamente para el uso del individuo o entidad
> a la que fue dirigida y puede contener información propietaria que no es
> del dominio público. Si has recibido este correo por error o no eres el
> destinatario, por favor notificar al remitente de inmediato y borra este
> mensaje de la computadora o dispositivo. Cualquier uso, distribución o
> reproducción de este correo que no sea por el destinatario de intención
> queda prohibido.*
>
--
Disclaimer:
Privileged & confidential information is contained in this
message (including all attachments). If you are not an intended recipient
of this message, please destroy this message immediately and kindly notify
the sender by reply e-mail. Any unauthorised use or dissemination of this
message in any manner whatsoever, in whole or in part, is strictly
prohibited. This e-mail, including all attachments hereto, (i) is for
discussion purposes only and shall not be deemed or construed to be a
professional opinion unless expressly stated otherwise, and (ii) is not
intended, written or sent to be used, and cannot and shall not be used, for
any unlawful purpose. This communication, including any attachments, may
not be free of viruses, interceptions or interference, and may not be
compatible with your systems. You should carry out your own virus checks
before opening any attachment to this e-mail. The sender of this e-mail and
*Fynarfin Tech Private Limited* shall not be liable for any damage that
you may sustain as a result of viruses, incompleteness of this message, a
delay in receipt of this message or computer problems experienced.
Re: Fineract Dev Pentaho Reports Issue Discussion
Posted by Luis Alberto Alegría de los Santos <lu...@innovar.app>.
Hi all
Ed, is it possible for an IF to compile fineract with pentaho support by
themselves, without infringing licenses?
If this is possible I could do a guide, I have done some tests to support
pentaho to fineract 1.2 and I was able to compile the code with class
"PentahoReportingProcessServiceImpl.java". I am not done yet, I need to
debug the code and do more tests, at this moment it still does not work,
however with the help of the most experienced developers I think it is
possible.
I think that being able to access the reports from the MIFOS X itself is
something that gives added value and makes the operation easier for end
users. And if there are no problems with the licenses, it is worth it to be
able to use the 95 pentaho reports that exist, as well as the ones that the
FIs could have created.
Best regards
El mar., 30 jun. 2020 a las 2:38, Ankit Muellner (<an...@muellners.org>)
escribió:
> Hey Bharat, Thanks for putting together this thread.
> As Saransh pointed out, not only integration of Pentaho with latest
> versions started extinguishing, I have noticed that this Pentaho
> integration misses out a lot more requirements.
>
> *3.* Clearly, a new external open solution needs to be integrated because
> of the following scenarios:
> a.) No ability for generating an external feed of reporting which many FIs
> wish to use to report to their different Information Systems. I am talking
> about file interchange format feeds. (CSV, excel is a limited function.)
> b.) Reports are not highly configurable as we promise with Pentaho. Of
> Course, those with SQL knowhow can customize them. But somehow we have
> missed out the aspect of this for non technical functional experts
> routinely managing the system configuration of Fineract via community app.
> Pentaho does not help in this direction.
> c.) There is no user level encryption of the reports getting fired and up
> for download, also at API level.(which of course can be extended & executed)
> d.) The direct end points of granular level reporting(e.g accounting
> reports in pentaho) are again missing which is increasingly becoming a
> standard point of Financial reporting. e.g if an FI wishes to push their
> portfolio reporting for an external securitization or better if Risk
> reporting solutions need to be embedded, Pentaho does not support this to
> the extent of 2020 level reporting.
>
> I would be happy to point a functional specification on a Jira Issue.
> Prior to that, I am looking for a technical conversation of feasibility on
> this thread.
>
> On Tue, Jun 30, 2020 at 9:22 AM Bharath Gowda <bg...@mifos.org> wrote:
>
>> Hello Everyone,
>>
>> Initiating this thread to understand and discuss a solution for the
>> Pentaho reporting issues which has surfaced recently.
>>
>> 1. From which version, Fineract has stopped supporting Pentaho due to
>> Licencing issues?
>> 2. When we run a Pentaho report on Develop version, we get an sql
>> injection error like below, Will it be appropriate to raise an issue to
>> handle the pentaho errors (if it is due to the licence support issue) which
>> will help the users to understand better?
>>
>> {"developerMessage":"The request was invalid. This typically will happen
>> due to validation errors which are
>> provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
>> Commands
>> found","userMessageGlobalisationCode":"error.msg.found.sql.injection
>>
>> 3. Should we discuss an alternate solution for this? Our stretchy reports
>> have limitations, many value added reports (with design and calculations)
>> will not work with stretchy reports.
>>
>> From an organization users perspective, this might become a bottleneck
>> for their End/Beginning of the Day/Month/Year Business Reconciliations.
>>
>>
>>
>> Regards,
>> Bharath
>> Lead Implementation Analyst | Mifos Initiative
>> Skype: live:cbharath4| Mobile: +91.7019636073
>> http://mifos.org <http://facebook.com/mifos>
>> <http://www.twitter.com/mifos>
>>
>>
>> On Tue, Jun 30, 2020 at 12:02 AM Saransh Sharma <sa...@muellners.org>
>> wrote:
>>
>>> Currently fineract does not support Pentaho reports due to Licensing
>>> issues.
>>>
>>> You can use or integrate some oss version of reporting engine if you
>>> want.
>>>
>>> Thanks
>>>
>>> Though Inbuilt Sql based reporting is also quite usable and powerful.
>>>
>>> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent, <vi...@gmail.com>
>>> wrote:
>>>
>>>> Hello Dev
>>>>
>>>> I have an instance running locally from the latest fineract repository
>>>> and also have accessed dev.mifos.io
>>>>
>>>> In both cases the Pentaho Reports show blank white screen. Am asking
>>>> for guidance on how to utilize Pentaho Reports on fineract
>>>> https://github.com/apache/fineract
>>>>
>>>> Kind Regards.
>>>>
>>> Mifos-developer mailing list
>>> mifos-developer@lists.sourceforge.net
>>> Unsubscribe or change settings at:
>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>
>>
>
> --
> Ankit Müllner
> Muellners Europe
> +4581929792
>
> This mail is governed by Muellners® IT policy.
> The information contained in this e-mail and any accompanying documents
> may contain information that is confidential or otherwise protected from
> disclosure. If you are not the intended recipient of this message, or if
> this message has been addressed to you in error, please immediately alert
> the sender by reply e-mail and then delete this message, including any
> attachments. Any dissemination, distribution or other use of the contents
> of this message by anyone other than the intended recipient is strictly
> prohibited. All messages sent to and from this e-mail address may be
> monitored as permitted by applicable law and regulations to ensure
> compliance with our internal policies and to protect our business. E-mails
> are not secure and cannot be guaranteed to be error free as they can be
> intercepted, amended, lost or destroyed, or contain viruses. You are deemed
> to have accepted these risks if you communicate with us by e-mail.
>
--
LSC. Luis Alegría
INNOVARAPP
*La información contenida en este correo electrónico y anexos es
confidencial. Ésta dirigida únicamente para el uso del individuo o entidad
a la que fue dirigida y puede contener información propietaria que no es
del dominio público. Si has recibido este correo por error o no eres el
destinatario, por favor notificar al remitente de inmediato y borra este
mensaje de la computadora o dispositivo. Cualquier uso, distribución o
reproducción de este correo que no sea por el destinatario de intención
queda prohibido.*
Re: Fineract Dev Pentaho Reports Issue Discussion
Posted by Ankit Muellner <an...@muellners.org>.
Hey Bharat, Thanks for putting together this thread.
As Saransh pointed out, not only integration of Pentaho with latest
versions started extinguishing, I have noticed that this Pentaho
integration misses out a lot more requirements.
*3.* Clearly, a new external open solution needs to be integrated because
of the following scenarios:
a.) No ability for generating an external feed of reporting which many FIs
wish to use to report to their different Information Systems. I am talking
about file interchange format feeds. (CSV, excel is a limited function.)
b.) Reports are not highly configurable as we promise with Pentaho. Of
Course, those with SQL knowhow can customize them. But somehow we have
missed out the aspect of this for non technical functional experts
routinely managing the system configuration of Fineract via community app.
Pentaho does not help in this direction.
c.) There is no user level encryption of the reports getting fired and up
for download, also at API level.(which of course can be extended & executed)
d.) The direct end points of granular level reporting(e.g accounting
reports in pentaho) are again missing which is increasingly becoming a
standard point of Financial reporting. e.g if an FI wishes to push their
portfolio reporting for an external securitization or better if Risk
reporting solutions need to be embedded, Pentaho does not support this to
the extent of 2020 level reporting.
I would be happy to point a functional specification on a Jira Issue. Prior
to that, I am looking for a technical conversation of feasibility on this
thread.
On Tue, Jun 30, 2020 at 9:22 AM Bharath Gowda <bg...@mifos.org> wrote:
> Hello Everyone,
>
> Initiating this thread to understand and discuss a solution for the
> Pentaho reporting issues which has surfaced recently.
>
> 1. From which version, Fineract has stopped supporting Pentaho due to
> Licencing issues?
> 2. When we run a Pentaho report on Develop version, we get an sql
> injection error like below, Will it be appropriate to raise an issue to
> handle the pentaho errors (if it is due to the licence support issue) which
> will help the users to understand better?
>
> {"developerMessage":"The request was invalid. This typically will happen
> due to validation errors which are
> provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
> Commands
> found","userMessageGlobalisationCode":"error.msg.found.sql.injection
>
> 3. Should we discuss an alternate solution for this? Our stretchy reports
> have limitations, many value added reports (with design and calculations)
> will not work with stretchy reports.
>
> From an organization users perspective, this might become a bottleneck for
> their End/Beginning of the Day/Month/Year Business Reconciliations.
>
>
>
> Regards,
> Bharath
> Lead Implementation Analyst | Mifos Initiative
> Skype: live:cbharath4| Mobile: +91.7019636073
> http://mifos.org <http://facebook.com/mifos>
> <http://www.twitter.com/mifos>
>
>
> On Tue, Jun 30, 2020 at 12:02 AM Saransh Sharma <sa...@muellners.org>
> wrote:
>
>> Currently fineract does not support Pentaho reports due to Licensing
>> issues.
>>
>> You can use or integrate some oss version of reporting engine if you
>> want.
>>
>> Thanks
>>
>> Though Inbuilt Sql based reporting is also quite usable and powerful.
>>
>> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent, <vi...@gmail.com>
>> wrote:
>>
>>> Hello Dev
>>>
>>> I have an instance running locally from the latest fineract repository
>>> and also have accessed dev.mifos.io
>>>
>>> In both cases the Pentaho Reports show blank white screen. Am asking for
>>> guidance on how to utilize Pentaho Reports on fineract
>>> https://github.com/apache/fineract
>>>
>>> Kind Regards.
>>>
>> Mifos-developer mailing list
>> mifos-developer@lists.sourceforge.net
>> Unsubscribe or change settings at:
>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
>
--
Ankit Müllner
Muellners Europe
+4581929792
This mail is governed by Muellners® IT policy.
The information contained in this e-mail and any accompanying documents may
contain information that is confidential or otherwise protected from
disclosure. If you are not the intended recipient of this message, or if
this message has been addressed to you in error, please immediately alert
the sender by reply e-mail and then delete this message, including any
attachments. Any dissemination, distribution or other use of the contents
of this message by anyone other than the intended recipient is strictly
prohibited. All messages sent to and from this e-mail address may be
monitored as permitted by applicable law and regulations to ensure
compliance with our internal policies and to protect our business. E-mails
are not secure and cannot be guaranteed to be error free as they can be
intercepted, amended, lost or destroyed, or contain viruses. You are deemed
to have accepted these risks if you communicate with us by e-mail.
Re: Fineract Dev Pentaho Reports Issue Discussion
Posted by Ed Cable <ed...@mifos.org>.
Thanks Bharath for your reply. To add to what Saransh said, Pentaho reports
don't ship with the Fineract release due to license constraints but they
still ship with the Mifos X discuss distribution on top of Fineract and one
could also grab the reports from this distribution and run against the
latest Fineract version.
Bharath, can you clarify on the that process and link to any available
documentation?
Thanks,
Ed
On Tue, Jun 30, 2020, 00:22 Bharath Gowda <bg...@mifos.org> wrote:
> Hello Everyone,
>
> Initiating this thread to understand and discuss a solution for the
> Pentaho reporting issues which has surfaced recently.
>
> 1. From which version, Fineract has stopped supporting Pentaho due to
> Licencing issues?
> 2. When we run a Pentaho report on Develop version, we get an sql
> injection error like below, Will it be appropriate to raise an issue to
> handle the pentaho errors (if it is due to the licence support issue) which
> will help the users to understand better?
>
> {"developerMessage":"The request was invalid. This typically will happen
> due to validation errors which are
> provided.","httpStatusCode":"400","defaultUserMessage":"Unexpected SQL
> Commands
> found","userMessageGlobalisationCode":"error.msg.found.sql.injection
>
> 3. Should we discuss an alternate solution for this? Our stretchy reports
> have limitations, many value added reports (with design and calculations)
> will not work with stretchy reports.
>
> From an organization users perspective, this might become a bottleneck for
> their End/Beginning of the Day/Month/Year Business Reconciliations.
>
>
>
> Regards,
> Bharath
> Lead Implementation Analyst | Mifos Initiative
> Skype: live:cbharath4| Mobile: +91.7019636073
> http://mifos.org <http://facebook.com/mifos>
> <http://www.twitter.com/mifos>
>
>
> On Tue, Jun 30, 2020 at 12:02 AM Saransh Sharma <sa...@muellners.org>
> wrote:
>
>> Currently fineract does not support Pentaho reports due to Licensing
>> issues.
>>
>> You can use or integrate some oss version of reporting engine if you
>> want.
>>
>> Thanks
>>
>> Though Inbuilt Sql based reporting is also quite usable and powerful.
>>
>> On Mon, 29 Jun 2020, 23:11 Kalanzi Vincent, <vi...@gmail.com>
>> wrote:
>>
>>> Hello Dev
>>>
>>> I have an instance running locally from the latest fineract repository
>>> and also have accessed dev.mifos.io
>>>
>>> In both cases the Pentaho Reports show blank white screen. Am asking for
>>> guidance on how to utilize Pentaho Reports on fineract
>>> https://github.com/apache/fineract
>>>
>>> Kind Regards.
>>>
>> Mifos-developer mailing list
>> mifos-developer@lists.sourceforge.net
>> Unsubscribe or change settings at:
>> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
>