Stack Overflow
Stack Overflow

Questions tagged [pentaho-cde]

Community Dashboard Editor from Open-source provider of reporting, analysis, dashboard, data mining and workflow capabilities.

304 questions
50
votes
10 answers

How to get last 7 days data from current datetime to last 7 days in sql server

Hi I am loading table A data from sql server to mysql using pentaho when loading data i need to get only last 7 days data from sql server A table to mysql In sql server createddate column data type is like datetime AND In mysql created_on column…
SRI
  • 531
  • 1
  • 4
  • 11
6
votes
2 answers

Pentaho BI server report without Log in

I need to integrate my Pentaho Community dashboard report in a DotNet application. Now I am facing a problem. I want the report to open on single click without the Pentaho server asking for authentication or log in. I tried to find out a…
Ritesh
  • 237
  • 1
  • 4
  • 13
5
votes
2 answers

Pass value from job to transformation in Pentaho

I have the following transformation in Pentaho PDI (note the question mark in the SQL statement): The transformation is called from a job. What I need is to get the value from the user when the job is run and pass it to the transformation so the…
ps0604
  • 1,227
  • 23
  • 133
  • 330
5
votes
2 answers

Updating Selected Values of Dynamic Multiselectors in Pentaho-CDE

Short version: How, using JavaScript or JQuery, do I dynamically reassign the selected value of a dynamically generated multiselector box to a default value given certain conditions are met on the change (user select) in another? Long version: I…
Serban Tanasa
  • 3,592
  • 2
  • 23
  • 45
3
votes
0 answers

Pentaho PDI: Metadata related Null Pointer Exception in Scripting task

Using Pentaho PDI 6, with: A) CSV Input on .csv (4 row .csv from IBM), with ASCII file encoding (preview rows works fine) connected to B) CPython Script Executor, installable from Tools -> MarketPlace. Assumes Python, Pandas, Numpy installed. Script…
Kwame
  • 752
  • 7
  • 19
3
votes
0 answers

Pentaho CDE new charts not rendering

New charts I add to an existing CDE dashboard are not rendering. Existing charts are working ok. I have also created brand new dashboards and the same problem occurred. I checked Pentaho - charts not displaying in CDE dashboards and Pentaho CDE Bar…
ftuomey
  • 33
  • 1
  • 5
3
votes
1 answer

Pentaho 6: CDE and OLAP Selector wizard

I'am trying to create a Dashboard in Pentaho 6 with CDE. I'm follwing this tutorial (https://www.youtube.com/watch?v=Nq86J5t5c18). I already have a Cube and I've been using it on other tools like "Saiku", "New Openl Analysis report" and "Pivot4j".…
Evandro C.
  • 71
  • 6
3
votes
1 answer

how to make pentaho bi server connection secure

I want to access http://localhost:8080/pentaho as a secure connection. like https://localhost:8080/pentaho I am using bi-server-5.4 i tried to make changes in server.xml file In connector i changed protocol="HTTP/1.1" to protocol="HTTPS/1.1" after…
Helping Hand..
  • 2,430
  • 4
  • 32
  • 52
3
votes
2 answers

pentaho cde export button- how tp set the export file name?

The pentaho cde export component is working for me , it export the table data and the file name is cda-export.csv, can I set the file name atomically?
wave
  • 61
  • 3
3
votes
0 answers

Pentaho CDE Line Chart Padding

I'd like to remove the gap between the start of my line, and the Y-axis, is there a variable that'll let me do that? I've messed around with every padding, and margin variable that I could find, but nothing has changed. Is there an extension point…
knoll
  • 295
  • 6
  • 18
3
votes
1 answer

How to use Spoon on aws pentaho community version?

I have spinned up a Pentaho server on AWS with Pragmatic Pentaho BA Server Community Edition 5.4 @ AWS Platform and want to use the Kettel GUI(Spoon) to control from localhost through installed client or web browser. How can I achieve…
Hello lad
  • 17,344
  • 46
  • 127
  • 200
3
votes
3 answers

Pivot4J not showing int Pentaho Business Analytics - Community Edition

I am taking a course on Coursera and we have been asked to use the community version of Pentaho Business Analytics (PBA). I have download the latest PBA server and plugin for Pivot4J, however, when I launch the web interface and click on new, I do…
MIG
  • 33
  • 1
  • 4
3
votes
1 answer

Error Starting Pentaho BIserver

Im running Pentaho 5.3 Biserver in a Redhat machine yesterday there was a power failure, when the power came back i tried to start the biserver it gives HTTP Status 404 - type Status report message description The requested resource is not…
Maharaj
  • 87
  • 3
  • 11
3
votes
0 answers

Pentaho CDE Dashboard not scrollable on ipad

we are currently using Pentaho with a CDE Dashboard on bootstrap template. When opening the Dashboard in Pentaho Mobile or in Safari/Chrome on an iPad 2 we are unable to scroll down on the Dashboard. We already tried the fixes provided in the…
eFMM
  • 51
  • 4
3
votes
1 answer

Pentaho : How to split single Excel file to multiple excel sheet output

I have a list of employee details. I want to split each employee detail in separate Excel sheet. I tried a lot but I get only separate Excel files alone, not all the sheets in a single file by using Pentaho kettle. Eg: Raja 22 developer …
Dhamodharan
  • 133
  • 1
  • 3
  • 16
1
2 3
…
20 21