Pentaho Community Forums - Community Tools - CToolshttp://forums.pentaho.com/
Community Tools and including but not limited to CDF, CDE, CDA, CCC, CBF and CST. All things previously known as Dashboards.enTue, 26 Sep 2017 21:45:56 GMTvBulletin60http://forums.pentaho.com/images/misc/rss.pngPentaho Community Forums - Community Tools - CToolshttp://forums.pentaho.com/
chart is not showing on cde dashbboardhttp://forums.pentaho.com/showthread.php?229799-chart-is-not-showing-on-cde-dashbboard&goto=newpost
Tue, 26 Sep 2017 09:45:56 GMThi

I have pentaho version 7.1. I'm trying to build a bar chart in my CDE dashboard. I'm using sql over jdbc datasource and my database is mysql version 8.42 .
the problem is that this chart shows nothing!

I'm trying to find a way to see my repositry files fro y BI server (7.1.0.0-12) in a Dashboard that I have implemented.
I saw there is an amazing CTOOLS tool for that, CFR.

My problem here is that I think the plugin is just updated till version 7.1.0.0-6.

What should I do? Will be a new update soon for this tool?

Thanks in advance for your time.
]]>Community Tools - CToolschikoi13http://forums.pentaho.com/showthread.php?229611-CFR-for-pentaho-7-1-0-0-12Data population based on parameter selectedhttp://forums.pentaho.com/showthread.php?229581-Data-population-based-on-parameter-selected&goto=newpost
Thu, 21 Sep 2017 13:42:45 GMTHi All,
In a filter dropdown I have values monthly, Weekly and Daily. I have two text components :from date and to date that should get populated...Hi All,

In a filter dropdown I have values monthly, Weekly and Daily. I have two text components :from date and to date that should get populated as per Monthly or Weekly or Daily selected from dropdown. Datasource: KTR. The output of Ktr query contains Month and Week. Based on the parameter ‘Monthly’ I should fetch the first column of query, for Weekly, 2nd column and For Date calendar should get displayed.

My data source is a KTR , component is a table component. Getting three columns <Col1, Col2, Col3> as output from KTR to Pentaho CDE.
My requirement is to set Col1 value as the header and Col2, Col3 value as body of the table but not getting how to do it.Can anyone please help.

Now I want to hide the Revenue and cost on initial load.
I follow this article but I cannot use this.chart.data in my pre-execution. A message comes, that the chart property is null. This is strange. When I debug this, the chart property exists....

i have a table, and one column is hidden, i'm trying that when I click in the first column (visible) i get the content (text) of the hidden column and print it in a popup.

I need help, thanks!
]]>Community Tools - CToolsPedro111http://forums.pentaho.com/showthread.php?229238-How-print-determinated-column-in-a-popuppass parameters from CDE to ktrhttp://forums.pentaho.com/showthread.php?229230-pass-parameters-from-CDE-to-ktr&goto=newpost
Thu, 14 Sep 2017 12:12:18 GMTHi All,
Can you explain how to pass parameters from CDE kettle over kettletransfrom file to table input of ktr?
I have been looking all the day...Hi All,

Can you explain how to pass parameters from CDE kettle over kettletransfrom file to table input of ktr?

I have been looking all the day for the solution but still can't find the answer hope anyone of you helps me!

All i need to do is to pass parameter from CDE to a query in table input (select * from table where column in (${parameter}))

]]>Community Tools - CToolsIamAhmedhttp://forums.pentaho.com/showthread.php?229221-Passing-Parameter-value-from-CDE-Dashboard-to-PDIsave data on serverhttp://forums.pentaho.com/showthread.php?229190-save-data-on-server&goto=newpost
Wed, 13 Sep 2017 15:39:21 GMTHi, I'm using CDE Dashboard and I'd like to save data on server, when I click a button. How can I do it? With Ajax and Php? :confused:

Davide
]]>Community Tools - CToolsSondavidehttp://forums.pentaho.com/showthread.php?229190-save-data-on-serverkettle over kettle TransFromFilehttp://forums.pentaho.com/showthread.php?229173-kettle-over-kettle-TransFromFile&goto=newpost
Wed, 13 Sep 2017 08:35:47 GMTHi All,
In kettle over kettle TransFromFile (CDE)
I just want to know the exact path where to place to KTR file so that file picker fetches...Hi All,

In kettle over kettle TransFromFile (CDE)

I just want to know the exact path where to place to KTR file so that file picker fetches (shows) my KTR file? Currently, i placed my file where file picker shows the sample ktr when I have placed my file on the same path, it does show the sample ktr but not mine

Thanks in Advance!
]]>Community Tools - CToolsIamAhmedhttp://forums.pentaho.com/showthread.php?229173-kettle-over-kettle-TransFromFileAuthentication of Pentaho Users of custom WebApp on BI Serverhttp://forums.pentaho.com/showthread.php?229091-Authentication-of-Pentaho-Users-of-custom-WebApp-on-BI-Server&goto=newpost
Mon, 11 Sep 2017 17:04:56 GMTI have created a simple servlet outside the pentaho folder whose job is the stream an excel to the browser. I have the following structure:
...I have created a simple servlet outside the pentaho folder whose job is the stream an excel to the browser. I have the following structure:

tomcat/webapps/pentaho
tomcat/webapps/createExcel

How can I protect access to this servlet only to pentaho authenticated users?

