Stack Overflow
Stack Overflow

Questions tagged [pentaho-design-studio]

Pentaho Design Studio is a collection of editors, viewers and administration modules integrated into a single application that provides a graphical environment for building and testing Action Sequence documents, and JFree reports. NOTE: Not the same as "pentaho-report-designer".

Pentaho Design Studio is a collection of editors, viewers and administration modules integrated into a single application that provides a graphical environment for building and testing Action Sequence documents, and JFree reports. NOTE: Not the same as pentaho-report-designer.

See http://wiki.pentaho.com/display/ServerDoc2x/Design+Studio

83 questions
6
votes
1 answer

Stop running Kettle Job/Transformation using Java

I'm developing a web-app based ETL too (with Kettle engine), using Java. I'm running into issues, while trying to stop a running Job. I'm not sure if using the CarteSingleton.java is correct. I'm using a custom singleton map. My code is as below…
Sanjeev Kulkarni N
  • 341
  • 1
  • 4
  • 14
4
votes
4 answers

Pentaho | GC overhead limit exceeded

I want to insert data from xlsx file into table. Excel has around 1,20,000 records. But while running transformation, I am getting below error: GC overhead limit exceeded I have changed in spoon.bat. Xmx2g -XX:MaxPermSize=1024m But still I am…
Nilesh Patil
  • 91
  • 2
  • 11
3
votes
3 answers

how to remove duplicate row from output table using Pentaho DI?

I am creating a transformation that take input from CSV file and output to a table. That is running correctly but the problem is if I run that transformation more then one time. Then the output table contain the duplicate rows again and again. Now I…
user3946530
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
3
votes
1 answer

Pentaho merge rows (diff) not showing "changed"

I've got this steps The merge rows diff is configured as follow But when a update is detected it doesn't show the "changed" tag, it show two rows, a deleted and a new The documentation says that a "changed" tag should be displayed on the update…
mariowise
  • 2,167
  • 2
  • 21
  • 34
3
votes
2 answers

Pentaho BI Marketplace

I'm trying to make some changes in my Dashboards with CDE . But when I access Pentaho plateform 5.0 as Admin I can't find the Marketplace in all the menus Thanks for helping me !
ATTAR
  • 33
  • 1
  • 4
3
votes
3 answers

Building pentaho-platform from github

i have cloned github repository after tht i have created the following…
ye win
  • 31
  • 2
2
votes
0 answers

Pentaho PDI on Ubuntu 18

I have Pentaho setup and running on Windows 10, I am planning to migrate to Ubuntu. Has anyone setup Pentaho on Ubuntu 18.04? If yes, what is the configuration you are using? Pentaho documentation says mentions Ubuntu 14 and 16 to be used and are…
amey
  • 21
  • 2
2
votes
0 answers

Query Scripting in Pentaho using groovy

I am using pentaho as reporting engine in my project, I have a situation where I have to dynamically generate a query based on parameters and from there the report out come will be processed, so I found query scripting is the best way to do that,…
NaN
  • 683
  • 1
  • 8
  • 15
2
votes
2 answers

Dynamical variables in pentaho for Step - Table Input

In my ktr, I need to create dynamic query for Step Table Input. like - Select ${SelectList} from ${Table} The value of SelectList Table is coming from Step - Set Variables. It is not working. Am I missing something?
user2093576
  • 3,082
  • 7
  • 32
  • 43
2
votes
1 answer

Authorization in Pentaho

Is it possible to show the reports filtered by a field (say location) for a user in pentaho? For eg: UserA manages RegionA UserB manages RegionB UserAB manages RegionA and RegionB When a user log into the system, (s)he should see the report showing…
Gopal
  • 1,372
  • 2
  • 16
  • 32
1
vote
1 answer

Pentaho Report Designer crosstab is not grouping columns properly

I was creating a crosstab in Pentaho Report Designer 7.0 and expeting output like this, Expected Output Unfortunately, I am getting output as below, Output getting It is simply not grouping the nested column component properly.
Sourabh Shitre
  • 11
  • 1
1
vote
2 answers

Pentaho | Issue with CSV file to Table output

I am working in Pentaho spoon. I have a requirement to load CSV file data into one table. I have used , as delimter in CSV file. I can see correct data in preview of CSV file input step. But when I tried to insert data into Table Output step, I am…
Nilesh Patil
  • 91
  • 2
  • 11
1
vote
1 answer

Pentaho | kjb file stuck

I am working in Pentaho DI spoon tool. I have created one KJB job with many transformations. I have click on run button ini KJB file but it is not showing any response. I think it is not even started. Where should I see logs? What should be the…
Nilesh Patil
  • 91
  • 2
  • 11
1
vote
1 answer

Filtering The Analyzer report in Pentaho

I successfully created the Pentaho Analyzer report of some data . Than i apply filter on one column let suppose house_id and which contains the data H1,H10,H15,H20 and in filter option when i type H1 it gives output H1,H10,H15 because filter has…
user5064261
1
2 3 4 5 6