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
0
votes
1 answer

Issue with html pentaho report in openerp

i have integrated the pentaho report designer with openerp,and able to generate reports from openerp with pdf,html,csv.But when i click on pdf report i able to see graphs and charts whereas in HTML ther is no graph and charts.Any solution would be…
sanath meti
  • 5,179
  • 1
  • 21
  • 30
0
votes
1 answer

Pentaho - CDE How to use a one datasource with one execution for two components

I have a chart component and a table component. Both are pointing to same query. When I load the dashboard the same query executes twice for bar and table component. So the execution time got delay in this. How to avoid this delay? I tried to…
Dhinakar
  • 4,061
  • 6
  • 36
  • 68
0
votes
1 answer

Scheduling a job in pentaho 5.1 setting logging information to Email

In pentaho [PDI(Kettle)] 5.1 version after scheduling job i have set email to the transformation in job if job fails email has send to the mail where the error occured.If i want to see detailed log information what happening during scheduling. How…
SRI
  • 531
  • 1
  • 4
  • 11
0
votes
0 answers

Using pentaho report parameter to modify SQL query using nested AND/OR

I am trying to use a drop down menu to have a report act like 2 separate reports. this is a parameter called rtype that is value of 0-2. Data is client appointment and I am trying to report on their ability to keep appointments. Option 1 and 2 we…
mikew0w
  • 1
  • 2
0
votes
1 answer

pentaho kettle mail job entry

I have done a job adding the mail job entry step.I have configured the mail job entry correctly with the To and From addresses.In server tab given localhost and 25 port.I executed the job and it finished successfully.But no mail is delivered to…
0
votes
1 answer

Pentaho replace variables in a query defined in a properties file

I have a query defined in a properties file like this config.properties DYNAMIC_SELECT=select * from accounts where username=${username} I then have a Table Input where the variable DYNAMIC_SELECT is used like this ${DYNAMIC_SELECT} How should I…
Farouk Alhassan
  • 3,780
  • 9
  • 51
  • 74
0
votes
2 answers

How to use Community Startup tabs (CST) in pentaho CDE?

I am using Pentaho version 5.0.1 stable. I am creating a dashboard which would be user specific. As the user login's, respective dashboard will open. So a user would not need to go through browse and then open the dashboard. The user authentication…
Alen
  • 174
  • 4
  • 11
0
votes
1 answer

Creating a manual link to Pentaho report

I'm using Pentaho report designer 3.9.4. I have an element "project_name" in my main report with several rows. I need to link the project_name element to the appropriate Pentaho report for every generated row. The project_name element should be a…
Tone
  • 765
  • 10
  • 24
  • 51
0
votes
1 answer

Unzip a list of files whose path has to be read from a table in Pentaho kettle

I am new to Pentaho kettle and have a requirement where we want to unzip a set of files and the paths to those files are there in a table. I am wondering how to go about it.
Sushant
  • 173
  • 1
  • 4
  • 15
0
votes
0 answers

Import records from a flat txt file with records delimited spacing?

I consulted as I can configure SPOON for correct import of data, knowing that I have the data delimited by spaces. And if it affects the import process in the penultimate record "SP_SEC" is not always a record and may be blank, affect the import? I…
0
votes
3 answers

Pentaho 5.0.1 CE Adding folder to pentaho-solutions directory

How do I get a folder to appear in the browser after adding it to \pentaho-solutions in Pentaho 5.0.1 CE. The documentation I read does not seem to work with this new version. 1. Create a new directory in…
flexxxit
  • 2,440
  • 5
  • 42
  • 69
0
votes
1 answer

Pentaho Kettle JSON Output

I have to design a KTR, where am passing fields from a step - Select values to JSON Output Step. The output from it is as shown in figure before: How Can i remove the fields Chart, Title , XAxis, YAxis, series? So that i get only result from this…
user2093576
  • 3,082
  • 7
  • 32
  • 43
0
votes
1 answer

CCC BarChart - how to set a fixed value for Y axis dynamically?

I'm using Pentaho's Community dashboard editor.I'm using barchart. I need to assign the fixed value for y axis dynamically according to result set. In pre execution: function(){ this.chartDefinition.orthoFixedMax = 10; } but result set are only…
0
votes
1 answer

JNDI ORACLE PENTAHO CONNECTION

I am unable to make JNDI connection from my pentaho report designer.Can able to connect native JDBC, but need JNDI.I am facing the following error : Error connecting to database [test] : org.pentaho.di.core.exception.KettleDatabaseException: Error…
0
votes
1 answer

How do I can check an input file is compressed (ZIP) or not?

How do I can check an input file is compressed (ZIP) or not ?. Is the solution to read the file info using "Get File Names" step and check the extension field ?
Hari
  • 397
  • 1
  • 9
  • 23