Profile

Paulo Pires

Hitachi Vantara

Contact Details

Hitachi Vantara

My Content

1 to 20 of 50+ total

RE: Looking to see if its possible to build a report

Posted By Paulo Pires 10-01-2019 16:19
Found In Community: Pentaho \ view thread
Yes and exporting to PDF is not available yet.   In your PUC go to Public\plugin-samples\CDE\CDE Reference\Addins and double click Addins Reference dashboard. Here you can see some pre-defined addins for the table component, the last one groupHeaders might be what you need for the first column.   Then ...

RE: Looking to see if its possible to build a report

Posted By Paulo Pires 10-01-2019 08:51
Found In Community: Pentaho \ view thread
Hi Ben,   If youre willing to use other things than analyzer and report designer, this can be done with CTools using a table component.   Best regards

RE: Pentaho BI server user cannot change his password? :-)

Posted By Paulo Pires 10-01-2019 08:46
Found In Community: Pentaho \ view thread
Hi Gosforth,   Only Administrator users can change own passwords or other users passwords.   Best regards

RE: Where can I find the installation documentation for pdi-ce-8.3.0.0-371?

Posted By Paulo Pires 09-27-2019 09:14
Found In Community: Pentaho \ view thread
Those are mainly for EE, this is for CE https://community.hitachivantara.com/s/article/data-integration-kettle

RE: multi bar chart and series display order in the legend

Posted By Paulo Pires 09-27-2019 08:54
Found In Community: Pentaho \ view thread
I think that the legend is sorted alphabetically and the bars are according the json columns order. Can you test it and change the order of the output to match the legend?

RE: Pentaho ETL Jobs

Posted By Paulo Pires 09-26-2019 09:05
Found In Community: Pentaho \ view thread
In your PDI installation folder you should have a samples folder with several examples.   Best regards

RE: PDI ETL Job

Posted By Paulo Pires 09-26-2019 09:03
Found In Community: Pentaho \ view thread
Hi Rajesh,   you can look at https://help.pentaho.com/Documentation/8.3/Setup/Define_data_connections   Best regards

RE: Where can I find the installation documentation for pdi-ce-8.3.0.0-371?

Posted By Paulo Pires 09-18-2019 07:42
Found In Community: Pentaho \ view thread
Hi Wayne,   There isnt, just unzip and run spoon.sh   Regards

RE: Kettle Jobs Won't Run Transformations

Posted By Paulo Pires 08-22-2019 14:03
Found In Community: Pentaho \ view thread
Hi Luis,   Try using $(Internal.Job.Repository.Directory) instead of $(Internal.Entry.Current.Directory) but not sure if it will work.   Best regards

RE: Can not write on large excel file PDI

Posted By Paulo Pires 08-19-2019 11:55
Found In Community: Pentaho \ view thread
Hi Samuel,   This thread is old but probably your issue is related, see if it helps https://forums.pentaho.com/threads/129264-Excel-Writer-stops-at-10000-records/   Regards

RE: download older versions of pentaho

Posted By Paulo Pires 06-04-2019 14:33
Found In Community: Pentaho \ view thread
Just enter the Business Intelligence Server folder Hitachi Vantara | Pentaho - Browse /Business Intelligence Server at SourceForge.net

RE: download older versions of pentaho

Posted By Paulo Pires 06-04-2019 13:58
Found In Community: Pentaho \ view thread
This was already answered here but you can go to: Hitachi Vantara | Pentaho - Browse Files at SourceForge.net  Best regards

RE: Why step insert/update in spoon is so slownly?

Posted By Paulo Pires 05-27-2019 14:57
Found In Community: Pentaho \ view thread
Hi Bianca, Generally the insert/update is slower than just insert because it checks the existing values on the DB. There is one option that you could try, I think the Transaction Size (Commit) by default is 100, but you can increase this value and check if the performance improves. Best regards

RE: Big Query Connection from Pentaho

Posted By Paulo Pires 05-24-2019 09:10
Found In Community: Pentaho \ view thread
Hi Mandar, You where right about the folder to deploy the drivers. Follow the steps in Google BigQuery - Pentaho Documentation  If you still have an error then its best to contact support. Best regards

RE: Filter component won't show values -- total newbie here, trying out my first dashboard. Using SQL as data source. Would anyone know why (Multiple Selection option is set to False for the Filter Component), or would you need a basic example? Many thanks.

Posted By Paulo Pires 05-23-2019 08:09
Found In Community: Pentaho \ view thread
Let me know if this helped Pentaho CDE how to use parameter in SQLQuery - Stack Overflow  De nada

RE: Big Query Connection from Pentaho

Posted By Paulo Pires 05-22-2019 15:10
Found In Community: Pentaho \ view thread
Hi Mandar, Copy the driver to \server\pentaho-server\tomcat\lib instead and test it again. Restart the server after copying the driver. Best regards

RE: Filter component won't show values -- total newbie here, trying out my first dashboard. Using SQL as data source. Would anyone know why (Multiple Selection option is set to False for the Filter Component), or would you need a basic example? Many thanks.

Posted By Paulo Pires 05-22-2019 08:55
Found In Community: Pentaho \ view thread
Hi Deborah, Go to your PUC, and in View activate the Show Hidden Files. Then go to Public -> plugin-samples -> CDE -> CDE Reference -> FilterComponent. There youll see examples on how to use the Filter Component. Best regards

RE: Migrate custom component from 7 to 8.x : missing js class error ?

Posted By Paulo Pires 05-20-2019 07:07
Found In Community: Pentaho \ view thread
Try to use dashboard.addComponents([ ... render_mytable]); instead, it was updated. Dashboard - Pentaho Documentation  Regards

RE: Pentaho Community edition vs EE

Posted By Paulo Pires 05-16-2019 07:54
Found In Community: Pentaho \ view thread
You can see here the current supported versions (EE only): Pentaho Product End of Life Policy – Pentaho Customer Support Portal  CE versions dont have a serial number and are not supported, you can purchase Services to help you with your issues. Check Pentaho Data Integration - Accelerate Data Pipeline ...

RE: Pentaho Community edition vs EE

Posted By Paulo Pires 05-16-2019 06:54
Found In Community: Pentaho \ view thread
CE versions are free, you can download them from sourceforge. https://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/5.4/biserver-ce-5.4.0.1-130.zip/download  Regards