Profile

Andrew Cave

BizCubed Pty Ltd

Contact Details

BizCubed Pty Ltd

My Content

1 to 20 of 37 total
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 ...
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..
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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 ...
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
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. ...
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?
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 ...
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
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 ...
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) ...