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
1
vote
2 answers

Pentaho Demo Graphs or Charts

Recently had a project in JBoss but want to move to Pentaho (JBoss kept crashing). JBoss was good because it showed you sample data and various types of results when you installed it. When I installed Pentaho, it is like a clean slate and I do not…
Philip Jones
  • 25
  • 5
1
vote
0 answers

Pentaho report chart is not displayed in Java application

I am trying to convert a report with chart and a grid into html and render it to a iframe, but it renders without chart. In my controller I am not using HtmlReportUtil.createStreamHTML (learned from other posts). I tried to use…
Vikash Jangra
  • 113
  • 2
  • 9
1
vote
1 answer

Pentaho 5.4.0 Community Edition Remote Execution

am using Pentaho community edition 5.4.0 ,I explain My requirement very Simply, 1) I have my jobs and transformation in my local windows machine and i like to execute those in my client machine ,So that i installed same Pentaho community version…
Dhamodharan
  • 133
  • 1
  • 3
  • 16
1
vote
0 answers

How to create dynamic sql query in pentaho report designer PRD 5.3?

I am using petaho report desiner My main query is select create_date , sum(product_uos_qty) from sale_order_line group by create_date It is running properly and sub query is SELECT column_name FROM information_schema.columns WHERE…
user3946530
1
vote
2 answers

Error: Unable to publish yor file in pentaho?

I am new to pentaho. I am using Pentaho Report Desiner ce-5.3.0 on Windows 7 32 bit. When I try to publish report then login window popup then filling all fields and click on ok, it gives error. Unable to publish your file please try again or…
user3946530
1
vote
1 answer

How to Use Multiple Condition in Open Formula in Pentaho Report Designer?

For single condition it is correct but if there is multiple condition hard to customize in open formula. For example i want grading like A,B,C .I did such but doesn't work? Code tried: =IF([total]>90;"A";0 IF(OR([total]<80 ; [total]<=90);"B";0;…
amr9349
  • 15
  • 1
  • 1
  • 8
1
vote
2 answers

how to get unique records using pentaho data integration

I have log_table with columns state,region,district,timestamp in sql server. ID state region district timestamp -- ----- ------ -------- --------- 1 GJ RE056 DI137 2014-02-05 09:00:00.257 2 …
SRI
  • 531
  • 1
  • 4
  • 11
1
vote
1 answer

Dynamic naming of excel sheets using pentaho kettle

I have a transformation with sequential steps of writing data from a table input step to Excel sheets using Excel writer step. The sheet names are basically provided in the sheet name box in content tab which was reflecting in the…
Ravipati John Chandra Teja
  • 11
  • 1
  • 2
1
vote
1 answer

Calling Pentaho Kettle job from BI Server using xaction

My requirement is to call my kettle job from Pentaho BI server. I am using Pentaho BI server 5.0.1 CE, PDI 4.3.0 - for kettle job and transformation design and PDS CE 4.0. - to design xaction that will call the kettle job I have created an…
lourdh
  • 449
  • 2
  • 12
  • 30
1
vote
1 answer

How to ensure transformations with output to more than one output table are carried out as atomic operations in Pentaho Kettle

I am totally new to ETL's in general and working on Pentaho kettle. I have made some transformations which involve writing output to more than one database tables and want to make sure that writing to these multiple tables is carried out as an…
Sushant
  • 173
  • 1
  • 4
  • 15
1
vote
1 answer

Pentaho Report Designer error: Assert: Shift is not as expected

I'm building a report which is basically a big set of pie charts (13 of them) grouped by user. Each pie chart uses a diferent query (actually, same query, different table). I laid them down, and everything was fine until pie number 11. Pie number…
Lucas Soares
  • 117
  • 1
  • 2
  • 12
1
vote
3 answers

Sum of Selected rows from column using pentaho report designer

I'm using Pentaho Report Designer (PRD) 3.8. My data structure is like this id| name |value | 1 | Jack | 200 | 2 | Will | 300 | 3 | Smith | 400 | 4 | Jack | 500 | Now the problem is that I want to get sum for column Value with only selected…
ANonmous Change
  • 798
  • 3
  • 10
  • 32
1
vote
1 answer

How to give different gradient in horizontal bar chart in Pentaho report designer

Is there any way to give different gradient color in each bar of bar chart in pentaho report designer. I'm trying with BeanShall Script but unable to get the gradient top to bottom, also I'm getting same gradient color in all the other bars too. I'm…
Ankit
  • 502
  • 1
  • 4
  • 20
1
vote
2 answers

Integrating OLAP Reporting in my java web application

I need to develop OLAP Reporting in my java web application. Which third party tool will suite the requirement. I should deploy in my own server like tomcat or jboss Open source or demo versions i can find Pentaho, it is quit challenging to deploy…
Ravi Chandran
  • 131
  • 2
  • 10
1
vote
1 answer

Define same output table across multiple transformations

I have 6 different input datasets. I want to run ETL over all 6 datasets so they all get transformed to the same output table (same columns and types). I am using Pentaho (Spoon) to do this. Is there a way I can define an output table schema to be…
rustybeanstalk
  • 2,722
  • 9
  • 37
  • 57
1
2
3 4 5 6