Profile

Luciano Donazzolo

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 13 of 13 total

RE: How do I make the filter component show a default value selected

Posted By Luciano Donazzolo 11-11-2019 12:09
Found In Community: Pentaho \ view thread
In the Filter Component pre-execution, try using something like this   if(this.dashboard.getParameterValue(myparam)===) (   this.dashboard.setParameter(myparam, [default-value )   (Filter Component value must be an array)   Hope this may help Luciano

RE: Unable to run Update query

Posted By Luciano Donazzolo 08-17-2019 17:25
Found In Community: Pentaho \ view thread
Hi Suman, I suspect your queries try to update the same table. In such a case you can get errors, because all the steps in a transformation execute in parallel, so each SQL step may try to update simultaneously the same table. If this is the case, I suggest you trying to rewrite your procedure, e.g. ...

RE: Kettle: File existed but CSV file input step cannot open

Posted By Luciano Donazzolo 07-05-2019 20:16
Found In Community: Pentaho \ view thread
1. Define a global variable pointing to your File System Repository Spoon Edit Edit the kettle.properties file insert a new variable (e.g. Variable name = REPO_DIR  Value = /home/test ) 2. Access the file in input step with: $(REPO_DIR)/abc.csv Luciano

RE: Single parameter gets "cloned" into several on passing into query

Posted By Luciano Donazzolo 05-30-2019 08:22
Found In Community: Pentaho \ view thread
I dont know postgresql. Anyway, as a my personal experience, when Im facing with such a parametrization need, I usually let a kettle datasource resolving all the dynamic issues.

RE: ccc chart: barchat - Change text style

Posted By Luciano Donazzolo 04-19-2019 11:09
Found In Community: Pentaho \ view thread
If I understand your question, try using these advanced properties of your CCC Bar Chart component: Values Visible = True Values Mask = (value) Values Font = 10px sans-serif If you need to change chart definition dinamically through javascript, you should use PreExecution function. Get more from htt ...

RE: Drill through is not working in CDE Dashboard.

Posted By Luciano Donazzolo 04-06-2019 09:48
Found In Community: Pentaho \ view thread
The article you mentioned refers to Pentaho4.8. If you are using a more recent version of server, try to replace the url with something like: url=http://localhost:8080/pentaho/api/repos/:public:reports:myreport.prpt/viewer?param1=mypar1 Hope this may help Luciano

RE: Date input Component calendar and the week day start

Posted By Luciano Donazzolo 02-14-2019 14:40
Found In Community: Pentaho \ view thread
Hi, do you know how to address the same issue in a RequireJS context? I tried both this.dashboard.i18nCurrentLanguageCode=it and this.dashboard.Utils.i18nCurrentLanguageCode=it with no success. Thanks in advance Luciano

RE: CDE and Date Input Component to use a parameter for SQL

Posted By Luciano Donazzolo 12-09-2018 19:24
Found In Community: Pentaho \ view thread
Sorry Pierre, Im afraid I missed the meaning of your question, in my previous answer. If now I understand it correctly, I think you can change the date format using the PreChange function, in Advanced Properties of Date Input Component: function f(value) (    return value.replace(/\-/g,  ) Hope this ...

RE: CDE and Date Input Component to use a parameter for SQL

Posted By Luciano Donazzolo 11-30-2018 08:37
Found In Community: Pentaho \ view thread
Hi Pierre, try something like the following: Parameters / Simple Parameter / name:vDate Selects / Date Input Component / Parameter:vDate (e.g. table component)     / Listeners: vDate     / Parameters: Name:vDate Value:vDate Datasource     / Parameters: Name:vDate Type:String Luciano

RE: Dashboard Not Rendering When Fed Empty Set

Posted By Luciano Donazzolo 11-30-2018 08:18
Found In Community: Pentaho \ view thread
For CCC charts you can use Extension points:: noDataMessage_text  = No data available noDataMessage_visible = function f()( return true; ) Note: when setting up the noDataMessage_text value, the editor shows a red x notifying a missing semicolon (V7.1); anyhow it turns out you can ignore such a message ...

RE: Column in table component as hyperlink

Posted By Luciano Donazzolo 11-09-2018 08:34
Found In Community: Pentaho \ view thread
I see. I dont know how to use the specific table component addin. Anyhow I think you could resolve your issue, coding into your table component PostFetch, something like the example that follows (I added a column in the dataset and used the new column to hold a link). function f(data) (   var newCol ...

RE: Column in table component as hyperlink

Posted By Luciano Donazzolo 10-31-2018 15:22
Found In Community: Pentaho \ view thread
InTable Component, specify Column Types setting hyperlink in the right column (string in the rest). This way, each cell value of that column becomes a link. I never went further, but you can customize a lot more, configuring the Table Component AddIn (ref. Pubic/plugin-samples/CDE/CDE Reference/AddIn ...

RE: Float Axis with little variances

Posted By Luciano Donazzolo 09-27-2018 14:44
Found In Community: Pentaho \ view thread
Did you try setting Ortho Axis Fixed Max and Ortho Axis Fixed Min? Luciano