Profile

RE: CDE doesn't respond when editing the last row of a dashboard

Posted By Luciano Donazzolo 09-06-2023 10:30
Found In Community: Pentaho \ view thread

Claudio, the workarounds I found was all of very low quality and not always usable reduce the zoom of the page, trying to position the last row a little far from the bottom of the page set the value of the last option, in the "Pre Execution" function set the value of the last option, in the *.cdfde file ...

RE: Pentaho CDE

Posted By Luciano Donazzolo 07-09-2023 13:07
Found In Egroup: Pentaho \ view thread

Marco, if you need to be able to switch between two or more predefined datasources, you can try something like the following in pre-execution: function f() ( this.chartDefinition.dataSource = (condition) ? "myds1" : "myds2"; ) where "myds1" and "myds2" are datasources defined in the Datasources ...

RE: MS Excel Writer doesn't work

Posted By Luciano Donazzolo 09-26-2022 07:08
Found In Community: Pentaho \ view thread

I don't know about CE 9.2 But I have no problems with "Microsoft Excel writer" step in CE 9.3. May be you have to properly adjust options "Extension" and/or "If file output exists" and/or "If sheet exists in output file" in File&Sheet tab. Luciano

RE: Pie chart: label value formatting

Posted By Luciano Donazzolo 10-08-2021 13:51
Found In Community: Pentaho \ view thread

Hi Nico, for question 1, try setting: pie chart / advanced properties Values Visible = True Values Mask = (value.percent) ((value)) Percent Value Format = function f(val) ( return Utils.numberFormat(val, 0.00% ) for question 2: I dont know Luciano

RE: How to build a report that take data from spoon transformation?

Posted By Luciano Donazzolo 10-08-2021 12:59
Found In Community: Pentaho \ view thread

Yes, it is possible. Pentaho Report Designer New Data / Add Datasource .. / Pentaho Data Integration Add a new Query (+ icon) Browse / select ktr file Select producer step Ok Hope this help Luciano

RE: CDE: Problems with sql over sqljndi

Posted By Luciano Donazzolo 04-06-2021 10:29
Found In Community: Pentaho \ view thread

I think you cannot use this syntax, because CDA internally passes your sql to prepared stmt, in order to handle the execution customization through the Parameters option in the Datasources Panel. Hope this helps Luciano

RE: Why CCC Charts are not responsive if parent layout is?

Posted By Luciano Donazzolo 11-30-2020 18:46
Found In Community: Pentaho \ view thread

I think you can get help at https://forums.pentaho.com/threads/182601-Chart-width-isn-t-dynamic-in-bootstrap/ I hope Luciano

RE: Change Pentaho Server from HTTP to HTTPS

Posted By Luciano Donazzolo 11-23-2020 11:40
Found In Community: Pentaho \ view thread

Hi Vinicius, I was able to did it (though in a test system) a long ago. This was the way I followed (note: I didnt repeat it now for testing): generate a certificate (say tomcat.cer) and import it into a keystore file (say keystore.jks) in \pentaho-server\tomcat\conf\server.xml : uncomment lines 84-88 ...

RE: Message in chart if query does not return data

Posted By Luciano Donazzolo 11-23-2020 11:13
Found In Community: Pentaho \ view thread

In the case of a CCC chart, set extension points with: noDataMessage_text : no data noDataMessage_visible : function f()( return true; ) Luciano

RE: How to use the results row of extraction table into sql execution script

Posted By Luciano Donazzolo 06-03-2020 17:30
Found In Community: Pentaho \ view thread

Take in mind that you cant use ? anywhere in the SQL statement. E.g. it doest work to set the field selection list in SELECT. If you need to extend parameters to table structure, you may use ETL Metadata Injection step. See more at https://wiki.pentaho.com/display/EAI/Table+Input Luciano

RE: When should I use requireJS support?

Posted By Luciano Donazzolo 06-03-2020 14:58
Found In Community: Pentaho \ view thread

This link https://help.pentaho.com/Documentation/8.2/Products/CTools/CDE_Advanced_Solutions gives a map list between RequireJS and Non RequireJS calls. Luciano

Luciano Donazzolo

Contact Details