Profile

RE: Multi Value List or Multi Selection Button parameters

Posted By Andrew Cave Nov 29, 2021 8:18 AM
Found In Egroup: General Discussion \ view thread

Hi Stanton Like this. The NameOfYourParameter inside $() and used as an 'IN' clause. Should come through as 'val1','val2','val3' ...INNER JOIN film ON film.film_id=inventory.film_id WHERE film.rating IN ($(SelectRating)) ------------------------------ Andrew Cave Systems Engineer BizCubed Pty ...

RE: Upgrading Pentaho Server CE from 8.0 to 9.2

Posted By Andrew Cave Nov 28, 2021 8:30 PM
Found In Community: Pentaho \ view thread

Hi John Have you tried using the import-export utility https://help.hitachivantara.com/Documentation/Pentaho/6.0/0P0/000/Backup_and_Restore_Pentaho_Repositories Not guaranteeing 8 to 9.1 but it it worth a try..

RE: PRD 8.3 drilldown new tab browser

Posted By Andrew Cave Nov 25, 2021 5:12 PM
Found In Community: Pentaho \ view thread

Hi Maxim Have you tried this? https://pentaho-community.atlassian.net/wiki/spaces/Reporting/pages/1422038161/DrillLinking Drilling into a new Window use the following javascript URL: javascript:top.reportViewer_openUrlInDialog('title', 'http://www.pentaho.com/','800px', '600px') This only works if ...

RE: Run pentaho Job/Trans in BI server with crontab (NOT kitchen or pan)

Posted By Andrew Cave Nov 24, 2021 11:18 AM
Found In Egroup: General Discussion \ view thread

Hi Alessandro. You can use curl with a REST call to executeTrans eg curl --request POST \ --url 'https://(server)/pentaho/kettle/executeTrans/?P_SUBMIT=%7B%22fin_year%22%3A%222021%22%2C%22business%22%3A%22102676%22%2C%22biz_ref%22%3A%221980145%22%2C%22product_code%22%3A%2230226%22%2C%22rec_date ...

RE: Getting "Unfortunately your browser is not supported" error when starting Pentaho Data Integration (Spoon)

Posted By Andrew Cave Nov 17, 2021 10:15 PM
Found In Community: Pentaho \ view thread

Hi Leonard - not sure how to work the threading on these comments. The Internet Explorer app is embedded in the executable file mshtml.dll. This file is used by the pentaho java program to provide browsing functionality inside Spoon). So when you go to Help inside Spoon it opened up Internet Explorer ...

RE: Getting "Unfortunately your browser is not supported" error when starting Pentaho Data Integration (Spoon)

Posted By Andrew Cave Nov 17, 2021 7:38 PM
Found In Community: Pentaho \ view thread

Hi Leonard. On the internals pentaho 8.2 is calling mshtml.dll which wraps Internet Explorer. The pentaho wiki has been moved onto Confluence and per this post https://community.atlassian.com/t5/Confluence-questions/I-m-getting-browser-not-supported-but-it-is-not-allowing-me-to/qaq-p/1511374 they refuse ...

RE: Pentaho Rest Client: need to upload a json body with DELETE method

Posted By Andrew Cave Nov 17, 2021 7:33 PM
Found In Egroup: Pentaho \ view thread

Hi Federico. The standard for a DELETE request is that there is no body (or the body is ignored). Though you could implement something if you wanted. I'd suggested using a curl request like this: curl -X DELETE https://reqbin.com/sample/delete/json -H "Accept: */*" -H "Authorization: Bearer ...

RE: JSON Output escaped

Posted By Andrew Cave Nov 12, 2021 12:54 AM
Found In Community: Pentaho \ view thread

The problem is the the JSON fields/values are being quoted with doublequotes and your string value contains doublequotes too. So Pentaho will escape so they are confused with the end of the value field. Use single-quotes instead.

RE: In Pentaho version 9.2, repository section doesn't seem

Posted By Andrew Cave Nov 12, 2021 12:48 AM
Found In Community: Pentaho \ view thread

Somethings gone wrong with the startup as you have no repository connections Stop spoon. Goto data-integration/system/karaf/caches and delete any folders in there. Restart If that doesn't work check the pentaho log in data-integration/logs and see if there is an error being thrown that might give further ...

RE: Spoon: Browser is not supported.

Posted By Andrew Cave Nov 12, 2021 12:42 AM
Found In Egroup: Pentaho \ view thread

Hi Chris. On the internals pentaho 8.2 is calling mshtml.dll which wraps Internet Explorer. The pentaho wiki has been moved onto Confluence and per this post https://community.atlassian.com/t5/Confluence-questions/I-m-getting-browser-not-supported-but-it-is-not-allowing-me-to/qaq-p/1511374 they refuse ...

RE: How to put in "Output Table" process, 3 Excels with different number of rows

Posted By Andrew Cave May 14, 2020 8:50 AM
Found In Community: Pentaho \ view thread

FULL OUTER tries to match on the key. If it matches it brings the matching rows from both sources. If they dont, they will return one source and null values for the other. An INNER join only returns the rows from the two sources where the key column matches. I assume that makes sense in your situa ...

RE: How to put in "Output Table" process, 3 Excels with different number of rows

Posted By Andrew Cave May 14, 2020 5:38 AM
Found In Community: Pentaho \ view thread

