Profile

Claudio Battaglino

cbc

Contact Details

cbc

My Content

1 to 16 of 16 total
Posted By Claudio Battaglino 01-19-2024 06:11
Found In Community: Pentaho
\ view thread
Hi, I'm using Pentaho PDI (Spoon) to read data from an Oracle database and move them, after some manipulation, into Pentaho's Postgresql database. Now I have to mix some rows based on a rule. That is I have to mix couple of rows like these: K1 K2 a3 a4 a5 a6 K1 K2 a3 a4 b5 b6 Where K1 K2 is the key to ...
Posted By Claudio Battaglino 09-07-2023 03:43
Found In Community: Pentaho
\ view thread
Thank you for your suggestions. I've solved downloading the file (.cdfde), modifying the source of this file with a text editor (I had only to remove the last row), deleting on Pentaho this file, and importing the modified file. It's strange that this bug has been around for years and hasn't been fixed ...
Posted By Claudio Battaglino 09-05-2023 05:45
Found In Community: Pentaho
\ view thread
Hi, I have this CDE dashboard on Pentaho 9.4 CE: If I try to edit, move or delete the dashboard's last row, the page becomes unresponsive. I think it's a bug that Pentaho has always had and hasn't fixed yet, do you know if there is a workaround or solution? Thank you very much Claudio
Posted By Claudio Battaglino 07-31-2023 15:26
Found In Community: Pentaho
\ view thread
Hi, is there a way on Pentaho Server 9.4 to add a callable endpoint that allows, using Javascript,  a CDE dashboard to add items into a table used by this dashboard? I mean, I have a dashboard with some tables and I have to allow the user to add the items of this dashboard on another table (selected ...
Posted By Claudio Battaglino 07-26-2023 04:29
Found In Community: Pentaho
\ view thread
I'm reading the documentation of the exportData function: https://help.hitachivantara.com/Documentation/Pentaho/8.2/Developer_Center/CDF_API/cdf.queries.CdaQuery#exportData Probably I can use the overrides parameter, but there are no examples, how can I override a query? Or probably I can use the export ...
Posted By Claudio Battaglino 07-24-2023 07:05
Found In Community: Pentaho
\ view thread
Hi, I have a CDE Dashboard with a table that shows some data. I've added  a button with this Javascript to export the data of the table: function exportTablePaInCsv(e) ( return this.Dashboards.getComponent('render_TabellaPa').queryState.exportData('csv') ) This exports all the columns of the table. Is ...
Posted By Claudio Battaglino 06-29-2023 04:15
Found In Community: Pentaho
\ view thread
I've found this solution: " Pentaho Data Integration Tool A: To enable the option, open options dialog box by selecting Edit- >Options from the menu bar and check the display tool tip Q13: How to resolve the following error? Kettle.ERROR_ RDBMS access to transformation not allowed when repository type ...
Posted By Claudio Battaglino 06-28-2023 16:42
Found In Community: Pentaho
\ view thread
Hi, when I execute "Run now" on a scheduled job, on the web interface of a Pentaho Server, I have this error : 6:58,393 ERROR [KettleComponent] 8725a00b-15f3-11ee-bad9-a288d66c0349:COMPONENT:context-452996252-1687984618369:j_load_accademici_datamart.xactionKettle.ERROR_0019 - [it_368] RDBMS access to ...
Posted By Claudio Battaglino 06-28-2023 02:55
Found In Egroup: Pentaho
\ view thread
Hi, I was using the file system way because I'm trying to build a Pentaho container from a virtual machine. However I was also looking for a way to make backups of the site and this seems a great way to do it. Thank you very much, it is really useful. Claudio b. ------------------------------ ...
Posted By Claudio Battaglino 06-27-2023 09:32
Found In Egroup: Pentaho
\ view thread
Ok, the path is:  pentaho-solutions/system/jackrabbit/repository ------------------------------ Claudio Battaglino IT Support Manager cbc ------------------------------
Posted By Claudio Battaglino 06-27-2023 06:43
Found In Egroup: Pentaho
\ view thread
Hi, but do you mean pentaho-server/data/hsqldb ? Because if I copy all the "data" directory and its subdirectories into another installation of Pentaho I can't see the folders created in the first server. It starts as an empty server. Why does this happen? Claudio -------- ...
Posted By Claudio Battaglino 06-21-2023 03:36
Found In Community: Pentaho
\ view thread
Hi, I can't figure out how the user-roles association works during LDAP authentication. It seems it is managed by these parameters: populator.convertToUpperCase=false populator.groupRoleAttribute=cn populator.groupSearchBase=OU\=Team-XXXX,OU\=XXXXUsers,DC\=xxxx,DC\=org populator.groupSearchFilter=(member\=(0)) ...
Posted By Claudio Battaglino 04-04-2023 11:32
Found In Community: Pentaho
\ view thread
Hi, I have the same problem with Pentaho Report Designer 9.2. And accented vocals are missing if they come from a database field but also if they are simply text labels. Did you solve this problem? Thank you Claudio B.
Posted By Claudio Battaglino 03-07-2023 13:07
Found In Egroup: Pentaho
\ view thread
Hi, I can see that Pentaho server uses Tomcat to serve web pages but I can't understand where it saves: users, data sources and CDE dashboards. Which kind of database does it use? Is it accessible? Thank you very much. Claudio ------------------------------ Claudio Battaglino IT Support ...
Posted By Claudio Battaglino 10-03-2022 09:59
Found In Egroup: Pentaho
\ view thread
Hi I have a dashboard that has a table that uses this "mdx over mondrianJndi" query: WITH SET [~COLUMNS] AS ([Classe].[Classe].Members) SET [~ROWS] AS ([Allievo.Tipo Studente].[Tipo Studente].Members) SELECT NON EMPTY CrossJoin([~COLUMNS], ([Measures].[Count allievi])) ON COLUMNS, NON EMPTY [~ROWS] ...
Posted By Claudio Battaglino 05-06-2022 11:39
Found In Egroup: Pentaho
\ view thread
Hi, I have some jobs scheduled on a Pentaho Server 9.2 that read data from a Mysql 5 and the authentication "mysql_native_password". Now the database has been migrated to Mysql 8.0.29 with caching_sha2_password authentication. I've added the connector library MySQL-connector-java-8.0.29.jar in the ...