Please your guidance.
]]>Community Tools - CToolsstijn wuytshttp://forums.pentaho.com/showthread.php?228959-Escaping-single-quotes-in-Pentaho-SQL-data-sourceHow to show Percentages on TOP of the bar CCC Bar Charthttp://forums.pentaho.com/showthread.php?228890-How-to-show-Percentages-on-TOP-of-the-bar-CCC-Bar-Chart&goto=newpost
Thu, 07 Sep 2017 07:04:54 GMTHi All,
My requirement is to show percentage on the top of the bar chart (non-stacked), so far I have got the percentages in between the bar...Hi All,

My requirement is to show percentage on the top of the bar chart (non-stacked), so far I have got the percentages in between the bar charts all I need is to display them on the top.

i have added this function in clickable action and made clickable TRUE

function(scene) { var pctVar = scene.vars.value.percent;

alert(pctVar.label);

}

Then in advance propetries i have changed values visible = True and Valuemask= {Value}{(value.percent)}

So what and all I need to do to show the percentages on the TOP of the Bar Charts? Thanks in Adnace!

]]>Community Tools - CToolsIamAhmedhttp://forums.pentaho.com/showthread.php?228890-How-to-show-Percentages-on-TOP-of-the-bar-CCC-Bar-ChartDashboard not refreshing multiple componentshttp://forums.pentaho.com/showthread.php?228782-Dashboard-not-refreshing-multiple-components&goto=newpost
Tue, 05 Sep 2017 07:30:09 GMTWith Pentaho 7.1 CE.
I have a dasboard with 2 Table Components in it.
I have set the Refresh Period of both tables to 15 seconds and the...With Pentaho 7.1 CE.

I have a dasboard with 2 Table Components in it.

I have set the Refresh Period of both tables to 15 seconds and the priority to 5.

After 1 refresh, it stop refreshing the dashboard.

If I only set the refresh Period to 1 table it does the refresh (of only that table).

I have changed the priority to be 1 for one table and 5 for the other, but It does nothing.

What I am doing wrong?

Thanks in advance.
]]>Community Tools - CToolsDaniel_Cafhttp://forums.pentaho.com/showthread.php?228782-Dashboard-not-refreshing-multiple-componentsExport Button not Workinghttp://forums.pentaho.com/showthread.php?228567-Export-Button-not-Working&goto=newpost
Thu, 31 Aug 2017 16:42:12 GMTI am having trouble getting my export button to work. This is such a simple component (I mean, not much to configure), so I don't know where I might be going wrong. This is my component:

Name

csv_export_l1

Label

Export CSV

Listeners

[]

Parameters

[]

Component Name

tbl_l1

Output Type

csv

HtmlObject

export-l1-div

Table tbl_l1 works just fine and the export button renders properly. When the button is clicked, there is the standards browser message "Waiting for my.server.url", and then nothing. Looking at the console, I see:

HTML Code:

GET https://my.server.url/pentaho/plugin/cda/api/unwrapQuery?path=%2Fhome%2Fmy.login.name%2FCPQ+Dashboard_tmp_tmp.cda&uuid=6fb66025-1a62-4e9b-8de5-d773d6cdcc32 net::ERR_INVALID_RESPONSE

My table has listeners and parameters; I shouldn't need to add them to the export button component, but I tried that also and got the same results.

Can anyone help? I'm dead in the water here.
]]>Community Tools - CToolskc1234http://forums.pentaho.com/showthread.php?228567-Export-Button-not-WorkingHow I can run CDE in the web browser?http://forums.pentaho.com/showthread.php?228547-How-I-can-run-CDE-in-the-web-browser&goto=newpost
Thu, 31 Aug 2017 09:50:31 GMTHello I want to open my CDE dashboard in the web browser.
I copy my link:
Code:
---------...Hello I want to open my CDE dashboard in the web browser.
I copy my link:

and try how it works on my phone. But I got a mistake "parameter location was not included in the GET request."

How I can check it?
]]>Community Tools - CToolskate158http://forums.pentaho.com/showthread.php?228547-How-I-can-run-CDE-in-the-web-browserBar chart base axis label formatting in pentaho CDEhttp://forums.pentaho.com/showthread.php?228538-Bar-chart-base-axis-label-formatting-in-pentaho-CDE&goto=newpost
Thu, 31 Aug 2017 05:00:20 GMTHi,i want to change the date format to dd-mm-yyyy on the base axis of bar chart as well as in a tooltip i want to change category format to...Hi,i want to change the date format to dd-mm-yyyy on the base axis of bar chart as well as in a tooltip i want to change category format to dd-mm-yyyy.I have tried using timeseries setting by seeting it to true and specifying the format to "%d-%m%Y" but not getting results.How can i do this in pentaho CDE?:confused:
]]>Community Tools - CToolsAnvitahttp://forums.pentaho.com/showthread.php?228538-Bar-chart-base-axis-label-formatting-in-pentaho-CDEhttp://forums.pentaho.com/showthread.php?228452-MultiButton-Component-amp-Multiple-Select-Component&goto=newpost
Tue, 29 Aug 2017 10:25:37 GMTHi,
I am doing a dashboard with CDE, is possible to select different value from the MultiButton and the Multiple Select Components at the same...Hi,

I am doing a dashboard with CDE, is possible to select different value from the MultiButton and the Multiple Select Components at the same time (now the query will refresh the dashboard on every click on these components)? I need this because when I click on a new value the query spend too much time (around 30 sec).

Ex: I have a MultiButton with the months, when I click on a new month it will pass the parameter to the queries, I want to select different months at the same time without the start of the refresh.