Profile

Claudio Battaglino

Contact Details

My Content

1 to 16 of 16 total
Posted By Claudio Battaglino 07-13-2023 19:09
Found In Community: Pentaho
\ view thread
Excuse me. I've solved the problem changing the password using the Spoon (PDI) interface in this way: The table involved is: r_user.
Posted By Claudio Battaglino 07-13-2023 18:30
Found In Community: Pentaho
\ view thread
Hi, I've Pentaho Server CE 9.4 on which I have enabled the Ldap authentication and the jobs and the procedures are stored on a Postgresql database. When I connect my PDI client (Kettle) to the server I can see that the account admin still works. How can I change the password of the admin user? Thank ...
Posted By Claudio Battaglino 06-20-2023 10:09
Found In Community: Pentaho
\ view thread
Hi, I'm trying to activate Ldap Authentication on Pentaho Server CE 9.4 with the manual configuration. As suggested in the official guide, I've modified the following files: security.properties applicationContext-security-ldap.properties repository.spring.properties However, with this configuration only ...
Posted By Claudio Battaglino 04-05-2023 06:53
Found In Community: Pentaho
\ view thread
Ok John, don't worry.  Yes it is the Pentaho Report Designer. We sometimes use it to create reports in PDF. What tool do you use to create the PDF report after creating the data Model? Claudio B.
Posted By Claudio Battaglino 04-04-2023 11:56
Found In Community: Pentaho
\ view thread
Hi, I've solved using this post: https://github.com/WilldooIT/Pentaho-reports-for-OpenERP/issues/183 cld
Posted By Claudio Battaglino 04-04-2023 03:49
Found In Community: Pentaho
\ view thread
Hi John, thank you for your answer. Really my problem is a bit simpler. I already use the data of the query (that uses avg..) to show a table into the header of the report and it works well. I'd like to use the same data to show a chart. In Pentaho Report I have this situation: I don't know how to configure ...
Posted By Claudio Battaglino 03-28-2023 09:35
Found In Community: Pentaho
\ view thread
Hi, I have to add into a Pentaho report a Chart like this one: This should be the representation of a query that returns only one row like this: SELECT     ROUND(AVG(es.i01), 2) AS risp1,     ROUND(AVG(es.i02), 2) AS risp2,     ROUND(AVG(es.i03), 2) AS risp3,     ROUND(AVG(es.i04),2) AS risp4,     ROUND(AVG(es.i05), ...
Posted By Claudio Battaglino 02-08-2023 13:44
Found In Egroup: Pentaho
\ view thread
Hi, is it possible to enable the SAML authentication on Pentaho Server CE 9.4? Our IDP uses the protocol Shibboleth 4.1. Thank you very much Claudio B. ------------------------------ Claudio Battaglino ------------------------------
Posted By Claudio Battaglino 09-23-2022 04:20
Found In Egroup: Pentaho
\ view thread
Hi, is it possible to publish a report or a dashboard so that it is accessible without authentication? I'm using Pentaho 9.2. Thank you very much Claudio B. ------------------------------ Claudio Battaglino ------------------------------
Posted By Claudio Battaglino 05-17-2022 11:15
Found In Egroup: Pentaho
\ view thread
Ok, I have solved. It was not a problem of a connector, I apologize to all you. The fact is that the on the new database Mysql 8 we changed the password of the user that executes query. I changed it on the file kettle.proporties on my pc, but not on the server. On the server there is this file:  ...
Posted By Claudio Battaglino 05-17-2022 10:03
Found In Egroup: Pentaho
\ view thread
Really now I've seen that also using the driver: mysql-connector-java-5.1.49.jar The connection between the pentaho server and Mysql 8 works. That is I can create a datasource and test that the connection works. Only the schedulations of jobs that execute query on Mysql 8 fail. The execution of ...
Posted By Claudio Battaglino 05-11-2022 03:08
Found In Egroup: Pentaho
\ view thread
Hi Andrew,                      "I've been connecting to MySQL 8 databases for the past three years.  I just confirmed it works in 9.2 and 9.3" this is good news, so there is hope :-) But are you using the Mysql driver or the generic driver? And the MySQL user uses the protocol "mysql_native_password" ...
Posted By Claudio Battaglino 05-09-2022 08:54
Found In Egroup: Pentaho
\ view thread
Hi, is there an official procedure to update Pentaho 9.2 to Pentaho 9.3? I mean the Pentaho CE. Thank you very much Claudio B. ------------------------------ Claudio Battaglino ------------------------------
Posted By Claudio Battaglino 05-09-2022 03:59
Found In Egroup: Pentaho
\ view thread
Thank you Andrew for your reply. I didn't know that xactions were deprecated. So which is the right way to schedule jobs on a Pentaho server 9.2? Clearing the cache doesn't solve the problem and I have only one MySQL-connector-java-8.0.29.jar. in the tomcat/lib directory. I've tried to use ...
Posted By Claudio Battaglino 09-16-2021 13:21
Found In Community: Pentaho
\ view thread
Hi, Id like to configure LDAP authentication on Pentahon Server 9.2 CE but I cant see the Authentication menu. Should I enable it somewhere?       Thank you   Claudio
Posted By Claudio Battaglino 07-16-2021 12:07
Found In Community: Pentaho
\ view thread
Hi, I have a dashboard that has an Olap selector that drives the content of some charts. These charts use as datasource a query done with mdx over mondrianJndi. In this case the condition is: WHERE $(academicYearFilterParameter)   Now, in the same dashboard, I have a table that uses as datasource a query ...