Hi Ana What you will need to do is to join the streams for the three Excel files using Merge Join steps (first 1 to 2 then join 1&2 to 3) and then output to the table

RE: HelloCould some body explain me how I can export a dashbord to excel or pdf. I have search the web, but all solution I have find are for older version of pentaho. Actually I use the version 8.3 thank's in advance for your answers.Sebastien

Posted By Andrew Cave May 14, 2020 4:51 AM
Found In Community: Pentaho \ view thread

Is that a CTOOLs dashboard or the Analyzer dashboard?

RE: SQLITE problem

Posted By Andrew Cave May 14, 2020 4:49 AM
Found In Community: Pentaho \ view thread

https://gobansaor.wordpress.com/2006/12/18/sqlite-jdbc-and-kettle-pentaho-data-integration-etl/ Within SPOON, make a new connection using for example a Table Input step. In the General tab, pick “Generic database” from the list of connection types. Pick “Native(JDBC)” from the Method of Access list. ...

RE: Im trying to create report with dynamic parameters/values But, Pentaho does not support comma delimited values as parameter to Stored_Procedure. I tried using "MultiValueQuery" function but its still not working ?

Posted By Andrew Cave May 14, 2020 3:48 AM
Found In Community: Pentaho \ view thread

Hi Chi, Are you trying to run the report and passing in a comma-delimited set of parameters or are you trying to call a stored procedure in the database with a comma-delimited string of parameters?

RE: Some questions about the difference between open source and Enterprise edition

Posted By Andrew Cave May 14, 2020 1:06 AM
Found In Community: Pentaho \ view thread

You can do a POST like this http://localhost:8080/pentaho/kettle/executeTrans/ \ --header Content-Type: application/x-www-form-urlencoded \ --header Authorization: Basic $(auth) \ --data-urlencode userid=admin \ --data-urlencode pass=password \ --data-urlencode rep=singleDiServerInstance \ --data-urlencode ...

RE: How to apply row-level security on the reports created using Pentaho Report Designer?

Posted By Andrew Cave May 14, 2020 12:39 AM
Found In Community: Pentaho \ view thread

If you are using the Pentaho BA server to present the report (I assume you are) then it will pick up the login

RE: How to Decrypt Column Values in Pentaho Report Designer which were encrypted using custom secret key in Database

Posted By Andrew Cave May 13, 2020 6:50 AM
Found In Community: Pentaho \ view thread

Hmmm...thats a risky way of doing it. Id rather use SSL and let the db encrypt. However..all us devs get stuck dealing with somebody elses bad choices You can use a Modified Javascript value step and follow the instructions here https://stackoverflow.com/questions/43067622/pentaho-data-integration ...

RE: How to apply row-level security on the reports created using Pentaho Report Designer?

Posted By Andrew Cave May 13, 2020 6:42 AM
Found In Community: Pentaho \ view thread

Hi Bhargavi The datasource for the PRPT will be an SQL query . You can use the $(env.username) variable to get the logged in user Perhaps like this... select si.sensitive_name, si.sensitive_date from sensitive_information as si where si.allowed_user = $(env::username) The value of $(env::username) ...

RE: I have installed trial version of Pentaho EE Suite on my system, which is a Windows 10 system on x64 processor. I am unable to open PUC page, it is throwing localhost connection refused. Firewall disabling didn't help. Please help.

Posted By Andrew Cave May 13, 2020 1:30 AM
Found In Community: Pentaho \ view thread

PUC is on port 8080 by default, so http://localhost:8080/pentaho

Andrew Cave

Contact Details

Andrew Cave

My Content

RE: Multi Value List or Multi Selection Button parameters

RE: Upgrading Pentaho Server CE from 8.0 to 9.2

RE: PRD 8.3 drilldown new tab browser

RE: Run pentaho Job/Trans in BI server with crontab (NOT kitchen or pan)

RE: Getting "Unfortunately your browser is not supported" error when starting Pentaho Data Integration (Spoon)

RE: Getting "Unfortunately your browser is not supported" error when starting Pentaho Data Integration (Spoon)

RE: Pentaho Rest Client: need to upload a json body with DELETE method

RE: JSON Output escaped

RE: In Pentaho version 9.2, repository section doesn't seem

RE: Spoon: Browser is not supported.

RE: How to put in "Output Table" process, 3 Excels with different number of rows

RE: How to put in "Output Table" process, 3 Excels with different number of rows

RE: HelloCould some body explain me how I can export a dashbord to excel or pdf. I have search the web, but all solution I have find are for older version of pentaho. Actually I use the version 8.3 thank's in advance for your answers.Sebastien

RE: SQLITE problem

RE: Im trying to create report with dynamic parameters/values But, Pentaho does not support comma delimited values as parameter to Stored_Procedure. I tried using "MultiValueQuery" function but its still not working ?

RE: Some questions about the difference between open source and Enterprise edition

RE: How to apply row-level security on the reports created using Pentaho Report Designer?

RE: How to Decrypt Column Values in Pentaho Report Designer which were encrypted using custom secret key in Database

RE: How to apply row-level security on the reports created using Pentaho Report Designer?

RE: I have installed trial version of Pentaho EE Suite on my system, which is a Windows 10 system on x64 processor. I am unable to open PUC page, it is throwing localhost connection refused. Firewall disabling didn't help. Please help.